Author Topic: PostgreSQL Observations And Issues  (Read 2686 times)

0 Members and 1 Guest are viewing this topic.

KurtA

  • Member
  • **
  • Posts: 2
    • View Profile
PostgreSQL Observations And Issues
« on: 2013-12-29 16:55:01 »
It took me several days to get ThumbsPlus 9 running on a new PostgreSQL database.  I ran into several issues.  I'm basically up and running with a few crashing issues.

The first issue is case sensitivity.  The case sensitivity issue is well explained by the following WEB page:
[link=http://www.thenextage.com/wordpress/postgresql-case-sensitivity-part-1-the-ddl/]http://www.thenextage.com/wordpress/postgresql-case-sensitivity-part-1-the-ddl/[/link]
To sum it up PostgreSQL treats quoted table/column names as case sensitive while unquoted table/column names as case insensitive.  I was able to verify the use of quoted and unquoted names by psqlodbc log files.
I found that I had to make the following changes in Thumbs9_postgres.sql:
1) Rename the table "ThumbsPlusDatabase" to "thumbsplusdatabase"
2) Rename the "Thumbnail" column "idFileType" to "idFiletype"

I used the PostgreSQL ODBC direver "psqlodbc".  It was the 32bit UNICODE version.  I eventually installed the latest 9.03 version.  I think 9.02 would be fine.  I had to set one option on the Advanced Options Page 2 "Bytea as LO: Allow the use of bytea columns for Large Objects".  Are there any other options in psqlodbc that should be set?

I'm still having some PostgreSQL crashes.  I have had 7 thumbnail creations in 350,000 images that caused crashes.  The crash is reproducible.  The crash is down underneath the psqlodbc driver in Microsoft code.  I suspect the crash has something to do with bytea objects used for the thumbnails.  I'm thinking about building a debug version of psqlodbc to find out more.

Thanks,
-Kurt