Postgres
 

I am trying to make a procedure call to a Postgres database and it keeps
giving me an invalid comment.

if I pass "SELECT * FROM TheTable" it works just fine

if I pass "EXEC GetTheRecords" which just does that same select...it bombs

any ideas?

Postgres
 

is the security level of the stored procedure correct?


"Richard Douglass" wrote in message
...
I am trying to make a procedure call to a Postgres database and it keeps
giving me an invalid comment.

if I pass "SELECT * FROM TheTable" it works just fine

if I pass "EXEC GetTheRecords" which just does that same select...it
bombs

any ideas?

Postgres
 

It was compiled using the DBA account.

I am not entirely sure though.

"Patrick Molloy" wrote in message
...
is the security level of the stored procedure correct?


"Richard Douglass" wrote in message
...
I am trying to make a procedure call to a Postgres database and it keeps
giving me an invalid comment.

if I pass "SELECT * FROM TheTable" it works just fine

if I pass "EXEC GetTheRecords" which just does that same select...it
bombs

any ideas?