GetSchema causes PostgreSQL Log Warnings

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
jjones
Posts: 1
Joined: Fri 05 Mar 2010 18:49
Location: San Diego, CA

GetSchema causes PostgreSQL Log Warnings

Post by jjones » Fri 05 Mar 2010 19:01

Calling this method:

Code: Select all

tables = Connection.GetSchema(PgSqlMetaDataCollectionNames.Tables, new string[] { null, table, null, null });
Causes these warnings in the PostgreSQL log file:
2010-03-05 10:41:35 PST WARNING: nonstandard use of escape in a string literal at character 1066
2010-03-05 10:41:35 PST HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
2010-03-05 10:41:35 PST WARNING: nonstandard use of escape in a string literal at character 1118
2010-03-05 10:41:35 PST HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.
Currently using version 3.75.31.0

Is this a bug that has been fixed in a later version, or is there something else I can do?

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Tue 09 Mar 2010 16:58

The problem is connected with the fact that escape symbols are processed differently in old and newer versions of PostgreSQL. Please refer to the PostgreSQL documentation for details.

Provided that you use PostgreSQL of version less than 8.3, or, for newer versions, that you have the standard_conforming_strings server variable set to 'off', these warnings are just informational and may be ignored.

We will fix the issue in one of the nearest builds.

StanislavK
Devart Team
Posts: 1710
Joined: Thu 03 Dec 2009 10:48

Post by StanislavK » Wed 31 Mar 2010 16:52

We have changed the queries retrieving metadata to support the newer format of PostgreSQL escape symbols.

Please try the new 4.90.120 build of dotConnect for PostgreSQL. It can be downloaded from
http://www.devart.com/dotconnect/postgr ... nload.html
(trial version) or from Registered Users' Area (for users with valid subscription only).

For more information, please refer to
http://www.devart.com/forums/viewtopic.php?t=17517.

Post Reply