On Sat, Nov 24, 2012 at 6:01 PM, Peter Eisentraut pete...@gmx.net wrote:
On Wed, 2012-11-21 at 15:12 -0500, Robert Haas wrote:
On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut pete...@gmx.net wrote:
On Mon, 2012-11-12 at 11:42 -0600, Karl O. Pinc wrote:
Could ALTER TABLE use an option to
On Wed, 2012-11-21 at 15:12 -0500, Robert Haas wrote:
On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut pete...@gmx.net 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
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 want
On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut pete...@gmx.net 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
On 11/21/2012 02:12:26 PM, Robert Haas wrote:
On Sat, Nov 17, 2012 at 1:22 AM, Peter Eisentraut pete...@gmx.net
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
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 pete...@gmx.net
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
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.
--
Sent
Karl O. Pinc k...@meme.com 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
On 11/12/2012 10:40:00 AM, Tom Lane wrote:
Karl O. Pinc k...@meme.com 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