| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Leon du Plessis" <leon(at)designit(dot)za(dot)com>, <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: Error when trying to add DEFAULT Value to NEW column |
| Date: | 2006-02-02 14:53:32 |
| Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40103DDF5@ratbert.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
________________________________
From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Leon du
Plessis
Sent: 02 February 2006 14:49
To: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Error when trying to add DEFAULT
Value to NEW column
Ok, This was me. When I looked at the SQL statement to trace
problem, I (sheepishly) used the wrong quotes !
Oh good - I was scratching my head trying to track that one down!
Can the single quotes be added automatically if they are not
supplied?
Not really, because it's difficult to know if they are required or not,
especially if custom datatypes are used, or the default is actually an
expression.
Regards,. Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Rogers | 2006-02-02 15:31:04 | Usability |
| Previous Message | Leon du Plessis | 2006-02-02 14:48:50 | Re: Error when trying to add DEFAULT Value to NEW column |