Skip site navigation (1) Skip section navigation (2)

pg_get_indexdef excludes tablespace info

From: "Steven Flatt" <steven(dot)flatt(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: pg_get_indexdef excludes tablespace info
Date: 2007-11-07 18:49:24
Message-ID: 357fa7590711071049j3f2607d3h5ae9e6d409320e6e@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Postgres 8.2.4.

Would this be considered a bug or is the tablespace info excluded for
a particular reason?

# CREATE TABLESPACE foo_space LOCATION '/some/dir';
# CREATE TABLE foo (a int);
# CREATE INDEX foo_idx ON foo(a) TABLESPACE foo_space;

# SELECT pg_get_indexdef(oid) FROM pg_class WHERE relname = 'foo_idx';
               pg_get_indexdef
---------------------------------------------
 CREATE INDEX foo_idx ON foo USING btree (a)
(1 row)

I would expect a "TABLESPACE foo_space" to be added on to the end of
that.  Haven't checked if other pg_get_* functions are affected, or if
it even applies to them.

Steve

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-11-07 18:49:53
Subject: Re: Test suite fails on alpha architecture
Previous:From: Mathias PalmDate: 2007-11-07 12:15:40
Subject: wrong results at using ltree

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group