Table with column names Min and Max

[paulsk]

PGNP32-1.2.8.1110

I have a table containing the column names 'Min' and 'Max' when these are defined in a SELECT statement then the driver seems to confuse them with the functions Min() and Max().

I have tried the following SQL incarnations but an SQL exception is still raised:

SELECT Min, Max FROM MyTable
SELECT MyTable.Min, MyTable.Max FROM MyTable
SELECT MyTable.Min as MinValue, MyTable.Max as MaxValue FROM MyTable
SELECT "Min", "Max" FROM MyTable
SELECT "MyTable.Min", "MyTable.Max" FROM MyTable

I accept that it was probably not a good idea to name these columns Min and Max, but I am attempting to use this driver on an existing database design so changing column names is not really an option. By using SELECT * FROM MyTable I can workaround it, but I just thought it was still worth informing you of a possibility of a bug with this version of the driver.

[Moderator]

Thank you for letting us know about the bug. We'll try to fix it and let you know.

[Moderator]

The defect is fixed in build 1120.
Here are the links to installation modules:
http://www.pgoledb.com/downloads/PGNP32-1.2.8.1120.exe (32-bit)
http://www.pgoledb.com/downloads/PGNP64-1.2.8.1120.exe (64-bit)

Let us know if you will have any questions.