PostgreSQL Version 8.3 connection

Carlos.basto · April 29, 2019, 5:17pm

I am trying to access a db in PostgreSQL in version 8.3.
I have enable the drivers in Xampp but my problem is that Schema.php in vendor/yiisoft/yii2/db/pgsql is for PostgreSQL version 9.x and above.

How can i have yii2 working for this older version of PostgreSQL - 8.3?

I am using xampp-windows-x64-5.6.40-1-VC11.

samdark · April 29, 2019, 5:33pm

Can’t you upgrade?

Carlos.basto · April 29, 2019, 5:58pm

No i cannot.

A segunda, 29/04/2019, 18:35, Alexander Makarov via Yii Forum forum@yiiframework.com escreveu:

Carlos.basto · April 30, 2019, 7:46am

Hi Alexander

Do you know any solution to get access to PostgreSQL version 8.3 using Yii?
It is really important since i am trying to accces a database that i really cannot upgrade.

samdark · April 30, 2019, 10:46am

I guess that would mean providing your own connection/schema for older PostgreSQL version.

Carlos.basto · April 30, 2019, 10:51am

Hi Alexander

I have already figured it out.

I have changed the findConstraint function on Schema.php and now it is working.

Thanks a lot.

samdark · April 30, 2019, 4:14pm

If there are no cons in the new code regarding new versions, consider making a pull request.

Carlos.basto · April 30, 2019, 4:17pm

There is a con because my change is not seaching for constrains.

samdark · April 30, 2019, 5:21pm

I see. Glad it worked for your case anyway.