Обсуждение: What is alias_list_srl() ?
Hi,
I am running PostgreSQL 7.4.5 and I notice the following 2 sets of error messages generated by the postmaster everything I do a query through my frontend application program (the application executes the same block of codes every time, except the querying criteria is different depending on my input) :
ERROR: relation "serialreg" does not exist
ERROR: syntax error at or near "MODE" at character 10
ERROR: syntax error at or near "MODE" at character 10
and
ERROR: relation "serialreg" does not exist
ERROR: function alias_list_srl() does not exist
ERROR: function alias_list_srl() does not exist
Nothing is crashed and these errors do not seem to affect the query results.
What do these errors mean and how can I correct them ? Do they have any impact on the performance of my queries (I am doing a performance test on a large volume of data) ?
TIA.
Fred
On Thu, 2004-11-25 at 15:00 -0500, Fred Fung wrote:
> I am running PostgreSQL 7.4.5 and I notice the following 2 sets of
> error messages generated by the postmaster everything I do a query
> through my frontend application program
The source of the errors is your frontend application, not PostgreSQL.
> ERROR: relation "serialreg" does not exist
Your application is submitting a query that references a table
("serialreg") that does not exist.
> ERROR: syntax error at or near "MODE" at character 10
Without seeing the query that produces this, it's difficult to say what
the problem is. Try enabling statement logging and reporting the query
that causes the error.
> ERROR: function alias_list_srl() does not exist
Again, your application is trying to invoke a user-defined function that
does not exist, so this is a problem with your application (or your
configuration), not PostgreSQL itself.
-Neil