Quick Links

Changing PL/pgSQL triggers

From:	"James Orr" <james(at)lrgmail(dot)com>
To:	<pgsql-sql(at)postgresql(dot)org>
Subject:	Changing PL/pgSQL triggers
Date:	2001-06-21 17:30:39
Message-ID:	004d01c0fa77$f64f0580$1600000a@lrg.office
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

Hi,

What's the easiest way to modify or view a function written in PL/pgSQL? I've been using pg_dump to get the original function, then dropping and creating the function and trigger after making a change. Is there an easier way?

-James

Responses

Re: Changing PL/pgSQL triggers at 2001-06-21 17:50:46 from Roberto Mello
Re: Changing PL/pgSQL triggers at 2001-06-21 18:10:31 from Alain Lavigne
Re: Changing PL/pgSQL triggers at 2001-06-21 19:31:44 from Josh Berkus

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Jan Wieck	2001-06-21 17:35:35	Re: Correct syntex for implicit curor in for loops
Previous Message	Martín Marqués	2001-06-21 17:02:21	case, new column not found