[ADMIN] dump a table in windows

2002-09-24 Thread Laurette Cisneros
I need to dump a table from a database on a server on another system into a file from a client on windows. I've tried using pgadminII and issuing a copy command but it runs dog slow! I've tried using Python/pyPgSQL by querying the records from the table and writing them to a file and it runs d

Re: [ADMIN] command line client on windows?

2002-09-24 Thread Laurette Cisneros
I don't suppose anyone has this compiled for win2000 already as I don't have MSVC++ available? L. On Sat, 21 Sep 2002, Peter Eisentraut wrote: > Laurette Cisneros writes: > > > Is there a command line client to run sql against a postgresql server (on a > > linux box elsewhere) available for win

Re: [ADMIN] [DBmirror Issue] recordchange() dies in packageData unless there is a PRIMARY KEY on DELETE and UPDATEs.

2002-09-24 Thread Tom Lane
"Rajesh Kumar Mallah." <[EMAIL PROTECTED]> writes: > # patch -p0 < patch > patch: malformed patch at line 7: PRIMARY); I think the patch got mucked up by line-wrapping, either in your mail program or Steve's ... regards, tom lane ---(end of

Re: [ADMIN] [DBmirror Issue] recordchange() dies in packageData unless there is a PRIMARY KEY on DELETE and UPDATEs.

2002-09-24 Thread Mark McEahern
[Rajesh Kumar Mallah] > Hi can you help me with applying the patch > i dunno much abt patch > > # patch -p0 < patch > patch: malformed patch at line 7: PRIMARY); It looks like a context patch. patch --help should tell you how to apply a context patch. It will also tell you the basic syntax

Re: [ADMIN] logging queries

2002-09-24 Thread Gaetano Mendola
""Nick Fankhauser"" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi- > > I'd like to set the logging or debug level so that the text of the queries > that are executed show up in the log file. It seems to me that I recall this > being discussed before, but I

Re: [ADMIN] [DBmirror Issue] recordchange() dies in packageData unless there is a PRIMARY KEY on DELETE and UPDATEs.

2002-09-24 Thread Rajesh Kumar Mallah.
Hi can you help me with applying the patch i dunno much abt patch # patch -p0 < patch patch: malformed patch at line 7: PRIMARY); regds mallah. On Tuesday 24 September 2002 02:18, Steven Singer wrote: > On Mon, 23 Sep 2002, Rajesh Kumar Mallah. wrote: > > Hi > > > > Is anyone using