Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] data type "serial"

From: Charles Tassell <ctassell(at)isn(dot)net>
To: pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] data type "serial"
Date: 1999-09-23 02:28:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
If you have this table:

create table testing (
	id	serial,
	data	text,
	md	int

You would use:

insert into testing (data, md) values ('my_data', 12);
insert into testing (data, md) values ('more data', 15);

The key part is that you don't specify the serial field in your insert command.

Anyway, hope this helps.

At 09:45 PM 9/22/99, 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. 
>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.

In response to

pgsql-general by date

Next:From: Adam HaberlachDate: 1999-09-23 05:45:21
Subject: unsubscribe
Previous:From: Charles TassellDate: 1999-09-23 02:15:50
Subject: Re: [GENERAL] how to emulate a simple case of a view on unions

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group