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.
You can add extra slave tables this way, one at a time, if you need
There's an erserver mailing list, BTW. I'm on it.
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
In response to
pgsql-general by date
|Next:||From: Seth||Date: 2003-08-29 18:27:38|
|Subject: view function details|
|Previous:||From: Williams, Travis L, NEO||Date: 2003-08-29 16:54:02|
|Subject: Re: Join question|