We recently upgraded from postgres version 8.2.7 to 8.3.7. The below
pl/pgsql test function behaves differently in the 2 versions.
The code of the function is :-
CREATE OR REPLACE FUNCTION public.testloop () RETURNS varchar AS
$body$
BEGIN
FOR idx IN 1..10 LOOP
raise notice
We want to implement a mechanism by which if any database function is
created or modified in one database, then the same should automatically get
done in another (1 or more) database(s).
It seems triggers on system catalogs like pg_proc are not allowed. Is there
any way in postgres to do this,
Could you give some examples of such utilities?
Thanks!
atul
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent: Friday, June 05, 2009 1:37 PM
To: Atul Chojar
Cc: pgsql-general@postgresql.org
We are unable to pass parameters into any sql script. Could anyone look at the
test below and give any suggestions? PostgreSQL version is 8.2.7, running on
Linux.
Test Script
$ cat chk_param.sql
select ||:p_date::char(8)||;
select count(*) from
Could someone reply to this email? I am testing my subscription; joined over 2
months ago, but never get any response to questions
Thanks!
Atul
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Joshua D. Drake
Sent:
Ferreira
Sent: Wednesday, April 22, 2009 1:34 PM
To: Atul Chojar
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Testing ... please reply
Coming loud and clear !
joao
On Wed, 2009-04-22 at 13:21 -0400, Atul Chojar wrote:
Could someone reply to this email? I am testing my subscription