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
Dear Friends,
While doing compressed backup for one of the database running
at Postgres Server 7.3.4 on RH Linux 7.2, I got the following error., but it
backup other items
--Command to backup
$ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f
/home/db_repository/testdb20031023.sql.tar.gz -
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
Hi
I try to create the following SQL function:
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';
but when I submit this query dire
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,
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?
Thanks
Huub
---(end of broadcast)--
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.
Hi I have Postgres 7.0.3/6 on a Suse Professional 7.1 (kernel 2.4.0)
machine.
The database is used very often and I see in the logfile the error
message: Sorry, too many clients already
Can I set the number of 'active' clients? And where can I set this? And
How?
Thanx in advance!
Sven Frank
12 matches
Mail list logo
