Tom Lane wrote:
>Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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 allow it.
>>
>>
>
>Hm. The syntax NATURAL CROSS JOIN is specifically disallowed by SQL99
>and our parser (see attached SQL99 excerpt). If pg_dump produces that
>in a view dump then that's a bug, but this test case doesn't let me see
>it happen, because the parser rejects the given view definition. Do
>you happen to have the original input that created the view?
>
> regards, tom lane
>
>
>[snip excerpt from gram.y]
>
>
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.
cheers
andrew