470,614 Members | 1,454 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

Returning error message

I am writing an application that inserts into a PostgreSQL database, but I
would like to know whenever a rollback occurs, whether there is an error
relating to referential integrity, etc., so that my client software will
know. I am using RealBasic as the front end development. Any suggestions
how to get Postgre to return these messages? Presently the app works well
but Postgre does not complain, etc. and just enforces the rules.

Jul 19 '05 #1
2 2808
Check out the syslog settings in postgresql.conf at
http://www.varlena.com/varlena/Gener...ed_conf_e.html
hth
Ron

Michael Dean wrote:
I am writing an application that inserts into a PostgreSQL database, but I
would like to know whenever a rollback occurs, whether there is an error
relating to referential integrity, etc., so that my client software will
know. I am using RealBasic as the front end development. Any suggestions
how to get Postgre to return these messages? Presently the app works well
but Postgre does not complain, etc. and just enforces the rules.


Jul 19 '05 #2
This sounds like the application (or driver?) ignoring the error message to
me. I've been using Access 97, php, perl and jdbc to access PostgreSQL and
can always trap the error that is returned. (usually whether I wanted to or
not :-) I've written some triggers to catch overlapping appointments that
return formatted html table text suitable for inserting into a web page when
an overlap is detected as well. Might be time to check with some other
RealBasic users?

Sean

Web Solutions That Work Developing custom web solutions designed
specifically to accomplish the unique objectives of our clients. Phone
503-639-2727 Fax 503-639-0807
"Michael Dean" <md*****@earthlink.net> wrote in message
news:BB485365.67C7%md*****@earthlink.net...
I am writing an application that inserts into a PostgreSQL database, but I
would like to know whenever a rollback occurs, whether there is an error
relating to referential integrity, etc., so that my client software will
know. I am using RealBasic as the front end development. Any suggestions
how to get Postgre to return these messages? Presently the app works well
but Postgre does not complain, etc. and just enforces the rules.

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Jochen Zeischka | last post: by
8 posts views Thread by Derek | last post: by
70 posts views Thread by junky_fellow | last post: by
7 posts views Thread by Thomas Lenz | last post: by
2 posts views Thread by FutureShock | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.