Wrong column default values

From: Andre Rothe <phosco(at)gmx(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Wrong column default values
Date: 2009-09-17 13:36:46
Message-ID: e88b0e3e-44e3-4819-80c1-0455b6fa6d22@r36g2000vbn.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Johann Spies 2009-09-17 13:38:46 Re: PostgreSQL 8.3
Previous Message Nigel Metheringham 2009-09-17 12:42:19 Loss of table structure on 7.3.19