Syntax Error near SQLSTATE

Question

I got a plpgsql function here to indicate if any warning raised during ANALYZE:

CREATE OR REPLACE FUNCTION analyzeWarning() RETURNS integer AS $$
DECLARE
  warningRaised int;
BEGIN
  warningRaised := 0;
  FOR i IN 1..10
  LOOP
    BEGIN
      ANALYZE;
    EXCEPTION
      WHEN SQLSTATE '01000' THEN return 1;
    END;
  END LOOP;
  RETURN 0;
END;
$$ LANGUAGE plpgsql;

This function kept giving me syntax error near:

ERROR:  syntax error at or near "SQLSTATE"
LINE 11:           WHEN SQLSTATE '01000' THEN return 1;

I am not sure where I missed the syntax error.

My postgres build is 8.2.15.

Pavel Stehule · Accepted Answer · 2015-10-14 04:33:24Z

2

PostgreSQL 8.2.15 is pretty old unsupported release. This release doesn't support SQLSTATE constant there.

But your code should not to work on any PostgreSQL release. You cannot to trap warnings or notices in PostgreSQL. Only exceptions are trappable.

answered Oct 14, 2015 at 4:33

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax Error near SQLSTATE

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related