[GENERAL] How to connect with postmaster through TCP socket

Hi, I am using postgresql 7.1.3 in RedHatLinux 7.2. Can anyone tell me how to connect with postmaster through TCP socket (it is started with -i option) using libpq from an external application. (written in C) -- regards, Deepa K ---(end of broadcast

[GENERAL] [Fwd: Abrupt close of pgsql backend]

Original Message Subject: Abrupt close of pgsql backend From:"Deepa K" <[EMAIL PROTECTED]> Date:Mon, October 25, 2004 8:04 pm To:

[GENERAL] ABRUPT CLOSURE OF POSTGRESQL SOCKET

b. How can the application detect such a abnormal closure of socket? -- regards, Deepa K ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] IP clash in the PC

uring rarely. >>> >>> Steps followed : >>> == >>> >>> 1. Linux installation (PC with IP adderss clash) >>> 2. Running psql -U corview manager -f "filename" >> out >>> >>> Can any one help me regarding

[Fwd: Re: [GENERAL] IP clash in the PC]

Original Message Subject: Re: [GENERAL] IP clash in the PC From:"Deepa K" <[EMAIL PROTECTED]> Date:Thu, August 26, 2004 10:56 am To: "Jan Wie

[GENERAL] Can trigger return value

ove problem. If so please explain me. regards, Deepa K. ---(end of broadcast)--- TIP 8: explain analyze is your friend

[GENERAL] ERROR STRINGS IN PGSQL

Hi All, Is proper error numbers are defined for all error strings returned by pgsql c library. Is so, where can I get those error numbers and is it possible to return error strings using error numbers. regards, Deepa K. ---(end of broadcast

[GENERAL] PQgetResultSet Problem

Hi all, I am using postgresql 7.1.3 and a client using libpq. I am executing a statement with muliple SQL commands semicolon seperated. If any one of the query in between fails, pqGetResultset returns NULL on the failed query. So i am unable to process the rest of the queries. Also

[GENERAL] Arrays is stored procedure

Hi all, Is it possible to declare a bit array in pgsql procedure. If so how to read and write values in that array. regards, Deepa K. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[GENERAL] About Pgdump

Hi all, I want to take backup of our online system on daily basis using crontab. But actually the pg_hba.conf is configured with password security. How I can take the backup without setting password. Or is their any other way to take backup. TIA regards, Deepa K

[GENERAL] COPY COMMAND

Hi All,     Is it possible to insert n rows with 1 or 2 invalid rows using copy command. I used it, it rollbacks everything even if 1 row gets an error. Is their any other way to do it. TIA --  regards, Deepa K.