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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
