npgsql and standard_conforming_strings

From: William Garrison <postgres(at)mobydisk(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: npgsql and standard_conforming_strings
Date: 2007-05-08 16:16:10
Message-ID: 4640A24A.6040508@mobydisk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I use npgsql 1.0 to access a PostgreSql 8.2.3 database. Recently, I
decided to test with standard_conforming_strings = on and I noticed that
npgsql still sends double-backslashes, which corrupts the data.

This is especially bad with byte arrays: if I insert N bytes I get back
4*N bytes because \123 (one byte) becomes \\123 (4 bytes).

Is this a bug in npgsql, or is there some way I can get npgsql to
realize that postgres is using standard_conforming_strings?

Thanks,
Bill

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-08 16:34:46 Re: Building Pg 8.2.4 on AIX 5.3 doesn't produce shared libs?
Previous Message Sic Transit Gloria Mundi 2007-05-08 16:14:41 Building Pg 8.2.4 on AIX 5.3 doesn't produce shared libs?