Re: ERROR: there is no parameter $1

Kevin Jenkins <gameprogrammer@rakkar.org> writes:
> I get ERROR:  there is no parameter $1.

> INSERT INTO FileVersionHistory(applicationID, filename, createFile,
> changeSetID, userName) VALUES (1,$1::text,FALSE,9,'postgres');

> outTemp[0]=deletedFiles.fileList[fileListIndex].filename;
> outLengths[0]=strlen(deletedFiles.fileList[fileListIndex].filename);
> formats[0]=0;
> result = PQexecParams(pgConn, query,1,0,outTemp,outLengths,formats,0);

> There obviously is a $1 parameter.

Hm, nothing obviously wrong there.  What PG version is this exactly?
Can you supply a self-contained test case?

            regards, tom lane