Re: Wrong column default values

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@setonhome.org
-------------------------------------------------------


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
>