All queries to database are only compatible with mysql. Mysql allows quoting strings with double quote marks ("), but for postgres - "something" means "object with name 'something'" not "string 'something'".

Attached patch makes sticky notes working with postgres.

CommentFileSizeAuthor
psql.diff1.64 KBmaho
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

berliner’s picture

berliner CreditAttribution: berliner commented

Thanks for the patch. I will add this to the dev version and it will be in the next regular release.

berliner’s picture

berliner CreditAttribution: berliner commented
Status: Patch (to be ported) » Fixed

This is in now. Thank you.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Liam Morland’s picture

Liam Morland
Primary language English
Location Ontario, CA 🇨🇦
CreditAttribution: Liam Morland commented
Issue tags: +PostgreSQL