Question : I’m trying to get when my table was modified by checking its file modification date as it is […]
Category: Postgresql
Postgres wait_event_type Extension
Question : I have a function that was written in Language SQL (not plpgsql) that is scheduled to be called […]
Lookup performance of Numeric vs String
Question : I’m working on a project that is using the instagram key format. TL;DR 64-bit integer ids. They’ll be […]
error query did explode the postgres database
Question : I had some problems last month. I had a bad query in Postgres (PostGIS) of a user launched […]
SQL command to clean job queue in pgAdmin 4
Question : I have a Postgres 9.6 installation on a developer pc and a restore seems to have failed. Even […]
In Postgres 10, how do the choice of SERIAL or UUID type as primary key affect replication, if at all?
Question : A popular answer on SO states that using UUIDs as primary keys has the following benefit: Makes replication […]
Get partial results in Postgres in case of timeout?
Question : Is it possible to send a query that does a sequential scan of the table – something like […]
Inserting null value without quotes
Question : I’m creating a PHP application which relies on PostgreSQL. Now I have this query: $query= ‘INSERT INTO “users” […]
Error during plperl compilation: quoted execution trapped by operation mask
Question : When I try to create a perl function, I get an error. CREATE OR REPLACE FUNCTION foo() RETURNS […]
Deleting duplicate subscribers using max uuid postgresql
Question : I am trying to eliminate duplicate subscribers from the subscribers table for a api_customer_id, this is the query […]