Re: Error: column "host" does not exist

Please post is possible the code (DDL and function).
Otherwise it'd be much more difficult.
And if you change the names, please check whether the error is still there.

--
Fahrbahn ist ein graues Band
weisse Streifen, grüner Rand

On Thursday 08 January 2009 09:15:05 Mayuresh Nirhali wrote:
> No. there are no name clashes.
>
> I actually changed the names in posted text a bit. The arguments,
> declared variables and column names, all have their unique prefixes.
>
> Thanks
> Mayuresh
>
> Reg Me Please wrote:
> > IS there any name clash with a function argument?
> >
> > --
> > Fahrbahn ist ein graues Band
> > weisse Streifen, grüner Rand
> >
> > On Thursday 08 January 2009 08:30:07 Mayuresh Nirhali wrote:
> >> Hello,
> >>
> >> I am working with 8.1.4 pgsql as my database backend. I have a function
> >> written in plpgsql language, that queries a particular table as below,
> >>
> >> select host from table_host where ip_address = ip_array[i] and port =
> >> port_array[i];
> >>
> >> The query is running in a for loop. I see ip_array and port_array
> >> getting populated with correct values during the execution.
> >> The error I see is,
> >>
> >> ERROR: column "host" does not exist
> >> CONTEXT: SQL statement "SELECT host"
> >> PL/pgSQL function "sp_get_ip_data" line 286 at raise
> >>
> >> throu psql, I can select the table_host fine.
> >> column "host" is a primary key here.
> >>
> >> I dont understand why I see the "column does not exist" error; any idea
> >> ?
> >>
> >> cheers
> >> Mayuresh