From: | "Michael" <michael(at)bizsystems(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [GENERAL] data type "serial" |
Date: | 1999-09-23 00:45:24 |
Message-ID: | 199909222345.QAA16334@bzs.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> >
> > So how do you store something in data type serial?
> > I've created the column but everytime I attempt to do an update I get
> > back the error message that I can't store a duplicate key.
> >
> > table_col_seq.last_value = 1
> > increment = 1
> > maxvalue = 2billion something
> >
> > I've tried storing 1,2,some other number in "serial" in the main
> > table to no avail. What is the magic to get this to work. There
> > appears to be no documentation anywhere on the necessary SQL commands
> > to cycle the generator. I've tried the method used for Oracle SQL but
> > that does not work. I'm a bit of a newbie at this.
> >
> > Michael
> > Michael(at)bizsystems(dot)com
>
> You cant insert into a serial as far as I know.
>
> The serial is simply incrimented automatically whenever a new INSERT
> is done on the table.
Hmmm.... that's a real problem when adding it to an existing table.
The values I get back on a select indicate all blanks. I've got
several hundred records in the table at the moment. There must be a
way to update the darn things.
Michael
Michael(at)bizsystems(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Charles Tassell | 1999-09-23 02:15:50 | Re: [GENERAL] how to emulate a simple case of a view on unions |
Previous Message | Michael Simms | 1999-09-23 00:34:29 | Re: [GENERAL] data type "serial" |