Re: Patch to add a primary key using an existing index

Поиск
Список
Период
Сортировка
Искать
От
Steve Singer
Тема
Re: Patch to add a primary key using an existing index
Дата
Msg-id
BLU0-SMTP647ABAF0843BF54B9B9E9F8EF50@phx.gbl
Ответ на
Список
Дерево обсуждения
Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Jim Nasby <jim@nasby.net>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Steve Singer <ssinger_pg@sympatico.ca>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Steve Singer <ssinger_pg@sympatico.ca>
Re: Patch to add a primary key using an existing index Steve Singer <ssinger@ca.afilias.info>
Re: Patch to add a primary key using an existing index Itagaki Takahiro <itagaki.takahiro@gmail.com>
Re: Patch to add a primary key using an existing index Robert Haas <robertmhaas@gmail.com>
Re: Patch to add a primary key using an existing index Peter Eisentraut <peter_e@gmx.net>
Re: Patch to add a primary key using an existing index Robert Haas <robertmhaas@gmail.com>
Re: Patch to add a primary key using an existing index Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Patch to add a primary key using an existing index Alvaro Herrera <alvherre@commandprompt.com>
Re: Patch to add a primary key using an existing index Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: Patch to add a primary key using an existing index r t <pgsql@xzilla.net>
Re: Patch to add a primary key using an existing index Robert Haas <robertmhaas@gmail.com>
Re: Patch to add a primary key using an existing index Peter Eisentraut <peter_e@gmx.net>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to add a primary key using an existing index "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: Patch to add a primary key using an existing index Robert Haas <robertmhaas@gmail.com>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Steve Singer <ssinger_pg@sympatico.ca>
Re: Patch to add a primary key using an existing index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to add a primary key using an existing index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to add a primary key using an existing index Joshua Tolley <eggyknap@gmail.com>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Robert Haas <robertmhaas@gmail.com>
Re: Patch to add a primary key using an existing index Robert Haas <robertmhaas@gmail.com>
Re: Patch to add a primary key using an existing index Josh Berkus <josh@agliodbs.com>
Re: Patch to add a primary key using an existing index Robert Treat <rob@xzilla.net>
Re: Patch to add a primary key using an existing index "Ross J. Reedstrom" <reedstrm@rice.edu>
Re: Patch to add a primary key using an existing index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to add a primary key using an existing index Robert Haas <robertmhaas@gmail.com>
Re: Patch to add a primary key using an existing index Robert Treat <rob@xzilla.net>
Re: Patch to add a primary key using an existing index Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch to add a primary key using an existing index Robert Haas <robertmhaas@gmail.com>
Re: Patch to add a primary key using an existing index Josh Berkus <josh@agliodbs.com>
Re: Patch to add a primary key using an existing index Josh Berkus <josh@agliodbs.com>
Re: Patch to add a primary key using an existing index David Fetter <david@fetter.org>
Re: Patch to add a primary key using an existing index Gurjeet Singh <singh.gurjeet@gmail.com>
Re: Patch to add a primary key using an existing index Andrew Dunstan <andrew@dunslane.net>
archives, attachments, etc (was: Patch to add a primary key using an existing index) Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: archives, attachments, etc (was: Patch to add a primary key using an existing index) Gurjeet Singh <singh.gurjeet@gmail.com>
Re: archives, attachments, etc Matteo Beccati <php@beccati.com>
I've taken a look at this version of the patch.


Submission Review
----------------
This version of the patch applies cleanly to master. It matches your git 
repo and includes test + docs.

Usability Review
---------------

The command syntax now matches what was discussed during the last cf.

The text of the notice:

test=# alter table a add constraint acons unique using index aind2;
NOTICE:  ALTER TABLE / ADD UNIQUE USING INDEX will rename index "aind2" 
to "acons"



Documentation
----------

I've attached a patch (to be applied on top of your latest patch) with 
some editorial changes I'd recommend to your documentation.  I feel it 
reads a bit clearer (but others should chime in if they disagree or have 
better wordings)

  A git tree with changes rebased to master + this change is available 
at https://github.com/ssinger/postgres/tree/ssinger/constraint_with_index


Code Review
-----------

src/backend/parser/parse_utilcmd.c: 1452
Your calling strdup on the attribute name.  I don't have a good enough 
grasp on the code to be able to trace this through to where the memory 
gets free'd.  Does it get freed? Should/could this be a call to pstrdup

Feature Test
-------------

I wasn't able to find any issues in my testing

I'm marking this as returned with feedback pending your answer on the 
possible memory leak above but I think the patch is very close to being 
ready.


Steve Singer


В списке pgsql-hackers по дате отправления
От: Noah Misch
Дата:
От: Kevin Grittner
Дата:
Сообщение: Re: limiting hint bit I/O
FAQ