elein <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend