On tor, 2010-01-28 at 10:34 -0500, Tom Lane wrote:
> Heikki Linnakangas <heikki.linnakan...@enterprisedb.com> writes:
> > ISTM you should explicitly grab a lock on the of-type at some point, to
> > make sure it doesn't get dropped while you're busy creating the table.
> > How do we protect against that for the types used in columns?
> 
> We don't.  There is no concept of a lock on a type.
> 
> For scalar types this is more or less irrelevant anyway, since a scalar
> has no substructure that can be altered in any interesting way.  I'm not
> sure how hard we ought to work on making composites behave differently.
> I think it's as likely to cause problems as solve them.

The right thing would probably be SELECT FOR SHARE on the pg_type row,
but I don't see that sort of thing used anywhere else in system catalog
changes.


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to