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

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 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: 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: 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: 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)

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: 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

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 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: 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: 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