Re: info schema : cardinal number domain - Mailing list pgsql-bugs

From Tom Lane
Subject Re: info schema : cardinal number domain
Date
Msg-id 9643.1075595198@sss.pgh.pa.us
Whole thread Raw
In response to info schema : cardinal number domain  (elein <elein@varlena.com>)
Responses Re: info schema : cardinal number domain
List pgsql-bugs
elein <elein@varlena.com> writes:
> When creating a table with a bit type
> of length less than 4, then any selection
> to the information.schema.columns table
> that hits that row gives the following error:
> -- ERROR:  value for domain cardinal_number violates check constraint "cardinal_number_domain_check"

This is fixed as of 7.4.1, along with several other information_schema
bugs.  If you have a database that was initdb'd under 7.4, you can load
the corrected views without re-initdb'ing: as superuser, DROP the
information_schema and execute the updated information_schema.sql file
(look in $INSTALLDIR/share).

            regards, tom lane

pgsql-bugs by date:

Previous
From: elein
Date:
Subject: info schema : cardinal number domain
Next
From: elein
Date:
Subject: Re: info schema : cardinal number domain