Simon Riggs wrote: > What I would like is a parameter called sql_compatibility which has > settings such as 8.3, 8.4 etc.. By default it would have the value 8.4, > but for people that want to upgrade *without* retesting their > application, they could set it to 8.3.
I think down this route lies code readability and maintenability madness. Right now, the optimizer and executor code is already a very complex beast. We don't need to make it more difficult to understand and improve. Besides, the guys not updating their applications would not be benefitted by the upgrade if they kept the compatibility with the older version, so why would they upgrade? -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers