Re: Tools to convert timestamp data to another time zone in PostgreSQL

On Mon, Jun 13, 2022 at 09:52:00PM +, Joel Rabinovitch wrote: >Hi, > > > >We have recently modified our application to work with PostgreSQL >databases and schemas. We also support Oracle and SQL Server Databases. [skipped] > >As a result, we have hit an issue where we n

RE: Build Postgres On AIX

Postgres will not build on AIX with either of the following options to the configure script: --with-uuid=e2fs --with-uuid=ossp so I was using --with-uuid=bsd which does work except for the arc4random undefined symbol error I was getting. I removed the --with-uuid=bsd option to the configure scr

Re: multiple entries for synchronous_standby_names

On Fri, Jun 10, 2022 at 05:04:30PM +0100, Nitesh Nathani wrote: > Trying to achieve sync streaming to barman server and i need to add an > entry to postgresql.conf for this parameter, which already has an entry and > tried a few variations but does not work. Any ideas? Also tried '&&' but in > vain

Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"

> x...@thebuild.com wrote: > > Isn't one of the reasons for the savepoint (in fact, the principal reason) to > reset the connection back to non-error state so that execution can continue? > In that case, it really does need to create the savepoint at the start of the > block, regardless of what

Re: Tools to convert timestamp data to another time zone in PostgreSQL

On 6/13/22 2:52 PM, Joel Rabinovitch wrote: Hi, We have recently modified our application to work with PostgreSQL databases and schemas. We also support Oracle and SQL Server Databases. Along with adding support for PostgreSQL, we have upgraded our infrastructure such that all environments a

Tools to convert timestamp data to another time zone in PostgreSQL

Hi, We have recently modified our application to work with PostgreSQL databases and schemas. We also support Oracle and SQL Server Databases. Along with adding support for PostgreSQL, we have upgraded our infrastructure such that all environments are configured to use the UTC time zone. Previou

Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"

> On Jun 12, 2022, at 23:07, Pavel Stehule wrote: > The lazy implementation theoretically can be possible, but why? Isn't one of the reasons for the savepoint (in fact, the principal reason) to reset the connection back to non-error state so that execution can continue? In that case, it rea

Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"

po 13. 6. 2022 v 21:02 odesílatel Bryn Llewellyn napsal: > *pavel.steh...@gmail.com wrote:* > > *b...@yugabyte.com napsal:* > > Does the “Tip” call-out box, from which the “Subject” here is copied, and > the larger story that I copied below, apply even when the executable > section of the block

Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"

Bryn Llewellyn writes: > OK, so I'm obliged to answer. > Because SQL rests on the principle that you just say *what* you want but > not *how*. It also rests on the principle that the programmer shouldn't be too concerned about micro-efficiencies. You've given a perfectly good six-line implementa

Re: "A block containing an EXCEPTION clause is significantly more expensive to enter and exit than a block without one"

> pavel.steh...@gmail.com wrote: > >> b...@yugabyte.com napsal: >> >> Does the “Tip” call-out box, from which the “Subject” here is copied, and >> the larger story that I copied below, apply even when the executable section >> of the block statement in question does nothing at all that could be

Re: Need optimization in query

Hi Team, Does anybody tried to have a look at it and would like to suggest any optimisations? Thanks On Sat, Jun 11, 2022 at 12:48 AM Shubham Mittal wrote: > Hi Team. > > *I have a use case to get the result as follows:* > > 1. asin_ymm is never null. > 2. If there is more than 1 entry for an