going crazy with serial type

From: Cindy <ctmoore(at)uci(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: going crazy with serial type
Date: 2002-01-31 19:40:56
Message-ID: 6387.1012506056@attalus.tlg.uci.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


OK. My background is in mysql, and I've been converting over to psql. Just
by way of background.

I do !NOT! understand how the SERIAL type works. I want something
like I had in mysql that would generate new, unique numbers, each time
I added a new record. I want something that sits down, shuts up, and
just GIVES me the number on demand. (I also want a guarantee that the
unique number is consecutive, and is never zero or negative.) In short,
I want the AUTO_INCREMENT behavior.

But so far it's been one giant headache. Tell me, how do I insert
new records into a table *without* specifying an actual number? In
mysql it's just an empty field. I have been unable to determine how
to do this in psql other than to ascertain it certainly isn't through
the same way.

I've been through the documentation, but for some reason, no one seems
to think a programmer would ever want functionality like mysql's
AUTO_INCREMENT, so as far as I can tell, it's not even addressed.

I'd appreciate any help. I basically have a table:

create table mytable (mytable_id serial, a int, b int);

and

insert into mytable ('', 1, 2); is accepted but then following
insert into mytable ('', 5, 6); etc, is rejected due to "duplicate key"

Thanks,
--Cindy
--
ctmoore(at)uci(dot)edu

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2002-01-31 19:49:03 Re: Function to Pivot data
Previous Message Gregory Wood 2002-01-31 19:35:19 Re: unique & update