On 01/07/2017 08:15 PM, Tom Lane wrote: > Ryan Murphy <ryanfmur...@gmail.com> writes: >> 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.
I agree. Perhaps the ERROR message should remain as is, and a DETAIL or HINT line could be emitted with the entire column definition (or close to it)? -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers