Re: erserver 1.2 problem

On Fri, Aug 29, 2003 at 08:13:55AM -0400, Andrew Rawnsley wrote:
>
> It appears in my case that the ers_addtable is failing to add
> everything it needs to the slave tables, with a:
>
> DBD::Pg::st execute failed: execute on disconnected handle at
> /db/erserver/lib/eRServer.pm line 54, <IN> line 22.
>
> which is the point it actually tries to add stuff to the slave. I'm not
> a perl head, so I'm not sure at the moment how to fix the problem.

Sure looks like the problem.  The versions I used (which are prior to
what was released) all used Pg.pm, and it looks like this was
re-written in DBI.

Anyway, this'll do it for you:

INSERT INTO _rserv_slave_tables_ (tname, cname, reloid, key)
    SELECT r.relname, a.attname, r.oid, a.attnum
    FROM pg_class r, pg_attribute a
    WHERE r.oid = a.attrelid
    AND r.relname = '[your_relation_name]'
    AND a.attname = '_ers_uniq'

(Uh, I _think_ it's called _ers_uniq.  Our older installation uses
the original _rserv_ts locution found in the example rserv script.
Ah, legacy.)

You can add extra slave tables this way, one at a time, if you need
to.

There's an erserver mailing list, BTW.  I'm on it.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110