From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Garner <peter_garner@yahoo.com>
Cc: pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Some needed features in postgresql
Date: Sat, 01 May 1999 12:18:04 -0400
Message-ID: <1464.925575484@sss.pgh.pa.us> (raw)
In-Reply-To: <19990430233724.1105.rocketmail@web216.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: tgl@sss.pgh.pa.us, peter_garner@yahoo.com, pgsql-interfaces@hub.org
Subject: Re: [INTERFACES] Some needed features in postgresql
In-Reply-To: <1464.925575484@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox