Re: debian bugrept involving fast default crash in pg11.7

[Tim Bishop]

SELECT attrelid::regclass, * FROM pg_attribute WHERE atthasmissing;
-[ RECORD 1 ]-+---------
attrelid      | download
attrelid      | 22749
attname       | filetype
atttypid      | 1043
attstattarget | -1
attlen        | -1
attnum        | 5
attndims      | 0
attcacheoff   | -1
atttypmod     | 36
attbyval      | f
attstorage    | x
attalign      | i
attnotnull    | t
atthasdef     | t
atthasmissing | t
attidentity   |
attisdropped  | f
attislocal    | t
attinhcount   | 0
attcollation  | 100
attacl        |
attoptions    |
attfdwoptions |
attmissingval | {csv}


On 4/9/20 2:31 PM, Justin Pryzby wrote:

On Thu, Apr 09, 2020 at 02:05:22PM -0400, Tim Bishop wrote:

I've attached a file containing the \d+ for all the tables involved and the
EXPLAIN ANALYZE for the query.

Thanks for your response.

Do you know if you used the "fast default feature" ?
That would happen if you did "ALTER TABLE tbl ADD col DEFAULT val"

I guess this is the way to tell:
SELECT attrelid::regclass, * FROM pg_attribute WHERE atthasmissing;