bug: Bit String Types

Поиск
Список
Период
Сортировка
От Pfuetz, Michael
Тема bug: Bit String Types
Дата
Msg-id CEA9200E8DACA943855F9AB11C3D7A470389C125@GONEXCL2.Sartorius.com
обсуждение исходный текст
Ответы Re: bug: Bit String Types  ("Dave Page" <dpage@pgadmin.org>)
Список pgadmin-support
<p><font face="Arial" size="2">Hello,</font><font face="Arial"> </font><p><font face="Arial" size="2">i think there is
bugsin pgadmin:</font><font face="Arial"><br /></font><font face="Courier New" size="2">CREATE TABLE
test_bit</font><fontface="Arial"><br /></font><font face="Courier New" size="2">(</font><font face="Arial"><br
/></font><fontface="Courier New" size="2">  id text NOT NULL,</font><font face="Arial"><br /></font><font face="Courier
New"size="2">  byte bit(8) NOT NULL,</font><font face="Arial"><br /></font><font face="Courier New" size="2"> 
CONSTRAINTtest_bit_pkey PRIMARY KEY (id)</font><font face="Arial"><br /></font><font face="Courier New"
size="2">)</font><br/><font face="Courier New" size="2">WITHOUT OIDS;</font><font face="Arial"><br /></font><font
face="CourierNew" size="2">ALTER TABLE test_bit OWNER TO assux;</font><font face="Arial"> </font><p><font face="Arial"
size="2">Insertwith pgadmin:</font><font face="Arial"><br /></font><font face="Courier New"
size="2">hello,10101010</font><fontface="Arial"><br /></font><br /><font face="Arial" size="2">ERROR: bit string length
1does not match type bit(8)</font><p><font face="Arial" size="2">Insert with psql:</font><font face="Arial"><br
/></font><fontface="Courier New" size="2">INSERT INTO test_bit (id,byte) VALUES ('hello', B'10101010');</font><font
face="Arial"><br/></font><font face="Courier New" size="2">INSERT 0 1</font><font face="Arial"> </font><p><font
face="CourierNew" size="2">My Pgadmin Version:<br /> 1.8.4, Windows XP, SP2<br /> 1.9.0-dev, Windows XP, SP2</font><br
/><fontface="Courier New" size="2">1.8.4, Linux SuSE 11.0</font><p><font face="Courier New" size="2">PostgreSQL
Version:</font><br/><font face="Courier New" size="2">8.2.4, SuSE 10.0</font><br /><font face="Courier New"
size="2">8.3.1,SuSE 11.0</font><p><span lang="zh-cn"><font color="#0000FF" face="SartoriusRotisMail">Thanks a lot in
advance!</font></span><p><spanlang="de"><b><font face="Arial" size="2">Michael Pfütz</font></b><font face="Arial">
</font></span><br/><br /><a href="http://www.blackspider.com/"><font color="#000000" style="BACKGROUND-COLOR:
#ffffff"></font></a><p><br/><font face="Arial" size="2">Disclaimer :</font><p>The information contained in this e-mail
isintended only for the individual<br />addressed. If you have received this e-mail by mistake, please notify us<br
/>immediatelyby return reply. Be sure to delete this message and all its<br />attachments from your system. Please note
thatany unauthorized review,<br />copying, disclosure or any other use of this information is strictly<br />prohibited.
E-mailtransmission cannot be guaranteed to be secure or<br />error-free as information could be intercepted, corrupted,
lost,destroyed,<br />received late or incomplete, or could contain viruses. The sender therefore<br />does not accept
anyliability for any error or omission in the content of<br />this message, either of which are caused as a result of
e-mailtransmission.<br />If verification is required, please request a hard-copy version. <br />Thank you. 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Julius Tuskenis
Дата:
Сообщение: Re: problem with check constraints
Следующее
От: Romaric SANKARA
Дата:
Сообщение: Demande de la documentation