[GitHub] [datasketches-postgresql] shubhamsachdeva89 commented on issue #66: could not find function "pg_theta_intersection_get_result" in file

["shubhamsachdeva89 (via GitHub)" <gi...@apache.org>]

shubhamsachdeva89 commented on issue #66:
URL: https://github.com/apache/datasketches-postgresql/issues/66#issuecomment-1582795493

   Hi Alexander,
   
   Thank you for the quick. I was able to upgrade the datasketches from 1.3 to 1.6.
   
   mbi1d01=# SELECT * FROM pg_extension WHERE extname = 'datasketches';
     oid  |   extname    | extowner | extnamespace | extrelocatable | extversion | extconfig | extcondition
   -------+--------------+----------+--------------+----------------+------------+-----------+--------------
    17085 | datasketches |       10 |        17081 | t              | 1.6.0      |           |
   (1 row)
   
   I have one doubt. I tried to run below command as suggested in documentation to test the installation, but it failed with error
   
   mbi1d01=# select cpc_sketch_to_string(cpc_sketch_build(1));
   ERROR:  function cpc_sketch_build(integer) does not exist
   LINE 1: select cpc_sketch_to_string(cpc_sketch_build(1));
                                       ^
   HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
   
   cpc_sketch_build is present in /datasketches_cpc_sketch.sql but somehow it is still missing
   
   While installing the so file, datasketches_cpc_sketch.sql was copied to  datasketches--1.6.0.sql
   
   make install
   /bin/mkdir -p '/pgbin/mbi1d/14.x/lib/postgresql'
   /bin/mkdir -p '/pgbin/mbi1d/14.x/share/postgresql/extension'
   /bin/mkdir -p '/pgbin/mbi1d/14.x/share/postgresql/extension'
   /bin/install -c -m 755  datasketches.so '/pgbin/mbi1d/14.x/lib/postgresql/datasketches.so'
   **cat sql/datasketches_cpc_sketch.sql sql/datasketches_kll_float_sketch.sql sql/datasketches_kll_double_sketch.sql sql/datasketches_theta_sketch.sql sql/datasketches_frequent_strings_sketch.sql sql/datasketches_hll_sketch.sql sql/datasketches_aod_sketch.sql sql/datasketches_req_float_sketch.sql sql/datasketches_quantiles_double_sketch.sql > sql/datasketches--1.6.0.sql**
   /bin/install -c -m 644 .//datasketches.control '/pgbin/mbi1d/14.x/share/postgresql/extension/'
   /**bin/install -c -m 644 .//sql/datasketches--1.6.0.sql** .//sql/datasketches--1.3.0--1.4.0.sql .//sql/datasketches--1.4.0--1.5.0.sql .//sql/datasketches--1.5.0--1.6.0.sql .//sql/datasketches--1.3.0--1.6.0.sql  '/pgbin/mbi1d/14.x/share/postgresql/extension/'
   
   
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datasketches.apache.org
For additional commands, e-mail: commits-help@datasketches.apache.org