sasog23

> @abn This is definitely something that we want to implement but we haven't added it to our pipeline yet. Hopefully, we can get this out in a couple of...

anything new on this feature request?

I guess you can use Class 22 — Data Exception error codes raise exception like this RAISE EXCEPTION USING ERRCODE= '22000', MESSAGE= 'business logic error message'; and the client will...

I need FIFO method within chosen unique key

anything new on this

is this maybe related to postgresql config ?? PostgreSQL 13.14 (Ubuntu 13.14-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit

nope, it's ok i've tested this query in pgadmin, and it takes 8+ seconds if i remove "AND ((pgn.nspname='servicedesk'))" and test it, it takes

``` Aggregate (cost=584.58..584.59 rows=1 width=32) -> Subquery Scan on info (cost=578.68..584.54 rows=7 width=152) -> GroupAggregate (cost=578.68..584.47 rows=7 width=324) Group Key: pgc.oid, pgn.nspname, pgc.relname, (CASE WHEN (pgc.relkind = 'r'::"char") THEN 'TABLE'::text...

nope, same result 8+seconds ``` EXPLAIN analyze...result Aggregate (cost=585.41..585.42 rows=1 width=32) (actual time=8303.574..8303.598 rows=1 loops=1) -> Subquery Scan on info (cost=579.51..585.37 rows=7 width=152) (actual time=8148.891..8303.426 rows=56 loops=1) -> GroupAggregate (cost=579.51..585.30...

works find with PostgreSQL 15.5 (Debian 15.5-1.pgdg110+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit PostgreSQL 13.13 (Ubuntu 13.13-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit...