[ADMIN] 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

[ADMIN] access multiple PostgreSQL Databases at the same time.

postgresql server. Is there a way to SELECT tables or create JOINs from multiple databases JDBC or psql . I aware that Oracle has Database Link concept. Any tip will help. I did some search on previous posting, but cannot find much. Louie Kwan > NUVO - THE IT OUT-TASKING COMPANY > (613) 72

[ADMIN] Re-Init database cluster.

Hi All, I did a pg_dumpall and psql the output and created a db. Basically, I would like to clean up everything including users and groups. I tried to do initdb, but it didn't work. My question is that can I just delete the directory where the database cluster stored before. I.e. rm -rf /var/

[ADMIN] IMPORT or ETL tools

Hi All, Do anyone of you aware of any good PG import tool same as SQL*LOADER in ORACLE We are doing some DataWarehouse work and need to import a large set of data from csv files. We are trying a import tool from ems-hitech.com, but I have troubles when loading time and date columns. Any help is

[ADMIN] EPOCH time vs PG timestamp

regards, Louie Kwan ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] SYSDATE in PostgreSQL !?

, statusINTEGER NOT NULL, remedyID VARCHAR2(15) UNIQUE, remedySchemaID NUMBER default 48, remedyLastModifiedINTEGER, updateTimeStamp DATE default (SYSDATE), createTimeStamp DATE default (SYSDATE) ); Regards, Louie Kwan

[ADMIN] Commercial PostgreSQL support

We are looking for some sort of commercial PostgreSQL support, but we have limited budget. Email based type support may be enough. Any pointer will be appreciated. Thanks. Regards, Louie Kwan ---(end of broadcast)--- TIP 3: if posting/reading

[ADMIN] "SELECT ANY TABLE" !!

I would like to create a user which has only read privilege, something like "SELECT ANY TABLE"... Any pointer or help is appreciated. Louie Kwan > Senior Systems Integrator > NUVO - THE IT OUT-TASKING COMPANY > (613) 726-5071Direct Line > (613

[ADMIN] "SELECT ANY TABLE" !!

I would like to create a user with only read privilege, something like "SELECT ANY TABLE"... Any pointer or help is appreciated. Louie Kwan [EMAIL PROTECTED] > NUVO - THE IT OUT-TASKING COMPANY > (613) 726-5071Direct Line > (613) 721-1399 Fax >

[ADMIN] Recall: "SELECT ANY TABLE" !!

Louie Kwan would like to recall the message, ""SELECT ANY TABLE" !!". ---(end of broadcast)--- TIP 8: explain analyze is your friend