X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CDA523A3DD6 for ; Tue, 21 Dec 2004 12:51:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78961-07 for ; Tue, 21 Dec 2004 12:51:14 +0000 (GMT) Received: from mail.softcom.dk (unknown [217.157.23.229]) by svr1.postgresql.org (Postfix) with ESMTP id 8C8403A2C11 for ; Tue, 21 Dec 2004 12:51:13 +0000 (GMT) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: FW: Weird problem, cant delete table ! X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Date: Tue, 21 Dec 2004 13:51:13 +0100 Message-ID: <2D4F76DE20C9B14BBF46FD1EC07FD441134527@earth.softcom.local> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Weird problem, cant delete table ! Thread-Index: AcTnW8DSPAVd1frPROyJfEGYSqWKYw== From: "Thomas Madsen" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/210 X-Sequence-Number: 15796 I have a postgresql ( psql (PostgreSQL) 7.2.1 ) database where i have a=20 problem deleting 1 off the tables Im logged in locally and access it with root In the database there is among more, 2 tables with similar names: infected infected_ When i try to delete the "infected_" ( drop table "infected_";) it says ERROR: table "infected_" does not exist. When i try to recreate it ( create table infected_ as select filename from infected limit 10; ) it says : type named infected_ already exists When i check the access rights ( \z ) it looks like i have no rights more tables/rights infected = {=3D,postgres=3DarwdRxt,mailadmin=3DarwdRxt,root=3DarwdRxt} infected_ more tables/rights When i try to give me rights on the "infected_" ( grant all on infected_ to mailadmin; ) it says ERROR: relation "infected_" not found when i do a query to pg_class like this it finds a record select * from pg_class where relname like 'infected_%'; it does find some records when i try to make a dump off the database it also complains ! pg_dump: Attempt to lock table "infected_" failed. ERROR: Relation=20 "infected_" does not exist Im at a lost here ! Please if anyone could guide me in the right direction :-) i would be very thankfull ! Best Regards Nikolaj Steensgaard