Re: problems selecting from altered table

From: Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problems selecting from altered table
Date: 2007-06-19 15:35:39
Message-ID: 4677F7CB.2090306@zg.htnet.hr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill Moran wrote:
> Have you tried altering the table, then disconnect and reconnect, then run
> your stored procedure?
>
> If that works, then the problem has to do with OID caching, which is known.
>
>
Yes, I even tried restarting postgres, but nothing helped.

Regards,
Rikard

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Noah Heusser 2007-06-19 15:55:30 Re: Dynamic Log tigger (plpgsql)
Previous Message Merlin Moncure 2007-06-19 15:24:29 Re: Subquery problems