Re: [HACKERS] Vacuum analyze bug CAUGHT

Hiroshi Inoue wrote:
> 
> > crashtest=> vacuum analyze;
> > NOTICE:  Rel pg_type: TID 4/3: InsertTransactionInProgress 129915
> > - can't shrink relation
...
> 
> CREATE TABLE doesn't lock system tables till end of transaction.
> It's a cause of these NOTICE messages.
> 
> Should we lock system tables till end of transaction ?

No, if we allow DDL statements inside BEGIN/END
(in long transaction).

> Moreover CREATE TABLE doesn't acquire any lock for pg_attribute
>                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> while tuples are inserted into pg_attribute.
> Concurrent vacuum may corrupt pg_attribute.

Should be fixed!

Vadim