From: | "Pfuetz, Michael" <Michael(dot)Pfuetz(at)SARTORIUS(dot)com> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | bug: Bit String Types |
Date: | 2008-10-09 12:45:50 |
Message-ID: | CEA9200E8DACA943855F9AB11C3D7A470389C125@GONEXCL2.Sartorius.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hello,
i think there is bugs in pgadmin:
CREATE TABLE test_bit
(
id text NOT NULL,
byte bit(8) NOT NULL,
CONSTRAINT test_bit_pkey PRIMARY KEY (id)
)
WITHOUT OIDS;
ALTER TABLE test_bit OWNER TO assux;
Insert with pgadmin:
hello,10101010
ERROR: bit string length 1 does not match type bit(8)
Insert with psql:
INSERT INTO test_bit (id,byte) VALUES ('hello', B'10101010');
INSERT 0 1
My Pgadmin Version:
1.8.4, Windows XP, SP2
1.9.0-dev, Windows XP, SP2
1.8.4, Linux SuSE 11.0
PostgreSQL Version:
8.2.4, SuSE 10.0
8.3.1, SuSE 11.0
Thanks a lot in advance!
Michael Pfütz
Disclaimer :
The information contained in this e-mail is intended only for the individual
addressed. If you have received this e-mail by mistake, please notify us
immediately by return reply. Be sure to delete this message and all its
attachments from your system. Please note that any unauthorized review,
copying, disclosure or any other use of this information is strictly
prohibited. E-mail transmission cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost, destroyed,
received late or incomplete, or could contain viruses. The sender therefore
does not accept any liability for any error or omission in the content of
this message, either of which are caused as a result of e-mail transmission.
If verification is required, please request a hard-copy version.
Thank you.
From | Date | Subject | |
---|---|---|---|
Next Message | Romaric SANKARA | 2008-10-11 10:33:06 | Demande de la documentation |
Previous Message | Julius Tuskenis | 2008-10-09 07:50:39 | Re: problem with check constraints |