[GENERAL] multiple sequence number for one column

2011-05-05 Thread mirthcyy
hi group, we need help on one postgresql locking issue: Originally we have a table like below; id bigint not null nextval('xxx)', customer_id int not null, insert_record_date timestamp not null ... so this id column is using a sequence number that applies to all customers. And it's the primary

[GENERAL] Execute permission for functions

2010-06-30 Thread mirthcyy
Hi there, I'm a newbie to postgresql and I have some problems working with its permissions. For security purpose, I want that my application service account only has execution permissions to the functions I created. so what I did is: Create a group testgroup (not super user) Create a user testus