Re: why doesn't this work?

* Ashley Clark in "[GENERAL] why doesn't this work?" dated 2000/12/09
* 18:37 wrote:

> Conceptually I don't understand why this doesn't work.
>
> from the psql prompt:

I have an even simpler example now:
plumbing=# begin;
BEGIN
plumbing=# insert into subdivs (code, name) values
plumbing-# ('VG', 'Village Grove');
INSERT 215717 1
plumbing=# delete from subdivs where code='VG';
ERROR: triggered data change violation on relation "subdivs"
plumbing=# abort;
ROLLBACK
plumbing=# \d subdivs
Table "subdivs"
Attribute | Type | Modifier
-----------+----------+----------
code | char(10) | not null
name | char(35) | not null
Indices: subdivs_name_key,
subdivs_pkey

But I've found another quirk... I have a set of functions that insert
and delete rows in a table (while maintaining a tree structure), these
work fine in a transaction but doing the same combination of steps in a
transaction by hand doesn't work. What's going on here?

I can provide any information needed to figure this out.

--
shaky cellar