Re: [GENERAL] ECPG could not connect to the database.

2001-01-09 Thread Michael Meskes
On Mon, Jan 08, 2001 at 06:20:42PM +0100, Peter Eisentraut wrote: is not in libpq's current sources anymore. I fully agree with Peter E's reasons for removing it, too. We do not need to overload the definition of libpq's dbname parameter. Why? Sorry, it seems I missed his mail. Ouch,

[GENERAL] xml middleware

2001-01-09 Thread Peter Cheng
Hi, Does Postgres provide xml middleware? If so, would anyone tell me where I can get it, thanks. - Peter ©_¼¯¹q¤l«H½c¡E·¾³q¤ß¥@¬É http://mail.kimo.com.tw ºô ¸ô ¥Í ¬¡¡EºÉ ¦b ©_ ¼¯ http://www.kimo.com.tw

Re: [GENERAL] DES encryption in Postgres?

2001-01-09 Thread Marko Kreen
On Tue, Jan 09, 2001 at 04:54:36AM -, [EMAIL PROTECTED] wrote: I looked through all the docs, and I couldn't find a function which would simply DES encrypt a string. Is DES not implemented in Postgres? Or am I just not finding the function? It is not implemented. In 7.1 you'll find

[GENERAL] Cluster means tangle for me

2001-01-09 Thread Jeff Eckermann
I would appreciate any advice on getting out of this strange situation. My table now doesn't exist, but I can't recreate it either (at least under that name). jeffe@kiyoko= psql -V psql (PostgreSQL) 7.0.0 jeffe@kiyoko= uname -a FreeBSD kiyoko.la.verio.net 4.0-STABLE FreeBSD 4.0-STABLE #0: Thu

Re: [GENERAL] Cluster means tangle for me

2001-01-09 Thread Tom Lane
Jeff Eckermann [EMAIL PROTECTED] writes: I would appreciate any advice on getting out of this strange situation. My table now doesn't exist, but I can't recreate it either (at least under that name). Hmm, was "dedcolo" a temp table? It looks like clustering a temp table gets confused. (In

Re: [GENERAL] Re: COPY error: pqReadData() -- backend closed thechannel unexpectedly

2001-01-09 Thread Tod McQuillin
On Tue, 9 Jan 2001, Tom Lane wrote: -S suppresses all log output, so first you need to get rid of that. The postgres.1 man page from postgresql-7.0.3/doc/man.tar.gz says: -S SortSize Specifies the amount of memory to be used by inter- nal sorts and hashes

Re: [GENERAL] Re: COPY error: pqReadData() -- backend closed the channel unexpectedly

2001-01-09 Thread Tom Lane
Tod McQuillin [EMAIL PROTECTED] writes: On Tue, 9 Jan 2001, Tom Lane wrote: -S suppresses all log output, so first you need to get rid of that. The postgres.1 man page from postgresql-7.0.3/doc/man.tar.gz says: -S SortSize Postmaster and backend switches are two different animals.

Re: [GENERAL] Re: COPY error: pqReadData() -- backend closed thechannel unexpectedly

2001-01-09 Thread Tod McQuillin
On Tue, 9 Jan 2001, Tom Lane wrote: Postmaster and backend switches are two different animals. To specify a backend switch to the postmaster, you need -o. Thus: postmaster -S -o "-S 1000" selects silent postmaster mode and 1000K sortsize for the backend. In short: postmaster.1 !=

Re: [GENERAL] xml middleware

2001-01-09 Thread Joseph Shraibman
According to the the tuning document released by GreatBridge, postgres is relational as well as object oriented. Since it is object-oriented methinks it shouldn't be a problem to translate a DTD to a database def, but trying to figure out the postgres backed code gives me a headache. Basically

[GENERAL] Re: trouble with db-restore

2001-01-09 Thread rob
I have seen that before on my own system. Same PG version for dump/restore. Wasn't a big deal for me to redo the views since I had so few (i.e. 1) I never reported it, but it happened more than once. Not sure of version, but was 7.0.1 or 7.0.2. --rob - Original Message - From: "Tom

[GENERAL] delete trigger function in 'C'

2001-01-09 Thread Sandeep Joshi
How do I get the values of parameters in the query? e.g. where x = 'op'; i.e. How do I get ? field: x value : op any example, pointers will help. thanks, Sandeep Joshi

Re: [GENERAL] Re: starting PGSQL automatically on Redhat 6.2

2001-01-09 Thread Tatsuo Ishii
From: T F [EMAIL PROTECTED] Subject: [GENERAL] Re: starting PGSQL automatically on Redhat 6.2 Date: Tue, 09 Jan 2001 12:12:52 -0700 Message-ID: [EMAIL PROTECTED] Ryan Mahoney wrote: Hey all, I copied the pg_ctl script and placed it in my /etc/rc.d/init.d/ directory and renamed it

Re: [GENERAL] Re: Loading optimization

2001-01-09 Thread Martijn van Oosterhout
On Tue, Jan 09, 2001 at 10:51:35AM -0500, Bruce Momjian wrote: Well, clustering certainly speeds up index access to multiple heap values because duplicate values are all on the same heap page. One thing that is missing is that there is no preference for index scans for clustered indexes.

Re: [GENERAL] Re: COPY error: pqReadData() -- backend closed the channel unexpectedly

2001-01-09 Thread Tom Lane
Tod McQuillin [EMAIL PROTECTED] writes: I was not aware the binary would behave differently depending on the name it was invoked as. Right. We used to have two separate binaries, and the postmaster would actually exec() the backend (postgres) binary for every session launch. About two years