| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [ERROR] syntax error at end of input |
| Date: | 2007-08-27 12:55:56 |
| Message-ID: | 20070827125556.GF13996@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Max Zorloff | 2007-08-27 13:18:19 | Re: Shared memory usage |
| Previous Message | Franck Roubieu - AXCENTEO | 2007-08-27 12:50:00 | How to restore my database ? |