diff options
| author | Bruce Momjian | 2003-07-27 04:51:45 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2003-07-27 04:51:45 +0000 |
| commit | 524cfad23f31db70a23fc1fe748c050838d5fad0 (patch) | |
| tree | 58833d4c5bad0d04c34f64b84c33126efc76dfd0 /contrib/oid2name/oid2name.c | |
| parent | 38fb906f93b40edc9ef367b5619f431851fc3867 (diff) | |
Here is 4 file in tgz:
the new timetravel.c,
new timetravel.README (cut from spi/README and modified),
modified timetravel.sql.in
and modified timetravel.example.
Features:
- optionally 3 parameter for insert/update/delete user name
- work with CREATE UNIQUE INDEX ixxx on table xxx
(unique_field,time_off);
(the original version was work with unique index on 6.5.0-6.5.3,
and not work on 7.3.2,7.3.3)
(before 6.5.0 and between 6.5.3 and 7.3.2 I dont know)
- get_timetravel(tablename) function for check timetravel-status.
- timetravel trigger not change oid of the active record. (it is not a
good feature, because the old version is automatice prevent the paralel
update with "where oid=nnn")
B?jthe Zolt?n
Diffstat (limited to 'contrib/oid2name/oid2name.c')
| -rw-r--r-- | contrib/oid2name/oid2name.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/contrib/oid2name/oid2name.c b/contrib/oid2name/oid2name.c index a5c18d761f8..9e8320eba18 100644 --- a/contrib/oid2name/oid2name.c +++ b/contrib/oid2name/oid2name.c @@ -355,7 +355,9 @@ sql_exec_dumptable(PGconn *conn, int systables) if (systables == 1) snprintf(todo, 1024, "select relfilenode,relname from pg_class order by relname"); else - snprintf(todo, 1024, "select relfilenode,relname from pg_class where relname not like 'pg_%%' order by relname"); + snprintf(todo, 1024, "select relfilenode,relname from pg_class " + "where reltype not in ('v','c') and " + "relname not like 'pg_%%' order by relname"); sql_exec(conn, todo, 0); } |
