Skip site navigation (1) Skip section navigation (2)

Wrong default values of columns

From: Andre Rothe <phosco(at)gmx(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Wrong default values of columns
Date: 2009-09-17 12:15:28
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs

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?



pgsql-bugs by date

Next:From: Robert HaasDate: 2009-09-17 13:53:20
Subject: Re: Wrong default values of columns
Previous:From: Kenaniah CernyDate: 2009-09-17 05:32:50
Subject: Re: BUG #5059: Planner ignores estimates when planning an IN () subquery

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group