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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Солодовников Константин <ks(at)tcnet(dot)ru>
Cc: "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Strangeness/bug when working with my own datatype in PostgreSQL
Date: 2001-02-25 04:36:54
Message-ID: 19494.983075814@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)tcnet(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Stu Coates 2001-02-25 15:25:16 Re: Lock Detection (was: pg_dump failing on LinuxPPC)
Previous Message Солодовников Константин 2001-02-24 23:47:26 Strangeness/bug when working with my own datatype in PostgreSQL