Postgres package can not cope with schema's enclose in ""
Original Reporter info from Mantis: wvdbos
-
Reporter name: Wim van den Bos
Original Reporter info from Mantis: wvdbos
- Reporter name: Wim van den Bos
Description:
Using a TSQLQuery whith SQL being:
SELECT * FROM link5_2data1;
works, but it resides in the public schema
I tried to use a schema
SELECT * FROM "schema_name".link5_2data1;
Then I got an error (" is going wrong in the parser)
See Uploaded screenshot in zip
Steps to reproduce:
Make a Form with a connection, transaction and a TSQLQuery.
Bind them together.
Have a SQL like:
SELECT * FROM "schema_name".link5_2data1;
with double quotes
And activate/Open it.
(Project also added in zip)
Btw without quotes is also going wrong.
Mantis conversion info:
- Mantis ID: 34511
- OS: Windows
- OS Build: 7
- Platform: Windows 64bit
- Version: 3.0.4
- Fixed in version: 3.3.1
- Fixed in revision: 40240 (#475fed4e)