Re: Field types
От | Pirtea Calin |
---|---|
Тема | Re: Field types |
Дата | |
Msg-id | 004801c1c482$ae113380$3b55e73e@dizzy обсуждение исходный текст |
Ответ на | Field types ("Pirtea Calin" <pcalin@rdsor.ro>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: