Re: Windows installation problem at post-install step

2024-07-23 Thread Dave Page
On Tue, Jul 23, 2024 at 1:27 AM Thomas Munro wrote: > On Mon, Jul 22, 2024 at 11:51 PM Sandeep Thakkar > wrote: > > EDB's windows installer gets the locales on the system using the > https://github.com/EnterpriseDB/edb-installers/blob/REL-16/server/scripts/windows/getlocales/getlocales.cpp > and

Re: Windows installation problem at post-install step

2024-07-23 Thread Sandeep Thakkar
On Tue, Jul 23, 2024 at 1:58 PM Dave Page wrote: > > > On Tue, Jul 23, 2024 at 1:27 AM Thomas Munro > wrote: > >> On Mon, Jul 22, 2024 at 11:51 PM Sandeep Thakkar >> wrote: >> > EDB's windows installer gets the locales on the system using the >> https://github.com/EnterpriseDB/edb-installers/bl

Re: Planet Postgres and the curse of AI

2024-07-23 Thread Greg Sabino Mullane
On Fri, Jul 19, 2024 at 3:22 AM Laurenz Albe wrote: > I have no problem with that definition, but it is useless as a policy: > Even in a blog with glaring AI nonsense in it, how can you prove that the > author did not actually edit and improve other significant parts of the > text? > Well, we ca

Re: Planet Postgres and the curse of AI

2024-07-23 Thread Laurenz Albe
On Tue, 2024-07-23 at 10:38 -0400, Greg Sabino Mullane wrote: > > Why not say that authors who repeatedly post grossly counterfactual or > > misleading content can be banned? > > Perhaps as you hint at, we need a policy to not just discourage AI-generated > things, but also wrong/misleading things

Re: Planet Postgres and the curse of AI

2024-07-23 Thread Avinash Vallarapu
Hi, As someone who has taken days to publish each blog upon so many reviews, corrections and edits while attempting to make it as best/informative and as perfect as possible, it might seem slightly frustrating when we see some AI generated content, especially when it is misleading readers. Howeve

Issue while creating index dynamically

2024-07-23 Thread veem v
Hi, It's postgres version 15.4. We have a requirement to create an index on a big partition table and want to do it online. And to make the script run in an automated way on any day , through our ci/cd pipeline we were trying to write it as below inside a begin/end block. I.e. create index using "O

Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres

2024-07-23 Thread Vincent Veyron
On Mon, 15 Jul 2024 20:31:13 + Dan Kortschak wrote: > My question is where would be the best place for me to looks to learn > about how to implement a port of this SQLite? and what would broadly be > the most sensible approach to take (to narrow down what I need to read > through in learning)

Re: Issue while creating index dynamically

2024-07-23 Thread Ron Johnson
On Tue, Jul 23, 2024 at 4:10 PM veem v wrote: > Hi, > It's postgres version 15.4. We have a requirement to create an index on a > big partition table and want to do it online. And to make the script run in > an automated way on any day , through our ci/cd pipeline we were trying to > write it as

Re: Issue while creating index dynamically

2024-07-23 Thread Tom Lane
Ron Johnson writes: > On Tue, Jul 23, 2024 at 4:10 PM veem v wrote: >> But we are getting an error while executing saying it cant be executed in >> transaction block with "CONCURRENTLY". So I want to understand , is there >> any alternate way to get away with this? > I'd write that in bash, not

Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres

2024-07-23 Thread Adrian Klaver
On 7/23/24 13:11, Vincent Veyron wrote: On Mon, 15 Jul 2024 20:31:13 + Dan Kortschak wrote: My question is where would be the best place for me to looks to learn about how to implement a port of this SQLite? and what would broadly be the most sensible approach to take (to narrow down what

Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres

2024-07-23 Thread Dominique Devienne
On Tue, Jul 23, 2024 at 10:35 PM Adrian Klaver wrote: > Just know that SQLite does not enforce types [...] That's true, and applies to the OP's schema. But for the record, SQLite *can* enforce types these days, on an opt-in basis, with [STRICT tables][1]. Albeit with a limited type-system. --DD

Re: re-novice coming back to pgsql: porting an SQLite update statement to postgres

2024-07-23 Thread Dan Kortschak
On 7/23/24 13:11, Vincent Veyron wrote: > On Mon, 15 Jul 2024 20:31:13 + > > This is the goto page for anything SQL : > https://www.postgresql.org/docs/current/sql-commands.html > > For DateTime types : > https://www.postgresql.org/docs/current/datatype-datetime.html > > For JSON types : > http