From: | Yury Don <yura(at)vpcit(dot)ru> |
---|---|
To: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re[2]: [GENERAL] Bug or my crooked hands? |
Date: | 2000-01-19 11:32:12 |
Message-ID: | 19689.000119@vpcit.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello J.,
Once, Wednesday, January 19, 2000, 4:19:12 PM, you wrote:
>> Hello All,
>>
>> I have the following situation:
>>
>> CREATE TABLE "Contacts" (
>> "Contact" Serial,
>> "StuffTheir" Text,
>> "TheDate" datetime DEFAULT TEXT 'now',
>> "Subj" Text,
>> "CustomerId" int4,
>> "Agent" int4,
>> "ActionType" int2,
>> "Done" bool default false not null,
>> "ExecutionDate" datetime,
>> "Whom" int4
>> );
>>
>> Then I have inserted data from text file and do a query
>>
>> mdb=> select Contact from Contacts;
>> Contacts
>> -----------
>> -2112563299
>> -2111287024
>> -2110307960
>> -2110004687
>> -2109773688
>> -2109611925
>> -2108616455
>> ...
JR> How did you get negative values in a Serial - field??
JR> Serial-fields default to positive numbers....
I have copied the data from MS Access table and there where negative
values. I can't change data in field Contacts because they are using
in other tables.
--
Best regards,
Yury ICQ 11831432
mailto:yura(at)vpcit(dot)ru
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Jewiss | 2000-01-19 11:55:26 | Re: Re[2]: [GENERAL] Bug or my crooked hands? |
Previous Message | J. Roeleveld | 2000-01-19 11:19:12 | Re: [GENERAL] Bug or my crooked hands? |