Thread: CVS Commit by andreas: todo update

Log Message:
-----------
todo update

Modified Files:
--------------
    pgadmin3:
        TODO.txt (r1.113 -> r1.114)

> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org
> [mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
> cvs@cvs.pgadmin.org
> Sent: 20 September 2004 16:25
> To: pgadmin-hackers@postgresql.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?

Regards, Dave.

Dave Page wrote:
>
>
>
>>-----Original Message-----
>>From: pgadmin-hackers-owner@postgresql.org
>>[mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
>>cvs@cvs.pgadmin.org
>>Sent: 20 September 2004 16:25
>>To: pgadmin-hackers@postgresql.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. Maybe we should accept PK for educational purposes only.

Regards,
Andreas

> -----Original Message-----
> From: Andreas Pflug [mailto:pgadmin@pse-consulting.de]
> Sent: 20 September 2004 17:43
> To: Dave Page
> Cc: pgadmin-hackers@postgresql.org; Andreas Pflug
> Subject: Re: [pgadmin-hackers] CVS Commit by andreas: todo update
>
> Dave Page wrote:
> >
> >
> >
> >>-----Original Message-----
> >>From: pgadmin-hackers-owner@postgresql.org
> >>[mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
> >>cvs@cvs.pgadmin.org
> >>Sent: 20 September 2004 16:25
> >>To: pgadmin-hackers@postgresql.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.

Dave Page wrote:

>
> 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?

Yup, let's collect candidates.

> Each one could have
> it's own 'don't show me this again' check box, along with a global
> option to turn them off.

... for making power users less annoyed :-) Teacher dialogs make my
pimples flourish.

Regards,
Andreas