From: Nelson Gonzaga <ngonzaga@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: How to change pg_largeobject tablespaces?
Date: Tue, 3 Mar 2009 06:30:06 -0800 (PST)
Message-ID: <302408.89490.qm@web55108.mail.re4.yahoo.com> (raw)
Hi,
I create a lot of tablespaces and now I like to split tables, indexes and lo in many HD, but I don´t get to change the tablespace of the pg_largeobject:
alter table pg_largeobject set tablespace tbs_lo;
ERROR: permission denied: "pg_largeobject" is a system catalog
How to avoid this error or bypass this permission?
Tks,
NG
Veja quais são os assuntos do momento no Yahoo! +Buscados
http://br.maisbuscados.yahoo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ngonzaga@yahoo.com
Subject: Re: How to change pg_largeobject tablespaces?
In-Reply-To: <302408.89490.qm@web55108.mail.re4.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox