PostgreSQL Database Forum

How to increase arguments more than 100 to function in posgresql when i try to send more than 100 arguments to posgresql function or SP it gives error cannot pass more than 100 arguments ...how to solve help needed

-In PostgreSQL, what is the difference between a Role and a Group, exactly? How do they relate to one another, and which one(s) can be asigned to another? -Can Policies be assigned to one or more aggregating entities in PostgreSQL, or are they just left on their own? If not, what can a Policy be assigned to?

-Is there a simple, immediate, straightforward way to temporarily disable PostgreSQL database use of all other users, except development users, or in fact just one user (one developer, yourself) so that Maintanence on the data or the data model may be performed? -The way things are, you after revoke connection priviledges for all the other...

Hello, I have a query to insert about 300k rows into a new table and it runs about a minute on my local Postgres 12 instance. However the same query runs for about 20 min on Amazon RDS instance before failing with "ERROR: SSL SYSCALL error: EOF detected" message. I went up to a medium RDS instance with 4G of RAM with the same result. Any ideas...

hi, I have written code in T-Sql used code converter for PostgreSQL, got below code but it is giving complier error. I have no clue in PostgreSQL so any pointer will be of great help. ------------------------------------------------------------------------------------------------------------------------------ select t.team_id,...

I was doing a replication for a database but then the base backup keeps getting interrupted when theres a connection failure and I have to start it all over again. My question is; is there a way to resume the base backup without starting all over again and also is there a way to just specify a single database to be replicated?

I am an Oracle developer, I have to write a stored procedure for the first time in postgreSql (for aws redshift) Question: is there a concept of error handling in plsql for postgresql ? (PL/pgSQL) ? According to what I hear, the errors are automatically logged in "system tables", is this true ? if so, what are those system tables ?

i tried create storeprocedure in postgress 13, when i set up with parameter and call. there is some error 42883 CREATE OR REPLACE PROCEDURE public.logavlunit(pavl_unit_id character varying, pvehicle_id integer, pvehicle_number character varying, pregistration_number character varying, pdevice_type smallint, pserver_port integer, pserver_address...

I really need advice on the below, trying to use DB function getpreviousorders.. NOTE: But this DB function got much faster if run directly on DB, without data reference entity data by spring hibernate code in Order entity. CREATE OR REPLACE FUNCTION "sample"."getpreviousorders"("_sampleid" varchar, "_mrn" varchar, "_createddate" timestamp)...

This query expected to update 1 row at a time and after processing we move the same row to next queue and query picks and update next row in infinite loop. Update queue_table set lock_flag = 150 Where row (entity, sub_entity, side) = (select entity, sub_entity, side from queue_table where lock_flag = 0 and entity = 'Abc' limit 1 for update skip...

How to listen from within a psql process and get the payloads? Do Postgres has any such a mechanism where in a session a process send a "listen <name>" sql command and then gets a message if someone in the other session issued a "notify <name>". Please provide an example how to do this.

I have a old code for unity3d game. I was able to update it from 2.7 to python 3. After running the code as shown below: from flask import Flask #from flask.ext.sqlalchemy import SQLAlchemy from flask_sqlalchemy import SQLAlchemy from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column, Sequence, Integer,...

yarn migrate:run && yarn start yarn typeorm migration:run --config ./lib/src/ormconfig /usr/src/app/node_modules/.bin/typeorm migration:run --config ./lib/src/ormconfig Error during migration run: { error: no PostgreSQL user name specified in startup packet at Connection.parseE (/usr/src/app/node_modules/pg/lib/connection.js:606:11) at...

Good day Below is the code which i use if i have 3 rows then it works but if i choose 1 record then i get a resultset error CREATE or REPLACE FUNCTION public.upload_coll( l_bilbatchno character(32), p_filnam CHARACTER, p_filnam1 CHARACTER, p_filnam2 CHARACTER, user_name CHARACTER )

Trying to change the docname to bring back a blank i instead get a resultSet error: Java Side; String filepath = foldername.trim() +"templates/" + control.getCoreports() + docname1 + ".docx"; String outpath = foldername.trim() +"merged/"+ docname1 + ".docx"; postgresql part update test.coltran set docstored = l_uuid_32, docname1 =...

select * from information_schema.tables where table_name=('pg_class' OR true) When using the above query it is throwing an error invalid input syntax for type boolean What are the reasons for it?

I have the following sample data: key | source_string --------------------- 1355 | hb;am;dr;cc; 3245 | am;xa;sp;cc; 9831 | dr;hb;am;ei; What I need to do:

While executing pg_start_backup function in postgres 9.6 DB I am getting below warning select pg_start_backup(to_char(now(), 'yyyy-mm-dd hh24:mi:ss')); WARNING: could not read symbolic link "pg_tblspc/oth_data_tbs": Invalid argument WARNING: could not read symbolic link "pg_tblspc/str_index": Invalid argument WARNING: could not read...

Hi, I would like to know how can i transfer .json file generated from couchbase database to postgresql I tried copy command but looks like some of the characters from couchbase json is not recognized by postgres copy schemaname.tablename from 'filename.json' ERROR: invalid input syntax for type json DETAIL: Token "H" is invalid....

Want to know the command for getting program name and machine name used for postgre script after aws sct conversion from oracle to postgresql.

Hello I have configuration pgpool and work loadbalancing and watchdog. I have replication type streaming too but when I perform command show pool_nodes I have empty columns replication_state and replication_sync_state while when I have replication and it working? Why i have empty columns? Might it is problem and because I can't switch...

Hello I have all configuration in pgpool2, Things such as load balancing and watchdog work but when I want execute command pcp_recovery_node. I received in log: DETAIL: starting recovery command: "SELECT pgpool_recovery('recovery_1st_stage', '192.168.164.202', '/var/lib/pgsql/12/data', '5432', 1, '5432')" LOG: executing recovery DETAIL:...

Hello Everyone, I want to learn PostgreSQL with a complete guide. Can anyone know any free or paid tutorial as a beginner point? I have a check on google but I can’t find the best one which shows step by step process.

Hi All, I am trying to install CSTORE_FDW for PGSQL on my Centos 7 server, but I keep getting this error; username-centos cstore_fdw]$ PATH=/usr/bin/:$PATH make Makefile:50: *** PostgreSQL 9.3 to 12 is required to compile this extension. Stop. However this is the version on PGSQL I am running; $ postgres -V postgres (PostgreSQL) 10.6

Hi, I'm stuck with setting up PostgreSQL with Django Every time I run Django server it shows : File "C:\Python38\lib\site-packages\psycopg2\init.py", line 127, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) django.db.utils.OperationalError: FATAL: password authentication failed for user "Test" ...