Re: Restoring database from false update

On Sunday, November 15, 2020, Maksim Fomin wrote: > > > plsql -d tsvt > psql (12.5) > Type "help" for help. > > tsvt=# \dt+ > List of relations > Schema | Name | Type | Owner | Size | Description > +--+---+--+-+- > public | te

Restoring database from false update

‐‐‐ Original Message ‐‐‐ On Sunday, November 15, 2020 4:47 AM, David G. Johnston wrote: > On Fri, Nov 13, 2020 at 1:56 PM Maksim Fomin wrote: > >> Later, I stopped the service and moved backup folder to the usual place. For >> some reason psql shows that there are no relations found in

Re: ERROR: could not find tuple for statistics object - is there a way to clean this up?

Morris de Oryx writes: > And here's the error that I get back: > ERROR: could not find tuple for statistics object 147574. Can you give a self-contained recipe for triggering this? regards, tom lane

ERROR: could not find tuple for statistics object - is there a way to clean this up?

I've been experimenting with CREATE STATISTICS to declare some functionally dependent columns. Right now, I'm working with a local copy of Postgres running on this version: PostgreSQL 12.5 on x86_64-apple-darwin16.7.0, compiled by Apple LLVM version 8.1.0 (clang-802.0.42), 64-bit We deploy on RDS

Re: Range partitioning and overlap

On Fri, Nov 13, 2020 at 2:08 PM Edson Richter wrote: > *De:* Tom Lane > *Enviado:* sexta-feira, 13 de novembro de 2020 17:58 > *Para:* Edson Richter > *Cc:* David G. Johnston ; pgsql-general < > pgsql-gene...@postgresql.org> > *Assunto:* Re: Range partitioning and overlap > > Edson Richter wri

Re: Restoring database from false update

On Fri, Nov 13, 2020 at 1:56 PM Maksim Fomin wrote: > Later, I stopped the service and moved backup folder to the usual place. > For some reason psql shows that there are no relations found in the > database, although the database is listed. My next step was to copy data > from file-system level

Re: New "function tables" in V13 documentation

On Fri, Nov 13, 2020 at 1:48 PM Adrian Klaver wrote: > Which is an indication that for changes of this scope it would be > prudent to create a mock up and have end users see and comment on before > rolling them out. > There were mockups and people did provide comments. Do you have any concrete

Re: I have just downloaded Postgre SQL and "pgadmin 4" doesn't open.

On 11/14/20 3:45 PM, Ecenur Corlu wrote: *I have just downloaded the latest version of PostgreSQL (vs.13.1) and Where did you download it from? More comments inline below. when I try to open "pgadmin 4", it doesn't open.* It first shows How are you starting it? */windows wait cursor/* an

I have just downloaded Postgre SQL and "pgadmin 4" doesn't open.

*I have just downloaded the latest version of PostgreSQL (vs.13.1) and when I try to open "pgadmin 4", it doesn't open.* It first shows *windows wait cursor* and then the wait cursor gets lost. Nothing happens. *I also realized that there is no folder created under* C:\Program Files. *like this* >

Re: conflict with recovery when delay is gone

On Sat, Nov 14, 2020 at 2:46 PM Radoslav Nedyalkov wrote: > > > On Fri, Nov 13, 2020 at 8:13 PM Radoslav Nedyalkov > wrote: > >> >> >> On Fri, Nov 13, 2020 at 7:37 PM Laurenz Albe >> wrote: >> >>> On Fri, 2020-11-13 at 15:24 +0200, Radoslav Nedyalkov wrote: >>> > On a very busy master-standby s

Re: conflict with recovery when delay is gone

On Fri, Nov 13, 2020 at 8:13 PM Radoslav Nedyalkov wrote: > > > On Fri, Nov 13, 2020 at 7:37 PM Laurenz Albe > wrote: > >> On Fri, 2020-11-13 at 15:24 +0200, Radoslav Nedyalkov wrote: >> > On a very busy master-standby setup which runs typical olap processing - >> > long living , massive writes

Re: PostgreSQL equivalent to Oracles ANYDATASET

Hi, many thanks for this suggestion. But the problem with this is that you have to know which columns are returned when you call the function. Regards Dirk -- Dirk Mika Software Developer [cid:mt_c1c59b3d-dd43-4ca6-992b-79f5a19f5999.png] mika:timing GmbH Strundepark - Kürtener Str. 11b 5146