| From: | "Craig L(dot) Ching" <cching(at)mqsoftware(dot)com> |
|---|---|
| To: | "'Gregory Wood'" <gregw(at)com-stock(dot)com>, PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | RE: Re: Test for existence of Table |
| Date: | 2001-01-05 17:41:36 |
| Message-ID: | E1B42CFD544FD31193EE0000E87C5CE771015B@mailserver2.mqsoftware.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>-----Original Message-----
>From: Gregory Wood [mailto:gregw(at)com-stock(dot)com]
>Sent: Thursday, January 04, 2001 9:12 PM
>To: PostgreSQL-General
>Subject: [GENERAL] Re: Test for existence of Table
>
>
>> DROP TABLE employees
>Error: ERROR: Relation 'employees' does not exist
>
>And execution halts.... which is I believe why he wanted to check for the
>existence before trying to DROP. I'd love to know if this exists as well...
>would come in very handy during development time.
>
Execution does not halt, it continues and creates the table. I rely on this
functionality, so I know it works. Good luck!
>
>Greg
Cheers,
Craig
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Wood | 2001-01-05 18:15:59 | Re: Re: Test for existence of Table |
| Previous Message | Tom Lane | 2001-01-05 17:18:00 | Re: PL/pgSQL NOT NULL variables |