| From: | Mark Jewiss <mark(at)knowledge(dot)com> |
|---|---|
| To: | Yury Don <yura(at)vpcit(dot)ru> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Re[2]: [GENERAL] Bug or my crooked hands? |
| Date: | 2000-01-19 11:55:26 |
| Message-ID: | Pine.BSO.4.10.10001191153320.30635-100000@office.knowledge.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
On Wed, 19 Jan 2000, Yury Don wrote:
> >> "Contact" Serial,
> 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.
I'd go along with the previous statement - a serial should only be a
positive number.
What was the schema for the table in MS Access? You may have to change
that (by copying everything into a new table), and then moving it into
Postgres.
What are you using this column for anyway? Is it just an identifier?
Regards,
Mark.
--
Mark Jewiss
Knowledge Matters Limited
http://www.knowledge.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Alliban | 2000-01-19 13:26:56 | Bug in CEIL? |
| Previous Message | Yury Don | 2000-01-19 11:32:12 | Re[2]: [GENERAL] Bug or my crooked hands? |