From: Piotr Stelmaszyk <kelman@fanthom.math.put.poznan.pl>
To: PgSQL-interfaces <pgsql-interfaces@postgresql.org>
Date: Mon, 7 Jun 1999 17:49:44 +0200
Message-ID: <14742.990607@fanthom.math.put.poznan.pl> (raw)
hi,
i'm trying to drop table in plpgsql trigger.
the problem is that table name depends on ID of object
that is to be removed.
so:
<cut>
declare
t text;
begin
t := 'objects' || trim(OLD.id);
drop table t;
end
</cut>
psql prints error:
<cut>
ERROR: parser: parse error at or near "$1"
</cut>
what may be the problem? what does it mean "$1"? i don't have
any function arguments.
any ideas? thanx.
/--------------------------------------------------------/
/- Piotr Stelmaszyk |---- Student of Computer Science ---/
/------------------ | at Poznan University of Technology /
/----- mailto:kelman@fanthom.math.put.poznan.pl ---------/
/----- mailto:kelman@alpha.net.pl -----------------------/
/--------------------------------------------------------/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: kelman@fanthom.math.put.poznan.pl
Subject: Re:
In-Reply-To: <14742.990607@fanthom.math.put.poznan.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox