This is fixed in the current CVS tree.
> Billy G. Allie ([EMAIL PROTECTED]) reports a bug with a severity of 2
> The lower the number the more severe it is.
>
> Short Description
> Can't insert a value of 0 (zero) into a Bytea type.
>
> Long Description
> It does not zeem possible to insert a value of zero (0) into a bytea type. Also,
>using '\134' (the octal code for a backslash) causes byteain() to generate an error
>message.
>
> As a side issue, how can one tell a backslash followed by 3 digits (four bytes of
>data) from an encoded byte of data? It seems to me that byteaout() should always
>output an octal escape sequence per byte, even if the character is printable. That
>way the result is unambiguous in meaning (even if it is wasteful of bytes).
>
> Sample Code
> bga=# select version();
> version
> -----------------------------------------------------------
> PostgreSQL 7.1.3 on i586-sco-sysv5uw7.1.1, compiled by cc
> (1 row)
> bga=# create table test6 (a bytea);
> CREATE
> bga=# insert into test6 values('\001\002\354ab\000de\004');
> INSERT 163734 1
> bga=# select * from test6;
> a
> ----------------
> \001\002\354ab
> (1 row)
>
> Note: It is possible to workaround (i.e. fake out postgresSQL) by inserting a
>backslash followsd by 3 zeros (a total of 4 bytes) into the bytea type. For example:
>
> bga=# insert into test6 values('\001\002\354ab\\000de\004');
> INSERT 163735 1
> bga=# select * from test6;
> a
> --------------------------
> \001\002\354ab
> \001\002\354ab\000de\004
> (2 rows)
>
> This also illustrates another problem with bytea types. How does one tell the
>difference between a backslash followed by 3 digits (four bytes of data) for an
>encoded (single) byte of data?
>
> The problem with using '\134' as input to a bytea field is illustrated here:
>
> bga=# insert into test6 values('\134');
> ERROR: Bad input string for type bytea
> bga=#
>
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Bruce Momjian | http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
