Andrus Moor wrote:
---
If nexval() call is prefixed with schema name
NEW.dokumnr = nextval('demo.'||TG_RELNAME || '_'|| NEW.doktyyp ||'_seq');
error does not occur.
Is this PgAdmin bug ?
Obviously not. See pgsql docs for nextval, further support in
pgsql-novice or pgsql-sql
I need to create trigger which does not depend on schema name but this does
not work when adding rows from pgadmin.
To reproduce:
1. Run the code
2. Open dok table in pgAdmin grid for editing.
3. Add new row. Enter g to doktyyp column. Try to save added row.
Observed result:
-
