Horton

Thread

  1. view problem

    Luca ghedini <luca.ghedini@mail.ing.unibo.it> — 1999-12-29T18:28:44Z

    ============================================================================
                        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:
---------------------------------------------------------------------