Re: FW: Error!

2023-04-15 Thread Adrian Klaver
On 4/15/23 16:56, Arquimedes Aguirre wrote: Adrian I am new using this postgres program and pgadmin 4 sorry, I am starting to use it. First to be clear Postgres is the database server and pgAdmin4 is just a client for that server, a GUI in this case. In your first question, you mean

Re: FW: Error!

2023-04-15 Thread Adrian Klaver
On 4/15/23 15:28, Arquimedes Aguirre wrote: Hi Dear If I have the postgres and admin 4 program running with the password that I set from the beginning, but when I want to start the psql shell and set the same password, it throws me the error, I send the screen I think it's self explanatory .

Re: cursors with prepared statements

2023-04-15 Thread Bryn Llewellyn
> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> I found this email from Peter Eisentraut: >> https://www.postgresql.org/message-id/762cc764-74f0-13fb-77ed-16f91c90f40d%402ndquadrant.com >> >> It caused the 42601 error, « syntax error at or near “execute” ». So it >>

Re: cursors with prepared statements

2023-04-15 Thread David G. Johnston
On Sat, Apr 15, 2023 at 2:15 PM Bryn Llewellyn wrote: > I found this email from Peter Eisentraut: > > https://www.postgresql.org/message-id/762cc764-74f0-13fb-77ed-16f91c90f40d%402ndquadrant.com > > It caused the 42601 error, « syntax error at or near “execute” ». So it > looks like Peter’s

Re: cursors with prepared statements

2023-04-15 Thread Bryn Llewellyn
I found this email from Peter Eisentraut: https://www.postgresql.org/message-id/762cc764-74f0-13fb-77ed-16f91c90f40d%402ndquadrant.com > I have developed a patch that allows declaring cursors over prepared > statements... This is an SQL standard feature. ECPG already supports it (with >

Logical replication failed with SSL SYSCALL error

2023-04-15 Thread shaurya jain
Hi Team, Postgres Version:- 13.8 Issue:- Logical replication failing with SSL SYSCALL error Priority:-High We are migrating our database through logical replications, and all of sudden below error pops up in the source and target logs which leads us to nowhere. *Logs from Source:-* LOG: could

RE: FW: Error!

2023-04-15 Thread Arquimedes Aguirre
Hi Dear! I was able to install the postgresql program and admin 4, as I told you before, but I got this type of error more than 30 times downloading various versions of postgresql that are in the link that you sent me, that's why I had to ask for help from Microsoft Team team, since it is a

Re: FW: Error!

2023-04-15 Thread Adrian Klaver
On 4/15/23 07:39, Arquimedes Aguirre wrote: Hi Dear! I was able to install the postgresql program and admin 4, as I told you before, but I got this type of error more than 30 times downloading various versions of postgresql that are in the link that you sent me, This is the part that

Re: Guidance on INSERT RETURNING order

2023-04-15 Thread Mike Bayer
On Fri, Apr 14, 2023, at 11:17 PM, Tom Lane wrote: > Federico writes: >> Would something like what was proposed by Mike Bayer be considered? > >>> A new token called "tuple_order" or something >>> >>> INSERT INTO table (a, b, c) VALUES ((1, 2, 3), (4, 5, 6), ...) RETURNING >>> table.id,

Re: JSON / ASP.NET AJAX Dates support in PostgreSQL

2023-04-15 Thread Peter J. Holzer
On 2023-04-15 09:12:41 -0700, Adrian Klaver wrote: > On 4/15/23 03:46, Peter J. Holzer wrote: > > On 2023-04-14 10:44:08 -0700, Adrian Klaver wrote: > > > On 4/14/23 9:31 AM, Peter J. Holzer wrote: > > > > On 2023-04-13 10:07:09 -0500, Ron wrote: > > > > > On 4/13/23 09:44, Sebastien Flaesch

Re: JSON / ASP.NET AJAX Dates support in PostgreSQL

2023-04-15 Thread Adrian Klaver
On 4/15/23 03:46, Peter J. Holzer wrote: On 2023-04-14 10:44:08 -0700, Adrian Klaver wrote: On 4/14/23 9:31 AM, Peter J. Holzer wrote: On 2023-04-13 10:07:09 -0500, Ron wrote: On 4/13/23 09:44, Sebastien Flaesch wrote: Is there an easy way to convert JSON data containing ASP.NET AJAX

Re: Guidance on INSERT RETURNING order

2023-04-15 Thread Federico
On Sat, 15 Apr 2023 at 15:40, Tom Lane wrote: > > Federico writes: > > I think the tuple order would not be connected to the values, but be > > determined by the input order of the rows in the insert. So when using > > INSERT ... SELECT the tuple_order value would be determined by the > > output

Re: Guidance on INSERT RETURNING order

2023-04-15 Thread Tom Lane
Federico writes: > I think the tuple order would not be connected to the values, but be > determined by the input order of the rows in the insert. So when using > INSERT ... SELECT the tuple_order value would be determined by the > output of the select, using the same logic as ROW_NUMBER. We

Re: JSON / ASP.NET AJAX Dates support in PostgreSQL

2023-04-15 Thread Peter J. Holzer
On 2023-04-14 10:44:08 -0700, Adrian Klaver wrote: > On 4/14/23 9:31 AM, Peter J. Holzer wrote: > > On 2023-04-13 10:07:09 -0500, Ron wrote: > > > On 4/13/23 09:44, Sebastien Flaesch wrote: > > > Is there an easy way to convert JSON data containing ASP.NET AJAX > > > Dates > > > into

Should I add a new schema for my application?

2023-04-15 Thread Alexander Farber
Good morning, I am seeking for a general advice if it would be a good idea for a PostgreSQL/PostGIS using application to add a third schema. I am using postgis/postgis Docker image which comes with "public" schema. Then I have loaded OpenStreetMap data into the database and have created

Re: Guidance on INSERT RETURNING order

2023-04-15 Thread Federico
On Sat, 15 Apr 2023 at 05:17, Tom Lane wrote: > > Federico writes: > > Would something like what was proposed by Mike Bayer be considered? > > >> A new token called "tuple_order" or something > >> > >> INSERT INTO table (a, b, c) VALUES ((1, 2, 3), (4, 5, 6), ...) RETURNING > >> table.id,