Re: [GENERAL] Rotating WAL files

remove everything in case you need a few files from the previous 24 hours later on. You need to be really careful when running the remove command... if you lose even one WAL file which postgres may need later on to continue the restore, you're boned. -salman -- Sent via pgsql-

[GENERAL] PITR archive_status/%p.done files

A couple of questions about these files: 1) When are these generated? Is this once an archive is generated, or once the full archive_command has run? 2) Is there any harm in removing these files by appending an rm command at the end of archive_command? -salman -- Sent via pgsql-general

[GENERAL] Error in Adding All Tables

Hi freinds, i wanted to add my all tables once in MFC application, i have a databank,which has 11 tables and i want to add them all togather. After Adding all tables, it shows me always this errors by debugging. ERROR: column reference "ctid" is ambiguous; Error while executing the quer

[GENERAL] Error in Adding All Table

Hi freinds, i wanted to add my all tables once in MFC application,normally we add it one by one. If i add all table by pressing control and click on all table ,i can add them,but by debugging it shows me always errors. ERROR: column reference "ctid" is ambiguous; Error while executing the

[GENERAL] ADO TO ODBC

hi freinds, I have an application software which has connection with MS Access through DAO.I want to use same software without any changing with my new databank Postgresql through Odbc. I dont think so,that i can change it,I must develope whole software with odbc for postgresql. can any bod

Re: [GENERAL] TODO list and "hyphen"

>> -Allow administrators to safely terminate individual sessions either via an SQL function or SIGTERM << Can't you already do this with pg_cancel_backend() or kill ? Or is this for something else altogether? -salman -- Sent via pgsql-general mailing list (pgsql-general@p

[GENERAL] Replacing MS Access with Postgresql

advance Sheikh Salman Ahmed Jetzt neu! Schützen Sie Ihren PC mit McAfee und WEB.DE. 30 Tage kostenlos testen. *http://www.pc-sicherheit.web.de/startseite/?mc=00* [http://www.pc-sicherheit.web.de/startseite/?mc=00]

[GENERAL] Query Problem

27;)"); if (PQresultStatus(res) != PGRES_COMMAND_OK) { printf("Problem with command: %s\n", PQerrorMessage(conn)); PQclear(res); PQfinish(conn); return 1; } PQclear(res); } PQfinish(conn); return 0; } It shows no relation between public and person,if i write only person ,it show

[GENERAL] Query Fails

, but connection to data it shows. i am using this code to insert data. res = PQexec (conn, "INSERT INTO public.Person values (121,'xxx','yyy')"); It will be grateful,if u ppl can help me. Sheikh Salman AhmedDiplomand in Nano Struktur TechnologieDuisburg-

[GENERAL] Query Fails

, but connection to data it shows. i am using this code to insert data. res = PQexec (conn, "INSERT INTO public.Person values (121,'xxx','yyy')"); It will be grateful,if u ppl can help me. Sheikh Salman AhmedDiplomand in Nano Struktur TechnologieDuisburg-

[GENERAL] Query Fails

, but connection to data it shows. i am using this code to insert data. res = PQexec (conn, "INSERT INTO public.Person values (121,'xxx','yyy')"); It will be grateful,if u ppl can help me. Sheikh Salman AhmedDiplomand in Nano Struktur TechnologieDuisburg-

[GENERAL] Query Fails

, but connection to data it shows. i am using this code to insert data.   res = PQexec (conn, "INSERT INTO public.Person values (121,'xxx','yyy')");   It will be grateful,if u ppl can help me.  Salman _

[GENERAL] Query Fails

, but connection to data it shows. i am using this code to insert data. res = PQexec (conn, "INSERT INTO public.Person values (121,'xxx','yyy')"); It will be grateful,if u ppl can help me. Sheikh Salman AhmedDiplomand in Nano Struktur TechnologieDuisburg-

[GENERAL] Problem by adding libpq++

  Hallo fellows i am new user of postgresql and need ur help to understand it.I am now using postgresql 3.0 with Microsoft Visual C++ 2005 express edition.But i can't connect MV C++ with postgresql.There is always library failure. Pls help me. I have installed all on window XP. s

Re: [GENERAL] dbsize command

pg-general. -salman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] how can i get initdb

pendencies. -- initdb for debian's postgres 8.3 package is in /usr/lib/postgresql/8.3/bin/initdb -- it's probably just not in your nomal path. [EMAIL PROTECTED]:~# dpkg -L postgresql-8.3 |grep -i initdb /usr/lib/postgresql/8.3/bin/initdb -salman -- Sent via pgsql-general mailing

Re: [GENERAL] PostgreSQL Replication with read-only access to standby DB

a future version of postgres but not something that's expected soon. Someone please correct me if I'm wrong. -salman -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Question about CLUSTER

ch value. Can anyone point me to docs which explain this better? -salman ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] Suppressing Error messages.

Hi All, I was wondering if there is way to suppress the error messages on the stdout from a perl dbi execute command, basically if I do a sth->execute() on a command and say the row cannot be updated then I get a err msg to stdout if there is foreign key violation, I want this error message