temp table problem - Mailing list pgsql-interfaces

From Ken J. Wright
Subject temp table problem
Date
Msg-id 3.0.32.19990714002028.00854100@ren.cncware.com
Whole thread Raw
Responses How can I unsubscribe from this list?  (Abdulaziz Ahmed <dal95aad@mds.mdh.se>)
List pgsql-interfaces
I created a temporary table using 'Select [fields] into temp table {table]'.
Then I altered the table, adding extra columns.
Then I updated the new table, attempting to fill in the new columns.
Only the *first* added column would except the update, even though no
errors were reported. psql says 'UPDATE 1' like all went well, however the
other extra columns remained null. This is consistant with libpq & psql.

Ken



pgsql-interfaces by date:

Previous
From: Peter Mount
Date:
Subject: RE: [INTERFACES] Upload...
Next
From: Abdulaziz Ahmed
Date:
Subject: How can I unsubscribe from this list?