diff options
| author | Marko Kreen | 2011-01-10 14:27:03 +0000 |
|---|---|---|
| committer | Marko Kreen | 2011-01-10 14:33:42 +0000 |
| commit | 1bf1fd4c2aaffad69abe888fd610353e6243ec8c (patch) | |
| tree | 8128ea339245e3382db016f3ae0c5d97ef325ae9 /sql/pgq/expected | |
| parent | 2a15fd367eaf78150420ad72bdcdd2292dbe1eb6 (diff) | |
pgq/triggers: disallow primary key updates
Diffstat (limited to 'sql/pgq/expected')
| -rw-r--r-- | sql/pgq/expected/logutriga.out | 6 | ||||
| -rw-r--r-- | sql/pgq/expected/sqltriga.out | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/sql/pgq/expected/logutriga.out b/sql/pgq/expected/logutriga.out index b3c1fd71..795618cb 100644 --- a/sql/pgq/expected/logutriga.out +++ b/sql/pgq/expected/logutriga.out @@ -166,3 +166,9 @@ insert into deny_test values ('1', '2'); ERROR: Table 'public.deny_test' to queue 'noqueue': change not allowed (I) truncate deny_test; ERROR: Table 'public.deny_test' to queue 'noqueue': change not allowed (R) +-- test pk update +insert into udata (id, txt) values (1, 'txt'); +NOTICE: insert_event(udata_que, I:id, id=1&txt=txt, public.udata) +CONTEXT: SQL statement "select pgq.insert_event($1, $2, $3, $4, $5, $6, $7)" +update udata set id = 2; +ERROR: primary key update not allowed diff --git a/sql/pgq/expected/sqltriga.out b/sql/pgq/expected/sqltriga.out index 81400511..6747a503 100644 --- a/sql/pgq/expected/sqltriga.out +++ b/sql/pgq/expected/sqltriga.out @@ -147,3 +147,9 @@ for each statement execute procedure pgq.sqltriga('que3'); truncate custom_expr; NOTICE: insert_event(que3, R, , public.custom_expr) CONTEXT: SQL statement "select pgq.insert_event($1, $2, $3, $4, $5, $6, $7)" +-- test pk update +insert into rtest values (1, 'value1'); +NOTICE: insert_event(que3, I, (id,dat,dat2) values ('1','value1',null), public.rtest) +CONTEXT: SQL statement "select pgq.insert_event($1, $2, $3, $4, $5, $6, $7)" +update rtest set id = 2; +ERROR: primary key update not allowed |