pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Actions: Edit / Delete only appears for some tables ?
3+ messages / 2 participants
[nested] [flat]

* Actions: Edit / Delete only appears for some tables ?
@ 2008-02-19 22:03  forest mars <compustretch@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: forest mars @ 2008-02-19 22:03 UTC (permalink / raw)
  To: pgsql-admin

I notice when browsing some of the tables in phppgadmin some of them have an
"Actions" column that includes buttons for "Edit" and "Delete" while other
tables do not have that as an additional column when viewing them in
phppgadmin.

Does someone know the difference between these 2 instances and moreover how
to get the "Edit" button to show up in tables where it is not currently
visible.

AFAIK, I have set permissions to grant all for testing on this, so I don't
think that is the issue.

TIA,

F. Mars
Compustretch NY

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Actions: Edit / Delete only appears for some tables ?
@ 2008-02-19 23:25  forest mars <compustretch@gmail.com>
  parent: forest mars <compustretch@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: forest mars @ 2008-02-19 23:25 UTC (permalink / raw)
  To: pgsql-admin

Actually I just noticed that all of the permissions on the tables that don't
have an edit button have an asterisk next to the permission type,
while on the tables with the edit button the permissions are exactly the
same, but there is no asterisk.

This is the clue I was looking for, though I don't know where to view/set
whatever it is this asterisk represents.

TIA,

f mars
-- 
"sig available on request"

On Feb 19, 2008 5:03 PM, forest mars <compustretch@gmail.com> wrote:

> I notice when browsing some of the tables in phppgadmin some of them have
> an "Actions" column that includes buttons for "Edit" and "Delete" while
> other tables do not have that as an additional column when viewing them in
> phppgadmin.
>
> Does someone know the difference between these 2 instances and moreover
> how to get the "Edit" button to show up in tables where it is not currently
> visible.
>
> AFAIK, I have set permissions to grant all for testing on this, so I don't
> think that is the issue.
>
> TIA,
>
> F. Mars
> Compustretch NY
>
>

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Actions: Edit / Delete only appears for some tables ?
@ 2008-02-20 10:05  ioguix <ioguix@free.fr>
  0 siblings, 0 replies; 3+ messages in thread

From: ioguix @ 2008-02-20 10:05 UTC (permalink / raw)
  To: pgsql-admin; +Cc: compustretch@gmail.com

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

phpPgAdmin (ppa) gives ability to edit/delete a row only when it founds
an unique index in the table (or in requested fields for a query) and
the value for the indexed col is not null.

Without unique index (or PK), ppa could not determine a WHERE clause to
select the only row you want to edit/drop.

Regards,
- --
Guillaume (ioguix) de Rorthais
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHu/txxWGfaAgowiIRAiE3AKCcdz/JIFqSZcgFfgkgMS2Mc7C9zwCffcnT
SaNMZDrGZWMk5qdTM0cm7Go=
=cRDx
-----END PGP SIGNATURE-----




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2008-02-20 10:05 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-19 22:03 Actions: Edit / Delete only appears for some tables ? forest mars <compustretch@gmail.com>
2008-02-19 23:25 ` forest mars <compustretch@gmail.com>
2008-02-20 10:05 Re: Actions: Edit / Delete only appears for some tables ? ioguix <ioguix@free.fr>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox