By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,296 Members | 1,472 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,296 IT Pros & Developers. It's quick & easy.

Slony setup help needed

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi all,

has anyone encountered an error when running a slony_setup.pl generated script
to set up a master?
The problem I hit is that the xxid.v73.sql file aborts with the following
error:

Aug 10 20:57:57 ibserver postgres[9749]: [12] ERROR: parser: parse error at
or near "." at character 909
Aug 10 20:57:57 ibserver postgres[9749]: [13] LOG: query: select 1;
Aug 10 20:57:57 ibserver postgres[9749]: [14] ERROR: current transaction is
aborted, queries ignored until end of transaction block
Aug 10 20:57:57 ibserver postgres[9749]: [15] LOG: query: rollback
transaction;
Aug 10 20:57:57 ibserver postgres[9749]: [16] LOG: pq_recvbuf: unexpected EOF
on client connection

I traced the error to the two "CREATE CAST" statements for xxid in the script.
According to the pg-docs the types in create cast may not be namespace
specified, the script however adds the namespace.
Since I couldn't find a bugreport, any reference on google or anything else
about this I have to assume it's something local to my setup. If the
namespace specification wasn't possible at all, someone else would have run
into this problem already.

I'm using slony1-1.0.1 on a plain vanilla mandrake 9.1 with postgres 7.3.2
(from the rpm)

Any pointers would be greatly appreciated.

Uwe
- --
Open Source Solutions 4U, LLC 2570 Fleetwood Drive
Phone: +1 650 872 2425 San Bruno, CA 94066
Cell: +1 650 302 2405 United States
Fax: +1 650 872 2417
- ---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (GNU/Linux)

iD8DBQFBGctNjqGXBvRToM4RAkpuAKCRMR6DULDdj9uyFEzig5 W/jw8gowCdFxPi
g0IEiLhqmNhis6aG0Jw5hh4=
=hAMR
-----END PGP SIGNATURE-----
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Uwe C. Schroeder" <uw*@oss4u.com> writes:
I traced the error to the two "CREATE CAST" statements for xxid in the script.
According to the pg-docs the types in create cast may not be namespace
specified, the script however adds the namespace. I'm using slony1-1.0.1 on a plain vanilla mandrake 9.1 with postgres 7.3.2


Update. The refusal to take qualified names was a bug; it's fixed in
later 7.3.* releases. You really ought to be running 7.3.6 anyway ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.