Re: Intentionally produce Errors
От | Matthias.Pitzl@izb.de |
---|---|
Тема | Re: Intentionally produce Errors |
Дата | |
Msg-id | 11EC9A592C31034C88965C87AF18C2A70CFC88@m0000s61 обсуждение исходный текст |
Ответ на | Intentionally produce Errors (Markus Schiltknecht <markus@bluegap.ch>) |
Ответы |
Re: Intentionally produce Errors
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: