By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,512 Members | 660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,512 IT Pros & Developers. It's quick & easy.

Returning error message

P: n/a
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
Share this Question
Share on Google+
2 Replies

P: n/a
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

P: n/a
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.