Jessica Richard (rj...@yahoo.com)

Instead of using drop user username, I used drop user "username" with double quotes, then the error message told me more detail about a specific user defined function. Then I was able to drop that function, then drop this user.

My next question,

How do I check the ownership of the functions. I can't tell the difference between system functions and the user defined functions.

I am sure in the future there will be times that I need to check the ownership of the functions but not allowed to drop users to see check the dependencies.


Thanks a lot,
Jessica


Tom Lane <tgl@sss.pgh.pa.us> wrote: Jessica Richard  writes:
> I am trying to drop a user but it complained with the following message:
> ERROR: role "joe" cannot be dropped because some objects depend on it
> DETAIL:  1 objects in database Jan_test
> 1 objects in database Jan

> this user does not own any tables in those two databases. Is there any command I can use to check all the dependencies on this user?

Try to do the DROP ROLE within those databases.  You'll get more detail
about owned objects within the current database, but from outside that
database the info isn't reachable ...

   regards, tom lane


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com

Postgres:  8.2.4

IRIX:   IRIX64 machinename 6.5 

Thanks.
Jessica


"Jonah H. Harris" <jonah.harris@gmail.com> wrote: On 9/24/07, Jessica Richard wrote:
> I am seeing a lot of hanging Postgres connections on one Postgre server
> (IRIX platform). The main user uses a perl script talking to the database
> (insert, update, etc). Those hanging connections are in "IDLE" state and
> they look very old...

What version of Postgres and IRIX are you running?

I am seeing a lot of hanging Postgres connections on one Postgre server (IRIX platform). The main user uses a perl script talking to the database (insert, update, etc). Those hanging connections are in "IDLE" state and they look very old...

Why are those jobs not releasing their connections when they are done???

Thanks,
Jessica

       
---------------------------------
Boardwalk for $500? In 2007? Ha!
Play Monopoly Here and Now (it's updated for today's economy) at Yahoo! Games.

Everything was running fine under the default number 5432. After the port number was changed to another number in postresql.conf file and the server was restarted, dblink is broken, it is still looking for the old port number 5432... not sure if everything else is broken as well...

So, how to change the port number cleanly? There other Postgis components on the system too.

Thanks,
Jessica

       
---------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel.

I have never see this before....

In order to start my postgres server, I have to log out all my Postgres windows...and I I have two postgres user windonw open, the server just won't come up... as soon as I close all postgres windows leaving only one widow open, then I can start Postgres server....(it is on an Irix machine).

It is weird to me. I always have multiple postgres windows open doing my work on other postgres machines.


Is there a limit (on OS side or on Postgres side) for starting postgres?

Thanks,
Jessica

       
---------------------------------
Be a better Heartthrob. Get better relationship answers from someone who knows.
Yahoo! Answers - Check it out.