Bruce Momjian | 1 Sep 2002 02:52
Picon

pgindent

Just a reminder that once all the patches are in, I need to run
pgindent.

--

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman <at> candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

Marc G. Fournier | 1 Sep 2002 02:50
Favicon

Re: [ODBC] ODBC Driver moved to GBorg ...


This is all in Vince's area ...

On 23 Aug 2002, Greg Copeland wrote:

> I must be blind.  I don't see links to gborg anywhere on the developer
> or main site web pages.  Perhaps more obvious a sister site link would
> be of value.
>
> The only link I found was under "User's Lounge" and then "PostgreSQL
> Related Projects".  Perhaps extra link emphasis is needed since a
> seemingly new level of demand is being placed on gborg's significance?
>
> Sign,
>
> 	Greg Copeland
>
>
> On Thu, 2002-08-22 at 17:46, Marc G. Fournier wrote:
> >
> > Just so that everyone knows, Dave Page created a project on GBorg for the
> > ODBC driver, and I've just finished moving it over and removing it from
> > the main tree ...
> >
> > 2 down ... so many more to go :)
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
(Continue reading)

Tom Lane | 1 Sep 2002 04:42
Picon

CREATE CAST requires immutable cast function?

It says here that CREATE CAST insists the cast function be immutable.
This seems wrong to me, in view of the fact that we have numerous
built-in casts that don't adhere to that rule --- for example,
timestamptz(date) is not immutable because it depends on the timezone
setting.

Perhaps there's a case for prohibiting volatile casts (as opposed to
stable ones), but I don't really see it.  I'd prefer to just remove
this restriction.  Comments?

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Bruce Momjian | 1 Sep 2002 04:45
Picon

Re: CREATE CAST requires immutable cast function?

Tom Lane wrote:
> Perhaps there's a case for prohibiting volatile casts (as opposed to
> stable ones), but I don't really see it.  I'd prefer to just remove
> this restriction.  Comments?

Volatile casts can blow up.  I am sure that is the reasoning.  ;-)

--

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman <at> candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo <at> postgresql.org

Bruce Momjian | 1 Sep 2002 05:27
Picon

Help with finding checkpoint code

I am trying to find when WAL log files are rotated.  The message is:

  2002-02-11 21:18:13 DEBUG: recycled transaction log file 0000000000000005

and it is printed in MoveOfflineLogs(), and MoveOfflineLogs() is only
called by CreateCheckPoint(), but I can't see where CreateCheckPoint()
is called in normal operation.  I see it called by CHECKPOINT, and on
startup and shutdown, and from bootstrap, but where is it called during
normal backend operation.

--

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman <at> candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo <at> postgresql.org)

Alvaro Herrera | 1 Sep 2002 05:51

Re: Help with finding checkpoint code

En Sat, 31 Aug 2002 23:27:08 -0400 (EDT)
Bruce Momjian <pgman <at> candle.pha.pa.us> escribió:

> I am trying to find when WAL log files are rotated.  The message is:
> 
>   2002-02-11 21:18:13 DEBUG: recycled transaction log file 0000000000000005
> 
> and it is printed in MoveOfflineLogs(), and MoveOfflineLogs() is only
> called by CreateCheckPoint(), but I can't see where CreateCheckPoint()
> is called in normal operation.  I see it called by CHECKPOINT, and on
> startup and shutdown, and from bootstrap, but where is it called during
> normal backend operation.

I see it on TruncateCLOG(), src/backend/access/transam/clog.c; that is
called by vacuum code.  Also on CheckPoinDataBase(), macro in
src/backend/postmaster/postmaster.c (this is called on a periodic basis
AFAIU)

HTH

--

-- 
Alvaro Herrera (<alvherre[a]atentus.com>)
One man's impedance mismatch is another man's layer of abstraction.
(Lincoln Yeoh)

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

(Continue reading)

Nigel J. Andrews | 1 Sep 2002 19:52
Picon

Impending freeze


When is the beta freeze?

I've just started looking at a ToDo list item and hope it won't take too
long. However, I've got other things to do and this is the first I've looked in
this area. An idea about time left to complete it would be good so I decide if
I'm wasting my time and effort at the moment.

--

-- 
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

Gavin Sherry | 1 Sep 2002 19:58
Picon

Re: Impending freeze

On Sun, 1 Sep 2002, Nigel J. Andrews wrote:

> 
> 
> When is the beta freeze?

Today.

Gavin

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo <at> postgresql.org so that your
message can get through to the mailing list cleanly

Nigel J. Andrews | 1 Sep 2002 20:17
Picon

Re: Impending freeze


On Mon, 2 Sep 2002, Gavin Sherry wrote:

> On Sun, 1 Sep 2002, Nigel J. Andrews wrote:
> 
> > When is the beta freeze?
> 
> Today.
> 

Oops, my fault for being imprecise.

I was wondering what time of day with timezone. Someone suggested end of today
but that means different times to different people.

--
Nigel Andrews

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Rod Taylor | 1 Sep 2002 20:48
Picon

Re: Impending freeze


> Oops, my fault for being imprecise.
> 
> I was wondering what time of day with timezone. Someone suggested end of today
> but that means different times to different people.

This is what Marc said yesterday:

Yup, I believe that it is the case that both the US and Canada
"celebrate"
labour day on Monday, correct?  If so, then let's put the freeze on
effective 8:30amADT on Tuesday morning, at which point I'll put a tag in
place, and will package Beta1 up for the initial round of testing ...

I don't know if that suggestion will go through or not, but I can't see
why not.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


Gmane