Re: After the last update

2024-01-15 Thread Adrian Klaver
On 1/15/24 17:59, Arbol One wrote: Bro., is in the OP. 1) I am not your Bro. 2) When troubleshooting explicit is better then implicit. What is obvious to you might not be obvious others. I have more then once assumed and not verified and gone down a long trail of troubleshooting only to

Re: After the last update

2024-01-15 Thread David G. Johnston
On Mon, Jan 15, 2024 at 2:33 PM Arbol One wrote: > I am working on an application using NB-20, > PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian > 15.5-1.pgdg120+1)), > postgresql-42.7.0.jar. > openjdk 17.0.9 2023-10-17 > OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1)

Re: After the last update

2024-01-15 Thread Arbol One
Bro., is in the OP. - I am working on an application using NB-20, PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian 15.5-1.pgdg120+1)), postgresql-42.7.0.jar. openjdk 17.0.9 2023-10-17 OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1) OpenJDK 64-Bit Server VM

Re: After the last update

2024-01-15 Thread Adrian Klaver
On 1/15/24 14:38, Arbol One wrote: Netbeans 20. Sorry, my bad. And the rest of the questions? On 2024-01-15 4:48 p.m., Adrian Klaver wrote: On 1/15/24 13:33, Arbol One wrote: I am working on an application using NB-20, PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian

Re: After the last update

2024-01-15 Thread Arbol One
Netbeans 20. Sorry, my bad. On 2024-01-15 4:48 p.m., Adrian Klaver wrote: On 1/15/24 13:33, Arbol One wrote: I am working on an application using NB-20, PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian 15.5-1.pgdg120+1)), postgresql-42.7.0.jar. openjdk 17.0.9 2023-10-17 OpenJDK

Re: After the last update

2024-01-15 Thread Adrian Klaver
On 1/15/24 13:33, Arbol One wrote: I am working on an application using NB-20, PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian 15.5-1.pgdg120+1)), postgresql-42.7.0.jar. openjdk 17.0.9 2023-10-17 OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1) OpenJDK 64-Bit Server VM

After the last update

2024-01-15 Thread Arbol One
I am working on an application using NB-20, PG-psql (16.1 (Debian 16.1-1.pgdg120+1), server 15.5 (Debian 15.5-1.pgdg120+1)), postgresql-42.7.0.jar. openjdk 17.0.9 2023-10-17 OpenJDK Runtime Environment (build 17.0.9+9-Debian-1deb12u1) OpenJDK 64-Bit Server VM (build 17.0.9+9-Debian-1deb12u1,

Re: Help with "Create Extension unaccent"

2024-01-15 Thread Adrian Klaver
On 1/15/24 12:04, Lan Xu wrote: Hi Adrian and Ian, Thank you for responding! OS: CentOS 7.9.2009 Postgres: 14.5 It was an upgrade from an older version. From what repo? And was that same repo as the older version was installed from? Thanks again! Thank you for your guidance! Lan On

Re: Moving to Postgresql database

2024-01-15 Thread Henrique Lima
You can find a lot information in this link https://docs.aws.amazon.com/dms/latest/oracle-to-aurora-postgresql-migration-playbook/chap-oracle-aurora-pg.html To actually perform the migration, you can use some AWS tools such as SCT + DMS:

Re: Help with "Create Extension unaccent"

2024-01-15 Thread Lan Xu
Hi Adrian and Ian, Thank you for responding! OS: CentOS 7.9.2009 Postgres: 14.5 It was an upgrade from an older version. Thanks again! Thank you for your guidance! Lan > On Jan 14, 2024, at 8:50 AM, Adrian Klaver wrote: > > On 1/13/24 21:52, Lan Xu wrote: >> With CREATE EXTENSION

Re: Help needed for the resolution of memory leak

2024-01-15 Thread Merlin Moncure
On Mon, Jan 15, 2024 at 11:32 AM Sasmit Utkarsh wrote: > Hi Team, > > I am trying to test a code which basically tries to read some data from > postgresql db in a loop through a function SQL_get_tpf_rw() whose > definition and other details are shared in the attached file along with the > memory

Re: Moving to Postgresql database

2024-01-15 Thread Justin Clift
On 2024-01-15 14:16, veem v wrote: Hello Experts, If some teams are well versed with the Oracle database architecture and its optimizers working and designing applications on top of this. Now moving same team to work on AWS aurora postgresql databases design/development projects. Is any key

Re: multiple missing providers from pgdg-common

2024-01-15 Thread Joseph G
I can confirm everything works now, Thank you! Sent via mobile, please excuse typos and brevity. On Mon, Jan 15, 2024, 02:20 Devrim Gündüz wrote: > Hi, > > On Sat, 2024-01-13 at 13:23 -0800, Joseph G wrote: > > If we look, gdal35 or 36 is asking for libarmadillo.so.10 which > > doesn't look

Re: data migration using EXTENSION tds_fdw

2024-01-15 Thread Adrian Klaver
On 1/15/24 11:03 AM, Eyüp Liste wrote: Hello, 1)TURKISH_CI_AS at sql server database 2)Encoding : UTF8 Collate: en_US.UTF-8 at Postgresql I don't use tds_fdw, so the best I can do is point you at information Hopefully someone with practical experience will chime in with more specific

Re: Unable to find column

2024-01-15 Thread Adrian Klaver
On 1/15/24 09:26, arun chirappurath wrote: Hi Adrian, \d shows the tables and this id which is a sequence. What I asked for was the output of: \d automobile Add that output to your reply. Regards, Arun -- Adrian Klaver adrian.kla...@aklaver.com

Re: Unable to find column

2024-01-15 Thread arun chirappurath
Hi Adrian, \d shows the tables and this id which is a sequence. Regards, Arun On Mon, 15 Jan 2024 at 22:03, Adrian Klaver wrote: > On 1/15/24 08:16, arun chirappurath wrote: > > Dear all, > > > > I have a table automobile which has a column id. > > > > Table consists of id,make,year of

Re: Unable to find column

2024-01-15 Thread Adrian Klaver
On 1/15/24 08:16, arun chirappurath wrote: Dear all, I have a table automobile which has a column id. Table consists of id,make,year of manufacturing I use dbeaver for querying.. Select * from automobile provides me results However select id from automobile yields column doesn't exists. I

Re: Unable to find column

2024-01-15 Thread Ian Harding
On Mon, Jan 15, 2024 at 8:17 AM arun chirappurath wrote: > Dear all, > > I have a table automobile which has a column id. > > Table consists of id,make,year of manufacturing > > I use dbeaver for querying.. > > Select * from automobile provides me results > > However select id from automobile

Unable to find column

2024-01-15 Thread arun chirappurath
Dear all, I have a table automobile which has a column id. Table consists of id,make,year of manufacturing I use dbeaver for querying.. Select * from automobile provides me results However select id from automobile yields column doesn't exists. I tried double quotes on id As well but same

Re: Add support for data change delta tables

2024-01-15 Thread Adrian Klaver
On 1/15/24 02:44, Thomas Kellerer wrote: PavelTurk schrieb am 15.01.2024 um 11:00: Currently PostgreSQL doesn't support data change delta tables. For example, it  doesn't support this type of query: SELECT * FROM NEW TABLE ( INSERT INTO phone_book VALUES ( 'Peter Doe', '555-2323' ) ) 

Re: data migration using EXTENSION tds_fdw

2024-01-15 Thread Adrian Klaver
On 1/14/24 10:55, Eyüp Liste wrote: Hello, I have worked on migrate a table from sql server 2017 to postgresql 15 . İ have completed all steps. But when i try to migrate some columns , i got error; NOTICE: tds_fdw: Query executed correctly NOTICE: tds_fdw: Getting results ERROR: DB-Library

Postgres authorization ad groups

2024-01-15 Thread Czajkowski Łukasz
Hello I wondering about login to postgres with different method such ldap connected with ident. Same ldap don't make problem but I think about authorization by ldap and further automatic switch usera to another user. I think about authorization for only one group of active directory. Does it

data migration using EXTENSION tds_fdw

2024-01-15 Thread Eyüp Liste
Hello, I have worked on migrate a table from sql server 2017 to postgresql 15 . İ have completed all steps. But when i try to migrate some columns , i got error; NOTICE: tds_fdw: Query executed correctly NOTICE: tds_fdw: Getting results ERROR: DB-Library error: DB #: 2403, DB Msg: Some

Re: Add support for data change delta tables

2024-01-15 Thread Thomas Kellerer
PavelTurk schrieb am 15.01.2024 um 11:00: > Currently PostgreSQL doesn't support data change delta tables. For example,  > it doesn't support this type of query: > > SELECT * FROM NEW TABLE ( > INSERT INTO phone_book > VALUES ( 'Peter Doe', '555-2323' ) > ) AS t > > PostgreSQL has 

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
po 15. 1. 2024 v 11:27 odesílatel PavelTurk napsal: > > On 1/15/24 12:17 PM, Pavel Stehule wrote: > > > > po 15. 1. 2024 v 11:11 odesílatel PavelTurk > napsal: > >> >> On 1/15/24 12:05 PM, Pavel Stehule wrote: >> >> Hi >> >> po 15. 1. 2024 v 11:00 odesílatel PavelTurk >> napsal: >> >>> Hello

Re: Add support for data change delta tables

2024-01-15 Thread PavelTurk
On 1/15/24 12:17 PM, Pavel Stehule wrote: po 15. 1. 2024 v 11:11 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal: On 1/15/24 12:05 PM, Pavel Stehule wrote: Hi po 15. 1. 2024 v 11:00 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal: Hello all,

Re: multiple missing providers from pgdg-common

2024-01-15 Thread Devrim Gündüz
Hi, On Sat, 2024-01-13 at 13:23 -0800, Joseph G wrote: > If we look, gdal35 or 36 is asking for libarmadillo.so.10 which > doesn't look like its available for EL8 just an older EL7?  I can't > get past this error at the moment. Pushed GDAL 3.6.4-6 RPMS to the repos built against armadillo 12 for

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
po 15. 1. 2024 v 11:11 odesílatel PavelTurk napsal: > > On 1/15/24 12:05 PM, Pavel Stehule wrote: > > Hi > > po 15. 1. 2024 v 11:00 odesílatel PavelTurk > napsal: > >> Hello all, >> >> >> Currently PostgreSQL doesn't support data change delta tables. For example, >> it doesn't support this

Re: Add support for data change delta tables

2024-01-15 Thread PavelTurk
On 1/15/24 12:05 PM, Pavel Stehule wrote: Hi po 15. 1. 2024 v 11:00 odesílatel PavelTurk mailto:pavelturk2...@gmail.com>> napsal: Hello all, Currently PostgreSQL doesn't support data change delta tables. For example,  it doesn't support this type of query: SELECT * FROM NEW 

Re: Add support for data change delta tables

2024-01-15 Thread Pavel Stehule
Hi po 15. 1. 2024 v 11:00 odesílatel PavelTurk napsal: > Hello all, > > > Currently PostgreSQL doesn't support data change delta tables. For example, > it doesn't support this type of query: > > SELECT * FROM NEW TABLE ( > INSERT INTO phone_book > VALUES ( 'Peter Doe', '555-2323' ) >

Add support for data change delta tables

2024-01-15 Thread PavelTurk
Hello all, Currently PostgreSQL doesn't support data change delta tables. For example, it  doesn't support this type of query: SELECT * FROM NEW TABLE ( INSERT INTO phone_book VALUES ( 'Peter Doe', '555-2323' ) ) AS t PostgreSQL has RETURNING that provides only a subset of this