Regression test failure against PostgreSQL 19 #147

Activity

1. esabol commented on Jul 9, 2026

   

   esabol

   on Jul 9, 2026

   Contributor

   More actions

   What changed?
2. devrimgunduz commented on Jul 9, 2026

   

   devrimgunduz

   on Jul 9, 2026

   Author

   More actions

   --- moc.out	2025-10-20 12:13:46.000000000 +0300
   +++ moc_1.out	2026-07-09 14:39:57.301898031 +0300
   @@ -252,17 +252,17 @@
    ERROR:  function smoc(integer) does not exist
    LINE 1: SELECT smoc(-1);
                   ^
   -HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
   +DETAIL:  No function of that name accepts the given number of arguments.
    SELECT smoc(15); -- expected: error
    ERROR:  function smoc(integer) does not exist
    LINE 1: SELECT smoc(15);
                   ^
   -HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
   +DETAIL:  No function of that name accepts the given number of arguments.
    SELECT smoc(0);  -- expected: '0/'
    ERROR:  function smoc(integer) does not exist
    LINE 1: SELECT smoc(0);
                   ^
   -HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
   +DETAIL:  No function of that name accepts the given number of arguments.
    SELECT smoc('');
     smoc 
    ------
   
   
3. vitcpp

   self-assigned this

   on Sep 21, 2026
4. vitcpp

   linked a pull request that will close this issueFix 147 #149on Oct 18, 2026
5. vitcpp commented on Oct 18, 2026

   

   vitcpp

   on Oct 18, 2026

   Contributor

   More actions

   @devrimgunduz Thank you for reporting the issue. I've added an alternative file and added support for pg 19 in github actions. The PR is created.

   👍React with 👍1Reacted by Ed Sabol
6. waaeer

   added a commit that references this issue on Oct 19, 2026

   Fix moc.sql test failure with pg19 (issue #147)

   ...

   54c07d0
7. waaeer

   closed this as completedin #149on Oct 19, 2026
8. esabol commented on Oct 19, 2026

   

   esabol

   on Oct 19, 2026

   Contributor

   More actions

   @vitcpp @waaeer : PostgreSQL 19.0 is supposed to be released on 19 November 2026. A new pgsphere release for compatibility with 19 before then would be welcome.