Re: [GENERAL] Bug or my crooked hands? - Mailing list pgsql-general

> 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
> ...

How did you get negative values in a Serial - field??
Serial-fields default to positive numbers....