I have built and am running pgsql version 7.0.3 on
Redhat Linux 7.0. I downloaded ERServer version 7.0
but the source distribution seems to be missing
at least a Makefile. There is a README.rserv saying
Requirements:
- PostgreSQL >= 7.0.X
A separate Makefile is required for PostgreSQL 7.0.x a
Hi Rod,
This sounds nifty, but I'm wondering about the speed of such an operation.
Our design calls for a system that can do this one operation (over and
above all the other DB queries) 28 times per second.
What sort of performance are you getting out of this setup. Could it
handle 28 calls per
On Fri, Apr 06, 2001 at 09:11:38PM -0400, some SMTP stream spewed forth:
> I didn't get a response on my message, so I thought I would try again.
>
> 1. A large object has the data type OID. What then, is the data type of the
> instance object identifier? Is it an int4?
>
I believe it is of
I didn't get a response on my message, so I thought I would try again.
1. A large object has the data type OID. What then, is the data type of the
instance object identifier? Is it an int4?
2. How would I create a table such the following select statement will return
the instance object inde
Hi all,
I would like to do something like the following in a trigger:
update tablename on otherdbhost set field1 = new.field1 where keyfield =
new.keyfield;
Is this a pipe dream using Postgres or is there some way to perform such
a feat?
Thanks.
Marc Wrubleski
---(en
"Gordon A. Runkle" <[EMAIL PROTECTED]> writes:
> Yet, when running VACUUM ANALYZE on this table, I run out of
> space.
Not sure if that should be construed as a bug or not; Vadim will have to
answer that. But here's a thought: try increasing CHECKPOINT_TIMEOUT
and/or CHECKPOINT_SEGMENTS so that
Phuong Ma <[EMAIL PROTECTED]> writes:
> I read this from the 7.1 documentation:
> 3.2. Monetary Type
> The money type may become a locale-aware
> layer over the numeric type in a future release.
> The money type stores U.S.-style currency with fixed decimal point
> representation. If Postgres i
Hello all,
I'm running 7.1RC2 and have a question/problem:
I have a table which is 28150 pages in size. It has two indices
of 8001 and 9750 pages.
The filesystem on which pg_xlog resides has ~750MB free.
No other PostgreSQL work is running.
Yet, when running VACUUM ANALYZE on this table, I r
On Friday 06 April 2001 06:20, Ahmed Moustafa wrote:
> Tom,
>
> I set LD_LIBRARY_PATH in root's .profile and I still get the same error.
> Do I need to set somewhere else, please?
I had the same problem. It's because Solaris isn't reading the .bashrc,
.profile or what ever. Solution: ln -s /usr
