Data entry / data editing tools (more end-user focus).

2019-03-27 Thread Tony Shelver
Looking for a good tool that I can give to users to enter data (for example, products, categories, brands, price tables and so on). Preferably it should also allow images to be copied into a bytea field but I know I can't have everything. Been battling with a few open source 'headless' content man

Re: plctl extension issue postgresql 11.2

2019-03-27 Thread Prakash Ramakrishnan
Hi Adrian, Sorry for late reply am try to install the plctl but still getting error. [root@brurhenaaa001 postgres]# rpm -ivh postgresql11-pltcl-11.2-2PGDG.rhel7.x86_64.rpm error: Failed dependencies: postgresql11(x86-64) = 11.2-2PGDG.rhel7 is needed by postgresql11-pltcl-11.2-2PGDG.rhel7.

Upgrading PostgreSQL under Windows

2019-03-27 Thread Kumar Prince NCS
Hi Team, We are Upgrading PostgreSQL under Windows from v9.3 to 9.5. Following steps from https://www.postgresql.org/docs/10/pgupgrade.html We are using PostgreSQL database for confluence application. While running Step 9 , there is command to set path with postgres user. As per installation

Re: Upgrading PostgreSQL under Windows

2019-03-27 Thread Arnaud L.
Le 27/03/2019 à 07:02, Kumar Prince NCS a écrit : We are  Upgrading PostgreSQL under Windows from v9.3 to 9.5. Following steps from https://www.postgresql.org/docs/10/pgupgrade.html We are using PostgreSQL database for confluence application. While running Step 9 , there is command to set path

Re: Upgrading PostgreSQL under Windows

2019-03-27 Thread Thomas Kellerer
Arnaud L. schrieb am 27.03.2019 um 14:00: > Le 27/03/2019 à 07:02, Kumar Prince NCS a écrit : >> We are  Upgrading PostgreSQL under Windows from v9.3 to 9.5. Following steps >> from https://www.postgresql.org/docs/10/pgupgrade.html >> >> We are using PostgreSQL database for confluence application.

Re: plctl extension issue postgresql 11.2

2019-03-27 Thread Adrian Klaver
On 3/27/19 2:46 AM, Prakash Ramakrishnan wrote: Hi Adrian, Sorry for late reply am try to install the plctl but still getting error. From looks of it you did not do the original install of Postgres from the PGDG repos. The first thing you need to figure out is where you installed Postgres fr

Re: Data entry / data editing tools (more end-user focus).

2019-03-27 Thread Adrian Klaver
On 3/27/19 3:48 AM, Tony Shelver wrote: Looking for a good tool that I can give to users to enter data (for example, products, categories, brands, price tables and so on). Preferably it should also allow images to be copied into a bytea field but I know I can't have everything. Been battling w

Is it possible to have a cascade upwards query?

2019-03-27 Thread Mike Martin
As per title, is this possible? Scenario being two tables with a linking pair of fields, where one table is a superset of the other and key is generated by the second table I would like to have the record in table two deleted when I delete the record in table 1 Thanks

Re: Is it possible to have a cascade upwards query?

2019-03-27 Thread Adrian Klaver
On 3/27/19 8:58 AM, Mike Martin wrote: As per title, is this possible? Scenario being two tables with a linking pair of fields, where one table is a superset of the other and key is generated by the second table I would like to have the record in table two deleted when I delete the record in

Re: Is it possible to have a cascade upwards query?

2019-03-27 Thread Joseph Testa
Is this like a cascade delete based on constraints(like in the oracle world), delete parent and all children go away also? joe On Wed, Mar 27, 2019 at 12:15 PM Adrian Klaver wrote: > On 3/27/19 8:58 AM, Mike Martin wrote: > > As per title, is this possible? > > > > Scenario being two tables wi

Re: plctl extension issue postgresql 11.2

2019-03-27 Thread Adrian Klaver
On 3/27/19 8:32 AM, Prakash Ramakrishnan wrote: Hi Adrian, Sorry for the late reply please find the below details, Again I am not a RH user so take the following with that in mind. What if you do?: sudo yum install postgresql11-tcl [root@brurhenaaa001 postgres]# yum list installed | grep

Re: plctl extension issue postgresql 11.2

2019-03-27 Thread Prakash Ramakrishnan
Hi Adrian, Sorry for the late reply please find the below details, [root@brurhenaaa001 postgres]# yum list installed | grep -i postgresql postgresql.x86_64 9.2.24-1.el7_5 @rhel-7-server-rpms postgresql-devel.x86_64 9.2.24-1.el7_5 @rhel-7-server-rpms postgresql-

Re: Is it possible to have a cascade upwards query?

2019-03-27 Thread David G. Johnston
On Wed, Mar 27, 2019 at 8:58 AM Mike Martin wrote: > Scenario being two tables with a linking pair of fields, where one table > is a superset of the other and key is generated by the second table > > I would like to have the record in table two deleted when I delete the > record in table 1 > Sin