Forum OpenACS Q&A: Re: Development Tutorial Available

Collapse
17: Re: Development Tutorial Available (response to 1)
Posted by Gabriel Ricard on 04/17/03 07:43 PM
I'm getting this error when loading the data into postgresql:

psql:samplenote-functions-create.sql:22: ERROR:  Attribute 'samplenote__new' not found

any ideas?

Collapse
18: Re: Development Tutorial Available (response to 17)
Posted by Joel Aufrecht on 04/19/03 09:14 PM
The error in line twenty-two is because samplenote__new is a string to be passed in, not a function to be called, and so needs to be in single quotes: 
select define_function_args('samplenote__new','note_id,title,creation_date,creation_user,creation_ip,context_id');

Question for people: I omitted the object type, both in the __new function and in the wrapper for the __new function. My reason is that the object type is constant for the function samplenote__new. So there's no reason for it ever to be passed in, so I'll just hard-code it into the plpgsql. Is this okay or did I miss something?