always occur operator for type 1043 about pg_squeeze

[ahouska]

I already asked one of the guys. I'll remind him.

[JKeyZ]

search log found error report: syntax error at or near "ll"

[ahouska]

1. Which version of pg_squeeze is that?

2. What's the exact table definition, including indexes?

[JKeyZ]

pg_squeeze is REL1_1_0 .
pg version is 11 release.
The table including index on array.

[ahouska]

The index on array really appears to be the problem. It's fixed now in
https://github.com/cybertec-postgresql/pg_squeeze/archive/REL1_1.zip
and will be included in release 1.1.1 later. Thanks for the report!

[JKeyZ]

also occur "Failed to find = operator for type 1043"
Before start worker, I had run "ALTER EXTENSION pg_squeeze UPDATE" for update

[ahouska]

ALTER EXTENSION ... UPDATE will not apply the patch. You need to download the source code
https://github.com/cybertec-postgresql/pg_squeeze/archive/REL1_1.zip
and perform steps 1 through 5 from the "Installation" section of README.

[JKeyZ]

Before execute "alter extension update", I already make install. After update, pg show the info : NOTICE: version "1.1" of extension "pg_squeeze" is already installed

[ahouska]

Have you restarted the instance (cluster) after the "make install"? If even that did not help, please send me the exact DDLs (CREATE TABLE, CREATE INDEX, ...) for the table that causes the error.

[JKeyZ]

yes, I already restarted the instance.
Can you give me the email? I send the ddls

[ahouska]

My email address should be visible now in my github profile.

[ahouska]

Please try https://github.com/cybertec-postgresql/pg_squeeze/archive/REL1_1.zip again.

[JKeyZ]

It's working.Thank you

[srikanth-medikonda-ntnx]

@ahouska, are you the right person to reach about updating patch release 1.1.1 in pgdg repos? Or, is it PostgreSQL RPM Building Team: https://yum.postgresql.org/contact.php?

[drIceman]

Hi, what about making this fix for PG 9.6?
Because current version requires PG 10+