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: | 4.1.19990922232515.00c16640@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
>
>Michael
>Michael(at)bizsystems(dot)com
>
>************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Haberlach | 1999-09-23 05:45:21 | unsubscribe |
Previous Message | Charles Tassell | 1999-09-23 02:15:50 | Re: [GENERAL] how to emulate a simple case of a view on unions |