- Thank you received: 0
Issue with user_cons_columns.Position
- sonukukreja
- Topic Author
- Visitor
-
7 years 10 months ago #13879
by sonukukreja
Issue with user_cons_columns.Position was created by sonukukreja
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
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.
- Moderator
-
- Offline
- New Member
Less
More
7 years 10 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.151 seconds