RE: [HACKERS] Imperfect solutions

2001-06-05 Thread Stephan Szabo
On Wed, 6 Jun 2001, Christopher Kings-Lynne wrote: > > > Those two points are already mentioned - I have another 90% > > patch ready to > > > go that will add that functionality as well... > > > > As a question, are you doing anything to handle dropping referenced unique > > constraints or are w

RE: [HACKERS] Imperfect solutions

2001-06-05 Thread Stephan Szabo
On Tue, 5 Jun 2001, Christopher Kings-Lynne wrote: > > > Just thought you might like to add > > > > > > * ALTER TABLE ADD PRIMARY KEY > > > * ALTER TABLE ADD UNIQUE > > > > And what > > > > ALTER TABLE DROP PRIMARY KEY > > ALTER TABLE DROP UNIQUE > > > > BTW, it's a little cosmetic fe

Re: [HACKERS] Imperfect solutions

2001-06-05 Thread Karel Zak
On Tue, Jun 05, 2001 at 04:16:06PM +0800, Christopher Kings-Lynne wrote: > Hi Bruce, > > I was just looking at the TODO list and noticed my name in it - cool! (You > spelled it wrong - but hey :) ) > > Just thought you might like to add > > * ALTER TABLE ADD PRIMARY KEY > * ALTER TABLE ADD UNI

Re: [HACKERS] Imperfect solutions

2001-05-31 Thread Nathan Myers
On Thu, May 31, 2001 at 10:07:36AM -0400, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > What got me thinking about this is that I don't think my gram.y fix > > would be accepted given the current review process, > > Not to put too fine a point on it: the project has advanced a l

Re: [HACKERS] Imperfect solutions

2001-05-31 Thread Stephan Szabo
On Thu, 31 May 2001, Tom Lane wrote: > Indeed. You're looking at the aftermath of an "imperfect fix" to add > foreign keys. With all due respect to Jan and Stephan, who did a great > job adding the feature at all, there are still a lot of things that need > to be fixed in that area. The troubl

Re: [HACKERS] Imperfect solutions

2001-05-31 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > What got me thinking about this is that I don't think my gram.y fix > would be accepted given the current review process, Not to put too fine a point on it: the project has advanced a long way since you did that code. Our standards *should* be higher t

Re: [HACKERS] Imperfect solutions

2001-05-30 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Also, what about foreign keys? At the moment it is incredibly complicated > to determine all the foreign keys on a table, what column(s) they're defined > over, what column(s) they reference and what their behaviour is. And just > try writi