Hi, I'd like to propose the ability to create temporary schemas.
Unlike temporary tables, this feature would enable developers to create a temporary schema once and execute CREATE TABLE statements without the TEMPORARY parameter. This would facilitate running unit tests, where developers would like to run the same creation script for unit tests and production code but do not wish to parameterize each CREATE TABLE statement (both environments are expected to execute identical scripts). It further enables the use of temporary functions, something which is not possible today (apparently you can hack this too, but there isn't an "official" way of doing so). See http://dba.stackexchange.com/q/76494/4719 for a related discussion. Should I move this discussion to a different mailing list or is this the correct location? Thanks, Gili -- View this message in context: http://postgresql.1045698.n5.nabble.com/Feature-request-temporary-schemas-tp5819001.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
