Re: primary key error with PostgreSQL

[prev] [thread] [next] [Date index for 2005/05/20]

On Fri, May 20, 2005 at 07:03:23AM +0100, cesmky@xxxxx.xxx wrote:
>   itemid INTEGER PRIMARY KEY,

On SQLite this acts as an "auto incrementing" column. So when you don't
give a value for it, SQLite will fill one in for you. This isn't true of
Pg. You either need to give it a value, or add a sequence on that
column if you want an automagic value.

Tony