Friday, March 15, 2013

Recent feature requests

In the last few days customers have wanted the following PostgreSQL features:
  • A time zone setting of "system" which will just pick up whatever the system's time zone setting is at server start. This would be useful for appliance  makers who pre-install a database and then ship the appliance to a customer who can change the time zone, as one of our customers does.
  • The ability to set a default tablespace for a schema, and to move all the objects in the schema to that tablespace. This was apparently something that got ripped out in the very late stages of the 8.0 development cycle, but it doesn't seem like a terribly bad idea at first glance.


  1. Hi Mr. Andrew,

    I don't know in which level of discussion was stopped the second feature, but I have interest to working in this feature.

    Do you have more information about that feature?

    Best regards,

    Fabrizio de Royes Mello

  2. Well, it went in at commit a246739 on June 18 2004 and came out at commit 98e8b48 on Nov 5 2004, so to find out what happened you would need to search the archives of the pgsql-hackers mailing list between those 2 dates. I have no recollection of it. You can find the archives on the PostgreSQL web site: see You might be better off downloading the mbox files and using some text search tools rather than trying to find the stuff using the web pages.

  3. In the recent discussion on "general" mailing list I was one of those asking for something like "system" timezone that we need (and had in 8.4) exactly for the reason you describe.
    Was told, it's not going to happen.
    Did anything change since?
    Igor Neyman