Re: Question

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Mario Reis" <m(dot)reis(at)bca(dot)pt>
Cc: <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: Question
Date: 2005-04-04 00:12:06
Message-ID: 200504031712.06796.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy

Mario,

>         Well, i strongly beleave this isn't the best way of doing it. It
> should Raise an Exception for all the input
> fields or failures at the same time, joinning all the errors after an
> insert or update instruction and display/notify
> them at once. This way it w'll save time and resouces communications
> special in a large network with a large
> number of users. Sorry if i got it wrong. I also appologise if this isn't
> the right plece to put this question but
> i don't know where else puting it.

Actually, it wouldn't save database resources at all. What if you're doing
an improper database update to 100,000 rows? Do you really want the system
to test all 100,000 rows before returning an error?

Anyway, Chris is right, this isn't the right list for this question. Try
pgsql-general or pgsql-sql.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

  • Question at 2005-03-29 10:21:53 from Mario Reis

Browse pgsql-advocacy by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-04-05 03:02:21 Open source databases article
Previous Message Bruno Wolff III 2005-04-03 12:14:52 Re: [NOVICE] Function which gives back the