| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
| Cc: | Aarni Ruuhimäki <aarni(dot)ruuhimaki(at)kymi(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Fwd: Re: Sequence error ? |
| Date: | 2004-05-25 18:53:58 |
| Message-ID: | 26309.1085511238@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> Aarni Ruuhimki wrote:
>> There was a slight contradiction in this:
>> "country" integer DEFAULT '' NOT NULL,
> How was possible for you create that table ?
> on 7.4.1 I get:
> test=# create table test ( b integer, a integer default '' not null );
> ERROR: invalid input syntax for integer: ""
Yeah, but before 7.3 pg_atoi would have silently accepted '' as meaning
zero. So the problem wouldn't show up until Aarni updated ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Hammond | 2004-05-25 21:51:17 | Re: New from mssql. Help please |
| Previous Message | Gaetano Mendola | 2004-05-25 17:39:10 | Re: Fwd: Re: Sequence error ? |