Postgres Pro
Downloads
Home   >   mailing lists

Re: Error when trying to add DEFAULT Value to NEW column - Mailing list pgadmin-support

From Dave Page
Subject Re: Error when trying to add DEFAULT Value to NEW column
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40103DDF5@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Error when trying to add DEFAULT Value to NEW column  ("Leon du Plessis" <leon@designit.za.com>)
List pgadmin-support
Tree view
 

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Leon du Plessis
Sent: 02 February 2006 14:49
To: pgadmin-support@postgresql.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.

pgadmin-support by date:

Previous
From: "Leon du Plessis"
Date:
Subject: Re: Error when trying to add DEFAULT Value to NEW column
Next
From: Paul Rogers
Date:
Subject: Usability