On May 3, 2005, at 2:50 AM, Rolf Østvik wrote:
postgresql@xxxxxxxxxxxx ("Craig Bryden") wrote in 001601c54f15$b9d32fe0$0200a8c0@amd2800:">news:001601c54f15$b9d32fe0$0200a8c0@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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
