Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-25 Thread Robert Haas
On Sat, Nov 24, 2012 at 6:01 PM, Peter Eisentraut wrote: > On Wed, 2012-11-21 at 15:12 -0500, Robert Haas wrote: >> On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut wrote: >> > On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote: >> >> Could ALTER TABLE use an option to drop the >> >> primary

Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-24 Thread Peter Eisentraut
On Wed, 2012-11-21 at 23:56 -0600, Karl O. Pinc wrote: > No, wait. If constraint "name_of_primary_key" is an internal > and is to change over time, how do you deal with dropping, > now, a primary key constraint that was created, then, before > some change to the internal name. And you wouldn't w

Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-24 Thread Peter Eisentraut
On Wed, 2012-11-21 at 15:12 -0500, Robert Haas wrote: > On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut wrote: > > On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote: > >> Could ALTER TABLE use an option to drop the > >> primary key constraint? I needed to do that, > >> found it was not obvi

Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-21 Thread Karl O. Pinc
On 11/21/2012 10:00:11 PM, Karl O. Pinc wrote: > On 11/21/2012 02:12:26 PM, Robert Haas wrote: > > On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut > > wrote: > > > On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote: > > >> Could ALTER TABLE use an option to drop the > > >> primary key constra

Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-21 Thread Karl O. Pinc
On 11/21/2012 02:12:26 PM, Robert Haas wrote: > On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut > wrote: > > On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote: > >> Could ALTER TABLE use an option to drop the > >> primary key constraint? I needed to do that, > >> found it was not obvious, a

Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-21 Thread Robert Haas
On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut wrote: > On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote: >> Could ALTER TABLE use an option to drop the >> primary key constraint? I needed to do that, >> found it was not obvious, and this lead me to >> try to improve things. > > That coul

Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-16 Thread Peter Eisentraut
On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote: > Could ALTER TABLE use an option to drop the > primary key constraint? I needed to do that, > found it was not obvious, and this lead me to > try to improve things. That could be useful, I think. But it might open a can of worms. -- S

Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-12 Thread Karl O. Pinc
On 11/12/2012 10:40:00 AM, Tom Lane wrote: > "Karl O. Pinc" writes: > > Attached is a patch (against head) which documents the > > name of the constraint and index created when using > > PRIMARY KEY with CREATE TABLE, and the name of the > > index created when using UNIQUE. > Personally I don't

Re: [HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-12 Thread Tom Lane
"Karl O. Pinc" writes: > Attached is a patch (against head) which documents the > name of the constraint and index created when using > PRIMARY KEY with CREATE TABLE, and the name of the > index created when using UNIQUE. I haven't read all > the docs recently but I don't believe this is presentl

[HACKERS] Doc patch: Document names of automatically created constraints and indexes

2012-11-12 Thread Karl O. Pinc
Hi, Attached is a patch (against head) which documents the name of the constraint and index created when using PRIMARY KEY with CREATE TABLE, and the name of the index created when using UNIQUE. I haven't read all the docs recently but I don't believe this is presently documented. It's unclear t