Re: [GENERAL] JSON_AGG produces extra square brakets

Thank you! Glad to have helped! On Tue, Dec 2, 2014 at 7:40 PM, Tom Lane wrote: > Davide S writes: > > This is a small testcase that reproduces the problem on my machine. > > Ah, I see it: json_agg_finalfn is violating the rule that an aggregate > final function can't sc

Re: [GENERAL] JSON_AGG produces extra square brakets

| [{"image_url":"img1.jpg","severity":10}, {"image_url":"img2.jpg","severity":20}]] (2 rows) Note the ']]' at the end of the second row (the third would have 3 brackets, and so on). Some info on my system (debian testing, u

[GENERAL] JSON_AGG produces extra square brakets

I'm using JSON_AGG to create some arrays, but I get an invalid json (I'm using the latest postgres 9.4 in debian testing). Quick explanation: I've got some objects called Things that have Tags (many-to-many through the table ThingTag); Things also have a single ThingTemplate, which has ThingStates

Re: [GENERAL] Sharing data directories between machines

s to that one. I was able to have both access the same > databases, but they can't share changes. It's like they're running on two > separate data directories, even though show data_directory reports the same > path for each. > > How can I make them play nicely? >

[GENERAL] Speedup filtering on citext[] columns

rnal, internal, internal), FUNCTION4 ginarrayconsistent(internal, smallint, anyarray, integer, internal, internal, internal, internal), STORAGE citext; Regards. -- Davide Setti code: http://github.com/vad -- Sent via pgsql-general mailing list (pgsql-gene

[GENERAL] Question on the 8.0Beta Version

that this happen only with the beta version? When will you plan to release the production version?   Thanks You   Negri Davide --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.779 / Virus Database: 526 - Release Date: 19

[GENERAL] Log

Hello, i have installed the 8.0 beta3-dev1 version of postgres on my pc, and I want to disable log. How can I do? It is possible to disable and don’t write all the log, or how can I write all the log in a specific directory??   Thanks   Negri Davide --- Outgoing mail is

[GENERAL] Problem while reading from some tables

If a make a very simple query from the psql shell: nuovo_mercato=> SELECT * FROM prezzi; pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to th

[GENERAL] PostgreSQL slow on Reiserfs?

Hello all. I'm trying PostgreSQL 7.02 on Linux with Reiserfs, but I found it A LOT slower than with Ext2! Are there some know issues or tips to speed up this configuration? Read you soon \ Davide G. Borin \\ !!Anti-spam shield active!! Cut x's and "eliminami" from address \\\_

Re: [GENERAL] datetime ?#!!??@

Pathc PHSS_4630 applied ! Everything OK Davide Libenzi at : Maticad s.r.l. Via Della Giustizia n.9 Fano (PS) 61032 Italy Tel.: +39-721-808308 (ra) Fax: +39-721-808309 Email: <[EMAIL PROTECTED]> WWW: <http://www.maticad.it> -Original Message- From: Davide Libenzi <[

[GENERAL] datetime ?#!!??@

mydb==> select ffoo from foo; The rusult is a totally wrong date with year 2140. I've tried to set datestyle but the results don't change. Has anybody a hint for me ? Davide Libenzi at : Maticad s.r.l. Via Della Giustizia n.9 Fano (PS) 61032 Italy Tel.: +39-721-808308 (ra)