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

Re: scripts in Postgres

From: "Rolf stvik" <rolfostvikjobb(at)yahoo(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: scripts in Postgres
Date: 2005-05-03 06:50:00
Message-ID: Xns964B59DC9D060rolfostvikjobbyahoon@200.46.204.72 (view raw or flat)
Thread:
Lists: pgsql-general
postgresql(at)bryden(dot)co(dot)za ("Craig Bryden") wrote in
news:001601c54f15$b9d32fe0$0200a8c0(at)amd2800: 

> Hi Sean
> 
> Thanks for that. Does psql work differently to pgAmin III's Query
> program? I have tried exactly what you showed me below, and it did not
> work. It seems like the script stops on first error, and the first
> error is that the table does not exist.
> 

Could it be that it pgAdmin creates a transaction.
What happens if you set in some begin and commit.
(Just a wild suggestion, not tested in any way).
----------------------------------------
begin;
DROP TABLE tb_messages;
commit;
begin;
CREATE TABLE tb_messages (
....
);
commit;

-- 
Rolf

In response to

Responses

pgsql-general by date

Next:From: Richard HuxtonDate: 2005-05-03 08:12:50
Subject: Re: Tuning queries inside a function
Previous:From: Dinesh PandeyDate: 2005-05-03 04:25:41
Subject: Re: unable to open editor.

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