Slony1 PostgreSQL Replication - Re: about Execute SQL/DDL script and add

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: about Execute SQL/DDL script and add

Christopher Browne

2005-07-12, 9:24 am

Sun.betty wrote:

> Hello! All!
>
> create.sql :
> BEGIN;
> create table tb_test4 (
> INFO_ID NUMERIC(6) not null,
> TO_NAME VARCHAR(256) null,
> constraint PK_TB_TEST4 primary key (INFO_ID)
> );
> COMMIT ;
>
Please consult the documentation for EXECUTE SCRIPT.

It indicates:

"The script file must not contain any START or COMMIT TRANSACTION calls."

Sponsored Links