Re: [BUGS] pg_get_indexdef excludes tablespace info

2007-11-07 Thread Tom Lane
"Steven Flatt" <[EMAIL PROTECTED]> writes: > Would this be considered a bug or is the tablespace info excluded for > a particular reason? It's intentional: pg_dump doesn't want it there. In a pg_dump script we want to do set default_tablespace = foo_space; create index foo_idx o

[BUGS] pg_get_indexdef excludes tablespace info

2007-11-07 Thread Steven Flatt
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 reln