Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-14 Thread Vick Khera
On Tue, Dec 14, 2010 at 11:22 AM, tuanhoanganh wrote: > Thanks for your answer. But I don't want to change db config or ALTER > DATABASE data SET bytea_output='escape'; > I can change my app. So is there document introduce how to work with > postgresql 9 bytea Your .Net or whatever library you're

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-14 Thread Francisco Figueiredo Jr.
Latest Npgsql version 2.0.11 already has a fix to handle new bytea representation. Can you try with this version and see if it works ok? I hope it helps. On Tue, Dec 14, 2010 at 14:22, tuanhoanganh wrote: > Thanks for your answer. But I don't want to change db config or ALTER > DATABASE data SE

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-14 Thread Tom Lane
tuanhoanganh writes: > Thanks for your answer. But I don't want to change db config or ALTER > DATABASE data SET bytea_output='escape'; > I can change my app. So is there document introduce how to work with > postgresql 9 bytea ( I don't want to user lo_create, lo_import. lo_export) http://www.po

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-14 Thread tuanhoanganh
Thanks for your answer. But I don't want to change db config or ALTER DATABASE data SET bytea_output='escape'; I can change my app. So is there document introduce how to work with postgresql 9 bytea ( I don't want to user lo_create, lo_import. lo_export) Tuan Hoang Anh On Tue, Dec 14, 2010 at 8:5

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-14 Thread Ivan Voras
On 14/12/2010 14:51, tuanhoanganh wrote: Thanks for your help. Is there any .Net or VB tutorial new 9.0 bytea? You do not need to change your code if you add bytea_output = 'escape' # hex, escape into postgresql.conf. -- Sent via pgsql-general mailing list (pgsql-general@po

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-14 Thread tuanhoanganh
Thanks for your help. Is there any .Net or VB tutorial new 9.0 bytea? Tuan Hoang Anh On Tue, Dec 14, 2010 at 1:27 PM, Mark Felder wrote: > On Mon, 13 Dec 2010 23:06:32 -0600, tuanhoanganh > wrote: > > I have program work with bytea, this field store image. Program work well >> in >> postgresq

Re: [GENERAL] Bytea error in PostgreSQL 9.0

2010-12-13 Thread Mark Felder
On Mon, 13 Dec 2010 23:06:32 -0600, tuanhoanganh wrote: I have program work with bytea, this field store image. Program work well in postgresql 8.3.9 but error in postgresql 9.0 I don't know if this is your problem, but bytea changed in Postgres 9.0. Could you try enabling "set bytea_ou

[GENERAL] Bytea error in PostgreSQL 9.0

2010-12-13 Thread tuanhoanganh
I have program work with bytea, this field store image. Program work well in postgresql 8.3.9 but error in postgresql 9.0 Here is code to write image to database FileStream srcStream = new FileStream(file_name, FileMode.Open, FileAccess.Read); byte[] arrImage = new byte[srcStream.Length]; int read

[GENERAL] Bytea error in PostgreSQL 9.0

2010-12-13 Thread tuanhoanganh
I have program work with bytea, this field store image. Program work well in postgresql 8.3.9 but error in postgresql 9.0 Here is code to write image to database FileStream srcStream = new FileStream(file_name, FileMode.Open, FileAccess.Read); byte[] arrImage = new byte[srcStream.Length]; int read