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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to