Opened 8 months ago

Closed 8 months ago

Last modified 8 months ago

#973 closed defect (fixed)

PostgreSQL provider won't work on PostgresSQL >= 12.0

Reported by: jng Owned by: jng
Priority: major Milestone: 4.1.0
Component: PostgreSQL Provider Version:
Severity: 3 Keywords:
Cc: External ID:

Description

The PostgreSQL provider makes reference to the column pg_attrdef.adsrc here.

This column has been removed in PostgreSQL 12.0, rendering the provider un-usable for this version of PostgreSQL.

The use of d.adsrc can be replaced with pg_get_expr(d.adbin, d.adrelid). For even more safety, do a PG version check to see whether we can use adsrc or its replacement.

Change History (2)

comment:1 Changed 8 months ago by jng

Resolution: fixed
Status: assignedclosed

In 7962:

Fix PostgreSQL 12 compatibility.

Fixes #973

comment:2 Changed 8 months ago by jng

In 7964:

Merged revision(s) 7962-7963 from branches/4.1:

Fix PostgreSQL 12 compatibility.
Fixes #973

If CheckReaderString?? fails in any of the Expression Engine function tests, lets be at least courteous and record the values being tested that failed expectations.
........

Note: See TracTickets for help on using tickets.