prepared statements

Hi all,

I'm working with prepared statements directly in pg for the first time  
and have a couple of questions.

Does a prepared statement used to insert into a table need to insert  
into all columns of the table? I've found that, for a table with a  
serial sequence key as its first column, I have to specify the key in  
my prepared statement or I get type errors:  ERROR:  column "foo_id"  
is of type integer but expression is of type character varying.

What's the best way to specify the next value for the serial sequence  
key if subqueries are not allowed in a prepared statement's execute  
parameter:  ERROR:  cannot use subquery in EXECUTE parameter

For example, given the following table definition:
CREATE TABLE foo (
	foo_id				SERIAL		PRIMARY KEY,
	name				VARCHAR(32)	UNIQUE NOT NULL,
	description			TEXT,
	body				TEXT		DEFAULT NULL,
	created				timestamp	DEFAULT CURRENT_TIMESTAMP,
	UNIQUE				(name));

What's the best way to insert several records that have lots of  
special characters in the "body" column?  eg:

PREPARE fooprep (int, VARCHAR(32), text, text) AS
     INSERT INTO foo VALUES ($1, $2, $3, $4);
EXECUTE (fooprep
(SELECT nextval('foo_id_seq')),
'foo1',
'this is foo1',
'#!()[]{}
qwepoiasdlkjzxcmnb
/\1\2\3\4\5\6\7\8\9/');

Thanks in advance!
Scott