Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id D39736342AC for ; Tue, 3 Mar 2009 10:30:11 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 46554-01 for ; Tue, 3 Mar 2009 10:30:07 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web55108.mail.re4.yahoo.com (web55108.mail.re4.yahoo.com [206.190.58.157]) by mail.postgresql.org (Postfix) with SMTP id 2A114634283 for ; Tue, 3 Mar 2009 10:30:08 -0400 (AST) Received: (qmail 90200 invoked by uid 60001); 3 Mar 2009 14:30:06 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1236090606; bh=4/9wJ/yYrmZgG6CVwsuPeQH3dhQ5XAdFMMgcjiqlUvE=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=fxI+mulhxPsUw69WuJdGn2nfXFzLCAnPRlzlmqNU7yNYN0KNeJhuSiKuKdawwQ+ivZ3DWEv+hONyeyvkjJ0CbG9RUFtvh9ndkMdT2ZAzogwoR0XTPNWriIasjEbTuJkiddDvfWkaCh9Xy2GEgPg2VOAU5NP6ljR9YnuXo+rAfhE= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=nTLzvS9BuCqXUXxt7V0Ny255AbeywDs1hd4HrhXeTMzLn4AOqpE6Xher6L8/BqXI5s2aD5dOT0EfsYZlYAwhZiMG5lNM1u8/w99coBlFSu35VkxS2ELYxhe3IkPew5BWt5ZZZLaMxWkg6A/pC5HUuPMZK5mLPuR3EM82svZWL3E=; Message-ID: <302408.89490.qm@web55108.mail.re4.yahoo.com> X-YMail-OSG: pH2.wzYVM1mk8URo86VWKN3kur_.DgHS2jRFRG9l4.XUN_MkcxDRsiu9Zr2fof2PGAlld4zLitGXot3UhUeQjkTw88EYp8vMsYtbs3r4elwvuzuBGmDvw22GozHWj6uxosjCQTaX7HQbRT3AvNAfdjeWZd36DrF8w_xzG2mRafEJ.jQr2QJ_Cv.eCa9VwKKU43g4nsUGoOK_kCOOkA7t8ADsG95aPg-- Received: from [200.198.92.34] by web55108.mail.re4.yahoo.com via HTTP; Tue, 03 Mar 2009 06:30:06 PST X-Mailer: YahooMailRC/1277.29 YahooMailWebService/0.7.289.4 Date: Tue, 3 Mar 2009 06:30:06 -0800 (PST) From: Nelson Gonzaga Subject: How to change pg_largeobject tablespaces? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1561432096-1236090606=:89490" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200903/31 X-Sequence-Number: 31531 --0-1561432096-1236090606=:89490 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0AI create a lot of tablespaces and now I like to split tables, indexes= and lo in many HD, but I don=B4t=A0get to change the tablespace of the pg_= largeobject:=0A=0Aalter table pg_largeobject set tablespace tbs_lo;=0AERROR= :=A0 permission denied: "pg_largeobject" is a system catalog=0A=0AHow to av= oid this error or bypass this permission?=0A=0ATks,=0ANG=0A=0A=0A Veja= quais s=E3o os assuntos do momento no Yahoo! +Buscados=0Ahttp://br.maisbus= cados.yahoo.com --0-1561432096-1236090606=:89490 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,
=0A
I create a lot of tablespaces and now= I like to split tables, indexes and lo in many HD, but I don=B4t get = to change the tablespace of the pg_largeobject:
=0A
 
= =0A
alter table pg_largeobject set tablespace tbs_lo;
ERROR:  p= ermission denied: "pg_largeobject" is a system catalog
=0A
How= to avoid this error or bypass this permission?
=0A
 
= =0A
Tks,
=0A
NG

=0A=0A=0A
Vej= a quais s=E3o os assuntos do momento no Yahoo! + Buscados: To= p 10 - Celebridades - M=FAsica - Esportes --0-1561432096-1236090606=:89490--