Ryan Murphy <ryanfmur...@gmail.com> writes: > So I tried using format_type_with_typemod() thinking that the "typemod > info" meant things like NOT NULL, DEFAULT etc.
No, it means atttypmod, which stores info like the max length for varchar(n). > when I was hoping for > user=# alter table temp inherit entity; > ERROR: child table is missing column "id" uuid default uuid_generate_v1mc() > Is there an easy way to get the string that includes all those additional > constraints/defaults etc? No, and TBH I would vote strongly against including that much detail in this error message anyway. That info could be indefinitely long, and it's not especially relevant to the stated error condition --- for example, the presence of a default is *not* relevant to whether the column matches the parent. I'm okay with shoehorning column type into this message, but not much more than that. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers