On 11/17/2004 5:50 PM, Darcy Buskermolen wrote:

> On November 17, 2004 01:22 pm, Pallav Kalva wrote:
>> Darcy Buskermolen wrote:
>> >On November 8, 2004 09:55 am, Darcy Buskermolen wrote:
>> >>Hello,
>> >>
>> >>In order to apply some more improvements to the 1.1 branch of slony
>> >> making it more pg_dump friendly. I'm wondering if there is a compelling
>> >> reason to continue to have sl_table.tab_reloid and
>> >> sl_sequence.seq_reloid reference pg_class.oid, instead of storing the
>> >> fully qualified name ?
>> >
>> >Ok I've done some tests, and beat some code around and have pretty much
>> >discoverd that there is no "nice" way to convert to name usage and have
>> > ALTER TABLE foo RENAME bar work and not break replication under some
>> > cases.
>>
>>     Under what replication cases does the ALTER TABLE foo RENAME bar
>> does not work ? I am new to slony and right now I am  testing out all
>> the scenarios, I tried to rename a table which is replicated and I could
>> rename the table with the EXECUTE script on master and slave without any
>> problems .  am I missing something? excuse me if this is totally
>> unrelated .
> 
> It's totaly unrelated, this change is specificaly related to improvements I'm 
> planning to make to slony to make it more pg_dump friendly.  Currently alter 
> table foo rename bar works 100% as it should.   This message is more related 
> to current hackers  asking what their preference would be related to 
> extending the internal tables of slony.

I had discussed that matter with CBB a little. My current thoughts are 
that Slony-schema changes should be handled by a store procedure, which 
is (re)defined by the newly loaded slony1-funcs.sql and will be called 
by slon during "update functions" and will receive the previous schema 
version as an argument. That function then will execute all the version 
to version specific SQL for that upgrade.

As said ... current thoughts ... feel free to grind them to dust.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #