Mark Forums Read

CREATE TEMPORARY TABLE AS ... ON COMMIT?

Go Back

comp.databases.postgresql.general comp.databases.postgresql.general

Reply

#1

Old

Thomas F.O'Connell

Posts: n/a

CREATE TEMPORARY TABLE AS ... ON COMMIT? - 10-20-2004 , 03:40 PM

Is the ON COMMIT syntax available to temporary tables created using the
CREATE TABLE AS syntax? If not, is there a way to drop such a table at
the end of a transaction?

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Reply With Quote

#2

Old

Neil Conway

Posts: n/a

Re: CREATE TEMPORARY TABLE AS ... ON COMMIT? - 10-20-2004 , 06:32 PM

On Thu, 2004-10-21 at 06:40, Thomas F.O'Connell wrote:

Quote:

Is the ON COMMIT syntax available to temporary tables created using the
CREATE TABLE AS syntax?

No, but it should be. There's a good chance this will be in 8.1

Quote:

If not, is there a way to drop such a table at
the end of a transaction?

DROP TABLE

-Neil

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.