On Thu, Sep 17, 2009 at 8:15 AM, Andre Rothe <pho...@gmx.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs