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