On Tuesday 07 December 2004 12:45, Andreas Pflug wrote:
> Robert Treat wrote:
> > 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"
> > Table "public.pga_layout"
> > Table "public.pga_queries"
> > Table "public.pga_reports"
> > Table "public.pga_schema"
> > Table "public.pga_scripts"
>
> Clearly pgaII. Replication probably not necessary.
>
Hmm... the theory here is that in the event of failover, the client doesn't
want to lose all of thier reports and what not that they have in pgadmin.
Let me ask you this, would it break anything to add a serial key to each of
the tables?
--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL