It's not really clear what problem you are trying to solve. You say
both column defaults should be NULL. Well, evidently they are.
NULL::timestamp without time zone
NULL::character varying
Those are NULL values. Are you confused by the information displayed
after the double colon? That's just Postgres' way of showing you what
the data type of the column is.
Thank you,
Lewis Kapell
Computer Operations
Seton Home Study School
-------------------------------------------------------
For a free subscription to the Seton Home Study School monthly
electronic newsletter, send an e-mail to newsletter-sub@xxxxxxxxxxxxx
-------------------------------------------------------
Andre Rothe wrote:
Hi,
I have installed Postgres 8.3.8 on Fedora Linux. If I create a table,
the default values will be set by the database to
NULL::timestamp without time zone
for a timezone column and to
NULL::character varying
for a varchar column. How I can prevent such a behaviour? Both column
defaults should be NULL. I have read some posts about this point, it
seems to be a problem of a so called "acts_as_tsearch plugin", but I'm
not familiar enough with Postgres to know, what it means. Any other
detailled solutions?
Thanks
Andre
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
