pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedSome needed features in postgresql
5+ messages / 4 participants
[nested] [flat]
* Some needed features in postgresql
@ 1999-04-30 23:37 Peter Garner <peter_garner@yahoo.com>
0 siblings, 2 replies; 5+ messages in thread
From: Peter Garner @ 1999-04-30 23:37 UTC (permalink / raw)
To: pgsql-interfaces@hub.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Some needed features in postgresql
@ 1999-05-01 16:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Peter Garner <peter_garner@yahoo.com>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 1999-05-01 16:18 UTC (permalink / raw)
To: Peter Garner <peter_garner@yahoo.com>; +Cc: pgsql-interfaces@hub.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Some needed features in postgresql
@ 1999-05-02 11:28 Michael Meskes <meskes@postgreSQL.org>
parent: Peter Garner <peter_garner@yahoo.com>
1 sibling, 1 reply; 5+ messages in thread
From: Michael Meskes @ 1999-05-02 11:28 UTC (permalink / raw)
To: Peter Garner <peter_garner@yahoo.com>; +Cc: pgsql-interfaces@hub.org
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!
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Some needed features in postgresql
@ 1999-05-03 06:35 Hannu Krosing <hannu@trust.ee>
parent: Michael Meskes <meskes@postgreSQL.org>
0 siblings, 0 replies; 5+ messages in thread
From: Hannu Krosing @ 1999-05-03 06:35 UTC (permalink / raw)
To: Michael Meskes <meskes@postgreSQL.org>; +Cc: Peter Garner <peter_garner@yahoo.com>; pgsql-interfaces@hub.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [INTERFACES] Some needed features in postgresql
@ 1999-05-03 08:26 Peter Garner <peter_garner@yahoo.com>
0 siblings, 0 replies; 5+ messages in thread
From: Peter Garner @ 1999-05-03 08:26 UTC (permalink / raw)
To: Hannu Krosing <hannu@trust.ee>; Michael Meskes <meskes@postgreSQL.org>; +Cc: Peter Garner <peter_garner@yahoo.com>; pgsql-interfaces@hub.org
>> 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
yes, I have, :-) The problem is certain errors do not
mean the whole action should be aborted or that the
transaction invalidated. E.g. I believe the Default
config for DB2 is that an error has NO effect on the
transaction state. It would be nice to have that as
at least an option in Postgres! :-)
> But _nested_ transactions would still be nice .
Yes they would Hannu! :-)
===
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1999-05-03 08:26 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-04-30 23:37 Some needed features in postgresql Peter Garner <peter_garner@yahoo.com>
1999-05-01 16:18 ` Tom Lane <tgl@sss.pgh.pa.us>
1999-05-02 11:28 ` Michael Meskes <meskes@postgreSQL.org>
1999-05-03 06:35 ` Hannu Krosing <hannu@trust.ee>
1999-05-03 08:26 Re: [INTERFACES] Some needed features in postgresql Peter Garner <peter_garner@yahoo.com>
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