How to change pg_largeobject tablespaces?

From: Nelson Gonzaga <ngonzaga(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to change pg_largeobject tablespaces?
Date: 2009-03-03 14:30:06
Message-ID: 302408.89490.qm@web55108.mail.re4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Jakov Sosic 2009-03-03 19:40:05 Backing up postgresql database
Previous Message Alejandro D. Burne 2009-03-03 11:37:09 Troubles with pgagent