Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-07 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: During the irc discussion I discovered that. But the CREATE TABLE page in the docs appears to suggest that it is legal. That should be fixed. Where exactly? I see For the INNER and OUTER join types, a join condition must be spe

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-07 Thread Andrew Dunstan
Tom Lane wrote: Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: Just a note for the hackers, Jonathan (I think :) ) talked to me about this on the irc channel - we couldn't figure this one out. Seems that pg_dump produces NATURAL CROSS JOIN in the dump of a view, but the pgsql grammar d

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-07 Thread Andrew Dunstan
Gaetano Mendola said: > Christopher Kings-Lynne wrote: >> Just a note for the hackers, Jonathan (I think :) ) talked to me about >> this on the irc channel - we couldn't figure this one out. Seems >> that > > Exist a postgres irc server? If yes may I know the server and port ? > > irc://irc.free

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-07 Thread Gaetano Mendola
Christopher Kings-Lynne wrote: Just a note for the hackers, Jonathan (I think :) ) talked to me about this on the irc channel - we couldn't figure this one out. Seems that Exist a postgres irc server? If yes may I know the server and port ? Regards Gaetano Mendola

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-06 Thread Jonathan Scott
Tom, I have included a pg_dump of the schema that causes this problem. If you take out the word "CROSS" from my source files, it should load just fine. If you then pg_dump it, in there you should find "CROSS". Jonathan Scott On Thu, 06 May 2004 22:26:13 -0400 Tom Lane <[EMAIL PROTECTED]> wrot

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-06 Thread Tom Lane
Jonathan Scott <[EMAIL PROTECTED]> writes: > I have included a pg_dump of the schema that causes this problem. If > you take out the word "CROSS" from my source files, it should load > just fine. If you then pg_dump it, in there you should find "CROSS". Indeed, I had just come to the conclusion th

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-06 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > Just a note for the hackers, Jonathan (I think :) ) talked to me about > this on the irc channel - we couldn't figure this one out. Seems that > pg_dump produces NATURAL CROSS JOIN in the dump of a view, but the pgsql > grammar does not appe

Re: [HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-06 Thread Christopher Kings-Lynne
I have discovered a problem with psql 7.3.4 where it does not seem to like statements containing "NATURAL CROSS JOIN". I have a test that I have created that will show the problem. Please have a look at it, give it a try, and let me know if there is a problem with the program or with the operator.

[HACKERS] psql 7.3.4 disagrees with NATURAL CROSS JOIN

2004-05-06 Thread Jonathan Scott
Hello, I have discovered a problem with psql 7.3.4 where it does not seem to like statements containing "NATURAL CROSS JOIN". I have a test that I have created that will show the problem. Please have a look at it, give it a try, and let me know if there is a problem with the program or with the