Re: tablespace and sequences?

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: tablespace and sequences?
Date: 2004-08-20 03:36:32
Message-ID: 20040820033632.GM6173@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin pgsql-hackers pgsql-hackers-win32

On Fri, Aug 20, 2004 at 01:26:39PM +1000, Philip Warner wrote:
> At 01:09 PM 20/08/2004, Tom Lane wrote:
> >It seemed like a reasonable idea to me...
>
> Do we have a "SET DEFAULT TABLESPACE"? Can we add one for this release? If
> not, we probably need to go with the ALTER TABLE. Although a SET DEFAULT
> TABLESPACE would be convenent in general.

The problem with ALTER TABLE is that it can be hugely expensive, I think.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Thou shalt check the array bounds of all strings (indeed, all arrays), for
surely where thou typest "foo" someone someday shall type
"supercalifragilisticexpialidocious" (5th Commandment for C programmers)

In response to

Responses

Browse pgsql-cygwin by date

  From Date Subject
Next Message Bruce Momjian 2004-08-20 03:46:09 Re: tablespace and sequences?
Previous Message Philip Warner 2004-08-20 03:26:39 Re: tablespace and sequences?

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2004-08-20 03:46:09 Re: tablespace and sequences?
Previous Message Tom Lane 2004-08-20 03:34:42 Re: postgres uptime

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Bruce Momjian 2004-08-20 03:46:09 Re: tablespace and sequences?
Previous Message Philip Warner 2004-08-20 03:26:39 Re: tablespace and sequences?