From: | "Gaurav K Srivastava" <gauravgkp(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4980: Dblink issue |
Date: | 2009-08-12 12:00:03 |
Message-ID: | 200908121200.n7CC03tW008646@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4980
Logged by: Gaurav K Srivastava
Email address: gauravgkp(at)gmail(dot)com
PostgreSQL version: 8.3
Operating system: Windows xp
Description: Dblink issue
Details:
I have created a user by command
1: create user posuser with password ‘pos’;
2: create database chserver with owner = abc;
3: GRANT ALL PRIVILEGES ON database chserver TO posuser
Now I have a schema under it named 'pos'
Now there is a table 'tickets' ie pos.tickets
Now I want to make a trigger which link another database say it is chclient
using dblink while inserting any row in tickets table.
then i got dblink function is undefined.
after running contrib/dblink.sql
i got the error while using dblink
is
ERROR: permission denied for language c
and when I run the command
ALTER PROCEDURAL LANGUAGE C OWNER TO posuser;
then also I got the same error.
Please tell me how i make the dblink function available to posuser which is
non super user.
From | Date | Subject | |
---|---|---|---|
Next Message | Gaurav K Srivastava | 2009-08-12 12:01:00 | BUG #4981: Dblink issue |
Previous Message | Ashesh Vashi | 2009-08-12 11:45:55 | Re: BUG #4977: post installation failed |