oops. I need to update to 7.4.1. Thank you. --elein
On Sat, Jan 31, 2004 at 07:26:38PM -0500, Tom Lane wrote: > 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster