Re: ON COMMIT DROP

Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Is there any reason why the 'ON COMMIT' behaviour feature is not 
> available if you use CREATE TABLE AS ...?

Where exactly would you propose to stick it in the syntax?  Can you do
it without introducing more fully-reserved words than we have already?
Is there any spec or other-product precedent for it?  (Offhand I can't
even find CREATE TABLE AS in SQL99...)
        regards, tom lane