Hi all

Thanks to Andrew Sullivan for getting me started.  I am very close.
This is what I have:

CREATE OR REPLACE FUNCTION slony_ddl() RETURNS TRIGGER AS '
DECLARE
	NewSlonyTableID INTEGER;
	TableName VARCHAR(32);
BEGIN
	IF NEW.column IS NULL THEN

		-- Brand new table being added to slony

	SELECT count(*) INTO NewSlonyTableID FROM
_slony_cluster.sl_table; -- Obtain last used slony table id from slony
table
	NewSlonyTableID := NewSlonyTableID + 1; -- Increment by one
	TableName := "public." || NEW.tablename;
	PERFORM _slony_cluster.storeset (1000, TableName);
	PERFORM _slony_cluster.setaddtable(1000, NewSlonyTableID,
TableName, CAST (NEW.tablename as name), 

CAST (NEW.tablename AS text));

	ELSE
		-- Modifying existing table

	END IF;

	-- Remove row from temp table

	DELETE FROM slony_temp WHERE tablename=NEW.tablename;

	RETURN NEW;

END;
' LANGUAGE plpgsql;

Two things.  In the TableName assignment, I am trying to concatenate
string public. And the table name.  From what I gather in the docs, the
|| should concatentate the two strings.  I am getting an error that
column public doesn't exist.

Why does the following fail?

Quote_literal ("mark adan");

ERROR:  column "mark adan" does not exist

I just want to be able to set a string in a function name

Mark