pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedGood examples of calling slony stored procedures
8+ messages / 5 participants
[nested] [flat]
* Good examples of calling slony stored procedures
@ 2006-06-14 02:30 Mark Adan <markadan@ati.com>
2006-06-14 03:27 ` Re: Good examples of calling slony stored procedures Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 8+ messages in thread
From: Mark Adan @ 2006-06-14 02:30 UTC (permalink / raw)
To: pgsql-sql
Hi
I was wondering if where can I find some examples of calling the slony
stored procedures instead of using slonik? I want to be able to for
example add a table into slony. Thanks
Mark Adan
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Good examples of calling slony stored procedures
2006-06-14 02:30 Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
@ 2006-06-14 03:27 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-06-14 15:50 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
0 siblings, 1 reply; 8+ messages in thread
From: Tom Lane @ 2006-06-14 03:27 UTC (permalink / raw)
To: Mark Adan <markadan@ati.com>; +Cc: pgsql-sql
"Mark Adan" <markadan@ati.com> writes:
> I was wondering if where can I find some examples of calling the slony
> stored procedures instead of using slonik? I want to be able to for
> example add a table into slony. Thanks
This is likely the wrong bunch to ask --- there's a slony project
mailing list where the right people to ask hang out. Don't have
the address at hand.
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Good examples of calling slony stored procedures
2006-06-14 02:30 Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 03:27 ` Re: Good examples of calling slony stored procedures Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-06-14 15:50 ` Mark Adan <markadan@ati.com>
2006-06-14 15:53 ` Re: Good examples of calling slony stored procedures Jim Buttafuoco <jim@contactbda.com>
0 siblings, 1 reply; 8+ messages in thread
From: Mark Adan @ 2006-06-14 15:50 UTC (permalink / raw)
To: pgsql-sql
Hi
Can somebody direct me to the mailing list for slony. I couldn't find
it anywhere on the postgres.org website (which is where I found this
list to begin with). Thanks
Mark
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tuesday, June 13, 2006 20:27
To: Mark Adan
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Good examples of calling slony stored procedures
"Mark Adan" <markadan@ati.com> writes:
> I was wondering if where can I find some examples of calling the slony
> stored procedures instead of using slonik? I want to be able to for
> example add a table into slony. Thanks
This is likely the wrong bunch to ask --- there's a slony project
mailing list where the right people to ask hang out. Don't have
the address at hand.
regards, tom lane
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Good examples of calling slony stored procedures
2006-06-14 02:30 Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 03:27 ` Re: Good examples of calling slony stored procedures Tom Lane <tgl@sss.pgh.pa.us>
2006-06-14 15:50 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
@ 2006-06-14 15:53 ` Jim Buttafuoco <jim@contactbda.com>
2006-06-14 15:55 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
0 siblings, 1 reply; 8+ messages in thread
From: Jim Buttafuoco @ 2006-06-14 15:53 UTC (permalink / raw)
To: Mark Adan <markadan@ati.com>; pgsql-sql
try www.slony.info
---------- Original Message -----------
From: "Mark Adan" <markadan@ati.com>
To: <pgsql-sql@postgresql.org>
Sent: Wed, 14 Jun 2006 08:50:23 -0700
Subject: Re: [SQL] Good examples of calling slony stored procedures
> Hi
>
> Can somebody direct me to the mailing list for slony. I couldn't find
> it anywhere on the postgres.org website (which is where I found this
> list to begin with). Thanks
>
> Mark
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, June 13, 2006 20:27
> To: Mark Adan
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Good examples of calling slony stored procedures
>
> "Mark Adan" <markadan@ati.com> writes:
> > I was wondering if where can I find some examples of calling the slony
> > stored procedures instead of using slonik? I want to be able to for
> > example add a table into slony. Thanks
>
> This is likely the wrong bunch to ask --- there's a slony project
> mailing list where the right people to ask hang out. Don't have
> the address at hand.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
------- End of Original Message -------
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Good examples of calling slony stored procedures
2006-06-14 02:30 Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 03:27 ` Re: Good examples of calling slony stored procedures Tom Lane <tgl@sss.pgh.pa.us>
2006-06-14 15:50 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 15:53 ` Re: Good examples of calling slony stored procedures Jim Buttafuoco <jim@contactbda.com>
@ 2006-06-14 15:55 ` Mark Adan <markadan@ati.com>
2006-06-14 16:14 ` Re: Good examples of calling slony stored procedures Andrew Sullivan <ajs@crankycanuck.ca>
2006-06-14 20:55 ` Re: Good examples of calling slony stored procedures Christopher Browne <cbbrowne@acm.org>
0 siblings, 2 replies; 8+ messages in thread
From: Mark Adan @ 2006-06-14 15:55 UTC (permalink / raw)
To: pgsql-sql
Hi Jim
I looked there already and didn't find what I needed. I saw this web
page from cbbrowne and he briefly talked about using "bare metal" slony
functions, but doesn't have any examples.
Mark
-----Original Message-----
From: Jim Buttafuoco [mailto:jim@contactbda.com]
Sent: Wednesday, June 14, 2006 08:53
To: Mark Adan; pgsql-sql@postgresql.org
Subject: Re: [SQL] Good examples of calling slony stored procedures
try www.slony.info
---------- Original Message -----------
From: "Mark Adan" <markadan@ati.com>
To: <pgsql-sql@postgresql.org>
Sent: Wed, 14 Jun 2006 08:50:23 -0700
Subject: Re: [SQL] Good examples of calling slony stored procedures
> Hi
>
> Can somebody direct me to the mailing list for slony. I couldn't find
> it anywhere on the postgres.org website (which is where I found this
> list to begin with). Thanks
>
> Mark
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Tuesday, June 13, 2006 20:27
> To: Mark Adan
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Good examples of calling slony stored procedures
>
> "Mark Adan" <markadan@ati.com> writes:
> > I was wondering if where can I find some examples of calling the
slony
> > stored procedures instead of using slonik? I want to be able to for
> > example add a table into slony. Thanks
>
> This is likely the wrong bunch to ask --- there's a slony project
> mailing list where the right people to ask hang out. Don't have
> the address at hand.
>
> regards, tom lane
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
------- End of Original Message -------
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Good examples of calling slony stored procedures
2006-06-14 02:30 Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 03:27 ` Re: Good examples of calling slony stored procedures Tom Lane <tgl@sss.pgh.pa.us>
2006-06-14 15:50 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 15:53 ` Re: Good examples of calling slony stored procedures Jim Buttafuoco <jim@contactbda.com>
2006-06-14 15:55 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
@ 2006-06-14 16:14 ` Andrew Sullivan <ajs@crankycanuck.ca>
2006-06-14 16:24 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
1 sibling, 1 reply; 8+ messages in thread
From: Andrew Sullivan @ 2006-06-14 16:14 UTC (permalink / raw)
To: pgsql-sql
On Wed, Jun 14, 2006 at 08:55:21AM -0700, Mark Adan wrote:
> Hi Jim
>
> I looked there already and didn't find what I needed. I saw this web
But the mailing list link is at the top of that page:
http://gborg.postgresql.org/mailman/listinfo/slony1
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Good examples of calling slony stored procedures
2006-06-14 02:30 Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 03:27 ` Re: Good examples of calling slony stored procedures Tom Lane <tgl@sss.pgh.pa.us>
2006-06-14 15:50 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 15:53 ` Re: Good examples of calling slony stored procedures Jim Buttafuoco <jim@contactbda.com>
2006-06-14 15:55 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 16:14 ` Re: Good examples of calling slony stored procedures Andrew Sullivan <ajs@crankycanuck.ca>
@ 2006-06-14 16:24 ` Mark Adan <markadan@ati.com>
0 siblings, 0 replies; 8+ messages in thread
From: Mark Adan @ 2006-06-14 16:24 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
Excellent. I will subscribe to that one. Thanks
Mark
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Andrew Sullivan
Sent: Wednesday, June 14, 2006 09:14
To: pgsql-sql@postgresql.org
Subject: Re: [SQL] Good examples of calling slony stored procedures
On Wed, Jun 14, 2006 at 08:55:21AM -0700, Mark Adan wrote:
> Hi Jim
>
> I looked there already and didn't find what I needed. I saw this web
But the mailing list link is at the top of that page:
http://gborg.postgresql.org/mailman/listinfo/slony1
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Good examples of calling slony stored procedures
2006-06-14 02:30 Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 03:27 ` Re: Good examples of calling slony stored procedures Tom Lane <tgl@sss.pgh.pa.us>
2006-06-14 15:50 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 15:53 ` Re: Good examples of calling slony stored procedures Jim Buttafuoco <jim@contactbda.com>
2006-06-14 15:55 ` Re: Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
@ 2006-06-14 20:55 ` Christopher Browne <cbbrowne@acm.org>
1 sibling, 0 replies; 8+ messages in thread
From: Christopher Browne @ 2006-06-14 20:55 UTC (permalink / raw)
To: pgsql-sql
Martha Stewart called it a Good Thing when markadan@ati.com ("Mark Adan") wrote:
> I looked there already and didn't find what I needed. I saw this web
> page from cbbrowne and he briefly talked about using "bare metal" slony
> functions, but doesn't have any examples.
If you look at the source code for the slonik utility, it shows how
the functions actually get used.
In most cases, slonik.c submits fairly simple requests using the
functions in slony1-funcs.sql.
For instance, the slonik MOVE SET (id=1, old origin=11, new origin=22);
command runs a bunch of C "deteriorata" that is a wrapper for:
select _slony_schema.moveset(1, 22);
Plenty of the commands are about as simple as that.
And this means that, for these "simple" operations, if you want to
submit them via SQL queries, there's a very thin veiling you need to
do to submit the functions as SQL selects.
There are more complex cases, such as FAIL OVER, SET ADD TABLE,
EXECUTE SCRIPT, UPDATE FUNCTIONS, and WAIT FOR EVENT, where there is
considerably complex logic in addition to what is in the stored procs.
Looking at slonik.c is the best thing I can suggest you do...
--
"cbbrowne","@","cbbrowne.com"
http://linuxdatabases.info/info/x.html
Signs of a Klingon Programmer #6: "Debugging? Klingons do not
debug. Our software does not coddle the weak."
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2006-06-14 20:55 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-06-14 02:30 Good examples of calling slony stored procedures Mark Adan <markadan@ati.com>
2006-06-14 03:27 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-06-14 15:50 ` Mark Adan <markadan@ati.com>
2006-06-14 15:53 ` Jim Buttafuoco <jim@contactbda.com>
2006-06-14 15:55 ` Mark Adan <markadan@ati.com>
2006-06-14 16:14 ` Andrew Sullivan <ajs@crankycanuck.ca>
2006-06-14 16:24 ` Mark Adan <markadan@ati.com>
2006-06-14 20:55 ` Christopher Browne <cbbrowne@acm.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox