ipe
> ERROR: copy: line 1, Cannot insert a duplicate key into unique index
> rox_group_graph_pkey
> FATAL 1: Socket command type \ unknown
> ERROR: copy: line 1, Cannot insert a duplicate key into unique index
> rox_granted_permission_pkey
> pq_flush: send() failed: Broken pipe
> F
ome new stuff to deal with this
issue.
> and how will 7.2 be different, I remember a background vacuum
> being discused, what other great things are there waiting in
> the wings
Er... RTFM: http://developer.postgresql.org/todo.php stuff that's
slated for 7.2 has a - in fro
ill be granted access as user "puser".
>ANY IDEAS?
Have each user log in from the same UNIX account.
Instead of trying to make all users into one user, which is almost never
a good idea, why not just use the PUBLIC concept in the database's
access control system? Give ea
e database system. That stuff can be
controlled by GRANT and REVOKE.
- --
Andrew G. Hammond mailto:[EMAIL PROTECTED] http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
"To blow recursi
ner_idx ON pet(owner);
Anyway, I hope this is enough to get you pointed in the right dirrection.
Feel free to ask me for more details.
- --
Andrew G. Hammond mailto:[EMAIL PROTECTED] http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
x, it is
/usr/lib/postgresql/bin/pg_controldata
You should be able to find it quickly using
% locate pg_controldata
Alternately, if your system isn't properly maintained (and, unless you've got
some seriously nice hardware, this will take some time: grab a coffee while
you wait...), try
%
displays the query used by psql to list permissions in the filesystem:
SELECT relname as "Relation",
relacl as "Access permissions"
FROM pg_class
WHERE relkind in ('r', 'v', 'S') AND
relname !~ '^pg_'
ORDER BY
, user_name;
EXECUTE ''GRANT '' || privilidge || '' ON '' || row.relname || '' TO '' ||
user_name;
END LOOP;
RETURN ''t'';
END;' LANGUAGE 'plpgsql';
SELECT multi_grant('select'
