Re: using slony with pgadmin

On Tuesday 07 December 2004 04:18, Andreas Pflug wrote:
> Robert Treat wrote:
> > I need to replicate a database using slony that has tables created in it
> > from pgadmin.  I've hit a snag because slony requires that all replicated
> > tables have a primary key, and the pgadmin tables dont have one.
>
> I wonder what you mean by "pgadmin tables". pgAdmin III doesn't use or
> create any pgadmin specific tables, are you talking about pgAdmin II?
>
> FYI: In pgAdmin III V1.3/1.4, we plan to add some mechanism to encourage
> users to *always* add a PK.
>

Hmm... I guess these must be pgadmin II tables?  Honestly I am not sure, the 
client uses both pgadmin II and III, so I thought that's where they were 
coming from.  Here is the schema I'm talking about:
live=# \d pga_*           Table "public.pga_forms"  Column   |         Type          | Modifiers 
------------+-----------------------+-----------formname   | character varying(64) | formsource | text
|
 
          Table "public.pga_layout" Column   |         Type          | Modifiers 
-----------+-----------------------+-----------tablename | character varying(64) | nrcols    | smallint              |
colnames | text                  | colwidth  | text                  | 
 
           Table "public.pga_queries"   Column     |         Type          | Modifiers 
---------------+-----------------------+-----------queryname     | character varying(64) | querytype     | character(1)
        | querycommand  | text                  | querytables   | text                  | querylinks    | text
       | queryresults  | text                  | querycomments | text                  | 
 
           Table "public.pga_reports"   Column     |         Type          | Modifiers 
---------------+-----------------------+-----------reportname    | character varying(64) | reportsource  | text
        | reportbody    | text                  | reportprocs   | text                  | reportoptions | text
       | 
 
           Table "public.pga_schema"   Column    |         Type          | Modifiers 
--------------+-----------------------+-----------schemaname   | character varying(64) | schematables | text
     | schemalinks  | text                  | 
 
           Table "public.pga_scripts"   Column    |         Type          | Modifiers 
--------------+-----------------------+-----------scriptname   | character varying(64) | scriptsource | text
     | 
 
-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL