Index: FAQ.html
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/FAQ/FAQ.html,v
retrieving revision 1.395
diff -r1.395 FAQ.html
117,118c117,121
<      <A href="#item4.20">4.19</A>) What replication solutions are available?<BR>
<      <A href="#item4.21">4.20</A>) Why are my table and column names not
---
>      <A href="#item4.19">4.19</A>) Why do I get "relation with OID #####
>     does not exist" errors when accessing temporary tables in PL/PgSQL
>     functions?<BR>
>      <A href="#item4.20">4.20</A>) What replication solutions are available?<BR>
>      <A href="#item4.21">4.21</A>) Why are my table and column names no
1044c1047,1061
<     <H3 id="item4.19">4.19) What replication solutions are available?
---
>     <H3 id="item4.19">4.19) Why do I get "relation with OID #####
>     does not exist" errors when accessing temporary tables in PL/PgSQL
>     functions?</H3>
> 
>     <P>PL/PgSQL caches function scripts, and an unfortunate side effect
>     is that if a PL/PgSQL function accesses a temporary table, and that
>     table is later dropped and recreated, and the function called again,
>     the function will fail because the cached function contents still
>     point to the old temporary table. The solution is to use
>     <SMALL>EXECUTE</SMALL> for temporary table access in PL/PgSQL. This
>     will cause the query to be reparsed every time.</P>
> 
>     <P>This problem has been resolved in PostgreSQL 8.3.</P>
> 
>     <H3 id="item4.20">4.20) What replication solutions are available?
1066c1083
<     <H3 id="item4.20">4.20) Why are my table and column names not
---
>     <H3 id="item4.21">4.21) Why are my table and column names not