In PL/pgSQL you could use the RAISE command: http://www.postgresql.org/docs/8.1/interactive/plpgsql-errors-and-messages.h tml
Best regards, Matthias > -----Original Message----- > > Hi, > > this is sort of a silly question, but: what's the proper way to > intentionally generate an error? I'm writing tests for > pyPgSQL and want > to check it's error handling. Currently, I'm using: > > SELECT "THIS PRODUCES AN SQL ERROR"; > > Is there any better way to generate errors? Probably even generating > specific errors given? > > Regards > > Markus > > ---------------------------(end of > broadcast)--------------------------- > TIP 6: explain analyze is your friend > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
