fkater@xxxxxxxxxxxxxx wrote:
Hi,
what's an alternative to tableoids?
As I've learned today they are not consistant across pg_dump/restore.
I need to point to (lots of dynamically added) tables and used tableoids
before.
Are there other solutions to point to tables besides using tableoids
or wasting disk space using the strings of 'schema' and 'tablename'
everywhere as a reference?
Are you seriously saying that you have so many tables that storing their
names is a problem?
Anyway, since your code is expecting something that looks like an OID,
why not just build your own, something like:
CREATE TABLE my_sys_object_tracker (
objoid SERIAL,
objschema name NOT NULL,
objname name NOT NULL,
PRIMARY KEY (objoid),
CONSTRAINT unique_obj_name UNIQUE (objschema, objname)
);
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
