Re: [GENERAL] overwrite column data select - Postgres 9.2

2016-09-20 Thread John R Pierce
On 9/20/2016 10:56 PM, Patrick B wrote: update table tablename set email = 'test@example.com '; ? I can't overwrite the data into that column... I was hopping that in a SELECT I could replace the data from the email column to something else... sel

Re: [GENERAL] overwrite column data select - Postgres 9.2

2016-09-20 Thread Rick Widmer
I was hopping that in a SELECT I could replace the data from the email column to something else... maybe email = name_first + name_last? Is that possible? I can't overwrite the data into that column... that has to be done by the select (if possible) SELECT , , ..., name_first || ' ' || name_

Re: [GENERAL] overwrite column data select - Postgres 9.2

2016-09-20 Thread Patrick B
2016-09-21 17:27 GMT+12:00 John R Pierce : > On 9/20/2016 10:02 PM, Patrick B wrote: > > I've got a table with email column: > >> email CHARACTER VARYING(50) DEFAULT ''::CHARACTER VARYING NOT NULL, > > > There are 30k rows and the email column is not null... there is data in > there. > But for tes

Re: [GENERAL] overwrite column data select - Postgres 9.2

2016-09-20 Thread John R Pierce
On 9/20/2016 10:02 PM, Patrick B wrote: I've got a table with email column: email CHARACTER VARYING(50) DEFAULT ''::CHARACTER VARYING NOT NULL, There are 30k rows and the email column is not null... there is data in there. But for testing purpose I need to overwrite the email. So the cust

Re: [GENERAL] overwrite column data select - Postgres 9.2

2016-09-20 Thread amul sul
​First try to get backup using pg_dump & replace all data in email column. Restore table backup once you done with your testing. Regards, Amul. On Wed, Sep 21, 2016 at 10:32 AM, Patrick B wrote: > Hi guys, > > I've got a table with email column: > >> email CHARACTER VARYING(50) DEFAULT ''::CH

[GENERAL] overwrite column data select - Postgres 9.2

2016-09-20 Thread Patrick B
Hi guys, I've got a table with email column: > email CHARACTER VARYING(50) DEFAULT ''::CHARACTER VARYING NOT NULL, There are 30k rows and the email column is not null... there is data in there. But for testing purpose I need to overwrite the email. So the customer won't get an email from me whi

[GENERAL] PQexecFinish blocked forever in localhost also

2016-09-20 Thread sangeetha
Hi, PQexecFinish blocked in pqsocketpoll. As per blogs, it will not happen in localhost. We are using Postgres9.4 and server is running locally. Still it blocks in PQExecFinish. Since our application is multithreaded, We are using semaphore for each DB connection. please guide how to proceed. T