Question - Mailing list pgsql-advocacy

From Mario Reis
Subject Question
Date
Msg-id 001001c53449$2218e140$45111f0a@bca.pt
Whole thread Raw
Responses Re: Question  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: Question  (Josh Berkus <josh@agliodbs.com>)
List pgsql-advocacy
   Dear Sir,

    I' ve recently join to PostGreSql community. I'm testing it on a local
network and I'm very found of it .
However there are a few things that I'd like to understand better.

    As far as i realise, every time the Server validates a wrong value for an
input it Raises an Exception
with the check failure for each input. For example, for each invalid foreing
key, it automaticly raises an exception.
The same happens validity checks and so on.

    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.

    I hope you w'll understand what i mean. Sorry for my poor english.

Thanks any way

Mário




pgsql-advocacy by date:

Previous
From: "John Hansen"
Date:
Subject: Re: [pgsql-www] PG Graphics are up.
Next
From: "Virgile Beddok"
Date:
Subject: Re: [NOVICE] Function which gives back the