PostgreSQL is hanging up !?

I have created several domains at Postgresql and I am trying to create some
views on a domain "dcenter" using

create or replace view cw_nodir_v
as
select ...

However, my PostgreSQL hangs up.. on this domain only but not in other
domains... 

Don't want to reboot PQ, and methods I can find out the root causes and fix
the issues... and log I can look into..

Any help is appreciated. Thanks in advance.

[root@sedna itm]# ps -ef | grep postpostgres  2162     1  0 May19 ?        00:00:12 /usr/bin/postmaster
-i -p 5432postgres  2164  2162  0 May19 ?        00:00:02 postgres: stats
buffer process   postgres  2165  2164  0 May19 ?        00:00:05 postgres: stats
collector process   postgres  3016  2162  0 May19 ?        00:00:00 postgres: eoc_sim
eocdb 206.116.78.175 idlepostgres  3018  2162  0 May19 ?        00:00:03 postgres: eoc_sim
eocdb 206.116.78.175 SELECT waitingpostgres 14988  2162  0 15:42 ?        00:00:00 postgres: eoc_core
eocdb 206.116.78.128 SELECT waitingpostgres 16129  2162 23 16:03 ?        00:05:26 postgres: dcenter
eocdb 206.116.78.50 SELECTpostgres 16826  2162  0 16:17 ?        00:00:00 postgres: dcenter
eocdb 206.116.78.128 DROP VIEW waitingroot     17269  3236  0 16:26 pts/3    00:00:00 grep post 


Louie Kwan
lkwan@nuvo.com