Обсуждение: Some needed features in postgresql
Hi All! Please accept my apologies if this should have gone to the hackers list. But I have a few questions regarding features in postgres 1. Does postgres support the minus operator. It does not seem that I can query : select text_field from table_1 minus select text_field from table_2 2. Is there any work being done on the fact that transactions are aborted when an error occurs? It really lessens the usefulness of the product when, after adding 20,000 records, the transaction aborts because the 20,001th record is a dup key! :-) === Peace, Peter We are Microsoft of Borg, you will be assimilated!!! Resistance is fut... ***BZZZRT*** THUD!!! [General Protection Fault in MSBorg32.DLL] Please contact the vendor of this Borg for more information _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
Peter Garner <peter_garner@yahoo.com> writes: > 1. Does postgres support the minus operator. It does > not seem that I can query : > select text_field from table_1 > minus > select text_field from table_2 The standard-approved spelling is "EXCEPT", and support for it is new in 6.5. It could probably use some more beta testing, so please try it... > 2. Is there any work being done on the fact that > transactions are aborted when an error occurs? It > really lessens the usefulness of the product when, > after adding 20,000 records, the transaction aborts > because the 20,001th record is a dup key! :-) I've griped about that myself in the past, but it's not real clear how else it ought to work. Maybe you should be using smaller transactions ;-) > Please accept my apologies if this should have gone > to the hackers list. I'd say the pgsql-sql list would be the best place for this kind of question. It's off-topic for the interfaces list, for certain. regards, tom lane
On Fri, Apr 30, 1999 at 04:37:24PM -0700, Peter Garner wrote: > 2. Is there any work being done on the fact that > transactions are aborted when an error occurs? It > really lessens the usefulness of the product when, > after adding 20,000 records, the transaction aborts > because the 20,001th record is a dup key! :-) But this is exactly what a transaction is supposed to do. You should only make those commands inside one transaction that logically belong to each other or in other words, that you consider one action. michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael.Meskes@gmx.net | Use PostgreSQL!
Michael Meskes wrote: > > On Fri, Apr 30, 1999 at 04:37:24PM -0700, Peter Garner wrote: > > 2. Is there any work being done on the fact that > > transactions are aborted when an error occurs? It > > really lessens the usefulness of the product when, > > after adding 20,000 records, the transaction aborts > > because the 20,001th record is a dup key! :-) > > But this is exactly what a transaction is supposed to do. You should only > make those commands inside one transaction that logically belong to each > other or in other words, that you consider one action. But _nested_ transactions would still be nice . --------- Hannu