Returning error message - PostgreSQL Database

Michael Dean

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

Subscribe Post Reply

2930

rstp

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

Sean Utt

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

Similar topics

void function returning value?

by: Jochen Zeischka | last post by:

I'm puzzled. When compiling this: template<class ValRes, class Val1, class Val2> Veld<ValRes>& mult(Veld<ValRes>& res, const Veld<Val1>& v1, const Veld<Val2>& v2) { // something return res; }...

C / C++

Returning const objects?

by: Derek | last post by:

Some authors advocate returning const objects: const Point operator+(const Point&, const Point&); ^^^^^ Returning a const object prevents some bad code from compiling: Point a, b, c; (a +...

C / C++

Help, getting compiler error warning on returning a temporary character string

by: jt | last post by:

I'm getting a compiler error: warning C4172: returning address of local variable or temporary Here is the function that I have giving this error: I'm returning a temporary char string and its...

C / C++

Can't solve this CallBack returning structures

by: MyAlias | last post by:

Can't solve this CallBack returning structures Error message: An unhandled exception of type 'System.NullReferenceException' occurred in MyTest.exe Additional information: Object reference not...

Visual Basic .NET

Returning multiple values (but one row) in plpgsql

by: Karl O. Pinc | last post by:

I want to return multiple values, but not a set, only a single row, from a plpgsql function and I can't seem to get it to work. (I suppose I'd be happy to return a set, but I can't seem to make...

PostgreSQL Database

Problem with webservice returning an array (You must implement a default accessor on System.Array because it inherits from ICollection. )??

by: Stacey Levine | last post by:

I have a webservice that I wanted to return an ArrayList..Well the service compiles and runs when I have the output defined as ArrayList, but the WSDL defines the output as an Object so I was...

.NET Framework

Asking again: Implementing interface, returning subclass

by: David Thielen | last post by:

Hi; I am writing a class that implements IDbConnection. The i/f defines a method BeginTransaction() that returns an IDbTransaction. I want to define this as returning a DbTransaction (as...

C# / C Sharp

returning error from main()

by: junky_fellow | last post by:

Guys, If main() calls some function func() and that function returns the error (errno), then does it make sense to return that value (errno) from main. (in case main can't proceed further) ? ...

C / C++

returning a string from an ostringstream

by: Thomas Lenz | last post by:

Please consider the following code snippet: string myfunction() { ostringstream oss; oss << "junk"; // do something more with oss; I can't make it const... return oss.str(); } Is the...

C / C++

Returning error message from Classes

by: FutureShock | last post by:

I am using a registration class to process a registration form and need some opinions on returning error messages. I am self referring the page on submit. I would like to send each form field...

PHP

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

Access Europe meeting on Wed 4 Oct - The future of Access

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to find best mobile app development company in usa

by: Aliciasmith | last post by:

In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...

Mobile Development

Can faster file sharing be achieved by connecting computers simultaneously via WiFi and LAN cables

by: tracyyun | last post by:

Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...

Networking - Hardware / Configuration

Energy Model code modification to account for year dependent interest rate

by: giovanniandrean | last post by:

The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...

Python

Send Current Object to PDF

by: NeoPa | last post by:

Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...

Microsoft Access / VBA

VBA Class Basics

by: NeoPa | last post by:

Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...

Microsoft Access / VBA

VBA Class Basics (Report Class)

by: NeoPa | last post by:

Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...

Microsoft Access / VBA

Take a Database to the Next Level

by: GKJR | last post by:

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

Microsoft Access / VBA