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?