Re: insert statement woes - Mailing list pgsql-sql

From Rodrigo De León
Subject Re: insert statement woes
Date
Msg-id 1182528191.769825.63870@p77g2000hsh.googlegroups.com
Whole thread Raw
List pgsql-sql
On Jun 22, 3:25 am, earthwormgaz <earthworm...@googlemail.com> wrote:
> hello, i'm trying to do a simple (so i thought) sql insert operation,
> but i'm being told the insert violates unique constraint
> say i've got three columns, two text and one integer for the id, i'm
> doing the following
> INSERT INTO myTable (text1, text2) VALUES ('some text', 'some more
> text');
> so i'm not trying to enter anything into the key column, i thought a
> unique one should be generated for me?

DDL please...



pgsql-sql by date:

Previous
From: Jean-David Beyer
Date:
Subject: Embedded C++ with ecpg?
Next
From: Richard Huxton
Date:
Subject: Re: Transactions and Exceptions