Postgres Pro
Downloads
Home   >   mailing lists

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 227547.73029.qm@web26708.mail.ukl.yahoo.com
Whole thread Raw
In response to INSERT with SELECT not working in pgAdmin  (Stefan Wild <wilds81@yahoo.de>)
List pgsql-general
Tree view 
Ok I found the solution. I have to use the UPDATE command and not the INSERT:

UPDATE c_transactions SET timestamp = entrytimestamp

and than:

UPDATE c_transactions SET timestamp = exittimestamp WHERE exittimestamp IS NOT NULL

pgsql-general by date:

Previous
From: Peter Hopfgartner
Date:
Subject: Re: Getting FATAL: terminating connection due to administrator command
Next
From: Dmitriy Igrishin
Date:
Subject: Re: INSERT with SELECT not working in pgAdmin