Questions tagged [postgresql-12]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
35 views
+50

Installing extensions on Postgres 12 causes collation errors on startup

I'm attempting to stand up a new Postgres 12 instance (debian). When trying to create pg_stat_statements there is a collation error raised and the database shuts down. Error follows: Oct 11 18:43:57 ...
1
vote
0answers
15 views

Understanding PostgreSQL Execution Plans

I'm trying to understand the motivation of PostgreSQL 12 query planner here. Database Structure CREATE TABLE subjects ( id SERIAL PRIMARY KEY, name TEXT NOT NULL UNIQUE, ); CREATE TABLE ...
1
vote
2answers
31 views

Why isn't it possible to cast to a timestamp in an index in PostgreSQL?

I am working with a JSON document which I receive from an external source. In this document, there is a timestamp property which corresponds to the textual format of a timestamp PostgreSQL data type. ...
0
votes
1answer
34 views

Postgresql - sequences bigger than bigint

PostgreSQL sequences (CREATE SEQUENCE) are limited to bigint (which is usually big enough). But in my case I need a bigger sequence. The table will not have this much records, it will be cleaned over ...
-3
votes
1answer
190 views

Return result sets from stored procedure in Postgres v12

How to return result sets from a procedure in Postgres v12(beta). The link below says that changes have been done in Postgres v12 beta. https://wiki.postgresql.org/wiki/TODO#Server-Side_Languages: ...