Re: [GENERAL] Problem running ALTER TABLE..., ALTER TABLE waiting

2012-08-10 Thread Brian McNally
that maybe there is prepared transaction that could be holding up the ALTER TABLE. I'm a bit confused though since previous attempts to find that didn't succeed. Maybe I just haven't used to correct query yet. -- Brian McNally On 08/09/2012 12:30 AM, Sergey Konoplev wrote: On Thu, Aug 9, 2012 at 4

Re: [GENERAL] Problem running ALTER TABLE..., ALTER TABLE waiting

2012-08-08 Thread Brian McNally
) at main.c:188 === -- Brian McNally On 08/02/2012 05:57 AM, Sergey Konoplev wrote: Hi Brian, On Wed, Aug 1, 2012 at 10:21 PM, Brian McNally bmcna...@uw.edu wrote: I was able to upgrade Postgres to 9.0.8 today and the ALTER TABLE... command still hangs. Stracing the hung PID doesn't reveal much

Re: [GENERAL] Problem running ALTER TABLE..., ALTER TABLE waiting

2012-08-08 Thread Brian McNally
Ok, I'm running with all available updates and kernel 2.6.18-308.4.1.el5 but am still having the same problem. -- Brian McNally On 08/07/2012 05:29 PM, Sergey Konoplev wrote: On Wed, Aug 8, 2012 at 4:27 AM, Brian McNally bmcna...@uw.edu wrote: RHEL 5.7 on both. 2.6.18-274.el5 on the system

Re: [GENERAL] Problem running ALTER TABLE..., ALTER TABLE waiting

2012-07-18 Thread Brian McNally
Hi Raghu, I don't get any rows returned back from that query. I'm running it while connected to the DB in question. Am I supposed to substitute values for any of the variables in the query? -- Brian McNally On 07/17/2012 07:23 PM, raghu ram wrote: On Wed, Jul 18, 2012 at 1:24 AM, Brian

[GENERAL] Problem running ALTER TABLE..., ALTER TABLE waiting

2012-07-17 Thread Brian McNally
it. Any ideas? Thanks for any help, -- Brian McNally -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general