Re[2]: [GENERAL] Bug or my crooked hands?

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@vpcit.ru