[GENERAL] How to select a postgresql table inside Oracle

2010-11-16 Thread Hu, William
Hi, I have a need to select some data in a Oracle database from a Postgresql table. I know how to do this among Oracle instances, eg. Select * from ta...@another_instance. Are there similar approach without replicate the database tables? Thanks in advance.

[GENERAL] Postgresql database for distributed transactions

2010-08-02 Thread Hu, William
Hi, I am designing a mobile POS application. I was hoping I can use the Postgresql database as the central transactional database. The application itself will run on a remote mobile PC. The retail transaction data is small, it consists of the transaction timestamp, location, amount, item pric

[GENERAL] PSQL 9.1.3 segmentation fault

2012-03-30 Thread Hu, William
I downloaded the stable version of postgresql-9.1.3.tar.gz, installed on a CentOS 5.7 final server. I used -with-openssl option with the configure, after starting the server, Psql would cause a segmentation fault, createuser did too. I don't think the postgresql log shows anything on this, plea