| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de> |
| Cc: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re : Am I overseen ? |
| Date: | 2007-10-18 19:35:43 |
| Message-ID: | 27482.1192736143@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de> writes:
> When there is a way to optionally add columns to existing tables via
> SQL I have very less development needs to get this working.
Why don't you just issue the ALTER ADD COLUMN and ignore the error
if it's duplicate column?
Or if you don't like that, it's not that hard to look into the system
catalogs and see if the column already exists. A program bright enough
to be issuing dynamic DDL commands ought to be able to do that ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomi N/A | 2007-10-18 19:46:09 | Re: a failover scenario |
| Previous Message | Alvaro Herrera | 2007-10-18 19:10:47 | Re: Abbreviation list |