From: | Piotr Stelmaszyk <kelman(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl> |
---|---|
To: | PgSQL-interfaces <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | |
Date: | 1999-06-07 15:49:44 |
Message-ID: | 14742.990607@fanthom.math.put.poznan.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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(at)fanthom(dot)math(dot)put(dot)poznan(dot)pl ---------/
/----- mailto:kelman(at)alpha(dot)net(dot)pl -----------------------/
/--------------------------------------------------------/
From | Date | Subject | |
---|---|---|---|
Next Message | Herouth Maoz | 1999-06-07 16:23:56 | Re: |
Previous Message | Heliodor Macko | 1999-06-07 11:38:48 | PG 6.5, ODBC for Win32 and BLOBs |