Sample Header Ad - 728x90

Can I replicate views with Slony?

2 votes
2 answers
669 views
Can I feed some SQL that creates a view to Slony? I have some SQL that does CREATE OR REPLACE VIEW name_of_view and so on, passes it to slonik_execute_script, and then tries to run slonik_create_set for a temporary Slony set containing only that view. I get rejected with ERROR: Slony-I: table "public"."name_of_view" has no primary key error. To my knowledge, views don't support primary keys. Does this mean there is no way, using the Slony admin scripts, to add a view to replication, and that I should just install it manually on all members of my replication cluster?
Asked by Zac B (526 rep)
Apr 10, 2012, 10:09 PM
Last activity: Oct 1, 2012, 09:15 PM