I didnt no the thread would become a postgresVSoracle thing. I just lost
couple of thousand rows and could not retrieve them back, so i wanted to
know if postgres had some way to get it back. Iam just a few days
expereinced in postgres hence iam still discovering its features.
No intention of compa
Hi all
This is a very basic question.can we roll back data after we run a
query.
I know that a delete within a transaction can be rolled back. But how about
independent delete queries???
If i ran a delete statement and lost data...how do i recover. I know that
oracle has this provision of r
exclude the records that can cause
integrity constraint errors.
I was wondering if there was a better way of doing this.
Thanks
Sam
On 6/6/08, Craig Ringer <[EMAIL PROTECTED]> wrote:
> samantha mahindrakar wrote:
> > Hi
> > Iam trying to insert records into a table..
Hi
Iam trying to insert records into a table..when an integrity
constarint violation occurs the exception is caughtbut i dont
want the whole thing to be rolled back or stopped because of one
exception. The insert statement is as follows:
'INSERT INTO '||imputation_table||'
%',FOUND;
END IF;
--Update the detector health data
EXECUTE 'INSERT into lane_detector_health (lane_id,
measurement_start,detector_status)
values('||lane||','''||measurement_start||''','||health||')';
I tried getting the output of the execute statements by printing the
FOUND variable. It is returning the value as false.
However i used PEFORM instead of EXECUTE for the update statement. It
On 6/3/08, samantha mahindrakar <[EMAIL PROTECTED]> wrote:
> Hi
> Iam facing a strange iss
Hi
Iam facing a strange issue
One of the functions in my program is running an update statement. The
statement is running cross-schema. What i mean is that the program
resides in one schema where as it updates a table from another schema.
How ever these scehmas are on the same database.
The
