Re: Function returns error (view)

From: Colin Wetherbee <cww(at)denterprises(dot)org>
To: Professor Flávio Brito <prof(dot)flaviobrito(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Function returns error (view)
Date: 2008-02-26 16:36:51
Message-ID: 47C44023.4080007@denterprises.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Professor Flávio Brito 2008-02-26 16:48:14 Re: Function returns error (view)
Previous Message Shavonne Marietta Wijesinghe 2008-02-26 16:36:09 Re: duplicate key violates unique constraint