Re: scripts in Postgres

On May 3, 2005, at 2:50 AM, Rolf Østvik wrote:

> 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;

That was my suspicion, also. I haven't tried to confirm it, though.
(I'm a MacOS user.)

Sean