-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

shafrudin a écrit :
> 
> 
> Raymond O'Donnell wrote:
>> On 24/03/2009 07:55, shafrudin wrote:
>>
>>> i read the article but i still dont undestand,...
>>> can anyone help me how to execute ddl script???
>> AIUI, you can do it like this:
>>
>> * Put your DDL into a file.
>>
>> * Create another script file with the EXECUTE SCRIPT command in it,
>> pointing to the first script (see the example at
>> http://www.slony.info/documentation/stmtddlscript.html).
>>
>> * Submit this second script to slonik.
>>
>> I haven't done it myself, but this is what I understand from scanning
>> the docs anyway. :-)
>>
> 
> 
> in file should just write ddl cript like
> create table a (id integer);
> or i need to write another script??
> and how to submit to slonik??
> please can you explain step by step i really get suck....
> 

There are two different things.
1. you want to add a table to a replication.
2. You want to modify already replicated objects.

In the first case, you have to create objects on every node, and then add them
to the replication. To do so, you'll have to create a new set, add objects to
that set, subscribe that set, exactly like the first set, and then merge the
two sets.

In the second case, you have to put all schema changes in a single script, and
tell some slonik script to "execute script", as said in documentation.

Regards,
SAS

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJyeP5A+REPKWGI0ERApfUAJ9HfJJ4JzJFBugU2NdN7C7NTbLzrACgxu2s
OfnjWh9TF3prABluINJMNtQ=
=Wmhx
-----END PGP SIGNATURE-----