C function returning a tuple containing an array of tuples

array (the 4th attribute of the outer tuple, in my case). For example, fcinfo->args[] array has some information about the attributes but I haven't found anything useful to call get_call_result_type(). Any suggest? Best regards Alberto

[no subject]

Good morning to all. I'd need some advice. I'm trying to install PgAdmin4 from its repository, on Debian 11, by the instructions in the concerning page in www.postgresql.org. The installation fails, as the packages cannot be verified. What shoud I do? I tried using deb [trusted=yes], but under

Re: duplicate key value violates unique constraint "chinese_price_infos_pkey"

You can fix the problem with this query: SELECT setval('chinese_price_infos_id_seq', sq.val) from ( SELECT MAX(id) as val FROM chinese_price_infos ) sq; But you have to search in your application because in some point the app are inserting the id column instead of leave this task to the DB. If y

Re: PITR based recovery in a primary/standby cluster setup

Hello.I'm not sure which replications issues you have, and I never used Wall-E before, but I get some issues with PotgreSql 10 and Barman. Try starting the primary server at first, when it finish to recovery this should start as primary, if not then go to the postgresql data directory and rename th

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

If you have the database modeled, the most quickly think I can thinks is with python framework Django. Configure the connection to the DB and make reverse engineer with Django, this create the entities class, then activate the administration forms and configure each form for the entities (few line

Re: One way replication in PostgreSQL

You could use FDW to replicate what you need to an external server from the provider/primary/master to the subscriber/secondary/slaveUsing triggers on the master tables that you want to replicate, you can execute the insert/update/delete actions on the secondary tables through the FDW.With this app

Re: One way replication in PostgreSQL

The FDW is a PostgreSQL extension to connect to other server from PosgreSQL server inside, with this solution you only need connections from P to S and no need a third server (external server), just use triggers to push the INSERT/UPDATE/DELETE information you want to replicate from P to S through

Re: Forks of pgadmin3?

You could try OmniDB, is web app but have a version that just feels like a desktop application. Is supported by 2ndQuadrant. This is the official website https://omnidb.org/en/ Greetings El vie., 22 mar. 2019 a las 4:56, Christian Henz () escribió: > I know I'm late to the party, but we're onl

PostgreSQL Kerberos Authentication

Hello All, I am trying to configure PostgreSQL9.6 (On Centos 7.4) with Kerberos (Active Directory) via GSSAPI authentication and I'm getting the following error: [postgres@hostname data]$ psql -h hostname -U usern...@domain.com postgres psql: GSSAPI continuation error: Unspecified GSS failure.

RE: PostgreSQL Kerberos Authentication

must be in uppercase or lowercase? POSTGRES or postgres? Just to confirm. Thanks Jorge From: EXTERNAL:Poul Kristensen [mailto:bcc5...@gmail.com] Sent: martes, 30 de enero de 2018 01:50 p.m. To: HIRTZ Jorge Alberto TENARIS Cc: pgsql-general@lists.postgresql.org Subject: Re: PostgreSQL

RE: PostgreSQL Kerberos Authentication

Thank you Peter!, I will check DNS configuration. Regards Jorge -Original Message- From: EXTERNAL:Peter Eisentraut [mailto:peter.eisentr...@2ndquadrant.com] Sent: miércoles, 31 de enero de 2018 01:33 a.m. To: HIRTZ Jorge Alberto TENARIS ; pgsql-general@lists.postgresql.org Subject: Re