What is alias_list_srl() ?

Started by Fred Fungover 21 years ago2 messagesgeneral
Jump to latest
#1Fred Fung
fred.fung@versaterm.com

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

and

ERROR: relation "serialreg" 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

#2Neil Conway
neilc@samurai.com
In reply to: Fred Fung (#1)
Re: What is alias_list_srl() ?

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