Re: [BUGS] BUG #2549: problem with NATURAL JOIN

2006-07-25 Thread Michael Fuhr
On Tue, Jul 25, 2006 at 12:58:55AM +, Kayteck wrote: > I have two tables joined by foreign key id_przelewu, and for some rows > results of queries with NATURAL JOIN and JOIN ... USING (...) differs ! I've > readed that NATURAL JOIN is only shorthand for the second method, but this > results sho

Re: [BUGS] BUG #2549: problem with NATURAL JOIN

2006-07-25 Thread Tom Lane
"Kayteck" <[EMAIL PROTECTED]> writes: > I have two tables joined by foreign key id_przelewu, and for some rows > results of queries with NATURAL JOIN and JOIN ... USING (...) differs ! I've > readed that NATURAL JOIN is only shorthand for the second method, but this > results shows that's not true:

Re: [BUGS] BUG #2549: problem with NATURAL JOIN

2006-07-25 Thread Simon Riggs
On Tue, 2006-07-25 at 00:58 +, Kayteck wrote: > I have two tables joined by foreign key id_przelewu, and for some rows > results of queries with NATURAL JOIN and JOIN ... USING (...) differs ! I've > readed that NATURAL JOIN is only shorthand for the second method, but this > results shows tha

Re: [BUGS] BUG #2546: PostgreSQL does not have native spinlock

2006-07-25 Thread John Weekley
On Mon, 2006-07-24 at 21:47 -0400, Bruce Momjian wrote: > Zdenek Kotala wrote: > > Tom Lane wrote: > > > "John Weekley" <[EMAIL PROTECTED]> writes: > > >> Platform is 64 bit Solaris x86. > > >> ... > > >> "../../../../src/include/storage/s_lock.h", line 814: #error: PostgreSQL > > >> does not have

[BUGS] BUG #2549: problem with NATURAL JOIN

2006-07-25 Thread Kayteck
The following bug has been logged online: Bug reference: 2549 Logged by: Kayteck Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Fedora Core 4 Description:problem with NATURAL JOIN Details: I have two tables joined by foreign key id_prze