| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: tablespace and sequences? |
| Date: | 2004-08-18 08:39:40 |
| Message-ID: | 412315CC.1030006@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cygwin pgsql-hackers pgsql-hackers-win32 |
> shell> pg_dump coelho | grep TABLESPACE
> CREATE SCHEMA test AUTHORIZATION coelho TABLESPACE test;
>
> "TABLESPACE" appears in a basic pg_dump SQL output. If the test tablespace
> does not exist, the command will fail, and so my whole restoration.
>
> Thus I still stick to my opinion;-)
Your complaint was that you need a way of continuing a restore if the
_tablespace_ cannot be created. ie. If the directory does not exist.
If you have objects in a tablespace, then too bad. It's no different to
if the schema the object in doesn't exist. Or the table the data is in
doesn't exist. Or the functin the view references doesn't exist.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2004-08-18 09:03:32 | Re: tablespace and sequences? |
| Previous Message | Fabien COELHO | 2004-08-18 08:24:37 | Re: tablespace and sequences? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2004-08-18 09:03:32 | Re: tablespace and sequences? |
| Previous Message | Fabien COELHO | 2004-08-18 08:24:37 | Re: tablespace and sequences? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2004-08-18 09:03:32 | Re: tablespace and sequences? |
| Previous Message | Eric Rosenquist | 2004-08-18 08:37:31 | Re: psql reading from stdin |