Postgres Pro
Downloads
Home   >   mailing lists

Re: [ERROR] syntax error at end of input - Mailing list pgsql-general

From A. Kretschmer
Subject Re: [ERROR] syntax error at end of input
Date
Msg-id 20070827125556.GF13996@a-kretschmer.de
Whole thread Raw
In response to [ERROR] syntax error at end of input  ("Marcelo de Moraes Serpa" <celoserpa@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: SQL Diff ?
Next
From: Joseph S
Date:
Subject: Re: EXPLAIN ANALYZE not considering primary and unique indices!