Skip site navigation (1) Skip section navigation (2)

Raise Exception

From: "Mario Reis" <m(dot)reis(at)bca(dot)pt>
To: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Raise Exception
Date: 2005-04-04 09:24:17
Message-ID: 004401c538f8$13b856e0$45111f0a@bca.pt (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
  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 each
record"
 For example, for each invalid foreing key, it automaticly raises an
exception.If you
have a large file 20fields to validate before insert the validates each on
at a time and
raises an exception for each falure.
 As far as i understand it should join all  the validities from each field
record and latter
 display/notify, all them at once, joinning all the errors after an insert
or update instruction
 for each record of course.
 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 place 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

Responses

pgsql-hackers by date

Next:From: Marco ColomboDate: 2005-04-04 09:26:33
Subject: Re: [HACKERS] plPHP in core?
Previous:From: Teodor SigaevDate: 2005-04-04 07:15:52
Subject: Re: TSearch2 performance issue?

pgsql-general by date

Next:From: Marco ColomboDate: 2005-04-04 09:26:33
Subject: Re: [HACKERS] plPHP in core?
Previous:From: pckDate: 2005-04-04 09:14:24
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group