Would the same work for pg_user and pg_group?
It would be handy at times to easily check wether or not someone is member
of a group...
and since in pg_group the usernumbers are stored, one might need to do a
few lookups:
would it be hard to put such a thing in a view, or is that not-smart
think
To those who pointed at the SELECT currval , thanks!, I think
this is what I need instead of a trigger. So the real problem is solved I
think. However I am quite curious about the plpgsql thing, I think I may
need to use it, or may WANT to use it (performance wise... better to be as
close as po
That is indeed true. Also I see you do everything as root, try creating a
new user especially for postgres databases. create a directory with root in
/usr/loca/pgsql/ named data, or any other directory that is in $PGDATA.
chown the directory to the postgres user, log in as the postgres user and
Maybe this should be sent to novice... I was not certain, but if it should,
please tell me so.
The matter at hand is this:
When I do an 'INSERT INTO VALUES '
and on the table is a serial primary key named p_key.
As I want this number to be auto-generated, but use it as a 'customer
number', I w
