Re: info schema : cardinal number domain

From: elein <elein(at)varlena(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: elein <elein(at)varlena(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: info schema : cardinal number domain
Date: 2004-02-01 00:52:41
Message-ID: 20040131165241.Z14914@cookie.varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 <elein(at)varlena(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PostgreSQL Bugs List 2004-02-02 14:47:13 BUG #1072: "$libdir/ascii_and_mic": No such file or directory
Previous Message Tom Lane 2004-02-01 00:26:38 Re: info schema : cardinal number domain