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
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
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
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