view problem

From: Luca ghedini <luca(dot)ghedini(at)mail(dot)ing(dot)unibo(dot)it>
To: pgsql-bugs(at)postgresql(dot)org
Subject: view problem
Date: 1999-12-29 18:28:44
Message-ID: 386A52DC.F2858C64@mail.ing.unibo.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Luca Ghedini
Your email address : luca(dot)ghedini(at)mail(dot)ing(dot)unibo(dot)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:
---------------------------------------------------------------------

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Mcbride 2000-01-01 13:56:35 bugs
Previous Message Erix MOLINIE 1999-12-29 08:03:51 unsubscribe