Use this tag to indicate that your question is about PostgreSQL version 13. Questions concerning database administration should go to https://dba.stackexchange.com/
Questions tagged [postgresql-13]
368 questions
0
votes
1 answer
Do local versions of postgres foreign data wrappers update automatically?
Apologies if this is answered in the docs or somewhere else obvious, but I have just gone through the rigmorale of having to use postgres_fdw to get data from another database (quite different to the ease of MS SQL!)
I ran an IMPORT SCHEMA statement…
volume one
- 6,800
- 13
- 67
- 146
0
votes
0 answers
How to set the value of a variable in one function with the returned value from another function?
I am extremely new to postgresql and do not understand how to set the value of a variable in one function with the value from another function. This is as far as I have got:
Function A
CREATE FUNCTION functiona(_postid integer) RETURNS integer
…
volume one
- 6,800
- 13
- 67
- 146
0
votes
1 answer
Trigger before insert in PostgreSQL and except some columns
I'm trying to write a trigger for my table. This table has 50 columns and 3 of them are timestamp type. In the future I will insert new rows and they can be duplicate of existing, so I need to compute hash of each row. My idea is to compute row's…
Nobody
- 103
- 4
0
votes
0 answers
postgres create extension invalid support function
I am trying to create a operator class for my index in postgres. But when creating extension i am getting a error " invalid function number 4, must be between 1 and 3".
I dont know where this error is occured my operator class is
CREATE OPERATOR…
0
votes
1 answer
Password authentication failed for user "postgresql"
Pls I have downloaded postgresql for Windows and I want to connect my models in Django model file to postgresql database but it keep throwing that error
Name : "django 1",
User: "postgresql",
Password: "bless90",
Host: "local host"
Nnamani William
- 31
- 3
0
votes
0 answers
Increment by 1 in sequence numbering and dynamically partitioned tables
I am using dynamically created table partitions to store event information in a Postgresql 13 database. The master table from which the child tables inhert their structure contains an id field with an auto-incrementing sequence. The sequence, master…
Peter K.
- 517
- 3
- 19
0
votes
0 answers
How to resolve error reading result of streaming command?
I have a master database doing logical replication with a publication and a slave database subscribing to that publication. It is on the slave that I am occasionally getting the following error:
ERROR: error reading result of streaming…
theQuestionMan
- 1,270
- 2
- 18
- 29
0
votes
2 answers
SQL query : multiple challenges
Not being an SQL expert, I am struggling with the following:
I inherited a larg-ish table (about 100 million rows) containing time-stamped events that represent stage transitions of mostly shortlived phenomena. The events are unfortunately recorded…
Peter K.
- 517
- 3
- 19
0
votes
0 answers
Mybatis PostgreSQL throws an error "column does not exist" for an column that exists and its values are auto generated
Below is the create table statement which has successfully created the table in the PostgreSQL database.
CREATE TABLE
SYNC_REPOSITORIES (
REPOSITORY_ID BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
REPOSITORY_NAME…
Anusha HV
- 131
- 11
0
votes
1 answer
Failure to install psycopg2 in Pycharm
I'm trying to install psycopg2 to use a postgresql db in the backend of my django project, but every time I run the pip install psycopg2 command I get an error saying:
Error: pg_config executable not found.
pg_config is required to build psycopg2…
RusskiT
- 106
- 7
0
votes
1 answer
Is there any way to connect to PostgreSQL13 in OLEDB Command in SSIS. I have found NpgSQL but I don't see in the list of OLE connections
Though I have installed ODBC drivers for PostgreSQL as well as NpgSQL I can see them in server explorer of Visual 2019, but not in the list of OLEDB available connections as shown in the figure. What steps should I take to achieve PostgreSQL…
Suhail Abdul Rehman Chougule
- 2,369
- 2
- 12
- 23
0
votes
1 answer
How to select an array of composite types into local variable in Postgres PL/pgSQL?
This is a simple question: In PL/pgSQL, how do I select an array of composite objects into a local variable?
I'm on Postgres 13. Here is an example of what I'd like to do:
create type udt_foo as (
col1 numeric,
col2 numeric
);
create or…
DBot
- 3
- 5
0
votes
0 answers
SailsJS: not able to connect to postgresql database
We have SailsJS app with postgresql adapter. Requests made to server chokes at database query via models. i.e Users.find(). Database server is up and running, connection string is correct and one can connect to database using same connection…
ducktyped
- 4,354
- 4
- 26
- 38
0
votes
1 answer
Is it possible to guarantee a minimum set number of workers for a parallel aggregate function in postgres?
I have a custom parallel aggregate extension to Postgresql and I would like to have at least N worker processes performing the aggregation every time the aggregate function is used.
Is it possible to tell postgresql to ALWAYS use at least N workers…
ReverseFlowControl
- 766
- 6
- 30
0
votes
3 answers
How will the space be reused after the item identifier is freed in PostgreSQL?
Recently I started to do some research on PostgreSQL free space management and defragmentation. I understand that each page on the heap contains a page header, page identifier, free space, and items. When inserting a new tuple, a new item identifier…
Kris1313
- 11
- 2