View Issue Details

IDProjectCategoryView StatusLast Update
0034511FPCDatabasepublic2018-11-06 13:47
ReporterWim van den Bos Assigned ToLacaK  
Status resolvedResolutionfixed 
PlatformWindows 64bitOSWindows 
Product Version3.0.4 
Fixed in Version3.3.1 
Summary0034511: Postgres package can not cope with schema's enclose in ""
DescriptionUsing 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 ReproduceMake 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.
TagsNo tags attached.
Fixed in Revision40240
Attached Files


Wim van den Bos

2018-11-05 10:00

reporter (146,540 bytes)


2018-11-06 13:47

developer   ~0111810

Quick fix applied in rev.40240

Issue History

Date Modified Username Field Change
2018-11-05 10:00 Wim van den Bos New Issue
2018-11-05 10:00 Wim van den Bos File Added:
2018-11-06 06:16 LacaK Assigned To => LacaK
2018-11-06 06:16 LacaK Status new => assigned
2018-11-06 13:47 LacaK Fixed in Revision => 40240
2018-11-06 13:47 LacaK Note Added: 0111810
2018-11-06 13:47 LacaK Status assigned => resolved
2018-11-06 13:47 LacaK Fixed in Version => 3.3.1
2018-11-06 13:47 LacaK Resolution open => fixed