Re: [ADMIN] primary key and insert

2008-12-11 Thread Suresh Borse
Create a sequence and use the sequence in your insert statement. On Thu, 2008-12-11 at 15:27 -0800, Marc Fromm wrote: > I created this table: >Column | Type | Modifiers > ++ >first_name | charact

Re: [ADMIN] primary key and insert

2008-12-11 Thread johnf
On Thursday 11 December 2008 03:27:59 pm Marc Fromm wrote: >  id         | integer                       | not null I believe you did not set the field 'id' to a data type of serial. If you had you would have "nextval(" in the Modifiers column. -- John Fabiani -- Sent via pgsql-admin mailing

Re: [ADMIN] primary key and insert

2008-12-11 Thread Steve Crawford
Marc Fromm wrote: I created this table: ... id | integer | not null Indexes: "alert_list_pkey" PRIMARY KEY, btree (id) I get this error when I run the insert a listed below. The insert does not have an entry for the primary key "id" since I thought it upd

[ADMIN] primary key and insert

2008-12-11 Thread Marc Fromm
I created this table: Column | Type | Modifiers ++ first_name | character varying(20) | last_name | character varying(30) | w_number | character varying(9)| alert | character va