Re: Function returns error (view)

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

<www.cecierj.rj.gov.br>
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(at)denterprises(dot)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
>

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2008-02-26 16:59:57 Re: Function returns error (view)
Previous Message Colin Wetherbee 2008-02-26 16:36:51 Re: Function returns error (view)