Re: INSERT with SELECT not working in pgAdmin

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: Stefan Wild <wilds81(at)yahoo(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: INSERT with SELECT not working in pgAdmin
Date: 2010-09-20 19:34:59
Message-ID: AANLkTi=-Zx06q78VNdw1pDOmJbG+yBbJWcgH2bcr9rU7@mail.gmail.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" ?

--
Regards,
Dmitriy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2010-09-20 19:38:37 Re: Installing Contrib Modules with a Precompiled Binary
Previous Message Richard Huxton 2010-09-20 19:27:10 Re: to_date conversion semantics?