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

2022-06-13 Thread Ilya Anfimov
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: lifetime of the old CTID

2022-07-06 Thread Ilya Anfimov
On Wed, Jul 06, 2022 at 02:26:00PM +0200, Matthias Apitz wrote: > El d??a Mittwoch, Juli 06, 2022 a las 11:45:14 +0200, Karsten Hilbert > escribi??: > > > Am Wed, Jul 06, 2022 at 08:18:42AM +0200 schrieb Matthias Apitz: > > [skipped] > WHERE-clause of its interest ("WHERE d01status=4"), here a

Re: jsonb Indexing

2021-09-20 Thread Ilya Anfimov
On Mon, Sep 20, 2021 at 12:52:54PM +0200, rami...@gmail.com wrote: > Hello Julien, > > On 9/17/21 4:00 PM, Julien Rouhaud wrote: > > Hi, > > > > On Fri, Sep 17, 2021 at 9:55 PM wrote: > > > I was wondering what I'm doing wrong. There are steps what I've tried: > > > > > > CREATE TABLE api ( > >

Re: develop a extension with cpp?

2021-11-02 Thread Ilya Anfimov
On Tue, Nov 02, 2021 at 01:31:22AM +, huangning...@yahoo.com wrote: >Hi >if i can develop a extension with cpp language? >regards! Generally, like in any other language. Write files, use calls and APIs available inside Postgres, compile it and install to postgres direct

Re: SELECT fails to present result rows depending on the columns to show

2021-11-23 Thread Ilya Anfimov
On Tue, Nov 23, 2021 at 09:15:06AM +0100, Matthias Apitz wrote: > > Hello, > > We encounter the following problem in a 13.1 server on Linux: > > sisis=# select desk, feldnr from titel_worte where desk = '2' and feldnr = > 257; > desk | feldnr > --+ > 2|257 > (1 row) > >

Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication

2024-11-25 Thread Ilya Anfimov
On Sun, Nov 24, 2024 at 09:35:15PM +0530, Subhash Udata wrote: >Dear PostgreSQL Community, > >I have a production database setup with a primary server and a standby >server. The database is currently running on PostgreSQL 15.0, and I plan >to upgrade both servers to 15.9. > >I