[GENERAL] Simple Trigger Error

es for few seconds and I get my terminal gets filled with the above stated message. Also that, the original 'insert into' operation over the 'addressbook' table doesn't happen. Where am I wrong in the trigger function ? -- With Regards Parthan (Techno

[GENERAL] Error in PostgreSQL query with psycopg

s or in the string formatting used? How will i pass the date and time data which are in the form of 'dd-mm-' and 'hh:mm:ms' as required by the date and time data types of PostgreSQL ? Am i wrong in useing back slash escaped single quotes to quote strings in the query? Am u

Re: [GENERAL] Simple Trigger Error

On 12/20/06, A. Kretschmer <[EMAIL PROTECTED]> wrote: But i have questions/suggestions: - you have never-used variables in your function. Perhaps you have an older version from the function with an error and the wrong version runs? - perhaps, you have an other trigger on phonebook that calls

[GENERAL] Column does not exist when trying to insert data.

Hello, My table 'orderitems' looks like this create table orderitem ( id serial not null primary key, item integer not null, quantity numeric(6,2) not null, unit varchar(10), conference integer not null, seller integer not null, incharge integer not null, orderdate date not null, duedate date no

Re: [GENERAL] Error in PostgreSQL query with psycopg

On 7/31/06, Richard Huxton wrote: > Line68:> query = cursor.execute("""INSERT INTO ConfMain (ConfName, ConfHost,> ConfStart, ConfEnd, ConfDays, ConfStartTime, ConfEndTime, ConfSize)> VALUES (\'%s\', \'%s\', \'%%\', \'%%\', %i, \'%%\', \'%%\', %i);""" % > (conf_name, host_name, st

Re: [GENERAL] Error in PostgreSQL query with psycopg

. [code] name = 'GLV' host = 'Parthan' start = '04-08-2006' end = '04-08-2006' days = 1 starttime = '15:00:00' endtime = '18:00:00' size = 20 arglist =  (name, host, start, end, days, starttime, endtime, size) connection = connect(&quo