Issue with user_cons_columns.Position

  • sonukukreja
  • Topic Author
  • Visitor
  • Visitor
8 years 4 months ago #13879 by sonukukreja
Issue with user_cons_columns.Position was created by sonukukreja

We are doing some assessment to use PGNP Oledb driver to fetch data from Postgres in C# .net application.

When we execute query string cmdText = "select table_name, position from user_cons_columns;"; it returns below error.
** ERROR: Failed to parse statement: select table_name, position from user_cons_columns

But when we updated the query string to string cmdText = "select table_name, \"position\" from user_cons_columns;"; it worked fine.

Is there any specific reason on why do I need to put POSITION column in double quotes?


Please Log in or Create an account to join the conversation.

8 years 3 months ago #13880 by Moderator
Replied by Moderator on topic Re: Issue with user_cons_columns.Position
This was a bug in the parser - it treated word POSITION as a keyword. We fixed it in build 3418 that will be officially released soon. Please contact our support if you want to obtain fixed module before official release.

Please Log in or Create an account to join the conversation.

Time to create page: 0.119 seconds
Powered by Kunena Forum