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

Bug #767: Bug when inserting in "bytea" column type

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #767: Bug when inserting in "bytea" column type
Date: 2002-09-14 20:41:36
Message-ID: 20020914204136.F2EB8475E26@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Roman A.Grigorovich (atz(at)atz(dot)msk(dot)ru) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
Bug when inserting in "bytea" column type

Long Description
PosgreSQL version 7.2.2
./configure --prefix=/usr/local/pgsql --enable-multibyte=WIN --cache-file=/dev/null

In "psql" command line tool:
CREATE TABLE IMAGES (ID SERIAL,NAME VARCHAR(32), DATA BYTEA);
and then i type.

INSERT INTO IMAGES (NAME,DATA) VALUES ('image1','\377\000\556\211\000');

after this i do next:
SELECT * FROM IMAGES;
and result of this query was:
ID     |   NAME     |   DATA
1          image1       \377

all data after '\000' have been missed. Is this a bug?
>From PHP 4.0.6-client this work the same.



Sample Code


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2002-09-14 20:49:10
Subject: Re: Bug #767: Bug when inserting in "bytea" column type
Previous:From: Tom LaneDate: 2002-09-14 15:46:11
Subject: Re: Bug #766: version difference creates problem

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