Re: Strangeness/bug when working with my own datatype in PostgreSQL

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Солодовников Константин <ks@tcnet.ru>
Cc: "'pgsql-bugs@postgresql.org'" <pgsql-bugs@postgresql.org>
Date: 2001-02-25T04:36:54Z
Lists: pgsql-bugs
=?KOI8-R?Q?=F3=CF=CC=CF=C4=CF=D7=CE=C9=CB=CF=D7_=EB=CF=CE=D3=D4=C1?= =?KOI8-R?Q?=CE=D4=C9=CE?= <ks@tcnet.ru> writes:
> When I insert a new row into this table without providing a value for the
> "i1" column, I get a value of "45" in it.

Seems odd to me too; it should default to NULL if no value is specified
or available from a DEFAULT clause.  Can't guess why you're seeing a
problem without more details, though.  Could you show us the code you
used to define your datatype?

			regards, tom lane