Re: minor upgrade

On 6/24/19 6:42 PM, Prakash Ramakrishnan wrote: Hi Team, I had an one small issue i did the installation 11.2 using pgdg repo file in production server now how can i update or upgrade the 11.4 version please do the needfull? Whether it is deb or rpm do something like: 1) Package manager upd

Re: Function Volatility Stable vs Immutable

On 6/24/2019 7:38 PM, David G. Johnston wrote: On Mon, Jun 24, 2019 at 7:31 PM Igal @ Lucee.org > wrote: If a function select data from a table, and the rows in the table may change, would that function qualify for Immutable or does it have to be Stable?  I

Re: Function Volatility Stable vs Immutable

On Mon, Jun 24, 2019 at 7:31 PM Igal @ Lucee.org wrote: > If a function select data from a table, and the rows in the table may > change, would that function qualify for Immutable or does it have to be > Stable? I'm asking because according to the docs [1]: "An IMMUTABLE > function cannot modify

Function Volatility Stable vs Immutable

If a function select data from a table, and the rows in the table may change, would that function qualify for Immutable or does it have to be Stable?  I'm asking because according to the docs [1]: "An IMMUTABLE function cannot modify the database and is guaranteed to return the same results giv

minor upgrade

Hi Team, I had an one small issue i did the installation 11.2 using pgdg repo file in production server now how can i update or upgrade the 11.4 version please do the needfull? -- Thanks, Prakash.R

Re: Coalesce 2 Arrays

On 6/24/19 5:19 PM, David G. Johnston wrote: On Mon, Jun 24, 2019 at 4:11 PM Rob Sargent > wrote: On 6/24/19 4:46 PM, Alex Magnum wrote: Yes, they are. On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent mailto:robjsarg...@gmail.com>> wrote:

Re: Coalesce 2 Arrays

On Mon, Jun 24, 2019 at 4:11 PM Rob Sargent wrote: > > On 6/24/19 4:46 PM, Alex Magnum wrote: > > Yes, they are. > > On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent wrote: > >> >> >> On Jun 24, 2019, at 2:31 PM, Alex Magnum wrote: >> >> Hi, >> I have two arrays which I need to combine based on the

Re: Coalesce 2 Arrays

On 6/24/19 4:46 PM, Alex Magnum wrote: Yes, they are. On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent > wrote: On Jun 24, 2019, at 2:31 PM, Alex Magnum mailto:magnum11...@gmail.com>> wrote: Hi, I have two arrays which I need to combine based on the in

Re: Coalesce 2 Arrays

On 6/24/19 4:46 PM, Alex Magnum wrote: Yes, they are. On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent > wrote: On Jun 24, 2019, at 2:31 PM, Alex Magnum mailto:magnum11...@gmail.com>> wrote: Hi, I have two arrays which I need to combine based on the in

Re: Need a DB layout gui

I've been enjoying dbeaver for this Tim Clarke IT Director Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420 On 24/06/2019 23:38, Adrian Klaver wrote: > On 6/24/19 3:25 PM, David Gauthier wrote: >> Hi: >> >> I've been poking around >> https://wiki.postgresql.org/wiki/Community_Guide_to_Pos

Re: Coalesce 2 Arrays

Yes, they are. On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent wrote: > > > On Jun 24, 2019, at 2:31 PM, Alex Magnum wrote: > > Hi, > I have two arrays which I need to combine based on the individual values; > i could do a coalesce for each field but was wondering if there is an > easier way > > ar

Re: Need a DB layout gui

On 6/24/19 3:25 PM, David Gauthier wrote: Hi: I've been poking around https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to see if there is anything that can read PG metadata in and display it graphically in a gui.  You know, the kind of picture that is 1 block per tabl

Re: Need a DB layout gui

On Mon, 24 Jun 2019, David Gauthier wrote: I've been poking around https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to see if there is anything that can read PG metadata in and display it graphically in a gui. You know, the kind of picture that is 1 block per table with 1

Re: Need a DB layout gui

On 6/24/19 3:25 PM, David Gauthier wrote: Hi: I've been poking around https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to see if there is anything that can read PG metadata in and display it graphically in a gui.  You know, the kind of picture that is 1 block per tabl

Need a DB layout gui

Hi: I've been poking around https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to see if there is anything that can read PG metadata in and display it graphically in a gui. You know, the kind of picture that is 1 block per table with 1->many arrows connecting up the primary/

Re: Coalesce 2 Arrays

> On Jun 24, 2019, at 2:31 PM, Alex Magnum wrote: > > Hi, > I have two arrays which I need to combine based on the individual values; > i could do a coalesce for each field but was wondering if there is an easier > way > > array_a{a, null,c, d,null,f,null} primary > array_b{null,2 ,nul

Coalesce 2 Arrays

Hi, I have two arrays which I need to combine based on the individual values; i could do a coalesce for each field but was wondering if there is an easier way array_a{a, null,c, d,null,f,null} primary array_b{null,2 ,null,4,5 ,6,null} secondary result {a, 2, c, d,5, f,null) Any

RE: [EXT EMAIL] Re: First Time Starting Up PostgreSQL and Having Problems

> From: Tom Lane Brent Bates writes: > > I found the problem. I cleared everything out and started from > > scratch, then slowly added my changes back to the configuration files. The > > problem was in the postgresql.conf. At the bottom of the file I had > > uncommented all the ‘includ

encryption of specific columns

Hello, I've read the 10.x handbook, chapter 18.8. about the various encryption options. One question remains: If I encrypt a column, for example the birthdate of PII data, is this still searchable with SELECT * FROM table WHERE birthdate = 07.12.1955; Thanks matthias -- Matthias Apit

Re: got stuck in pglogical upgrade on FreeBSD

On 24/6/19 12:20 μ.μ., Rahul Chordiya wrote: Hi, Sorry for delayed response. Hello, did you use gcc or clang/llvm? I would suggest trying with gcc. * * * * -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt

RE: sequences

Thanks for replies. I looked at some tutorial page and there were more instructions in that, so got confused. I was aware sequences create integers. //Martin S Disclaime

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

Shay Rojansky writes: >> I don't think that's true - schema information (table, column names) >> definitely seems like it's in a different category than table contents. > > You're not visualizing this with the appropriate amount of paranoia: just > because the database thinks that something is a

Re: sequences

There's nothing really "in" a sequence, it just generates numbers for you, generally for unintelligent primary keys. Those statements perfectly create new sequences which will start from 1. Tim Clarke IT Director Direct: +44 (0)1376 504510 | Mobile: +44 (0)7887 563420 On 24/06/2019 10:01, Karl

Re: sequences

Hi Karl I did not double check with the doc whether the SQL you posted is valid (I guess it could by applying the defaults) however I do not see how sequences would govern the sending of data to users. Kind regards Thiemo Quoting Karl Martin Skoldebrand : Hi, I'm trying to troubleshoot

Re: got stuck in pglogical upgrade on FreeBSD

Hi, Sorry for delayed response. The first error is: pglogical_fe.c:54:7: error: implicit declaration of function 'WIFEXITED' is invalid in C99 [-Werror,-Wimplicit-function-declaration] if (WIFEXITED(ret)) ^ pglogical_fe.c:55:124: error: implicit declaration of function 'WEXITSTATUS' is invalid in

sequences

Hi, I'm trying to troubleshoot a case where users are getting data from a database, despite they having said they are not interested. There is a number of sequences in the database in question, but to me they look "empty", like stubs. create sequence db_table_seq; alter sequence db_table_seq o