Обсуждение: Question
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
Hi Mario, The best place to ask development questions is on pgsql-hackers@postgresql.org. This list is for PostgreSQL advertising. I understand what you mean here, but there are many reasons it will not be changed. Chris Mario Reis wrote: > 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 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
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