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