[ERROR] syntax error at end of input

From: "Marcelo de Moraes Serpa" <celoserpa(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: [ERROR] syntax error at end of input
Date: 2007-08-27 12:40:45
Message-ID: 1e5bcefd0708270540p5a45ae19h5e43568cadb373ea@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2007-08-27 12:48:04 Re: SQL Diff ?
Previous Message Andrus 2007-08-27 12:23:38 Re: simple query runs 26 seconds