Postgres Pro
Downloads
Home   >   mailing lists

Re: Function returns error (view) - Mailing list pgsql-sql

From Colin Wetherbee
Subject Re: Function returns error (view)
Date
Msg-id 47C44023.4080007@denterprises.org
Whole thread Raw
In response to Function returns error (view)  ("Professor Flávio Brito" <prof.flaviobrito@gmail.com>)
Responses Re: Function returns error (view)
List pgsql-sql
Tree view 
Professor Flávio Brito wrote:
> When I Test my view I receive
> 
> SELECT  seach_password('user_login_foo')
[...]
> ERROR: column "user_login_foo" does not exist
> SQL state: 42703
> Context: PL/pgSQL function "search_password" line 14 at for over execute 
> statement

seach_password and
search_password are different.

Perhaps you have two functions with similar names, and one is broken?

Colin

pgsql-sql by date:

Previous
From: "Bart Degryse"
Date:
Subject: Re: duplicate key violates unique constraint
Next
From: "Shavonne Marietta Wijesinghe"
Date:
Subject: Re: duplicate key violates unique constraint