| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "fkater(at)googlemail(dot)com" <fkater(at)googlemail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Alternative to tableoids? |
| Date: | 2008-02-05 10:21:58 |
| Message-ID: | 20080205102158.GB10083@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Feb 04, 2008 at 08:12:51PM +0100, fkater(at)googlemail(dot)com wrote:
> 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?
Use regclass, takes the same space as OIDs but works across
dump/restore. For tables anyway (not indexes etc al)
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2008-02-05 10:28:34 | cursor vs. for _row in select... |
| Previous Message | Dave Page | 2008-02-05 09:58:08 | Re: postgresql-8.3.0-1-binaries-no-installer: gssapi32.dll missed ? |