GetSchema causes PostgreSQL Log Warnings

GetSchema causes PostgreSQL Log Warnings

Postby 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?
jjones
 
Posts: 1
Joined: Fri 05 Mar 2010 18:49
Location: San Diego, CA

Postby 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

Postby 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/postgresql/download.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.
StanislavK
Devart Team
 
Posts: 1710
Joined: Thu 03 Dec 2009 10:48


Return to dotConnect for PostgreSQL