Re: [GENERAL] [ERROR] syntax error at end of input

2007-08-27 Thread Tom Lane
"Marcelo de Moraes Serpa" <[EMAIL PROTECTED]> writes: >DROP FUNCTION IF EXISTS aNomeProcAudita; >DROP TRIGGER IF EXISTS 'Audita_' || pTabAudit || '_trigger'; Neither of those match the documented syntax for the commands: you have left off required information. Also, as And

Re: [GENERAL] [ERROR] syntax error at end of input

2007-08-27 Thread A. Kretschmer
am Mon, dem 27.08.2007, um 9:40:45 -0300 mailte Marcelo de Moraes Serpa folgendes: > Hello list, > > I'm trying to execute the following sentences in a pl/pgsql function. > aNomeProcAudita and pTabAudit are both variables. > >DROP FUNCTION IF EXISTS aNomeProcAudita; Which version?

[GENERAL] [ERROR] syntax error at end of input

2007-08-27 Thread Marcelo de Moraes Serpa
Hello list, I'm trying to execute the following sentences in a pl/pgsql function. aNomeProcAudita and pTabAudit are both variables. DROP FUNCTION IF EXISTS aNomeProcAudita; DROP TRIGGER IF EXISTS 'Audita_' || pTabAudit || '_trigger'; When I try to create this function with