ED]>
To: "Senthil Kumar S" <[EMAIL PROTECTED]>
Cc: "psql" <[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 6:01 PM
Subject: Re: [SQL] Error message during compressed backup
> Senthil Kumar S writes:
>
> > $ $ pg_dump -h 192.xxx.x
ED]>
To: "Senthil Kumar S" <[EMAIL PROTECTED]>
Cc: "psql" <[EMAIL PROTECTED]>
Sent: Friday, October 24, 2003 6:01 PM
Subject: Re: [SQL] Error message during compressed backup
> Senthil Kumar S writes:
>
> > $ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb
Senthil Kumar S writes:
> $ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f
> /home/db_repository/testdb20031023.sql.tar.gz -u -F c
> WARNING: owner of function "plpgsql_call_handler" appears to be invalid
Run
select proowner from pg_proc where proname = 'plpgsql_call_handler';
which gives yo
Thanks
You were right, it was because of the return void
But I think in the documentation, I read somewhere that this kind of
return was allowed ... I must have mistaken ...
---(end of broadcast)---
TIP 6: Have you searched our list archives?
[EMAIL PROTECTED] (krysto) writes:
> CREATE FUNCTION update_affiliate(int,double precision,double
> precision) RETURNS void AS ' UPDATE affiliate SET balance=balance +
> $2, balance_in_points=balance_in_points + ( $2 / $3 ) WHERE id = $1; '
> LANGUAGE 'sql';
I don't believe there was a type "v
On Fri, 15 Nov 2002, Huub wrote:
> Hi,
>
> When I copied a function call into an SQL-statement and executed it, I
> got the message 'Aggregate function calls may not be nested'. Does that
> mean this is the case in standard SQL or is this specifically PostgreSQL?
Umm, both sort of. It's an entr
Huub <[EMAIL PROTECTED]> writes:
> When I copied a function call into an SQL-statement and executed it, I
> got the message 'Aggregate function calls may not be nested'. Does that
> mean this is the case in standard SQL or is this specifically PostgreSQL?
It's in the standard: SQL92 (which calls
Hi Sven,
There is a startup option, "-N" of how many clients are allowed to be
connected simultaneously. The default is 32 in the source code, not
sure if SuSE has it changed.
You can also alter the default maximum before compiling it, but I get
the feeling you've installed pre-built packages.
