Postgres Pro
Downloads
Home   >   mailing lists

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

From Professor Flávio Brito
Subject Re: Function returns error (view)
Date
Msg-id 6a5e3a6f0802260848u5c780346m45059969439c9627@mail.gmail.com
Whole thread Raw
In response to Re: Function returns error (view)  (Colin Wetherbee <cww@denterprises.org>)
List pgsql-sql
Tree view

Hi Colin

When I translated from Portuguese to English I forgot a letter, but using the corrected name I received an error.



2008/2/26, Colin Wetherbee <cww@denterprises.org>:
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: "Shavonne Marietta Wijesinghe"
Date:
Subject: Re: duplicate key violates unique constraint
Next
From: "Bart Degryse"
Date:
Subject: Re: Function returns error (view)