Re: [GENERAL] Count column with name 'count' returns multiple rows. Why?

On 2017-08-18 15:57:39 -0500, Justin Pryzby wrote: > On Fri, Aug 18, 2017 at 10:47:37PM +0200, Peter J. Holzer wrote: > > On 2017-08-18 06:37:15 -0500, Justin Pryzby wrote: > > > On Fri, Aug 18, 2017 at 01:01:45PM +0200, Rob Audenaerde wrote: > > > > Can anyone please explain this behaviour? > > >

Re: [GENERAL] archive_command fails but works outside of Postgres

Alvaro Herrera-9 wrote > I saw one installation with "gsutil cp" in archive_command recently. > Ithad the CLOUDSDK_PYTHON environment variable set in the > archive_commanditself. Maybe that's a problem. After all, this was the solution: archive_command = 'CLOUDSDK_PYTHON=/usr/bin/python gsutil

Re: [GENERAL] archive_command fails but works outside of Postgres

> On Aug 19, 2017, at 04:05, twoflower wrote: > > Alvaro Herrera-9 wrote > I saw one installation with "gsutil cp" in archive_command recently. It had > the CLOUDSDK_PYTHON environment variable set in the archive_command itself. > Maybe that's a problem. > After all,

[GENERAL] Postgres Log Message Translations

Hello, Is there a way I can access the ".po" files containing the English -> Foreign language translations of postgres' log messages? I only need the translations from English to Japanese for a project I'm working on. Thank you! -Enis

Re: [GENERAL] Results interpretation

Igor Korot wrote: > If I do PQexec() call, the results will be interpreted as binary or text? > > I'm trying to get an int field from the query and wonder if I need to do > hton() call or not? In the most general case, you may call PQfformat(const PGresult *res, int column_number) to

Re: [GENERAL] Results interpretation

Hi, Daniel, On Sat, Aug 19, 2017 at 12:51 PM, Daniel Verite wrote: > Igor Korot wrote: > >> If I do PQexec() call, the results will be interpreted as binary or text? >> >> I'm trying to get an int field from the query and wonder if I need to do >> hton() call or

Re: [GENERAL] Results interpretation

Igor Korot wrote: > In my case I simply executing: > > SELECT t.table_catalog AS catalog, t.table_schema AS schema, > t.table_name AS table, u.usename AS owner, c.oid AS table_id FROM > information_schema.tables t, pg_catalog.pg_class c, pg_catalog.pg_user > u WHERE t.table_name =