Re: [HACKERS] 8.1 Release Candidate 1 Coming ...

2005-10-29 Thread Dave Page
On 29/10/05 4:47 am, Marc G. Fournier [EMAIL PROTECTED] wrote: Tomorrow evening, I'm going to wrap up RC1, to announce it on Monday ... if anyone is sitting on *anything*, please say something before about midnight GMT ... Don't include a link for the Windows version in your email please

[HACKERS] Update for supported platforms list

2005-10-29 Thread Devrim GUNDUZ
Hi, All regression tests passed on : * SUSE LINUX 10.0 (i586) OSS * Fedora Core release 4 * Red Hat Linux release 9 * Red Hat Enterprise Linux ES release 3 (Taroon Update 6) Both are x86. Regards, -- Devrim GUNDUZ Kivi Bilişim Teknolojileri - http://www.kivi.com.tr devrim~gunduz.org,

Re: [HACKERS] 8.1 Release Candidate 1 Coming ...

2005-10-29 Thread Stefan Kaltenbrunner
Marc G. Fournier wrote: Tomorrow evening, I'm going to wrap up RC1, to announce it on Monday ... if anyone is sitting on *anything*, please say something before about midnight GMT ... hmm well -HEAD(and 8.0.4 too!) is broken on AIX 5.3ML3:

Re: [HACKERS] FKs on temp tables: hard, or just omitted?

2005-10-29 Thread Sander Steffann
You can have foreign keys between temp tables, just not between temp and permanent tables. The latter case is either fairly silly, or technically hard, depending on which direction you have in mind. A temp table referencing a permanent table wouldn't be very silly IMHO... Sander.

Re: [HACKERS] FKs on temp tables: hard, or just omitted?

2005-10-29 Thread Martijn van Oosterhout
On Sat, Oct 29, 2005 at 02:54:31PM +0200, Sander Steffann wrote: You can have foreign keys between temp tables, just not between temp and permanent tables. The latter case is either fairly silly, or technically hard, depending on which direction you have in mind. A temp table referencing a

Re: [HACKERS] FKs on temp tables: hard, or just omitted?

2005-10-29 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] on behalf of Sander Steffann Sent: Sat 10/29/2005 1:54 PM To: josh@agliodbs.com; Tom Lane Cc: PostgreSQL-development Subject: Re: [HACKERS] FKs on temp tables: hard, or just omitted? You can have foreign keys between temp tables, just not

Re: [HACKERS] 8.1 Release Candidate 1 Coming ...

2005-10-29 Thread Tom Lane
Stefan Kaltenbrunner [EMAIL PROTECTED] writes: hmm well -HEAD(and 8.0.4 too!) is broken on AIX 5.3ML3: http://archives.postgresql.org/pgsql-hackers/2005-10/msg01053.php [ shrug... ] The reports of this problem have not given enough information to fix it, and since it's not a regression from

Re: [HACKERS] 8.1 Release Candidate 1 Coming ...

2005-10-29 Thread Stefan Kaltenbrunner
Tom Lane wrote: Stefan Kaltenbrunner [EMAIL PROTECTED] writes: hmm well -HEAD(and 8.0.4 too!) is broken on AIX 5.3ML3: http://archives.postgresql.org/pgsql-hackers/2005-10/msg01053.php [ shrug... ] The reports of this problem have not given enough information to fix it, and since it's

Re: [HACKERS] FKs on temp tables: hard, or just omitted?

2005-10-29 Thread Tom Lane
Martijn van Oosterhout kleptog@svana.org writes: You solve it by allowing other backends to lock and examine your temporary tables. But AIUI temporary tables are not stored in shared memory so how do you get a consistant view of it? Not unsolvable, but very tricky. Right, the problem isn't

[HACKERS] The argument for reinstating --as-needed

2005-10-29 Thread Martijn van Oosterhout
As some of you may remember, a patch for adding --as-needed to the GNU linker command line was added [1] and subsequently removed [2] under the mistaken assumption that it was a linker bug [3]. It isn't. The bug is actually in readline, in that it doesn't declare its dependancy on

Re: [HACKERS] The argument for reinstating --as-needed

2005-10-29 Thread Bruce Momjian
At this stage, I am thinking this is best left for 8.2. It is impossible for us to test it enough. --- Martijn van Oosterhout wrote: -- Start of PGP signed section. As some of you may remember, a patch for adding

Re: [HACKERS] The argument for reinstating --as-needed

2005-10-29 Thread Martijn van Oosterhout
On Sat, Oct 29, 2005 at 02:47:17PM -0400, Bruce Momjian wrote: At this stage, I am thinking this is best left for 8.2. It is impossible for us to test it enough. I agree. I missed the messages when it went in and missed where it came out. So I looked into it and have found a solution, but

Re: [HACKERS] The argument for reinstating --as-needed

2005-10-29 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: At this stage, I am thinking this is best left for 8.2. It is impossible for us to test it enough. Agreed --- the portability risks are way too high for 8.1. I see no reason not to try it during the 8.2 cycle though.

Re: [HACKERS] The argument for reinstating --as-needed

2005-10-29 Thread Bruce Momjian
This has been saved for the 8.2 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Martijn van Oosterhout wrote: -- Start of PGP signed section. As some of you may remember, a patch for adding

Re: [HACKERS] [PATCHES] TODO Item - Add system view to show free

2005-10-29 Thread Simon Riggs
On Fri, 2005-10-28 at 18:43 +0200, Martijn van Oosterhout wrote: On Fri, Oct 28, 2005 at 05:05:25PM +0100, Simon Riggs wrote: 3. Helping Readahead efficiency: Currently blocks are allocated one at a time. If many tables are extending at the same time, the blocks from multiple tables will be

Re: [HACKERS] [ADMIN] Fatal error

2005-10-29 Thread Tom Lane
Peter Ivarsson [EMAIL PROTECTED] writes: FATAL: could not read statistics message: Resource temporarily unavailable What platform is this on exactly, and what version of Postgres? PostgreSQL version 8.0.4 and OS is OsX 10.3 on a Mac G4. I spent some time trying to duplicate this on my

[HACKERS] 8.1 Release Candidate 1 Bundled ...

2005-10-29 Thread Marc G. Fournier
Take a look through it, will announce this evening ... Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664 ---(end of broadcast)--- TIP 4: