"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
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
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.
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
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
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
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
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
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:
> -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
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.
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
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
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,
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 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
16 matches
Mail list logo
