[ppa-help] [ phppgadmin-Feature Requests-876850 ] Editing the result of a SELECT

[SourceForge.net <no...@so...>]

Feature Requests item #876850, was opened at 2004-01-14 15:18
Message generated for change (Comment added) made by bvdb
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=876850&group_id=37132

Category: General
Group: Next Release
>Status: Open
Priority: 5
Submitted By: Bernd von den Brincken (bvdb)
Assigned to: Christopher Kings-Lynne (chriskl)
Summary: Editing the result of a SELECT

Initial Comment:
On larger databases it is often neccessary to edit the
results of a SELECT (tables.php). 

This is an often-needed feature an _all_ database admin
software - it would be really nice to see it in the
next release.

----------------------------------------------------------------------

>Comment By: Bernd von den Brincken (bvdb)
Date: 2004-01-28 19:02

Message:
Logged In: YES 
user_id=256180

"???? How the heck do you expect us to magically be able to
uniquely reference one of your rows if it has no unique
identifier?"

Yes, and how "the heck" do you expect a _user_ to be
magically able to include the OID in the SELECT if you do
not offer it to him in the SELECT form
(tables.php?action=confselectrows)?
Not even if he chooses "Select all fields"?


----------------------------------------------------------------------

Comment By: Christopher Kings-Lynne (chriskl)
Date: 2004-01-16 02:11

Message:
Logged In: YES 
user_id=82305

I don't believe you can edit the select results unless you
include your primary key, unique key or OID column in the
select itself.

"And, it _does_ make sense to have someone edit the contents
of a DB and _not_ change the structure (like adding a
primary / unique index), however wise or unwise this
structure was designed. "

???? How the heck do you expect us to magically be able to
uniquely reference one of your rows if it has no unique
identifier?  What kind of update query do you expect us to
be able to execute to update your row?

----------------------------------------------------------------------

Comment By: Bernd von den Brincken (bvdb)
Date: 2004-01-15 14:31

Message:
Logged In: YES 
user_id=256180

I can not edit the result of a SELECT of a table that I
_could_ edit in browse mode. 
So the criteria for being able to edit seem to be different
between browse and SELCECT-result.

And, it _does_ make sense to have someone edit the contents
of a DB and _not_ change the structure (like adding a
primary / unique index), however wise or unwise this
structure was designed. 


----------------------------------------------------------------------

Comment By: Christopher Kings-Lynne (chriskl)
Date: 2004-01-15 02:12

Message:
Logged In: YES 
user_id=82305

Err - phpPgAdmin DOES have this feature.  You need to have a
primary key or unique index on the table, however...

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418983&aid=876850&group_id=37132