Re: INSERT with SELECT not working in pgAdmin

From: Stefan Wild <wilds81(at)yahoo(dot)de>
To: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT with SELECT not working in pgAdmin
Date: 2010-09-21 15:33:26
Message-ID: 887590.473.qm@web26702.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 a sequence for "c_transactions"."id" ?" ? When values are inserted into the table, I find out in my code the next higher value for the id and insert this with the data.

Thanks, Stefan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bryan Murphy 2010-09-21 15:45:06 Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working
Previous Message Bryan Murphy 2010-09-21 15:26:04 Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working