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 post
    postgres  2162     1  0 May19 ?        00:00:12 /usr/bin/postmaster
-i -p 5432
    postgres  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 idle
    postgres  3018  2162  0 May19 ?        00:00:03 postgres: eoc_sim
eocdb 206.116.78.175 SELECT waiting
    postgres 14988  2162  0 15:42 ?        00:00:00 postgres: eoc_core
eocdb 206.116.78.128 SELECT waiting
    postgres 16129  2162 23 16:03 ?        00:05:26 postgres: dcenter
eocdb 206.116.78.50 SELECT
    postgres 16826  2162  0 16:17 ?        00:00:00 postgres: dcenter
eocdb 206.116.78.128 DROP VIEW waiting
    root     17269  3236  0 16:26 pts/3    00:00:00 grep post