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: | 603c8f070909170653p675b44c9ibd514957dec1194f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
...Robert
From | Date | Subject | |
---|---|---|---|
Next Message | philip wright | 2009-09-17 14:14:43 | BUG #5062: 8.4.1 compile fails on debian can't find libdl |
Previous Message | Andre Rothe | 2009-09-17 12:15:28 | Wrong default values of columns |