Re: Problem loading custom PostgreSQL function at syncdb time.

2008-12-11 Thread Raymond Cote
Malcolm Tredinnick wrote: > On Wed, 2008-12-10 at 16:01 -0500, Raymond Cote wrote: > >> Hi Everyone, >> >> I'm having problems loading a custom PostgreSQL trigger function during >> syncdb and not sure how to address this: >> ... > I suspect this is because the initial SQL option isn't really

Re: Problem loading custom PostgreSQL function at syncdb time.

2008-12-10 Thread Malcolm Tredinnick
On Wed, 2008-12-10 at 16:01 -0500, Raymond Cote wrote: > Hi Everyone, > > I'm having problems loading a custom PostgreSQL trigger function during > syncdb and not sure how to address this: > The function (trimmed down) looks as follows: > > CREATE OR REPLACE FUNCTION probe_data_insert() > RE

Re: Problem loading custom PostgreSQL function at syncdb time.

2008-12-10 Thread DavidA
This sounds suspiciously similar to the problem I had with initial SQL scripts in MySQL. In my case I was inserting rows into a table and one of the string fields contained %. I had to "escape" the % (using %%). I'm guessing that the SQL isn't directly executed but somehow evaluated in the django.

Problem loading custom PostgreSQL function at syncdb time.

2008-12-10 Thread Raymond Cote
Hi Everyone, I'm having problems loading a custom PostgreSQL trigger function during syncdb and not sure how to address this: The function (trimmed down) looks as follows: CREATE OR REPLACE FUNCTION probe_data_insert() RETURNS SETOF trigger AS $$ DECLARE ofs VARCHAR; BEGIN NEW.collect