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

[Boris Gulay]

Sorry for the delay with the answer, I was out of the city at weekend.

23.09.2011 23:10, 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.
Yes, I have DBAL active in the 4.4 and does not touch it during upgrade
procedure.