From: | "Gaurav K Srivastava" <gauravgkp(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4981: Dblink issue |
Date: | 2009-08-12 12:01:00 |
Message-ID: | 200908121201.n7CC10Yu009627@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: 4981
Logged by: Gaurav K Srivastava
Email address: gauravgkp(at)gmail(dot)com
PostgreSQL version: 8.3.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 | Greg Stark | 2009-08-12 12:04:43 | Re: BUG #4974: Equivalent of "= ANY" and "BETWEEN" not observed by planner. |
Previous Message | Gaurav K Srivastava | 2009-08-12 12:00:03 | BUG #4980: Dblink issue |