Re: determine what column(s) form the primary key, in C extention

2020-08-30 Thread James Sewell
> > (2) > > I'll use this C code as an example to build an extention in Rust. The > Postgresql bindings for Rust I have don't contain a definition of > `FirstLowInvalidHeapAttributeNumber` for some reason. I can define it > since it's simply single digit constant. > Not an answer to your question

Re: Postgres DB hacked.

2020-08-30 Thread Ron
On 8/30/20 11:58 PM, Yogesh Sharma wrote: Dear All, Thanks for your support. We faced the below issue and our all DB backup data has lost.  It seems Hacker deleted all the tables in the DB and created a single table called "warning". when I am trying to select this table so it's showing Error

Re: Postgres DB hacked.

2020-08-30 Thread Pavel Stehule
po 31. 8. 2020 v 6:58 odesílatel Yogesh Sharma napsal: > Dear All, > Thanks for your support. > > We faced the below issue and our all DB backup data has lost. > > It seems Hacker deleted all the tables in the DB and created a single > table called "warning". when I am trying to select this tabl

Postgres DB hacked.

2020-08-30 Thread Yogesh Sharma
Dear All, Thanks for your support. We faced the below issue and our all DB backup data has lost. It seems Hacker deleted all the tables in the DB and created a single table called "warning". when I am trying to select this table so it's showing Error (relation "warning" does not exist). Hacker c

Re: Request clarification w/ PG_DUMPALL -d.

2020-08-30 Thread Adrian Klaver
On 8/30/20 7:31 AM, ERR ORR wrote: I'm trying to migrate a 9.5 DB to a current version using PG_DUMPALL. It reclaims that what I pass in the -d parameter is missing a "=" and the man directs me to look at chapter 31.1.1 Connection Strings of the dox PDF. The Problem is that there are different

Request clarification w/ PG_DUMPALL -d.

2020-08-30 Thread ERR ORR
I'm trying to migrate a 9.5 DB to a current version using PG_DUMPALL. It reclaims that what I pass in the -d parameter is missing a "=" and the man directs me to look at chapter 31.1.1 Connection Strings of the dox PDF. The Problem is that there are different connection strings listed there and I d

Re: How to properly query lots of rows based on timestamps?

2020-08-30 Thread Thorsten Schöning
Guten Tag Tom Lane, am Samstag, 29. August 2020 um 17:19 schrieben Sie: > Timestamp comparison reduces to comparison of int64's, so it's > hard to imagine that anything could be much cheaper.[...] Do you think it matters much if the timestamp related calculations are done outside the query by the

Re: How to properly query lots of rows based on timestamps?

2020-08-30 Thread Thorsten Schöning
Guten Tag Alban Hertroys, am Samstag, 29. August 2020 um 11:29 schrieben Sie: > [...]Next, it loops over those to match the other condition of > your query (id = clt_rec.oms_rec). You didn’t tell whether there’s > an index on that column. Which column, oms_rec.id or clt_rec.oms_rec? The former ha

Re: How to properly query lots of rows based on timestamps?

2020-08-30 Thread Thorsten Schöning
Guten Tag Tom Lane, am Samstag, 29. August 2020 um 17:19 schrieben Sie: > TBH, this seems like a pretty awful data design. If you included the > timestamp column into oms_rec, and had an index on it, then you would > not need a join at all. clt_rec and oms_rec are different types of data and onl