| Lists: | pgsql-general |
|---|
| From: | Thomas F(dot)O'Connell <tfo(at)sitening(dot)com> |
|---|---|
| To: | PgSql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | CREATE TEMPORARY TABLE AS ... ON COMMIT? |
| Date: | 2004-10-20 20:40:22 |
| Message-ID: | 4378634B-22D8-11D9-A5E5-000D93AE0944@sitening.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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
| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com> |
| Cc: | PgSql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: CREATE TEMPORARY TABLE AS ... ON COMMIT? |
| Date: | 2004-10-20 23:32:35 |
| Message-ID: | 1098315155.6602.167.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Thu, 2004-10-21 at 06:40, Thomas F.O'Connell wrote:
> 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
> If not, is there a way to drop such a table at
> the end of a transaction?
DROP TABLE :)
-Neil