view problem - Mailing list pgsql-bugs

From Luca ghedini
Subject view problem
Date
Msg-id 386A52DC.F2858C64@mail.ing.unibo.it
Whole thread Raw
List pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name               :   Luca Ghedini
Your email address      :   luca.ghedini@mail.ing.unibo.it


System Configuration
---------------------
  Architecture (example: Intel Pentium)         : sun Ultra 3500

  Operating System (example: Linux 2.0.26 ELF)  : solaris 2.6

  PostgreSQL version (example: PostgreSQL-6.5.3):   PostgreSQL-6.5.3

  Compiler used (example:  gcc 2.8.0)           : gcc 2.8.1


Please enter a FULL description of your problem:
------------------------------------------------
hi, I'm new to postgress word.

the bug (or at least what i think is a bug)

I createte a view with pgaccess.
The name of the view is elenco utenti (Ok, a spce in a name is not a
great idea!)

Now is immposible remove the view element.

From pgaccess i got this error:


drop view "elenco utenti"

...

ERROR: nodeRead: Bad type 0

in the table list (psql \d)

i got
 | mailadmin        | elenco utenti                    | view?    |


If I try to dump the db pg_dump tell me

dumpRules(): SELECT failed for table elenco utenti.  Explanation from
backend: 'ERROR:  nodeRead: Bad type 0
'.



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------





If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

pgsql-bugs by date:

Previous
From: Erix MOLINIE
Date:
Subject: unsubscribe
Next
From: greathunterbob@webtv.net (Robert Mcbride)
Date:
Subject: bugs