[GENERAL] FDW and transaction management

2016-02-07 Thread Michael Holzman
Greetings, I am trying to understand the subject. I see in the documentation ( http://www.postgresql.org/docs/current/static/postgres-fdw.html) that F.31.3. Transaction Management During a query that references any remote tables on a foreign server, postgres_fdw opens a transaction on the remote

Re: [GENERAL] Is PRIMARY KEY the same as UNIQUE NOT NULL?

2016-02-07 Thread Ben Leslie
On 8 February 2016 at 08:04, Tom Lane wrote: > Geoff Winkless writes: >> On 31 January 2016 at 19:53, David G. Johnston >> wrote: >>> A PRIMARY KEY enforces a UNIQUE, NOT NULL constraint and additionally allows >> [snip] > >> I would just remove the whole paragraph. A primary key does what it >>

Re: [GENERAL] Trouble installing postgresql server on Amazon Linux

2016-02-07 Thread Augori
Thanks for the reply. Yes, it seems that you're right about having multiple pgdg93 repos,. # yum repolist Loaded plugins: priorities, update-motd, upgrade-helper Repository pgdg93 is listed more than once in the configuration Repository pgdg93-source is listed more than once in the configuration

Re: [GENERAL] Is PRIMARY KEY the same as UNIQUE NOT NULL?

2016-02-07 Thread Tom Lane
Geoff Winkless writes: > On 31 January 2016 at 19:53, David G. Johnston > wrote: >> A PRIMARY KEY enforces a UNIQUE, NOT NULL constraint and additionally allows > [snip] > I would just remove the whole paragraph. A primary key does what it > does, a unique constraint does what it does. I'm not r

Re: [GENERAL] Trouble installing postgresql server on Amazon Linux

2016-02-07 Thread Adrian Klaver
On 02/07/2016 11:18 AM, Augori wrote: Hello, I'm trying to install postgresql on an Amazon Linux AMI release 2015.09. I got the rpm for Amazon Linux AMI 2015.03 - x86_64 under PostgreSQL 9.3 linked here: http://yum.postgresql.org/repopackages.php But a yum install complains that it requires s

[GENERAL] Trouble installing postgresql server on Amazon Linux

2016-02-07 Thread Augori
Hello, I'm trying to install postgresql on an Amazon Linux AMI release 2015.09. I got the rpm for Amazon Linux AMI 2015.03 - x86_64 under PostgreSQL 9.3 linked here: http://yum.postgresql.org/repopackages.php But a yum install complains that it requires systemd-units, which I haven't figure out

Re: [GENERAL] four template0 databases after vacuum

2016-02-07 Thread Adrian Klaver
On 02/06/2016 06:43 PM, Kazuaki Fujikura wrote: Hi there, Version: 9.1.6 running since Dec, 2014 We have 3 different databases. See comment in line. [problem history/background] Jan 10th, 2016: The first problem was autovacuum issue. - autovacuum could not finish successfully. - I set auto

Re: [GENERAL] four template0 databases after vacuum

2016-02-07 Thread Melvin Davidson
On Sun, Feb 7, 2016 at 4:51 AM, Karsten Hilbert wrote: > Just a shot in the dark for a possible lead to follow down (sorry for > top-posting): > > Is there index corruption on system tables ? > > (like, several index entries pointing to the one template0 row) > > Karsten > > > *Gesendet:* Sonntag

Re: [GENERAL] Asp.net 5 and EF6

2016-02-07 Thread FarjadFarid(ChkNet)
Hi Arjen, Currently one can only add a reference to asp.net5 that is rebuilt with asp.net5 library. In the case of EF6 with full .net library and not the core. The problem seems to be the build versioning of the npgsql library for the full .net library. It is emitting one thing but expecti

Re: [GENERAL] four template0 databases after vacuum

2016-02-07 Thread Karsten Hilbert
Just a shot in the dark for a possible lead to follow down (sorry for top-posting):   Is there index corruption on system tables ?   (like, several index entries pointing to the one template0 row)   Karsten     Gesendet: Sonntag, 07. Februar 2016 um 03:43 Uhr Von: "Kazuaki Fujikura" An: