[TYPO3-english] Upgrading from 4.4 to 4.5 with Postgres

[Jigal van Hemert]

Hi,

There were reports of problems with Postgres on TYPO3 4.5. I wanted to 
do some investigation this weekend and this report certainly helps!

On 23-9-2011 17:08, Boris Gulay wrote:
> works fine. When I've checked PGSQL log file I found the following query:
>   SELECT * FROM "pages" WHERE   "pid" = 0 AND  "pages"."deleted" = 0 AND
>   "pages"."hidden" = 0 AND  "pages"."starttime"<= 1316789940 AND
> ("pages"."endtime" = 0 OR  "pages"."endtime">  1316789940) AND NOT
> "pages"."t3ver_state">  0 AND  "pages"."doktype"<  200 AND
> ("pages"."fe_group" = '' OR  "pages"."fe_group" IS NULL OR
> "pages"."fe_group" = '0' OR   FIND_IN_SET('0', "pages"."fe_group") != 0
> OR   FIND_IN_SET('-1', "pages"."fe_group") != 0) ORDER BY "sorting"
> LIMIT 1 OFFSET 0
>
> that executes with an error:
> "function find_in_set(unknown, character varying) does not exist"

You do have DBAL active I suppose? DBAL should rewrite the FIND_IN_SET() 
to a Postgres compatible construction, but something goes wrong here it 
seems.

If I can reproduce this the coming days, it will probably be relatively 
easy to fix. Stay tuned!

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert.