Skip site navigation (1) Skip section navigation (2)

info schema : cardinal number domain

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 (view raw or flat)
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

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-02-01 00:26:38
Subject: Re: info schema : cardinal number domain
Previous:From: Tom LaneDate: 2004-01-31 18:15:57
Subject: Kerberos as source of user name? (Re: segfault in psql on x86_64)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group