• Don't hide errors. Use use strict; and use warnings;.

• user=postgres
  [download]

  should be

  'postgres'
  [download]

  As is, it means

  'user' = 'postgres'
  [download]

  and it doesn't make sense to assign to a constant string.

• You have an argument missing. While the option hash is optional, the password isn't. It must appear between the user name and the option hash, even if it's only ''.

• I don't think quotes are allowed around the dbname. They're definitely not needed.

  "DBI:Pg:dbname='five'; port=5432"
  [download]

  should be

  "DBI:Pg:dbname=five;port=5432"
  [download]

• ... or just

  "DBI:Pg:dbname=five"
  [download]

  since port 5432 is the default.

Update: Added last two bullets.

this is only the piece of the error, there is more, so I use strict.

I now changed it into this:


#!usr/bin/perl

use 5.6.1;

use strict;
use warnings;
use DBI;

my$dbh = DBI->connect("DBI:Pg:dbname=five; port=5432", 'postgres', '',
+{ RaiseError => 1, AutoCommit => 0 })
or die "kon de database niet openen!";
[download]


and now I get this:
DBD::Pg::db do failed: ERROR: parser: parse error at or near "voor" at character 94
DBD::Pg::db do failed: ERROR: parser: parse error at or near "voor" at character 94

and what is the meaning of that?

DBD::Pg::dbdo failed: ERROR: parser: parse error at or near "voor" at character 94

So it worked, cause you made it to some $dbh->do call further down.

From the DBD::Pg documentations section on the connect method:

"The following connect statement shows almost all possible parameters:"

$dbh = DBI->connect("dbi:Pg:dbname=$dbname;host=$host;port=$port;optio
+ns=$options",
    $username,
    $password,
    {AutoCommit => 0, RaiseError => 1, PrintError => 0}
    );   );
[download]

So try:

my$dbh = DBI->connect("DBI:Pg:dbname=five;port=5432", 
'postgres',
'',
{ RaiseError => 1, AutoCommit => 0 }) or die "kon de database niet ope
+nen!";
[download]

Update: Changed wording of the opening sentence.

Update 2: Added blank password, thanks erix

Hope this helps

Martin

yes it worked ;) I get now a new error of something else so I can now look at it.

well, that is acactly my problem, if I don't use quotes, use single quotes or double quotes... It doesn't matter :S

look:
with double quotes:
Can't modify constant item in scalar assignment at geheeldb.txt line 9, near ""postgres","

with single quotes:
Can't modify constant item in scalar assignment at geheeldb.txt line 9, near "'postgres',"

with no quotes at all:
Can't modify constant item in scalar assignment at geheeldb.txt line 9, near "postgres,"

I said, use 'postgres' as the second argument. I did not say to use user='postgres' as the second argument.