| From: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: tablespace and sequences? |
| Date: | 2004-08-19 07:35:36 |
| Message-ID: | Pine.LNX.4.58.0408190927160.31684@sablons.cri.ensmp.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cygwin pgsql-hackers pgsql-hackers-win32 |
> > If the location doesn't exist will postgresql try to create it? istm
> > it could do this and if it fails then you are no worse off, but if it
> > were to succeed you're that much better off.
>
> Yea, I assume if you can't create the tablespace you put everything for
> that tablespace in the default tablespace.
If your talking about a restoration, the answer is NO.
It just fails, because on "CREATE TABLE foo ... TABLESPACE bla" the table
will not be created if tablespace bla does not exists, and so the
restoration will fail.
This is the current situation, and that's why I'm arguing in the void;-)
--
Fabien Coelho - coelho(at)cri(dot)ensmp(dot)fr
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2004-08-19 07:40:04 | Re: tablespace and sequences? |
| Previous Message | Bruce Momjian | 2004-08-19 04:41:39 | Re: tablespace and sequences? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chinni | 2004-08-19 07:39:20 | tablespace |
| Previous Message | Magnus Hagander | 2004-08-19 06:49:16 | Re: Open items |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2004-08-19 07:40:04 | Re: tablespace and sequences? |
| Previous Message | Bruce Momjian | 2004-08-19 04:41:39 | Re: tablespace and sequences? |