[GENERAL] ElasticSearch Beats

You may decide not to use Elasticsearch but take a look at other components of Elastic Stack like logstash and beats. They can be helpful even when you use Postgres as the end point. Otherwise (IMHO), you would spend a lot of time writing scripts and jobs to capture and stream logs. If I were yo

[GENERAL] Graylog

Am 23.08.2016 um 22:42 schrieb Terry Schmitt: Certainly Postgres is capable of handling this volume just fine. Throw in some partition rotation handling and you have a solution. If you want to play with something different, check out Graylog, which is backed by Elasticsearch. A bit more work

[GENERAL] ON CONFLICT does not support deferrable unique constraints

Hope some -hackers read this...   Are there any plans to lift this restriction?   -- Andreas Joseph Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com www.visena.com

[GENERAL] pglogical Replication CONFLICT

I am using PostgreSQL 9.4 with pglogical replication. I have 1 provider node and 1 subscriber in 2 separate locations. The subscriber subscribes to 1 database on the provider. Every evening a function runs that DELETE's & INSERT's to tables that are replicated to the subscriber and causes CONFLI

Re: [GENERAL] ON CONFLICT does not support deferrable unique constraints

On Wed, Aug 24, 2016 at 6:05 AM, Andreas Joseph Krogh wrote: > > Hope some -hackers read this... > > Are there any plans to lift this restriction? I'm trying to figure out a method for making this work in my head. These two things seem kind of opposed to each other. -- Sent via pgsql-general m

Re: [GENERAL] ON CONFLICT does not support deferrable unique constraints

On Wed, Aug 24, 2016 at 6:26 PM, Scott Marlowe wrote: > On Wed, Aug 24, 2016 at 6:05 AM, Andreas Joseph Krogh >> Are there any plans to lift this restriction? > I'm trying to figure out a method for making this work in my head. > These two things seem kind of opposed to each other. He probably wa

Re: [GENERAL] ON CONFLICT does not support deferrable unique constraints

På onsdag 24. august 2016 kl. 18:36:16, skrev Francisco Olarte < fola...@peoplecall.com >: On Wed, Aug 24, 2016 at 6:26 PM, Scott Marlowe wrote: > On Wed, Aug 24, 2016 at 6:05 AM, Andreas Joseph Krogh >> Are there any plans to lift this restriction? > I'm trying t

Re: [GENERAL] Forward declaration of table

Hello again, I have went the ALTER TABLE route to add my 2 "cyclic" FKs: https://gist.github.com/afarber/c40b9fc5447335db7d24 And now I have these 2 tables in my 9.5.3 database: #TABLE words_moves; mid | action | gid | uid |played |

Re: [GENERAL] Forward declaration of table

On Wed, Aug 24, 2016 at 4:27 PM, Alexander Farber < alexander.far...@gmail.com> wrote: > > Why aren't m.tiles and m.score returned please? > > ​How about you output g.mid1 and g.mid2 in the first query and confirm that the rows being returned from words_games actually have a value in the set {2,3,

Re: [GENERAL] Forward declaration of table

On Wed, Aug 24, 2016 at 4:38 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Aug 24, 2016 at 4:27 PM, Alexander Farber < > alexander.far...@gmail.com> wrote: > >> >> Why aren't m.tiles and m.score returned please? >> >> > ​How about you output g.mid1 and g.mid2 in the first qu

[GENERAL] Alter default privileges vs new schemas

https://www.postgresql.org/docs/current/static/sql-alterdefaultprivileges.html Have a client where their development teams use extensive use of schemas. We use default privileges like this ALTER DEFAULT PRIVILEGES FOR ROLE jobs_owner_local GRANT SELECT ON tablesTO ro_group; ALTER DEFAULT

Re: [GENERAL] Forward declaration of table

On 08/24/2016 01:27 PM, Alexander Farber wrote: Hello again, I have went the ALTER TABLE route to add my 2 "cyclic" FKs: https://gist.github.com/afarber/c40b9fc5447335db7d24 And now I have these 2 tables in my 9.5.3 database: Why aren't m.tiles and m.score returned please? Reformatted y

Re: [GENERAL] Determining table change in an event trigger

On 08/24/2016 12:58 AM, Alvaro Herrera wrote: > Jonathan Rogers wrote: >> I am trying to use an event trigger to do something when a column >> changes. I can declare an event trigger "ON sql_drop WHEN TAG IN ('ALTER >> TABLE')" to get dropped columns. However, I can't figure out any good >> way to

Re: [GENERAL] Forward declaration of table

Thank you and apologies for the misformated mail - I kept fixing it for many minutes, but once I hit the "Send" button in Gmail it went south again.