| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> |
| Cc: | PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: tablespace and sequences? |
| Date: | 2004-08-17 15:47:22 |
| Message-ID: | 5002.1092757642@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-cygwin pgsql-hackers pgsql-hackers-win32 |
Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> writes:
> (1) the "CREATE SEQUENCE foo TABLESPACE disk2" syntax does not seem
> to be implemented.
This is intentional. Sequences are not large enough to need to be
pushed around among multiple tablespaces. Also, if we did allow
sequences to be associated with tablespaces, we'd be precluding other
implementation changes that are on the wish-list (such as storing all
sequences in a single system table, instead of needing a separate disk
file for each one).
The original patch actually had support for specifying a tablespace for
a sequence. That was deliberately removed, and it's not going to go
back in later.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2004-08-17 16:17:52 | Re: tablespace and sequences? |
| Previous Message | Fabien COELHO | 2004-08-17 15:40:13 | Re: tablespace and sequences? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-08-17 15:58:48 | Re: LDFLAGS vs. shared libraries |
| Previous Message | Fabien COELHO | 2004-08-17 15:40:13 | Re: tablespace and sequences? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2004-08-17 16:17:52 | Re: tablespace and sequences? |
| Previous Message | Fabien COELHO | 2004-08-17 15:40:13 | Re: tablespace and sequences? |