bug: Bit String Types / question: edit view

Поиск
Список
Период
Сортировка
От Pfuetz, Michael
Тема bug: Bit String Types / question: edit view
Дата
Msg-id CEA9200E8DACA943855F9AB11C3D7A472C5D00@GONEXCL2.Sartorius.com
обсуждение исходный текст
Список pgadmin-support
<p><font face="Arial" size="2">Hello,</font><p><font face="Arial" size="2">i think there are 2 bugs in
pgadmin:</font><br/><font face="Courier New" size="2">CREATE TABLE test_bit</font><br /><font face="Courier New"
size="2">(</font><br/><font face="Courier New" size="2">  id text NOT NULL,</font><br /><font face="Courier New"
size="2"> byte bit(8) NOT NULL,</font><br /><font face="Courier New" size="2">  CONSTRAINT test_bit_pkey PRIMARY KEY
(id)</font><br/><font face="Courier New" size="2">) </font><br /><font face="Courier New" size="2">WITHOUT
OIDS;</font><br/><font face="Courier New" size="2">ALTER TABLE test_bit OWNER TO assux;</font><p><font face="Arial"
size="2">Insertwith pgadmin:</font><br /><font face="Courier New" size="2">hello,10101010</font><br /><font
face="Arial"size="2">German error: Länge der Bitkette 1 stimmt nicht mit Typ bit(8) überein</font><br /><font
face="Arial"size="2">my translation: The length of the Bit string 1 is not conform to type bit(8)</font><p><font
face="Arial"size="2">Insert with psql:</font><br /><font face="Courier New" size="2">INSERT INTO test_bit (id,byte)
VALUES('hello', B'10101010');</font><br /><font face="Courier New" size="2">INSERT 0 1</font><p><font face="Courier
New"size="2">-------------------</font><p><font face="Courier New" size="2">CREATE OR REPLACE FUNCTION
test_procedure(INbit1 "bit", OUT bit_out "bit") AS</font><br /><font face="Courier New"
size="2">$BODY$DECLARE</font><br/><font face="Courier New" size="2">BEGIN</font><br /><font face="Courier New"
size="2"> bit_out := bit1;</font><br /><font face="Courier New" size="2">END;$BODY$</font><br /><font face="Courier
New"size="2">  LANGUAGE 'plpgsql' VOLATILE;</font><br /><font face="Courier New" size="2">ALTER FUNCTION
test_procedure(INbit1 "bit", OUT bit_out "bit") OWNER TO assux;</font><p><font face="Arial" size="2">by editing with
pgadminthe resolve sql-statment is wrong</font> <font face="Courier New" size="2">(""bit""</font><font face="Arial"
size="2">):</font><br/><font face="Courier New" size="2">CREATE OR REPLACE FUNCTION test_procedure(IN bit1 ""bit"", OUT
bit_out""bit"") AS</font><br /><font face="Courier New" size="2">$BODY$DECLARE</font><br /><font face="Courier New"
size="2">BEGIN</font><br/><font face="Courier New" size="2">  bit_out := bit1;</font><br /><font face="Courier New"
size="2">END;$BODY$</font><br/><font face="Courier New" size="2">LANGUAGE 'plpgsql' VOLATILE;</font><p><font
face="CourierNew" size="2">-------------------</font><p><font face="Arial" size="2">Is it possible to edit an view with
pgadmin?I add the rules:</font><br /><font face="Courier New" size="2">ON UPDATE TO,</font><br /><font face="Courier
New"size="2">ON INSERT TO,</font><br /><font face="Courier New" size="2">ON DELETE TO</font><p><font face="Courier New"
size="2">MyPgadmin Version:</font><br /><font face="Courier New" size="2">1.6.2 (Jan 6 2007, rev: 5837), Windows XP,
SP2</font><br/><font face="Courier New" size="2">1.6.2 (Dec 14 2006, rev: 5784), SuSE Linux 10.0</font><p><font
face="Arial"size="2">I hope you can help my.</font><p><font face="Arial" size="2">Best regards<b></b></font><p><b><font
face="Arial"size="2">Michael Pfütz</font></b><br /><br /><a href="http://www.blackspider.com/"><font color="#000000"
style="BACKGROUND-COLOR:#ffffff"></font></a><p><br />Disclaimer : <p>The information contained in this e-mail is
intendedonly 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.<p
align="center"> 

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

Предыдущее
От: Mathias Durst
Дата:
Сообщение: Bug in Exporter V1.6.X
Следующее
От: Dave Page
Дата:
Сообщение: Re: Re : Backup file not UTF-8 (introduced bug