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-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 ?

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

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

[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

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.

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 appear to

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 that this

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] wrote: