Re: BUG #11321: describe command is getting locked due to ALTER statement running on public table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #11321: describe command is getting locked due to ALTER statement running on public table
Date
Msg-id 11249.1409590914@sss.pgh.pa.us
Whole thread Raw
In response to BUG #11321: describe command is getting locked due to ALTER statement running on public table  (adurugkar@xento.com)
List pgsql-bugs
adurugkar@xento.com writes:
> describe command is getting locked due to ALTER statement running on real
> table.

This isn't a bug IMO; if anything, it's a bug that the old implementation
of pg_get_indexdef didn't result in acquiring any lock.  Without a lock,
you're at least at risk of printing garbage information, and I suspect
crashes were not out of the question.

> It was working fine on 9.3.4 version.

I rather doubt this behavior changed just in 9.3.5.  That code got
rewritten during 9.3 development.

            regards, tom lane

pgsql-bugs by date:

Previous
From: adurugkar@xento.com
Date:
Subject: BUG #11321: describe command is getting locked due to ALTER statement running on public table
Next
From: thomas@landauer.at
Date:
Subject: BUG #11325: Documentation Bug / RFE