Re: Default value for char/varchar columns is not quoted automaticaly

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Oldrich Dlouhy" <oldrich(dot)dlouhy(at)seznam(dot)cz>, "PGAdmin support forum" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Default value for char/varchar columns is not quoted automaticaly
Date: 2003-10-03 07:50:34
Message-ID: 03AF4E498C591348A42FC93DEA9661B844B741@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: Oldrich Dlouhy [mailto:oldrich(dot)dlouhy(at)seznam(dot)cz]
> Sent: 03 October 2003 07:04
> To: PGAdmin support forum
> Subject: [pgadmin-support] Default value for char/varchar
> columns is not quoted automaticaly
>
>
> Default value for char/varchar columns is not quoted
> automaticaly when
> creating a table or adding new column to existing table.
>
> Same behavior is when creating the table.
>
> If this behavior is "by design" and the user required to enter the
> quotes manualy, take it please just as a feature request to
> automaticaly
> quote character-type defaults

It is by design because pgAdmin would have no way of determining whether
you are entering a literal string, or an expression which definately
shouldn't be quoted.

> Thank you for creating great tool as PGAdmin is.

You're welcome - glad you like it.

Regards, Dave.

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-10-03 08:21:26 Re: not sure if you take non-list posts or not
Previous Message Dave Page 2003-10-03 07:09:49 Re: Reverse engineered Column definition incorrect