Re: [HACKERS] pg_get_constraintdef

2003-01-13 Thread Kris Jurka
> On Mon, Jan 13, 2003 at 11:59:33AM +0800, Christopher Kings-Lynne wrote: > > > > I will, but unfortunately the damage has already been done...since I have to > > support 7.3 anyway, fixing the above problem will actually make my life > > harder, not easier... Another issue to consider is that

Re: [HACKERS] pg_get_constraintdef

2003-01-13 Thread Ross J. Reedstrom
On Mon, Jan 13, 2003 at 11:59:33AM +0800, Christopher Kings-Lynne wrote: >Tom Lane writes: > > > > Feel free to contribute some code. > > I will, but unfortunately the damage has already been done...since I have to > support 7.3 anyway, fixing the above problem will actually make my life > harder,

Re: [HACKERS] pg_get_constraintdef

2003-01-12 Thread Christopher Kings-Lynne
> "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > > Is there some reason why pg_get_constraintdef only supports Foreign Key > > constraints? > > Lack of implementation effort --- the original definition/implementation > was FK-specific, but now, as the code says, > > * XXX The present impl

Re: [HACKERS] pg_get_constraintdef

2003-01-12 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Is there some reason why pg_get_constraintdef only supports Foreign Key > constraints? Lack of implementation effort --- the original definition/implementation was FK-specific, but now, as the code says, * XXX The present implementation onl

[HACKERS] pg_get_constraintdef

2003-01-12 Thread Christopher Kings-Lynne
Is there some reason why pg_get_constraintdef only supports Foreign Key constraints? Why not have it output ALTER TABLE commands for UNIQUE and PRIMARY KEY constraints? That would make my life so much easier for phpPgAdmin and also pg_dump could be simplified quite considerably...? Chris -