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

2016-01-31 Thread David G. Johnston
On Sun, Jan 31, 2016 at 10:17 AM, Bill Moran wrote: > On Sun, 31 Jan 2016 18:02:38 +0100 > Tom Lane wrote: > > > Harald Fuchs writes: > > > Ben Leslie writes: > > >> "Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT > NULL" > > >> > > >> I wanted to clarify if that was, techn

Re: [GENERAL] BDR replication on Postgresql 9.5.0

2016-01-31 Thread John R Pierce
On 1/29/2016 3:00 AM, Kaushal Shriyan wrote: Do i need to install any BDR specific package to enable it in postgresql 9.5 version. While reading http://bdr-project.org/docs/0.9.0/install-requirements.html i assumed that it is available in 9.5 version by default without using any patches. Ple

Re: [GENERAL] BDR replication on Postgresql 9.5.0

2016-01-31 Thread Sachin Jain
BDR extension is not available in 9.5. You need to install it separately. - Sachin On 29 Jan 2016 4:31 p.m., "Kaushal Shriyan" wrote: > Hi, > > I am following http://bdr-project.org/docs/stable/index.html to setup BDR > for postgresql version 9.5 as per > > [root@ip-172-31-1-17 9.5]# cat /etc/re

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

2016-01-31 Thread Joshua D. Drake
On 01/31/2016 09:02 AM, Tom Lane wrote: Harald Fuchs writes: Ben Leslie writes: "Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT NULL" I wanted to clarify if that was, technically, true. Yes, but see below. "identifying a set of columns as primary key also provides m

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

2016-01-31 Thread Bill Moran
On Sun, 31 Jan 2016 18:02:38 +0100 Tom Lane wrote: > Harald Fuchs writes: > > Ben Leslie writes: > >> "Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT NULL" > >> > >> I wanted to clarify if that was, technically, true. > > > Yes, but see below. > > >> "identifying a set of

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

2016-01-31 Thread Tom Lane
Harald Fuchs writes: > Ben Leslie writes: >> "Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT NULL" >> >> I wanted to clarify if that was, technically, true. > Yes, but see below. >> "identifying a set of columns as primary key also provides metadata >> about the design of t

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

2016-01-31 Thread Harald Fuchs
Ben Leslie writes: > "Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT NULL" > > I wanted to clarify if that was, technically, true. Yes, but see below. > "identifying a set of columns as primary key also provides metadata > about the design of the schema, as a primary key imp