Обсуждение: 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