view problem

Started by Luca ghediniover 26 years ago1 messagesbugs
Jump to latest
#1Luca ghedini
luca.ghedini@mail.ing.unibo.it

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