On Thu, Jul 25, 2024 at 7:42 AM veem v wrote:
> I was thinking the individual statement will work fine if I pull out those
> from the begin..end block, as those will then be not bounded by any outer
> transaction.
> However, When I was trying it from dbeaver by extracting individual index
> cr
On Wed, 24 Jul 2024 at 02:02, Tom Lane wrote:
> 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 altern
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
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
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
