bug: Bit String Types

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.

Responses

Browse pgadmin-support by date

  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