Use this tag to indicate that your question is about PostgreSQL version 14. Questions concerning database administration should go to https://dba.stackexchange.com/
Questions tagged [postgresql-14]
227 questions
0
votes
0 answers
Postgres 14 stored procedure out params
I have a bunch of funcs (or procs) for simple inserts, ex: insert_user( email );
Most of them return the inserted_id, whether it's for other procs or a driver. And some don't, like inserts to many-many tables with no id.
PG stored procs have out…
Sean
- 509
- 2
- 11
0
votes
1 answer
Postgresql: read the content of file and insert in to Column throws 'cat' is not recognized as an internal or external command,
i have 2 files. 1) is txt.sql and 2) is post.html . i am try to insert in to my postgresql Table using .sql script. used windows cmd, Powershell and my IDE(vscode as well).
my script code here txt.sql
\set content `cat post.html`
INSERT INTO posts…
sdandamud1
- 97
- 2
0
votes
0 answers
PgSql 14-Pgagent not connected with database
Hi I am using PgSql 14 and I have installed it's relevant PgAgent from stack builder.
By using local and remote both are not connected to the database.
But the same job script working fine with PgSQL 12.3 and it's PgAgent.
What are the things needs…
shathi
- 1
0
votes
1 answer
Format interval date type as a parameter in PostgreSQL function
What is the best way to parameterize interval date type in a PostgreSQL function?. I have the following function
CREATE OR REPLACE FUNCTION testing(
min_time integer
)
RETURNS void AS
$BODY$
BEGIN
EXECUTE format('CREATE TABLE foo AS
SELECT
…
kartoza-geek
- 341
- 1
- 6
- 20
0
votes
1 answer
Having Trouble with a First Time Installation of PostgreSQL 14.1 on Ubuntu 18.04
I've been having a bit of trouble trying to install PostgreSQL 14 for the first time.
I would like to apologize in advance if this question has been asked in the manner that I am about to ask it, but I do not think it has. If it has been, please…
thepeoplescoder
- 1
- 1
0
votes
1 answer
failed to load sql modules into the database cluster
I tried to install postgreSQL v14.1.1 x64 in my windows 10 but on completion I got an error
"failed to load sql modules into the database cluster".
But the app still runs, so opened "pgadmin4", entered the postgres user password while connecting…
Akash Sharma
- 134
- 1
- 3
- 13
0
votes
1 answer
Errors attempting to INSERT INTO table with identity column from a staging table
I'm trying to insert data from a staging table into a another similar table with an identity column and cannot get the SQL syntax correct without errors. This is in PostgreSQL 14.
Staging table:
CREATE TABLE IF NOT EXISTS public.productstaging
(
…
user69166
- 115
- 5
0
votes
0 answers
PostgreSQL 14.2: out of memory - Failed on request of size 24576 in memory context "TupleSort main"
I have recently installed a PostgreSQL 14.1 in parallel to my old 12.9 on my RedHat server. Both instances are running their default configurations. The server itself has 48 CPU and 188 GB RAM, which seemed to be more than sufficient for…
user16479527
- 1
- 1
- 2
0
votes
1 answer
Postgres error with SQL state function: 42601
create or replace function fibonacci(int) returns int
as $$
declare
a int;
res int := 0;
begin
a := $1;
if(a = 1 or a = 2) then
res :=1;
else
res := fibonacci(a - 2) + fibonacci(a - 1);
end if;
return…
0
votes
1 answer
PostgreSQL crashing: terminating connection due to unexpected postmaster exit
I am doing a datamigration task running 60 parallel processes from Python using Python threading.
After a while, PG crashes, see the end of the PG log file:
2021-11-17 09:30:09.973 CET [19372] FATAL: terminating connection due to unexpected…
Ulrik Balslev
- 53
- 5
0
votes
1 answer
How do I fix this problem it say's 'queryForObject(java.lang.String, java.lang.Object[], java.lang.Class)' is deprecated
I'm not sure how to fix this since I just started doing spring boot project last Thursday. Unfortunately today is the deadline of my project so frankly I'm quite panicking right now :/
Here is my sample problem code:
@Override
public Integer…
Lance0567
- 13
- 1
- 4
-1
votes
1 answer
Why My Postgresql query could not find the data in Net Core 6?
I have a query of Postgresql-14 as below, the record was found if I run it on DBeaver 23.1.4.
I use:
Dapper 2.0.143
Npgsql 7.0.4
Npgsql.EntityFrameworkCore.PostgreSQL 7.0.4
Additional info:
process_datetime and start_datetime are of datatype…
Donald
- 551
- 2
- 6
- 22
-1
votes
2 answers
Slowness while using two boolean columns in the where condition
CREATE TABLE IF NOT EXISTS schema1.table1
(
ID bigint NOT NULL,
eid bigint NOT NULL,
sID bigint,
oname character varying COLLATE pg_catalog."default" NOT NULL,
obtype integer NOT NULL,
parentid bigint,
pageorder integer,
…
jptech84
- 1
- 3
-1
votes
1 answer
Azure VM and disk recommendation
I want to have your recommendation for vm and disk on Azure.
Here is my requirements. And I want to install postgreSQL 14 on it.
Data location : /pgdbfiles => 1 Tb
Internal memory : => 32 Gb
Number vcpu’s : => 16
Filesystem for log shipping wal…
bizimunda
- 819
- 2
- 9
- 26
-1
votes
1 answer
HowTo: Completely Uninstall Postgresql14 from MacOs Catalina If I've used the EnterpriseDB.com GUI installer
I've been trying to get this to work by following the answers in these questions:
How to uninstall postgresql on my Mac (running Snow Leopard)
Completely uninstall PostgreSQL 9.0.4 from Mac OSX Lion?
...but they're not working. So, here's what I…
Flak DiNenno
- 2,193
- 4
- 30
- 57