Re: [INTERFACES] Some needed features in postgresql

Peter Garner <peter_garner(at)yahoo(dot)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