On 11-11-04 04:15 PM, Christopher Browne wrote:
> On Fri, Nov 4, 2011 at 4:11 PM, Steve Singer<ssinger at ca.afilias.info>  wrote:
>> Does this seem cleaner?
>>
>> create table @NAMESPACE at .sl_log_ddl (
>>         log_origin                      int4,
>>         log_txid                        bigint,
>>         log_actionseq           int8,
>>         log_query                       text
>>   ) WITHOUT OIDS;
>
> Ah, yes, that seems like a fine justification.  Works for me, I'll
> change forthwith.

Another thought.

Do we want to be using 'ddl' in these names or something else 
(sl_log_script?)

The scripts you submit with EXECUTE SCRIPT don't need to contain DDL. 
If I often do bulk updates/deletes of tables I might choose to route 
those through slonik/EXECUTE SCRIPT instead of via psql.

Also if I have some function that has side-effects outside the database 
(or even to non replicated tables) and you want that function to run on 
all nodes you might also use execute script.