Re: INSERT with SELECT not working in pgAdmin - Mailing list pgsql-general

From Stefan Wild
Subject Re: INSERT with SELECT not working in pgAdmin
Date
Msg-id 887590.473.qm@web26702.mail.ukl.yahoo.com
Whole thread Raw
In response to Re: Empty SELECT result at simultaneous calls  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: INSERT with SELECT not working in pgAdmin
List pgsql-general
> Hey Stefan,
>
> The sounds like you have a field "id" in you "c_transactions" without
> default value (which usually should be nextval('some_sequence'::regclass).
> Do you create a sequence for "c_transactions"."id" ?
>

Hi Dmitriy,

yes it's right, the id column does not have a default value and it shouldn't also. What do you mean with "Do you create
asequence for "c_transactions"."id" ?" ? When values are inserted into the table, I find out in my code the next higher
valuefor the id and insert this with the data. 

Thanks, Stefan




pgsql-general by date:

Previous
From: Bryan Murphy
Date:
Subject: Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working
Next
From: Bryan Murphy
Date:
Subject: Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working