Some queries SQL does not execute in Postgres
|Priority:||Must have||Due date:|
Field author of table tx_t3blog_post is compared to beusers.uid, but data types of this field are different. author is of type varchar(255), uid is of type bigint. This issue leads to database error:
sqlError ERROR: operator does not exist: bigint = character varying
LINE 1: ..."tx_t3blog_post"."pid" = 46 AND "be_users"."uid" = "tx_t3bl...
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
More details can be found in my message to TYPO3 mailing list:
Because of this error is is impossible to run t3blog extension on Postgres.
|related to T3BLOG - Bug #27617: Non-portable SQL syntax in listFunctions||Resolved||2011-06-21|