[ERROR] syntax error at end of input
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 without these two sentences, everything
goes ok, however, when I've got these two sql senteces, I get the following
error:
ERROR: syntax error at end of input
Is there anything wrong with the code?
Thanks in advance,
Marcelo.
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? DROP object IF EXISTS is a new feature since 8.2. Do you
have 8.2?
DROP TRIGGER IF EXISTS 'Audita_' || pTabAudit || '_trigger';
I guess you need to rewrite this to use EXECUTE for dynamic querys like
this.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
"Marcelo de Moraes Serpa" <celoserpa@gmail.com> 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 Andreas noted, if you want to
construct a name dynamically then you have to use EXECUTE. The second
one should go something like
EXECUTE 'DROP TRIGGER IF EXISTS Audita_' || pTabAudit || '_trigger ON ' || tableName;
regards, tom lane