[BUGS] Can you please let me know?

2010-04-14 Thread Gaurav K Srivastav
oracle. or select object_name,CREATED,OBJECT_TYPE from user_objects; so that I can get the name of all objects created in a database schema. If yes Please help me out or is there any tutorial online please give me URL for the same. -- Thanks & Regards Gaurav K Srivastav

Fwd: [BUGS] Can we force fully disconnect all client connected to localhost:5432

2009-12-30 Thread Gaurav K Srivastav
told pg_terminate_backend() is for 8.4. Can you please let me know the how I can do this task via shell script. Guarav Kumar Srivastava -- Forwarded message -- From: Gaurav K Srivastav Date: Wed, Dec 30, 2009 at 5:57 PM Subject: Re: [BUGS] Can we force fully disconnect all client

[BUGS] Can we force fully disconnect all client connected to localhost:5432

2009-12-30 Thread Gaurav K Srivastav
Hi, Do we have any command to forcefully disconnet each client in postgres . If we have please let me know. Gaurav Kumar Srivastava

[BUGS] Regarding permissions

2009-08-19 Thread Gaurav K Srivastav
HI, I have a normal user 'abcd' and grant all previliges to this user on the database 'pqr'. now i am unable to use dblink(text,text). while via super user 'postgre' which is the owner of database 'postgre' I am able to use dblink(text,text). Can you please let me know how to get use of dblink(