Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 977282E0041
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 26 Feb 2008 12:49:08 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 94891-10 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 26 Feb 2008 12:49:03 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5
Received: from wf-out-1314.google.com (wf-out-1314.google.com
 [209.85.200.170])
	by postgresql.org (Postfix) with ESMTP id DCAD82E003D
	for <pgsql-sql@postgresql.org>; Tue, 26 Feb 2008 12:48:45 -0400 (AST)
Received: by wf-out-1314.google.com with SMTP id 28so1399184wff.28
	for <pgsql-sql@postgresql.org>; Tue, 26 Feb 2008 08:48:15 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=kvtaWpHYFNONA7E6/uY4PYkdLDOYrdc3ecXEeOzYfAE=;
	b=vLx+xNrNtkNxjW9zZ/b2VjmNGPQzeUjt0ZEVK+cCNjDZm2IbgPNlg0VgG/dW9CAYX5MQlJvkSqTG2mjBwBiD/aj9oPLnu3NG6glF3KXQ3jQ99m1Zx3/x22URuvRzCk8ZAj2yYgbop72qx8v7YoohxfEnW5GPxglc/YgvlJnBjUI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=MGprLicywVvXP0x+GdcUF2T1+7nSvrrFY+Rz4hQ7zlw7px0KnVnQTjhOEf/jrvFBqpW5YJC3Uui0JgNlr/QqeKdZdVJkQ0v+G8YIQzytLhfMG9Gvl/D21QQOP7DHkdNm4gV93ZR3UayuyD+PPc2G13NG3CkCWtLRBRbpFTgRq5U=
Received: by 10.142.232.20 with SMTP id e20mr3960483wfh.198.1204044494082;
	Tue, 26 Feb 2008 08:48:14 -0800 (PST)
Received: by 10.142.131.13 with HTTP; Tue, 26 Feb 2008 08:48:14 -0800 (PST)
Message-ID: <6a5e3a6f0802260848u5c780346m45059969439c9627@mail.gmail.com>
Date: Tue, 26 Feb 2008 13:48:14 -0300
From: "=?ISO-8859-1?Q?Professor_Fl=E1vio_Brito?=" <prof.flaviobrito@gmail.com>
To: "Colin Wetherbee" <cww@denterprises.org>
Subject: Re: Function returns error (view)
Cc: pgsql-sql@postgresql.org
In-Reply-To: <47C44023.4080007@denterprises.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_3473_18661151.1204044494076"
References: <6a5e3a6f0802260832k9c1375ap632f8adad0740fa2@mail.gmail.com>
	<47C44023.4080007@denterprises.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200802/209
X-Sequence-Number: 30300

------=_Part_3473_18661151.1204044494076
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

 <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@denterprises.org>:
>
> Professor Fl=E1vio 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 execut=
e
> > statement
>
>
> seach_password and
> search_password are different.
>
> Perhaps you have two functions with similar names, and one is broken?
>
>
> Colin
>

------=_Part_3473_18661151.1204044494076
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div><table><tbody><tr><td><a target=3D"_blank" href=3D"www.cecierj.rj.gov.=
br"><span class=3D"siglinkB"></span></a><br></td></tr></tbody></table>Hi Co=
lin<br><br>When I translated from Portuguese to English I forgot a letter, =
but using the corrected name I received an error.<br>
<br></div><br><br><div><span class=3D"gmail_quote">2008/2/26, Colin Wetherb=
ee &lt;<a href=3D"mailto:cww@denterprises.org">cww@denterprises.org</a>&gt;=
:</span><blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid r=
gb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Professor Fl=E1vio Brito wrote:<br> &gt; When I Test my view I receive<br> =
&gt;<br> &gt; SELECT&nbsp;&nbsp;seach_password(&#39;user_login_foo&#39;)<br=
> <br>[...]<br> <br>&gt; ERROR: column &quot;user_login_foo&quot; does not =
exist<br>
 &gt; SQL state: 42703<br> &gt; Context: PL/pgSQL function &quot;search_pas=
sword&quot; line 14 at for over execute<br> &gt; statement<br> <br> <br>sea=
ch_password and<br> search_password are different.<br> <br> Perhaps you hav=
e two functions with similar names, and one is broken?<br>
 <br><br> Colin<br> </blockquote></div><br>

------=_Part_3473_18661151.1204044494076--