Обсуждение: pg_aclcheck error?

I'm using postgres 7.0.2 on the backend to do a problem logging db, with JSP
and Apache Jserv from Web pages to enter data via JDBC connection.

I've set up a unique serial id so that a user gets a ticket number
auto-generated.

When they hit submit, it should log data into db, but right noow I get the
following:

ERROR: pg_aclcheck: class "problem_seq_incident" not found.

can anyone tell me what the pg_aclcheck is doing?

My sequence is setup in the db config as problem_incident_seq, and also in
the java code for the bean that connects to the db, so i'm a bit curious on
this..

Any ideas appreciated..





_______________________________________________________
Say Bye to Slow Internet!
http://www.home.com/xinbox/signup.html

Jan Mlotkiewicz <jmlotk@excite.com> writes:
> ERROR: pg_aclcheck: class "problem_seq_incident" not found.                            ^^^^^^^^^^^^^^^^^^^^

> My sequence is setup in the db config as problem_incident_seq,
^^^^^^^^^^^^^^^^^^^^

Is that just a typo in your message, or does it suggest that you didn't
spell the sequence name the same everywhere?

It looks like the sequence functions (nextval() etc) start out with
a permissions check, so if you call them on a nonexistent sequence name
the above complaint is what you'd get.
        regards, tom lane