[GENERAL] Slides for PGCon2016; "FTS is dead ? Long live FTS !"

Hi.   Any news about when slides for $subject will be available?   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com www.visena.com

Re: [GENERAL] Aborted pg_dump run empties existing archive file

Ken Winter writes: > I just discovered that a run of pg_dump that gets aborted empties any > pre-existing backup file of the same name.  It happens whether the run was > deliberately canceled > by the user or just failed because of a bad password (as in the example > below).  > > ~/dba$ pg_d

Re: [GENERAL] Aborted pg_dump run empties existing archive file

On Thu, May 26, 2016 at 2:48 PM, Ken Winter wrote: > I just discovered that a run of pg_dump that gets aborted empties any > pre-existing backup file of the same name. It happens whether the run was > deliberately canceled by the user or just failed because of a bad password > (as in the example

[GENERAL] Aborted pg_dump run empties existing archive file

I just discovered that a run of pg_dump that gets aborted empties any pre-existing backup file of the same name. It happens whether the run was deliberately canceled by the user or just failed because of a bad password (as in the example below). ~/dba$ pg_dump --host=localhost -U ken --format=c

Re: [GENERAL] full text search index

You don't provide much context, like PostgreSQL version or machine characteristics. https://wiki.postgresql.org/wiki/SlowQueryQuestions On Wed, May 25, 2016 at 11:04 PM, Patrick Baker wrote: >> SELECT COUNT(DISTINCT j0_.id) AS sclr10 >> FROM customers j0_ >> WHERE ((LOWER(j0_.name_first) LIKE '

Re: [GENERAL] Subquery uses ungrouped column

"David G. Johnston" writes: > From observation PostgreSQL doesn't recognize the equivalency of the > outer "group by substring(fileid from -1)" and the subquery expression. Well, it would without the subselect in between. There's a code comment in parse_agg.c about this: * NOTE: we recognize g

Re: [GENERAL] Subquery uses ungrouped column

On Thu, May 26, 2016 at 12:02 PM, Alex Ignatov wrote: > Hello! > > Why the following query: > > SELECT (select msc_id > from collectors > where id = substring(fileid from -1) >) msc_id >from ip_data_records >group by substring(fileid from -1) >

[GENERAL] Subquery uses ungrouped column

Hello! Why the following query: SELECT (select msc_id from collectors where id = substring(fileid from -1) ) msc_id from ip_data_records group by substring(fileid from -1) gives me: ERROR: subquery uses ungrouped column "ip_data_records.fileid"

Re: [GENERAL] Do docs miss information about timing of triggers?

Yes, you are right. But "after" the statement could mean before commit, too. Why not add this? Proposal: When no CONSTRAINT option is specified, this command creates a normal trigger. They get fired at the end of the statement (IMMEDIATE). Regards, Thomas Güttler Am 26.05.2016 um 15:43 sc

[GENERAL] Permission Denied Error on pg_xlog/RECOVERYXLOG file

Hi Folks, We reported a bug last month (#14119) related to receiving a permission denied error on the pg_xlog/RECOVERYXLOG file when performing a database recovery (PostgreSQL versions 9.2.16 and 9.2.17). The bug report was for version 9.2.16 but we also are having the same problem with 9.2.17

Re: [GENERAL] full text search index

On 26 May 2016 at 06:04, Patrick Baker wrote: > Hi there, > > I've got the following query: >> >> >> SELECT COUNT(DISTINCT j0_.id) AS sclr10 >> FROM customers j0_ >> WHERE ((LOWER(j0_.name_first) LIKE '%some%' >> OR LOWER(j0_.name_last) LIKE '%some%') >>AND j0_.id = 5) >> AND j0_

Re: [GENERAL] Do docs miss information about timing of triggers?

On 05/26/2016 05:50 AM, Thomas Güttler wrote: I (and a team mate) guess that the docs miss information about the timing of triggers, which are not constraint triggers: https://www.postgresql.org/docs/devel/static/sql-createtrigger.html {{{ When the CONSTRAINT option is specified, this command

Re: [GENERAL] Do docs miss information about timing of triggers?

"David G. Johnston" writes: > On Thu, May 26, 2016 at 8:50 AM, Thomas Güttler < > guettl...@thomas-guettler.de> wrote: >> OK, timing of constraint triggers is explained. >> But I think the docs don't state the timing of normal AFTER triggers. > ​Through omission. It's not *that* bad. See htt

Re: [GENERAL] Do docs miss information about timing of triggers?

On Thu, May 26, 2016 at 8:50 AM, Thomas Güttler < guettl...@thomas-guettler.de> wrote: > I (and a team mate) guess that the docs miss information about the timing > of triggers, > which are not constraint triggers: > > https://www.postgresql.org/docs/devel/static/sql-createtrigger.html > > > {{{ >

[GENERAL] Do docs miss information about timing of triggers?

I (and a team mate) guess that the docs miss information about the timing of triggers, which are not constraint triggers: https://www.postgresql.org/docs/devel/static/sql-createtrigger.html {{{ When the CONSTRAINT option is specified, this command creates a constraint trigger. This is the same

Re: [GENERAL] full text search index

> > > > Maybe Lucas Possamai can help. He seems to be a little bit further along > in this exercise. > > I'm too tired to care at the moment. And I haven't had much practical > work here anyway. > > David J. > > > > I subscribed to the list today, so don't have the old emails I had a look o

Re: [GENERAL] empty pg_stat_replication when replication works fine?

The instance is still running, I tried to collect more information from it: all databases are working as expected, the only issue is that monitoring SQL commands (pg_stat_activity, pg_stat_replication) are not working as expected (do not reflect postgres processes list from command-line) on Maste