Skip site navigation (1) Skip section navigation (2)

Re: CVS Commit by andreas: todo update

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Andreas Pflug" <pgadmin(at)pse-consulting(dot)de>
Cc: <pgadmin-hackers(at)postgresql(dot)org>,"Andreas Pflug" <Andreas(dot)Pflug(at)web(dot)de>
Subject: Re: CVS Commit by andreas: todo update
Date: 2004-09-21 07:28:53
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E430659F@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
 

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de] 
> Sent: 20 September 2004 17:43
> To: Dave Page
> Cc: pgadmin-hackers(at)postgresql(dot)org; Andreas Pflug
> Subject: Re: [pgadmin-hackers] CVS Commit by andreas: todo update
> 
> Dave Page wrote:
> >  
> > 
> > 
> >>-----Original Message-----
> >>From: pgadmin-hackers-owner(at)postgresql(dot)org
> >>[mailto:pgadmin-hackers-owner(at)postgresql(dot)org] On Behalf Of 
> >>cvs(at)cvs(dot)pgadmin(dot)org
> >>Sent: 20 September 2004 16:25
> >>To: pgadmin-hackers(at)postgresql(dot)org
> >>Subject: [pgadmin-hackers] CVS Commit by andreas: todo update
> >>
> >>+		<li>EditGrid: allow editing if unique key existent, but
> > 
> > no PK/OID
> > 
> > You realise that'll only work if there is a not null 
> contraint as well?
> 
> Not really. 

Not really you didn't realise, or not really you don't agree? Unique
indexes can still contain multiple null values on the same column, hence
a not null constraint is required to make them useful as a row
identifier.

> Maybe we should accept PK for educational purposes only.

I'd rather not prevent the user from shooting his own foot in quite such
a nannying way, but on a more general theme, what about having a bunch
of tips in appropriate places to help the newbie? Each one could have
it's own 'don't show me this again' check box, along with a global
option to turn them off. In this case, when creating a table without a
pkey it could pop-up and warn about the problem and give the user the
chance to correct the problem.

Regards, Dave.

Responses

pgadmin-hackers by date

Next:From: Adam H.PendletonDate: 2004-09-21 13:21:07
Subject: pgAdmin3 on Mac
Previous:From: Serguei MokhovDate: 2004-09-21 04:45:10
Subject: Re: Necessity of wxstd.po

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group