My submission is a simple question. 
Using Slony to replicate one Database into another, there is few Stored procedures that need to be loaded thru Slony.

How can I include Comment lines.

Also how can I comment a portion of a line and let execute all rest?

Thanks,

TonyF

-----Original Message-----
From: slony1-hackers-bounces at lists.slony.info [mailto:slony1-hackers-bounces at lists.slony.info] On Behalf Of slony1-hackers-request at lists.slony.info
Sent: Monday, October 06, 2008 3:00 PM
To: slony1-hackers at lists.slony.info
Subject: Slony1-hackers Digest, Vol 18, Issue 1

Send Slony1-hackers mailing list submissions to
	slony1-hackers at lists.slony.info

To subscribe or unsubscribe via the World Wide Web, visit
	http://lists.slony.info/mailman/listinfo/slony1-hackers
or, via email, send a message with subject or body 'help' to
	slony1-hackers-request at lists.slony.info

You can reach the person managing the list at
	slony1-hackers-owner at lists.slony.info

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Slony1-hackers digest..."


Today's Topics:

   1. Slony-I Communications Costs (Bernd Helmle)
   2. Commented lines in Stored Procedures code uploaded	thru SLONY
      (Tony Fernandez)
   3. Re: Commented lines in Stored Procedures code	uploaded thru
      SLONY (Christopher Browne)


----------------------------------------------------------------------

Message: 1
Date: Mon, 06 Oct 2008 13:42:30 +0200
From: Bernd Helmle <mailings at oopsware.de>
Subject: [Slony1-hackers] Slony-I Communications Costs
To: slony1-hackers at lists.slony.info
Message-ID: <932147FBA0722CEA5F821732 at imhotep.credativ.de>
Content-Type: text/plain; charset=us-ascii; format=flowed

The Slony-I documentation states the following:


"This points to it being a bad idea to have the large communications 
network resulting from the number of nodes being large. Up to a half dozen 
nodes seems pretty reasonable; every time the number of nodes doubles, this 
can be expected to quadruple communications overheads."

Consider a setup with dozens of very small nodes which aren't heavliy 
frequented. Neither of these nodes is considered to be a forwarder and 
stores only information which aren't updated frequently (so we consider a 
small database between 20 - 30 MB).  The Lagtime can be minutes (we don't 
care wether 5 or 15 minutes). The network is stable.

I wonder wether the number of nodes can be significantly larger than the 
half dozens the documentation mentions, especially if you don't need to use 
Failover, MOVE SET and you are able to use high SYNC timeouts values. For 
example, this can be configuration clusters of a large network where 
configuration changes needs to be propagated through a large number of 
nodes.

A customer is planning such a setup and they consider Slony-I exactly for 
this purpose since they are impressed about its reliability. However, 
because communications cost is quadratic, there can be significant network 
traffic.

Opinions? Experiences?

-- 
  Thanks

                    Bernd


------------------------------

Message: 2
Date: Mon, 6 Oct 2008 08:22:16 -0500
From: "Tony Fernandez" <Tony.Fernandez at vocalocity.com>
Subject: [Slony1-hackers] Commented lines in Stored Procedures code
	uploaded	thru SLONY
To: <slony1-hackers at lists.slony.info>
Message-ID:
	<925169557BAB6947A70CB145F894A75B4F1EF8 at mail-41ps.atlarge.net>
Content-Type: text/plain; charset="us-ascii"

Hello all,

 

Is there a way to instruct Slony-I about comment lines that should not
be executed when utilizing the tool?

 

In code below, the "This is a comment" line and the following should be
ignored.

 

How do we accomplish that.

 

Thanks,

 

Tony Fernandez

 

 

----------------------------------------------------------------------

CREATE OR REPLACE FUNCTION MyFunction(  )

  RETURNS integer AS

$BODY$

  DECLARE

 

/* This is a comment

      Slony-I should not execute

*/

 

  BEGIN

     Return 0;

  END;

$BODY$

  LANGUAGE 'plpgsql' VOLATILE SECURITY DEFINER

  COST 100;

----------------------------------------------------------------------

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-hackers/attachments/20081006/7217989c/attachment.html

------------------------------

Message: 3
Date: Mon, 06 Oct 2008 14:18:35 -0400
From: Christopher Browne <cbbrowne at ca.afilias.info>
Subject: Re: [Slony1-hackers] Commented lines in Stored Procedures
	code	uploaded thru SLONY
To: "Tony Fernandez" <Tony.Fernandez at vocalocity.com>
Cc: slony1-hackers at lists.slony.info
Message-ID: <87od1xh9j8.fsf at dba2.int.libertyrms.com>
Content-Type: text/plain; charset=iso-8859-1

"Tony Fernandez" <Tony.Fernandez at vocalocity.com> writes:
>       :v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word"
> 		       xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
>
> 								  Hello all,:p>
>
> 								      :p> 
>
> 		 Is there a way to instruct Slony-I about comment lines that should not be executed when utilizing the tool?:p>


I'm not sure I understand the problem.

Are you experiencing some problem where comments in stored functions
are not being handled as comments?

If you are, then a bug report might lead either to a fix, or to some
suggestion of a workaround.

>From what you're writing, you appear to be asking how to instruct
PostgreSQL about comment lines, as opposed to Slony-I.  Which is
documented, for pl/pgsql, here:

   <http://www.postgresql.org/docs/8.3/static/plpgsql-structure.html>
-- 
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://cbbrowne.com/info/unix.html
Rules of the Evil Overlord #38. "If  an enemy I have just killed has a
younger sibling or offspring anywhere,  I will find them and have them
killed immediately, instead  of waiting for them to  grow up harboring
feelings of vengeance towards me in my old age."
<http://www.eviloverlord.com/>


------------------------------

_______________________________________________
Slony1-hackers mailing list
Slony1-hackers at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-hackers


End of Slony1-hackers Digest, Vol 18, Issue 1
*********************************************

No virus found in this incoming message.
Checked by AVG - http://www.avg.com 
Version: 8.0.173 / Virus Database: 270.7.5/1706 - Release Date: 10/6/2008 9:23 AM