Postgres Pro
Downloads
Home   >   mailing lists

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

From Dmitriy Igrishin
Subject Re: INSERT with SELECT not working in pgAdmin
Date
Msg-id AANLkTi=-Zx06q78VNdw1pDOmJbG+yBbJWcgH2bcr9rU7@mail.gmail.com
Whole thread Raw
In response to INSERT with SELECT not working in pgAdmin  (Stefan Wild <wilds81@yahoo.de>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: to_date conversion semantics?
Next
From: Dave Page
Date:
Subject: Re: Installing Contrib Modules with a Precompiled Binary