Question:
When I try to create a new entry information field, I receive the error message: “ERROR: function usp_getautonm(unknown) does not exist; Error while executing query”. I am using a PostgreSQL connected database.
Answer:
BioNumerics by default makes use of of so-called “stored procedures” for auto-numbering of database objects, such as entries, entry information fields, attachments, etc. This ensures consistent numbering in supported database management systems such as SQL Server, Oracle and MySQL. However, in Postgres these stored procedures do not work. To connect a PostgreSQL relational database with BioNumerics, the option Do not use stored procedures in the database settings should be checked.
Package(s):
BIONUMERICS
Applicable for:
Version 6.0 - 8.1