Rainer - sorry for the late reply, I haven't been at work for a few days!
Yeah, we've seen this happen before (on an old 6.3.2 database). At first
I just noticed the view wasn't working and re-ran our 'create view' script
against the database. This fixed the view but had a knock-on effect and
screwed up another view (actually the next view when listing tables etc.
in the database using '\d')! It wasn't until I did a table listing that I
noticed that Postgres was listing the view as a table and - as you did - I
dropped the view as a table, then rebuilt it from our 'create view' script
and everything was OK. Never did find out why though?!! As you say, it
does smell like a bug.
Paul M. Breen, Software Engineer - Computer Park Ltd.
Tel: (01536) 417155
Email: pbreen@computerpark.co.uk
On Tue, 21 Nov 2000, Rainer Mager wrote:
> Hi all,
>
> We've run into an odd problem here. We had a db that we upgraded to PG7
> without problems. We then dumped that db via pgdump and restored it to a
> different server. The odd part is that the restored database had at least
> one view from the original db that magically turned into a table (not a
> view) in the new db. This broke some of our code that accesses the db (I
> can't remember exactly why off hand) so I had to delete the table and
> recreate it as a view by hand.
> Has anyone else seen this? It smells like a bug to me.
>
> --Rainer
>