Thread: features of PGSQL
Hi, all along we have been using other RDBMSs in NT environment and now we are thinking of Linux But these features we need, Are they available in PG-SQL 1. Log of transactions than can be disassembled into SQL and placed on different media for recovery 2. Replication accross mutli-site file-based 3. Specifying a sub-query in place of a column-name or in place of a table-name (in the from clause) Regards Sanjay Minni nospam_sminni@vsnl.com
[Charset iso-8859-1 unsupported, filtering to ASCII...] > Hi, > > all along we have been using other RDBMSs in NT > environment and now we are thinking of Linux > > But these features we need, Are they available > in PG-SQL > > 1. Log of transactions than can be disassembled > into SQL and placed on different media for recovery In process for 7.1 called WAL. Should 6 months. > > 2. Replication accross mutli-site file-based > Asked for a lot. > 3. Specifying a sub-query in place of a column-name > or in place of a table-name (in the from clause) Column name will be in 7.0, from clause is on TODO list. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
On Thu, 3 Feb 2000, Sanjay Minni wrote: > Hi, > > all along we have been using other RDBMSs in NT > environment and now we are thinking of Linux > > But these features we need, Are they available > in PG-SQL > > 1. Log of transactions than can be disassembled > into SQL and placed on different media for recovery Nope. > > 2. Replication accross mutli-site file-based Nope. > > 3. Specifying a sub-query in place of a column-name > or in place of a table-name (in the from clause) Target list yes, from clause nope. At least item 1 and 3 are slated to be implemented some time, but that won't help you very much right now. :( -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden