Re: [ADMIN] Terminating a query that appears to be hung

2007-02-02 Thread Robert D Oden
om the menu. In PHP you'll need to call pg_close function... Every 'client' will have a different method... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert D Oden Sent: Tuesday, 30 January 2007 2:03 AM To: PgSQL ADMIN Subject: [ADMIN]

[ADMIN] Terminating a query that appears to be hung

2007-01-29 Thread Robert D Oden
Is there a way to terminate a client session without having to restart Postgres. Thanks -- Robert D Oden Database Marketing Technologies, Inc 951 Locust Hill Circle Belton MO 64012-1786 Ph: 816-318-8840 Fax: 816-318-8841 [EMAIL PROTECTED] ---(end of broadcast

[ADMIN] Converting CP1252 to UTF-8

2006-11-23 Thread Robert D Oden
UTF-8 encoding Restore the data Thanks in advance, Doug -- Robert D Oden Database Marketing Technologies, Inc 951 Locust Hill Circle Belton MO 64012-1786 Ph: 816-318-8840 Fax: 816-318-8841 [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: don

Re: [ADMIN] closed connection unexpectedly

2005-01-17 Thread Robert D Oden
and recreating or is it possible for Postgres to use the same corrupted location when re-creating the table? Doug Tom Lane wrote: Robert D Oden <[EMAIL PROTECTED]> writes: I am trying to execute the following SQL: create table rdo_tmp0 as select distinct * from rp_na_mm where acct_no like '

[ADMIN] closed connection unexpectedly

2005-01-17 Thread Robert D Oden
I am trying to execute the following SQL: create table rdo_tmp0 as select distinct * from rp_na_mm where acct_no like '1%' and acct_no >= '13873365' This is the result I get: DBD::Pg::db do failed: server closed the connection unexpectedly Postgres Log file: Jan 17 05:06:51 dbs01 postgres[3130]: [8