If you have this table:
create table testing (
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 Haberlach||Date: 1999-09-23 05:45:21|
|Previous:||From: Charles Tassell||Date: 1999-09-23 02:15:50|
|Subject: Re: [GENERAL] how to emulate a simple case of a view on unions|