From: | elein <elein(at)varlena(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | elein <elein(at)varlena(dot)com> |
Subject: | info schema : cardinal number domain |
Date: | 2004-01-31 22:57:09 |
Message-ID: | 20040131145709.Y14914@cookie.varlena.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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:
drop table infoschema_bit;
create table infoschema_bit (
bitcol bit(3)
);
select * from columns;
-- ERROR: value for domain cardinal_number violates check constraint "cardinal_number_domain_check"
There may be other places where this hits.
I ran into it creating an "alltypes" table for
an example and just grabbed the bit(3) from the
documentation on the bit type.
This is relatively low priority as I suspect
few people use both the information schema AND
small bit types right now.
elein(at)varlena(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-02-01 00:26:38 | Re: info schema : cardinal number domain |
Previous Message | Tom Lane | 2004-01-31 18:15:57 | Kerberos as source of user name? (Re: segfault in psql on x86_64) |