| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | <operationsengineer1(at)yahoo(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Dev DB Structure Updates |
| Date: | 2006-05-11 17:06:28 |
| Message-ID: | C088E754.B556%sdavis2@mail.nih.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 5/11/06 12:55 PM, "operationsengineer1(at)yahoo(dot)com"
<operationsengineer1(at)yahoo(dot)com> wrote:
> hi all,
>
> i'm reading agile web dev with rails and the author
> discusses how he makes text sql snapshots of his
> databases. when a new column needs to be added, for
> example, he updates the text sql and reloads the file.
>
> in mysql, he puts a statement like...
>
> if table_example exists delete table_example
>
> that is close, but not the exact code. he is trying
> to delete the existing table (wrong structure) and
> replace it with the new structure.
Just drop the table as usual. If you get an error, that won't affect
further processing.
Sean
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Tucknott | 2006-05-11 18:39:33 | Re: Dev DB Structure Updates |
| Previous Message | operationsengineer1 | 2006-05-11 16:55:19 | Dev DB Structure Updates |