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

Re: Wrong default values of columns

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Andre Rothe <phosco(at)gmx(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Wrong default values of columns
Date: 2009-09-17 13:53:20
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
On Thu, Sep 17, 2009 at 8:15 AM, Andre Rothe <phosco(at)gmx(dot)de> 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.

Uh... that's exactly what they were set to.  The :: stuff is just a
type-annotation.  Your defaults really are 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?

I don't think that has anything to do with this.


In response to


pgsql-bugs by date

Next:From: philip wrightDate: 2009-09-17 14:14:43
Subject: BUG #5062: 8.4.1 compile fails on debian can't find libdl
Previous:From: Andre RotheDate: 2009-09-17 12:15:28
Subject: Wrong default values of columns

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