ProcessUtilityHook DropStmt RenameStmt - Mailing list pgsql-hackers

From geohas
Subject ProcessUtilityHook DropStmt RenameStmt
Date
Msg-id 53E8C7CD.70008@hasibether.at
Whole thread Raw
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!

I try to catch a DropStmt and convert it to a Rename Stmt, like petere's
pg_trashcan, but i don't like to create new schema. I only like to
rename the table in case of a drop table query.
Is this possible with something like:

ProcessUtility (Node * parsetree,              const char *queryString,              ParamListInfo params,
boolisTopLevel,              DestReceiver * dest, char *completionTag)
 

{
if (nodeTag(parsetree) == T_DropStmt)
{DropStmt *stmt = (DropStmt *) parsetree;if (stmt->removeType == OBJECT_TABLE)
{RenameStmt *newstmt = makeNode(RenameStmt);
newstmt->objectType = stmt->removeType;
newstmt->newname = new_name;
parsetree = (Node *) newstmt;
}
(*prev_ProcessUtility) (parsetree, queryString,    context, params,
dest, completionTag);
}

regards

ge0has
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.22 (GNU/Linux)

iQEcBAEBAgAGBQJT6MfNAAoJEJFGMlQe7wR/RCQH/1KOwtCLDT2QVrGm/PKfIFGF
e6w+oOCUYz8v78s+uvI5Y5qEuUr2wqYuUhhV7UWXWBwKgLPkSvUTv04TWS9Ms6FJ
+Zn+yzqWUygdwDzKbKY3/qYreYAL6ZBv62ldjtApNUh1VHpPtZsPWtIe/485KB6v
W4xZt7PUAKOUlqTiQwaZok2rdYt0t7vWdVmw6qncUnlPGBpJM/XGGwDl4w5NCK23
Ls5ueLpe8gKoH1eMYG27FKo1rRARVBtB3zPkXmmfRZR+f1FUIkhiDkfm1AYhBJPy
FG0yExArvZjZLQIIEaenb8GzwjR04Ulaqej5CLPdOB0NomkN0aN0CKcSRT9SrME=
=Y3t4
-----END PGP SIGNATURE-----




pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: psql: show only failed queries
Next
From: Kevin Grittner
Date:
Subject: Re: Proposal to add a QNX 6.5 port to PostgreSQL