pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedActions: 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>
2008-02-19 23:25 ` Re: Actions: Edit / Delete only appears for some tables ? 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 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>
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