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

2012-07-17 Thread Brian McNally
en't been able to find 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

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

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

2012-08-08 Thread Brian McNally
mple_query (query_string=0x95e3310 "alter table samples add column esp_race text;") at postgres.c:1060 #13 0x005f6ff4 in PostgresMain (argc=, argv=, username=) at postgres.c:3978 #14 0x005c6e35 in ServerLoop () at postmaster.c:3565 #15 0x005c7b3c in PostmasterM

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 wrote: RHEL 5.7 on both. 2.6.18-274.el5 on the system that

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

2012-08-10 Thread Brian McNally
seems 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