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