Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tharas

    Dynamic Cursors in PostgreSQL

    Hello all, I have a function in which I declared a cursor as REFCURSOR and this curosr selects some rows from a temporary table based on some condition. Within the cursor, I have to make updation to some field values of the temporary table and later execution of the cursor should be based on...
  2. tharas

    Restore problem pg_restore

    Hai, Thanks. I have tried a re-installation of PostgreSQL 8.2 server. And I installed everything that comes as part of the PostgreSQL installer package (postgresql-8.2.msi). Yet I am getting the same error messages while restoring. regards, ...tharas
  3. tharas

    Restore problem pg_restore

    Hai all, I tried to restore a database dump in PostgreSQL server database server 8.0 to PostgreSQL server database server 8.2 on a Windows 2003 server platform. But it shows the following errors and the restoration completes with these errors ignored...
  4. tharas

    Exporting smalldatetime fields to PostgreSQL from SQL server

    Hello all, I am engaged in a work of porting a MS SQL server database to PostgreSQL. I am using PostgreSQL 8.0 and both the databases are in Windows. I have a smalldatetime field in one of the tables in which the data is stored in the format dd/MM/yyyy. But when I am exporting this field to...
  5. tharas

    Problem with pgaccess installation

    Dear all, I have a Pentium IV machine with Redhat Linux 9.0 installed in it. I installed the PostgreSQL 8.1 database server and it is working fine. When I tried to install pgAccess with the following command, it shows the message: rpm -ivh pgaccess-7.2.4-6.i686.rpm warning...
  6. tharas

    Upgradation from PostgreSQL 7.3 to PostgreSQL 8.1.

    Hai all, I have an Intel Pentium IV machine with Redhat Linux 9.0 installed in it. It was also having PostgreSQL 7.3 which was installed along with Redhat Linux 9.0 installation and it was working fine. The installation location of the PostgreSQL 7.3 was /usr/local/pgsql and data directory was...

Part and Inventory Search

Back
Top