Re: Insert records in the tavke only if they are not exist

2024-12-06 Thread Igor Korot
Hi, Dvid, On Fri, Dec 6, 2024, 9:55 PM David G. Johnston wrote: > On Friday, December 6, 2024, Igor Korot wrote: >> >> When my application starts up, ot creates some tables and insert records >> in them. >> >> When the app starts for the second time it should check if the tables and >> the reco

Re: Insert records in the tavke only if they are not exist

2024-12-06 Thread David G. Johnston
On Friday, December 6, 2024, Igor Korot wrote: > > When my application starts up, ot creates some tables and insert records > in them. > > When the app starts for the second time it should check if the tables and > the records in them are exist and skip the process. > > Everything is good, except

Insert records in the tavke only if they are not exist

2024-12-06 Thread Igor Korot
Hi, All, When my application starts up, ot creates some tables and insert records in them. When the app starts for the second time it should check if the tables and the records in them are exist and skip the process. Everything is good, except what if I have a connection from 2 different users?

Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed

2024-12-06 Thread Adrian Klaver
On 12/6/24 13:19, Zacher, Stacy wrote: Hello: We recently did an OS upgrade from Rocky Linux 8 to 9 on a Postgres v13 server that has 2 Foreign data wrappers that use tds_fdw for connections to 2 different SQL Servers. After the OS upgrade, one of the FDWs stopped working for some reason bu

Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed

2024-12-06 Thread Adrian Klaver
On 12/6/24 14:10, Zacher, Stacy wrote: Hi Adrian: Please see my replies below:** Thank you! Stacy -Original Message- From: Adrian Klaver Sent: Friday, December 6, 2024 3:51 PM To: Zacher, Stacy ; pgsql-general@lists.postgresql.org Subject: Re: tds_fdw DB-Library error: DB #: 20002,

RE: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed

2024-12-06 Thread Zacher, Stacy
Hi Adrian: Please see my replies below:** Thank you! Stacy -Original Message- From: Adrian Klaver Sent: Friday, December 6, 2024 3:51 PM To: Zacher, Stacy ; pgsql-general@lists.postgresql.org Subject: Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection f

Re: tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed

2024-12-06 Thread Adrian Klaver
On 12/6/24 13:19, Zacher, Stacy wrote: Hello: We recently did an OS upgrade from Rocky Linux 8 to 9 on a Postgres v13 server that has 2 Foreign data wrappers that use tds_fdw for connections to 2 different SQL Servers. After the OS upgrade, one of the FDWs stopped working for some reason bu

tds_fdw DB-Library error: DB #: 20002, DB Msg: Adaptive Server connection failed

2024-12-06 Thread Zacher, Stacy
Hello: We recently did an OS upgrade from Rocky Linux 8 to 9 on a Postgres v13 server that has 2 Foreign data wrappers that use tds_fdw for connections to 2 different SQL Servers. After the OS upgrade, one of the FDWs stopped working for some reason but the other one still works. The error mes

Re: Empty query_id in pg_stat_activity

2024-12-06 Thread Erik Wienhold
On 2024-12-06 15:32 +0100, Costa Alexoglou wrote: > Hey folks, I am running Benchbase and pgbench at the same time just for > debugging purposes, and I notice that sometimes query_id is missing > from pg_stat_activity. Any clue why this is happening? What's your Postgres version? Could be that qu

Empty query_id in pg_stat_activity

2024-12-06 Thread Costa Alexoglou
Hey folks, I am running Benchbase and pgbench at the same time just for debugging purposes, and I notice that sometimes query_id is missing from pg_stat_activity. Any clue why this is happening? ``` benchbase=# SELECT query_id, now() - query_start as duration, query FROM pg_stat_activity WHERE sta

Re: GRANT WITH INHERIT ??

2024-12-06 Thread Arbol One
Resolved. Thanks On 2024-12-06 7:40 a.m., Arbol One wrote: When enter this commands in psql : *sudo -u postgres psql CREATE GROUP arbolone_dev_group; // Create a group CREATE ROLE company_admin LOGIN PASSWORD 'myPassword' CREATEDB IN GROUP arbolone_dev_group CREATEROLE; GRANT arbolone_dev_gr

GRANT WITH INHERIT ??

2024-12-06 Thread Arbol One
Hello. When enter this commands in psql : *sudo -u postgres psql CREATE GROUP arbolone_dev_group; // Create a group CREATE ROLE company_admin LOGIN PASSWORD 'myPassword' CREATEDB IN GROUP arbolone_dev_group CREATEROLE; GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;* I get this e