The img_assist module doesn't support PostgreSQL out of the box. Attached is a suggested img_assist.pgsql script to support it.

CommentFileSizeAuthor
#2 pgsql-selects.diff1.32 KBelonen
#1 img_assist_1.pgsql103 bytespaulgear
img_assist_0.pgsql0 bytespaulgear

Comments

paulgear’s picture

paulgear commented
StatusFileSize
new img_assist_1.pgsql103 bytes

For some reason that script didn't upload. Here it is again.

elonen’s picture

elonen commented
StatusFileSize
new pgsql-selects.diff1.32 KB

At least in 4.5, you also have to change "image/%" to 'image/%' since Postgres only accepts single quotes as string values (double quotes are assumed to be table/column names). Another patch attached.

matt westgate’s picture

matt westgate commented

Added the Postgres schema to CVS HEAD. Thanks. The last patch doesn't seem to make sense since it just swaps double quotes with single quotes for a couple of queries. It would make more sense to say 'We need to always use single quotes for Postgres', or something of the like.

elonen’s picture

elonen commented

It would make more sense to say 'We need to always use
single quotes for Postgres', or something of the like.

Yes, that's exactly the case, so I hope you applied the hunk anyway. Postgres regards double quoted words as column/table names.

Anonymous’s picture

(not verified) commented