Hi List,
after an installation of PostgrSQL v6.5 on a new machine
i have problems with a view which is running without problems
under 6.4.x.
But the view isn't the problem. The same statement on the real table
realized the same error:
ERROR: illegal use of aggregate or non-group column in target
What version of PostgreSQL? The "backends dying problem", I thought, was
fixed already...
On Wed, 25 Aug 1999, Michael wrote:
> Hi all
>
> I have just isolated a big problem in one of my applications and it turns out
> to be a memory leak in postgresql on a VERY basic piece of functionality
>
Hi,
>after an installation of PostgrSQL v6.5 on a new machine
>i have problems with a view which is running without problems
>under 6.4.x.
>But the view isn't the problem. The same statement on the real table
>realized the same error:
>ERROR: illegal use of aggregate or non-group column in target
At 13:02 25.08.99 +0100, Stuart Rison wrote:
>Hi,
>
>>realized the same error:
>>ERROR: illegal use of aggregate or non-group column in target list
>>(aggregates are not existing in my database)
>>
>>Statement: select x1, x2, x3, x4 on tablex order by x1, x2;
have You set any triggers, rules, listens or defaults for tablex?
-Original Message-
From: Jens Felber [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, August 25, 1999 5:40 PM
To: Stuart Rison; [EMAIL PROTECTED]
Subject:Re: [GENERAL] changing between 6.4.1 and 6.5
At 13:02 25.08
>
>
> What version of PostgreSQL? The "backends dying problem", I thought, was
> fixed already...
=> select version();
version
--
PostgreSQL 6.5.1 on i586-pc-linux-gnu, compiled b
dear sirs,
How to stop the "pgsql_general_digest"
thanks
rongjainwei
Aug. 26 1999
At 18:02 25.08.99 +0200, you wrote:
>have You set any triggers, rules, listens or defaults for tablex?
>
Nothing is set. I create a new table for tests.
--> create table test1 (x1 int2, x2 int2, tx char);
then I've inserted some values:
--> insert into test1 values (1,2, 'a');
--> insert in
