Add this feature for implementing logging in procedure/function.
see http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/autonotransaction_pragma.htm156 votes
Postgres builit-in replication based on WAL replicates all databases in a system.There is no way to limit replication to some databases or tables. It would be really useful if filtering can be done at database or table level. We were forced to go with londiste even after 9.1 upgrade just due to this limitation.28 votes
Allow to create and use multicolumn statistics.
Or to suggests that column values depends on each other, in order to obtain better plans when a query involves conditions on related columns6 votes
I realize that this isn't standard SQL, but it is nicer to read.
It looks like:
INSERT INTO t SET
- Don't see your idea?