Hello ,
I am trying to install postgresql-8.1.5 and postgresql-8.2.5 in linux
(Linux
version 2.6.25-14.fc9.i686 (mockbuild@) (gcc version 4.3.0 20080428 (Red
Hat
4.3.0-8) (GCC) ) #1 SMP Thu May 1 06:28:41 EDT 2008).but during compilation
it is showing following error.
I configure with follow
Hello ,
I am trying to install postgresql-8.1.5 and postgresql-8.2.5 in linux (Linux
version 2.6.25-14.fc9.i686 (mockbuild@) (gcc version 4.3.0 20080428 (Red Hat
4.3.0-8) (GCC) ) #1 SMP Thu May 1 06:28:41 EDT 2008).but during compilation
it is showing following error.
make[3]: *** [plperl.o]
Martin Kjeldsen <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE VIEW v_test_with_number AS
> SELECT
> t.*,
> (SELECT SUM(number) FROM test_use WHERE test_id = t.id) as
> numbers
> FROM test t;
This is a bad way to do it --- the sub-select isn't read
Dear All,
Recently i have released the next version of the epqa. which is a very
useful tool for, gives input for optimizing psql queries, and fine tuning
it.
epqa is tool similar like, pqa. But designed and implemented to parse log
files which is in GB's. Report is similar like that.
More inf
Hi,
I have a small problem. I have one view which sum's a another tables field and
uses that sum for several things including filtering. Every time it uses the
that summarised field in other queries or views, the planner seems to duplicate
the SUM. Isn't it possible for the planner only to do t
