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.
> O
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
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 c
Hi
I'm using PostgreSQL 7.0.0 (PostgreSQL 7.0.0 on i686-pc-linux-gnu,
compiled by gcc egcs-2.91.66) on Redhat Linux 6.1.
When I start PostgreSQL, I use the command
/etc/rc.d/init.d/postgresql start
and pg_ctl starts.
I use Cold Fusion on Win2k as frontend to PostgreSQL, and Cold Fusion
opens up
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
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.
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 b
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 anim
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: postmast
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 w
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 La
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
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
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.
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 year
"rob" <[EMAIL PROTECTED]> writes:
> 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.
You should have reported it :-( ... as I said, I hadn't
16 matches
Mail list logo