From: | Teodor Cimpoesu <teo(at)digiro(dot)net> |
---|---|
To: | |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] data type "serial" |
Date: | 1999-09-23 00:08:25 |
Message-ID: | 37E96F79.57C2CE6B@digiro.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Michael wrote:
>
> > >
> > > 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.
? you can create another serial, starting @ max(serial attr)+1
> 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.
it should not, how do you make that select 7 what's the table
definition?
>
> Michael
> Michael(at)bizsystems(dot)com
>
> ************
--
CIMPOESU Teodor, Web Programmer (h)
@ DIGICOM S.A. Bucharest, Romania
@ Internet, site development
@ teo(at)digiro(dot)net, +(401)-330.47.28
official home page ~ http://www.digiro.net/
Internet web page ~ http://internet.digiro.net/
From | Date | Subject | |
---|---|---|---|
Next Message | Michael | 1999-09-23 00:17:31 | data type "serial" |
Previous Message | Michael Simms | 1999-09-22 23:36:58 | Re: [GENERAL] data type "serial" |