function min(pg_lsn) does not exist

[RekGRpth]

after commit 7d1b6ba
versions 12 has error

WARNING:  "PoWA".powa_take_snapshot(0): function "PoWA".powa_replication_slots_aggregate failed:
 	              state  : 42883
 	              message: function min(pg_lsn) does not exist
 	              detail : 
 	              hint   : No function matches the given name and argument types. You might need to add explicit type casts.
 	              context: PL/pgSQL function "PoWA".powa_replication_slots_aggregate(integer) line 12 at SQL statement
 	SQL statement "SELECT "PoWA".powa_replication_slots_aggregate(0)"
 	PL/pgSQL function "PoWA".powa_take_snapshot(integer) line 128 at EXECUTE

versions 10 and 11 have error

WARNING:  "PoWA".powa_take_snapshot(0): function "PoWA".powa_stat_database_snapshot failed:
 	              state  : 42804
 	              message: structure of query does not match function result type
 	              detail : Returned type integer does not match expected type bigint in column 17.

versions 6.5 and 9.6 have error

 WARNING:  "PoWA".powa_take_snapshot(0): function "PoWA".powa_stat_archiver_snapshot failed:
 	              state  : 42883
 	              message: function pg_last_wal_receive_lsn() does not exist
 	              detail : 
 	              hint   : No function matches the given name and argument types. You might need to add explicit type casts.
 	              context: PL/pgSQL function "PoWA".powa_stat_archiver_src(integer) line 14 at assignment

[rjuju]

Hi,

Yes I saw that yesterday when I merged the v5. I already fixed it this morning (#63) and also fixed pg11 compatibility (#64).

[rjuju]

I still have work to do for earlier versions I think, and probably for pg 17 too. I will take care of it this weekend or next weekend.

[RekGRpth]

thank you, versions 10 - 12 are fixed, but 9.5 and 9.6 still have errors

[rjuju]

yes, and 9.4 has a different error too. as I said I'm working on it and it will all be fixed before the beta

[rjuju]

out of curiosity do you still have 9.6 and older version in production?

[RekGRpth]

out of curiosity do you still have 9.6 and older version in production?

no, with powa only 14+

[rjuju]

ok!
a fix for EOLed version probably isn't top emergency then.

[RekGRpth]

now it works, thanx

[rjuju]

sorry, I didn't update this issue as pg 9.4 is still broken. I think I will just remove support for this major version though, there are just too many problems (doesn't know about the standard => named parameter, no ASSERT support in plpgsql and no function to get the list of created objects in an event trigger).

[RekGRpth]

typo: I meant NOW it works on 9.5 and 9.6