<div>
So enter the value for filename or alter table and remove &quot;not null&quot; constraint
</div>


<div>
you mean i cannot use ? in this case?
</div>


<div>
You cannot enter null value into &quot;not null&quot; field in any SQL database. You get error from SQL backend telling this, no problem with perl&amp;drivers
</div>


<div>
but i didnt enter a value to it by using ? to match the search
</div>


<div>
but i did enter a value it it by using ? to match the search...
</div>


<div>
Then you did not enter value in some particular case.
</div>


<div>
im currently use DBD:PgPP0.05(postgresql) driver<br />
<br />
as i had try to print $InsertFileProcessed-&gt;bind<wbr />_param(1,$<wbr />Folder) and there is a value in it but cannot pass to sub initialisedatabase.<br />
<br />
is it because PgPP does not support bind_param?<br />
<br />
below is my code<br />
&nbsp;<br />
&nbsp;<br />

<pre><code class="code-10 nolinks" id="code-262814"><span>...</span>
<span>                if ($fileTimestamp&gt;$lastFileReadTime) {</span>
<span>                    $InsertFileProcessed-&gt;bind_param(1,$FolderName);</span>
<span>                    print $InsertFileProcessed-&gt;bind_param(1,$Folder).&quot;\n&quot;;</span>
<span>                    $InsertFileProcessed-&gt;bind_param(2,$name);</span>
<span>                    $InsertFileProcessed-&gt;bind_param(3,$fileTimestamp);</span>
<span>                    $InsertFileProcessed-&gt;execute();</span>
<span>                    $InsertFileProcessed-&gt;finish();</span>
<span>               }           </span>
<span> </span>
<span>sub INITIALISEDATABASE {</span>
<span>$dbh=DBI-&gt;connect(</span>
<span>        &quot;dbi:PgPP:dbname=$dbname;$dbhost;$dbport&quot;,$UserName,$Password,{RaiseError=&gt;1,AutoCommit=&gt;1,LongTruncOk=&gt;1}) or die &quot;Can't connect to database \n&quot;;</span>
<span> </span>
<span>printf &quot;Connected: State is %s\n&quot;, $dbh-&gt;state || &quot;OK&quot;;</span>
<span> </span>
<span> </span>
<span> $sql=&quot;INSERT INTO $schemaName.LASTFILEDOWNLOAD (FOLDERNAME,FILENAME,FILETIME) VALUES (?,?,TO_TIMESTAMP(?, 'YYYY MM DD HH:MI'))&quot;;</span>
<span>  $InsertFileProcessed=$dbh-&gt;prepare($sql);</span>
<span>}</span>
</code></pre>
</div>


<div>
If you get error on prepare() then it is definetly a bug - if you can repeat the problem with psql then report bug with postgresql, if it is only with DBD then report about DBD module.<br />

</div>


<div>
??<br />
do you mind to repeat yourself <br />
i dont understand...
</div>


<div>
use psql.<br />
there execute PREPARE INSERT INTO...<br />
<br />
If you get error it is backend bug, otherwise all your drivers.
</div>


<div>
launch psql on your server.<br />
<br />
inside that prepare your insert statement followed by semicolon like there:<br />
<a href="http://www.postgresql.org/docs/current/static/sql-prepare.html" rel="ugc">http://www.postgresql.org/docs/current/static/sql-prepare.html</a><br />
<br />
record errors, terminate psql with \q<br />
<br />

</div>


<div>
thanks for your documentation for prepare() mind to show me the documentation for bind_param?
</div>


<div>
I am not talking about prepare() perl statement.<br />
I suggest that you use psql(.exe) to repeat error against PostgreSQL server.<br />
what prepare is expected to do - is to use SQL PREPARE and call parametrized named SQL afterwards.
</div>


<div>
i Found the answer, the reason i get the error message is because the driver version i use does not support bind_param with ?.<br />
i change PgPP.pm v0.05 to v0.06 it works now.<br />
thank you
</div>


<div>
you found answer to different question in different piece of code.
</div>


<div>
Then please tell me the solution
</div>


<div>
If you have better answer to handle this please do let me know and the point will be yours. Thank you
</div>


<div>
Obvious try when driver blocks some SQL feature is to get it at latest level. Just that you did not go through diagnosing if it is driver problem or something worse.
</div>


<div>
yah, it is because i have no much experience in postgresql and that why i pay to experts-exchange to get some advice. Hope some one will help me and shorten my time on debugging.<br />
<br />
I need to thank you for helping me .<br />
cheers
</div>


<div>
thanks for your effort. appreciate it.<br />
thanks
</div>


<div>
Good luck, you are not expert in everything, but using common sense worked just fine.
</div>


<div>
<div class="content wysiwyg-content">
i received message below:<br />
DBD::PgPP:: st execute failed: ERROR: null value in column &quot;filename&quot; violates not null constraint.<br />
<br />
Below is my code<br />
<br />
$sql=&quot;INSERT INTO EMP.LASTDOWNLOADTIME(REMOT<wbr />EFOLDERNAM<wbr />E,FILENAME<wbr />,FILETIME)<wbr /> VALUES (?,?,TO_TIMESTAMP('2009 10 22 14:25', 'YYYY MM DD HH:MI'))&quot;;<br />
&nbsp; &nbsp;$output=$dbh-&gt;prepare($sql<wbr />);<br />
<br />
what is wrong?
</div>
</div>


i received message below:
DBD::PgPP:: st execute failed: ERROR: null value in column "filename" violates not null constraint.

Below is my code

$sql="INSERT INTO EMP.LASTDOWNLOADTIME(REMOTEFOLDERNAME,FILENAME,FILETIME) VALUES (?,?,TO_TIMESTAMP('2009 10 22 14:25', 'YYYY MM DD HH:MI'))";
   $output=$dbh->prepare($sql);

what is wrong?

DBD::PgPP:: st execute failed: ERROR: null value in column &quot;filename&quot; violates not null constraint.

PostgreSQL is an object-relational database management system with an emphasis on extensibility and standards-compliance. As a database server, its primary function is to store data securely, supporting best practices, and to allow for retrieval at the request of other software applications. PostgreSQL implements the majority of the SQL2011 standard, is ACID-compliant and transactional using multiversion concurrency control (MVCC), and handles complex SQL queries using many indexing methods that are not available in other databases. It is cross-platform and runs on many operating systems including Linux, FreeBSD, OS X, Solaris, and Microsoft Windows.

DBD::PgPP:: st execute failed: ERROR: null value in column &quot;filename&quot; violates not null constraint.

DBD::PgPP:: st execute failed: ERROR: null value in column "filename" violates not null constraint.