Tag Info

New answers tagged

1

It looks like there is no easy to use SQL to query error codes inside Postgres. However, the source does contain the following file: src/backend/utils/errcodes.txt Which has the code listed in an easily parsable format: 01000 W ERRCODE_WARNING warning 0100C W ...


0

If you have access to restart the mysql daemon you can follow the mysql directions for recovering your root account.


2

Found it. You have to declare a continue handler instead of an exit handler. That way even if there is an exception, it goes into the handler and continues with the next record. DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING BEGIN ... Code that handles the exception/warning ... END



Top 50 recent answers are included