[GENERAL] Static linking of libpq with a windows application.

2007-11-20 Thread Farhan Khan
Hi, I am developing a windows application and will statically link pgsql frontend with as part of final binary (so that it will not require libpq.dlland other dll at runtime). Any pointers on how to do it? Do we have to compile the source code to generate a new lib file ?? Anyone with prior experie

[GENERAL] Start DB giving fatal message.(linux)

2007-10-23 Thread Farhan Khan
Because of some OS failure I have to reinstall linux and postgres and now database start gives me following error message. Any pointers will be apprciated ... [EMAIL PROTECTED]:postgresql-8.2.5$ /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data LOG: database system was shut down at 2007-10-

[GENERAL] Porting Schema from MySQL

2007-10-01 Thread Farhan Khan
Hi ... I am porting a db schema from MySQL to postgresql and having problem in defining a column level constraint... mtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, gives me problem at ^ON UPDATE ... Any pointer for implementing this functionality in postgresql ?? Tx ..