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
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
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
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
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
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
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
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
"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
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
10 matches
Mail list logo