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

Comments

berliner’s picture

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 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 🇨🇦
commented
Issue tags: +PostgreSQL