Received: from cncware.whidbey.com (IDENT:root@cncware.whidbey.com
	[208.25.171.37]) by hub.org (8.9.3/8.9.3) with ESMTP id DAA75993
	for <pgsql-interfaces@postgreSQL.org>;
	Wed, 14 Jul 1999 03:16:52 -0400 (EDT) (envelope-from ken@ori-ind.com)
Received: from ken (ken.cncware.com [192.168.61.201])
	by cncware.whidbey.com (8.8.7/8.8.7) with SMTP id AAA11298
	for <pgsql-interfaces@postgreSQL.org>; Wed, 14 Jul 1999 00:13:22 -0700
Message-Id: <3.0.32.19990714002028.00854100@ren.cncware.com>
X-Sender: ken_ori@ren.cncware.com
X-Mailer: Windows Eudora Pro Version 3.0 (32)
Date: Wed, 14 Jul 1999 00:20:30 -0700
To: pgsql-interfaces@postgreSQL.org
From: "Ken J. Wright" <ken@ori-ind.com>
Subject: temp table problem
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

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