Issue with user_cons_columns.Position

More
3 years 1 month ago #13879 by sonukukreja
sonukukreja created the topic: Issue with user_cons_columns.Position
Hi,

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?

Thanks
Sonu

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

More
3 years 3 weeks ago #13880 by Moderator
Moderator replied the 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.134 seconds
Powered by Kunena Forum