Menu

phpPgAdmin not showing a schema that exists

Help
2003-11-14
2003-11-20
  • Nobody/Anonymous

    i have a database named pglogd as well as a user named pglogd... i dropped the public schema because i dont want it public... i added a pglogd schema owned by pglogd... it says it added it successfully but it does not show it in the list... if i try to add it again it says it already exists... if i use psql and login, i can see the tables and manipulate everything fine... it just appears to be phpPgAdmin not display the schema...

    thanks

     
    • Christopher Kings-Lynne

      I can't think of any explanation for this.  Have you tried logging out of phpPgAdmin and then logging back in again?

      Otherwise, if you could pg_dump -s your database I will load it into a test one and see if I can figure it out.

      Chris

       
      • Nobody/Anonymous

        perhaps the user that is being used for connecting to the database does not have the new schema in it's search path?

         
        • Christopher Kings-Lynne

          That's actually irrelevant in the way that phpPgAdmin does things.  It simply displays every entry from pg_namespace.  I can't understand it.

           
    • Nobody/Anonymous

      yes, ive tried logging out and logging back in and even recreating it... heres the dump =D

      --
      -- PostgreSQL database dump
      --

      \connect - pglogd

      --
      -- TOC entry 2 (OID 563289)
      -- Name: pglogd; Type: SCHEMA; Schema: -; Owner: pglogd
      --

      CREATE SCHEMA pglogd;

      SET search_path = pglogd, pg_catalog;

      --
      -- TOC entry 3 (OID 563290)
      -- Name: log_entries; Type: TABLE; Schema: pglogd; Owner: pglogd
      --

      CREATE TABLE log_entries (
          request_time timestamp with time zone,
          seconds_to_serve integer,
          response_code integer,
          bytes_sent integer,
          request_type character varying(10),
          virtual_domain character varying(80),
          remote_host character varying(80),
          request_url_path character varying(80),
          referer text,
          user_agent text,
          request text,
          logname character varying(30),
          username character varying(30)
      );

      --
      -- TOC entry 4 (OID 563295)
      -- Name: temp_entries; Type: TABLE; Schema: pglogd; Owner: pglogd
      --

      CREATE TABLE temp_entries (
          request_time timestamp with time zone,
          seconds_to_serve integer,
          response_code integer,
          bytes_sent integer,
          request_type character varying(10),
          virtual_domain character varying(80),
          remote_host character varying(80),
          request_url_path character varying(80),
          referer text,
          user_agent text,
          request text,
          logname character varying(30),
          username character varying(30)
      );

      --
      -- TOC entry 5 (OID 563304)
      -- Name: full_entries; Type: TABLE; Schema: pglogd; Owner: pglogd
      --

      CREATE TABLE full_entries (
          request_time timestamp with time zone,
          seconds_to_serve integer,
          response_code integer,
          bytes_sent integer,
          request_type character varying(10),
          virtual_domain character varying(80),
          remote_host character varying(80),
          host_type character varying(3),
          request_url_path text,
          referer text,
          referer_domain character varying(80),
          referer_sengine character varying(80),
          user_agent text,
          request text,
          logname character varying(30),
          username character varying(30)
      );

      --
      -- TOC entry 7 (OID 563300)
      -- Name: temp_entries_requesttime; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX temp_entries_requesttime ON temp_entries USING btree (request_time);

      --
      -- TOC entry 8 (OID 563301)
      -- Name: temp_entries_responsecode; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX temp_entries_responsecode ON temp_entries USING btree (response_code);

      --
      -- TOC entry 9 (OID 563302)
      -- Name: temp_entries_virtualdomain; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX temp_entries_virtualdomain ON temp_entries USING btree (virtual_domain);

      --
      -- TOC entry 6 (OID 563303)
      -- Name: temp_entries_remotehost; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX temp_entries_remotehost ON temp_entries USING btree (remote_host);

      --
      -- TOC entry 12 (OID 563309)
      -- Name: full_entries_requesttime; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX full_entries_requesttime ON full_entries USING btree (request_time);

      --
      -- TOC entry 14 (OID 563310)
      -- Name: full_entries_responsecode; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX full_entries_responsecode ON full_entries USING btree (response_code);

      --
      -- TOC entry 13 (OID 563311)
      -- Name: full_entries_requesttype; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX full_entries_requesttype ON full_entries USING btree (request_type);

      --
      -- TOC entry 16 (OID 563312)
      -- Name: full_entries_virtualdomain; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX full_entries_virtualdomain ON full_entries USING btree (virtual_domain);

      --
      -- TOC entry 11 (OID 563313)
      -- Name: full_entries_remotehost; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX full_entries_remotehost ON full_entries USING btree (remote_host);

      --
      -- TOC entry 10 (OID 563314)
      -- Name: full_entries_refdomain; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX full_entries_refdomain ON full_entries USING btree (referer_domain);

      --
      -- TOC entry 15 (OID 563315)
      -- Name: full_entries_sengine; Type: INDEX; Schema: pglogd; Owner: pglogd
      --

      CREATE INDEX full_entries_sengine ON full_entries USING btree (referer_sengine);

       
      • Nobody/Anonymous

        OK, I've fixed this now.

        However, you'll need to get the CVS version of phpPgAdmin if you want to see the fixes.

        You can fix it yourself by editing the classes/database/Postgres73.php file.

        Find the getSchemas() function and change this:

        NOT LIKE 'pg_%'

        to this:

        NOT LIKE 'pg\\\\_%'

        And it will fix your problem.

        There are several other places in that file where the problem exists, but the above fix will help you the most I think.

        Chris

         
        • Nobody/Anonymous

          Gah - SF's forums are broken

          That should be 'pg_\\\\\\\\%'

          ie. FOUR backslashes

          Chris

           
    • David Rudie

      David Rudie - 2003-11-20

      thanks for fixing it, ill grab the latest cvs :)

       

Log in to post a comment.