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
Last activity: Oct 1, 2012, 09:15 PM