Re: [GENERAL] drop table before create

2005-08-27 Thread A. Kretschmer
am 26.08.2005, um 2:11:30 +0430 mailte Lee Harr folgendes: > >I have not been able to work out how to do this is Postgres 8 > >(pseudo-code) > > if exists table foo > > drop table foo; > > end > > create table foo; > >If I go with > > drop table foo; > > create table foo; > >then it barfs on

Re: [GENERAL] drop table before create

2005-08-25 Thread Lee Harr
I have not been able to work out how to do this is Postgres 8 (pseudo-code) if exists table foo drop table foo; end create table foo; If I go with drop table foo; create table foo; then it barfs on an empty db. The assumption here is that the SQL is coming in on a script via the

[GENERAL] drop table before create

2005-08-23 Thread Mark Probert
Hi .. I have not been able to work out how to do this is Postgres 8 (pseudo-code) if exists table foo drop table foo; end create table foo; If I go with drop table foo; create table foo; then it barfs on an empty db. I can find the table name in pg_class but I am not sure of where t