| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | nikhil raj <nikhilraj474(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Getting a error on creating a partition table index 12.2. |
| Date: | 2020-03-05 20:14:32 |
| Message-ID: | 20200305201432.GA9964@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2020-Mar-05, Adrian Klaver wrote:
> The OP was wondering why it worked in 12.1 and not 12.2?
>
> I could not see any obvious reason for that, so:
>
> 1) There is a not obvious reason
>
> 2) It did not work in 12.1 either.
(2) is correct.
55469 12.1 9913=# show server_version;
server_version
────────────────
12.1
(1 fila)
55469 12.1 9913=# create index on p (a) tablespace pg_default;
ERROR: cannot specify default tablespace for partitioned relations
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rory Campbell-Lange | 2020-03-05 20:52:38 | Re: Advice request : simultaneous function/data updates on many databases |
| Previous Message | Adrian Klaver | 2020-03-05 19:37:06 | Re: Getting a error on creating a partition table index 12.2. |