Stephen Frost <[email protected]> writes:
> So you're still looking for an 'OWNED' noise word to be added? Also, I
> did add the ability to specify types of objects (it's often that we'll
> have a "INDEXES" tablespace, so this made sense), so how about:
> ALTER TABLESPACE name MOVE OWNED TO name opt_nowait
> ALTER TABLESPACE name MOVE TABLES OWNED TO name opt_nowait
> ALTER TABLESPACE name MOVE INDEXES OWNED TO name opt_nowait
> ALTER TABLESPACE name MOVE MATERIALIZED VIEWS OWNED TO name opt_nowait
> Removing the 'ALL' entirely?
What if you're a superuser and you want to move everybody's objects
(perhaps in preparation for dropping the tablespace)? I think there's
value in both the ALL and OWNED forms.
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
