Re: [GENERAL] Two different (postgresql & postgresql93) packages installed?

On 11/06/2015 05:24 PM, Michael Convey wrote: Below is from my OpenSUSE command line. I only installed the first package, but both say, "Installed: Yes". Why is this? Are they really the same package? linux-srqm:~ # zypper info postgresql Loading repository data... Reading installed

[GENERAL] Two different (postgresql & postgresql93) packages installed?

Below is from my OpenSUSE command line. I only installed the first package, but both say, "Installed: Yes". Why is this? Are they really the same package? linux-srqm:~ # zypper info postgresql Loading repository data... Reading installed packages... Information for package postgresql:

Re: [GENERAL] Auto-analyse on insert operations

On 11/06/2015 09:13 AM, Bertrand Roos wrote: Le 04/11/2015 16:57, Adrian Klaver a écrit : On 11/04/2015 07:43 AM, Bertrand Roos wrote: Le 04/11/2015 14:55, Bill Moran a écrit : On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: I try to configure auto-analyse

Re: [GENERAL] How to search a string inside a json structure

Hi, I have simplified the case and tried to look from a list of json items (please see test table content). I think I have managed to unpack values in such a way that also partial matching is possible. However, the end result has two "value" named columns even if I have tried to rename them. How

Re: [GENERAL] pg_archivecleanup not deleting anything?

Michael Paquier wrote: >>> Something among those lines? >> >>> + >>> + WAL file segments and WAL file segments with .partial >>> + are deleted, while timeline history files and backup history files are >>> not. >>> + >> >> "WAL file segments with .partial" sounds strange. >> What about

Re: [GENERAL] is there any difference DROP PRIMARY KEY in oracle and postgres?

On 11/5/2015 11:25 PM, Thomas Kellerer wrote: But having an "alter table drop primary key" would indeed be nice. is that syntax in the sql standard? or is it just an oraclism? do any other major sql's have an equivalent ? -- john r pierce, recycling bits in santa cruz -- Sent via

Re: [GENERAL] ftell mismatch with expected position

> > Presumably it doesn't happen without the use of the pipe notation. > Indeed, it only happens when a pipe is involved. > > I suspect that what's happening is that stdout isn't getting put into > binary mode, so that Microsoft's CR/NL translation corrupts the data. > If that's true, though,

[GENERAL] "Web of trust" connections

Purely out of curiosity, is there any way of using some sort of "web of trust" (comparable with GPG or whatever) when verifying server and client certificates, rather than going back to a centralised CA? My apologies if this is a silly question, or if there are fundamental reasons why such a

Re: [GENERAL] is there any difference DROP PRIMARY KEY in oracle and postgres?

John R Pierce writes: > On 11/5/2015 11:25 PM, Thomas Kellerer wrote: >> But having an "alter table drop primary key" would indeed be nice. > is that syntax in the sql standard? or is it just an oraclism? AFAICS there is no such syntax in SQL:2011 --- it only offers

Re: [GENERAL] Auto-analyse on insert operations

Le 04/11/2015 16:57, Adrian Klaver a écrit : On 11/04/2015 07:43 AM, Bertrand Roos wrote: Le 04/11/2015 14:55, Bill Moran a écrit : On Wed, 4 Nov 2015 14:32:37 +0100 Bertrand Roos wrote: I try to configure auto-analyse task with postgresql 9.4. I have the