Re: [HACKERS] No more RH7.3 RPMs?

2003-05-30 Thread Lamar Owen
On Thursday 29 May 2003 17:41, Sander Steffann wrote: > Someone else has already built RPMs for RH73 and Lamar has already uploaded > them to ftp.postgresql.org. I just completed the RH62 packages. Lamar will > put them on the FTP server, but until then they can be picked up from > http://www.stef

Re: [HACKERS] No more RH7.3 RPMs?

2003-05-30 Thread Sander Steffann
Hi, > On Thursday 29 May 2003 07:26, ow wrote: > > RH7.3 is a supported distribution for at least 6 months. > > By Red Hat, but not necessarily by us. > That being said: > > > Any plans to add > > Postgres 7.3.3 RPMs for RH7.3? > > Yes. Please understand that I only have at my disposal machines r

Re: [HACKERS] No more RH7.3 RPMs?

2003-05-30 Thread Robert Treat
This message on the admin list has directions for recompiling the 7.3.3 SRPM on red hat 7.2 http://archives.postgresql.org/pgsql-admin/2003-05/msg00409.php Robert Treat On Thu, 2003-05-29 at 07:26, ow wrote: > RH7.3 is a supported distribution for at least 6 months. Any plans to add > Postgres 7

Re: [HACKERS] Question about simple function folding optimization

2003-05-30 Thread Bruno Wolff III
On Thu, May 29, 2003 at 15:19:09 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > Bruno Wolff III <[EMAIL PROTECTED]> writes: > > Can you use functional expressions in CREATE INDEX now (7.4 CVS) as well? > > You can use expressions. I'm not sure if you mean anything particular > by "functional expr

Re: [HACKERS] Sequence functions

2003-05-30 Thread Rod Taylor
Incase someone is interested, here is a patch without the CURRENT VALUE FOR portion. On Sat, 2003-05-24 at 23:39, Rod Taylor wrote: > We need to track sequence usage in things like defaults. nextval() > function calls don't easily allow this to happen. > > The 200N spec has NEXT VALUE FOR as th

Re: [HACKERS] Question about simple function folding optimization

2003-05-30 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > Can you use functional expressions in CREATE INDEX now (7.4 CVS) as well? You can use expressions. I'm not sure if you mean anything particular by "functional expressions". See the man page --- http://candle.pha.pa.us/main/writings/pgsql/sgml/sql-cre

Re: [HACKERS] Question about simple function folding optimization

2003-05-30 Thread Bruno Wolff III
On Thu, May 29, 2003 at 13:44:18 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > > I've now done this (amazing what you can do when you're putting off > editing thousands of elog() calls ...), and so Stephan's example > works again: Can you use functional expressions in CREATE INDEX now (7.4 CVS)

[HACKERS] Linux startup script

2003-05-30 Thread Darko Prenosil
I have noticed that after "/etc/init.d/postgresql restart", postmaster is no longer writes to "serverlog". (RedHat 9). Here is fixed "restart" section. restart) echo -n "Restarting PostgreSQL: " su - $PGUSER -c "$DAEMON restart -D '$PGDATA' -s -m fast -l $PGLOG" e

Re: [HACKERS] Question about simple function folding optimization

2003-05-30 Thread Tom Lane
Awhile back I said: > [ SQL-function inlining breaks planner's ability to recognize functional > indexes ] > The urge is becoming very strong to fix this by replacing functional > indexes with expressional indexes, as I suggested doing many moons ago. > Then the difficulty at hand would be easil

Re: [HACKERS] No more RH7.3 RPMs?

2003-05-30 Thread pgsql
> On Thursday 29 May 2003 07:26, ow wrote: >> RH7.3 is a supported distribution for at least 6 months. > > By Red Hat, but not necessarily by us. > That being said: > >> Any plans to add >> Postgres 7.3.3 RPMs for RH7.3? > > Yes. Please understand that I only have at my disposal machines > runn

Re: [HACKERS] Tom and Fernando: Status for "WITH RECURSIVE"

2003-05-30 Thread Andrew Overholt
> Do you know if your implementation will support multiple childs for each > node or will the implementation be limited to one link from each node in > the tree (making the tree to a list)? [...] > -will I then be able to fetch all childs (and grandchilds) for a given node > in the above tree

Re: [HACKERS] No more RH7.3 RPMs?

2003-05-30 Thread Lamar Owen
On Thursday 29 May 2003 07:26, ow wrote: > RH7.3 is a supported distribution for at least 6 months. By Red Hat, but not necessarily by us. That being said: > Any plans to add > Postgres 7.3.3 RPMs for RH7.3? Yes. Please understand that I only have at my disposal machines running Red Hat 9 (my