Thanks Patrick and Bruno for your replies,
The auto-added "FROM" feature is pretty slick for enabling JOINs within
a DELETE. Allowing this to be explicit in 8.1 is going to be even
better.
Since DELETEing from pg_users is an unsupported way to remove users, I
am going to use the procedure in the
On Wed, Aug 31, 2005 at 12:30:14 +0200,
David Sankel <[EMAIL PROTECTED]> wrote:
>
> DELETE FROM pg_user
> WHERE usesysid = ANY ( SELECT grolist
> FROM pg_group
> WHERE groname = 'somegroupname' )
>
> But, alas, it doesn't. Neither does any combination of IN and ANY. It seems
> to me like this
Hi
David,
The
correct syntax would probably be :
DELETE
FROM pg_user
WHERE usesysid = ANY
(pg_group.grolist) AND pg_group.groname =
'somegroupname'
However, you won't be allowed to delete users this
way.
The
only recommended methods is to use the DROP USER command to remove
u
Hello List,
I'm trying to delete all the users from a group and it seems as though there isn't sufficient array functionality to do it.
The pg_group columns:
http://www.postgresql.org/docs/8.0/interactive/catalog-pg-group.html
The pg_user columns:
http://www.postgresql.org/docs/8.0/interactive/v
