Re: Field types

From: "Tom Lane"
> > create table catalog1
> > (id int8 not null primary key
> > ,Info1 VarChar(15) not null
> > ,Info2 VarChar(30) not null);
>
> Looks fine to me.  You still haven't shown us exactly what goes wrong
> for you (like a query and an error message ...)

I used pgAdmin II to insert a row of the data into the table. Now i tried
also this query

insert into catalog1 (id, info1, info2) values
(999999999999999999,'asdf','asdf');
and it did work!

Now a big slam on my face! I tried first to insert 9223372036854775808 it
did not
work with range error then i changed that to 9223372036854775807 and it did
not
work because i had a unique index on info1.
i'm so sorry :(  (I'm just too tired)

This is obviously calling for a break. (I can't see straight anymore).

Thanks for your help.


Best regards,
Aplication Developer
Pirtea Calin Iancu
S.C. SoftScape S.R.L.
pcalin@rdsor.ro