Skip site navigation (1) Skip section navigation (2)

Drop table vs begin/end transaction

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Pgsql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Drop table vs begin/end transaction
Date: 2001-11-18 04:24:12
Message-ID: 20011117231740.S69022-100000@zoraida.natserv.net (view raw or flat)
Thread:
Lists: pgsql-novice
I have a table which I will populate every day from scratch (data coming
from a Foxpro system) and I am wandering if I could do something like:

begin transaction
drop table <name>
\i <create table script>
copy from <ascii file>
end transaction

Can this be done? In particular will the drop table honor begin/end?

My alternative is to use delete from <table>. Besides been slower I wonder
if this would not make my "vacuum analyze" run much slower.



Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2001-11-18 05:37:34
Subject: Re: Drop table vs begin/end transaction
Previous:From: Tom LaneDate: 2001-11-16 19:35:22
Subject: Re: switching from mysql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group