Thread

Forget [GENERAL] Postgres error.....

PostreSQL Server <postgres@tmt.kaybee.org> — 1998-06-05T19:05:19Z

i figured out what was wrong with it.... thanks anyways..tim

---------- Forwarded message ----------
Date: Fri, 5 Jun 1998 14:33:53 -0400 (EDT)
From: PostreSQL Server <postgres@tmt.kaybee.org>
To: pgsql-general@postgreSQL.org
Subject: [GENERAL] Postgres error.....


i wrote this simple script that exports a large object from database to a
file using the same database that contains a table  which matches the
objOid's to their names.  The script will work sometimes but sometimes it
doesn't.   Any one have any ideas...??? here is the script and the error.


proc export_file_lo { large_object_name filename {db "lo_db"} {host
"localhost"}
 {port "5432"} } {

     global lo_continue
     set conn [pg_connect $db -host $host -port $port]

     set lo_continue "false"

     pg_select $conn "SELECT * from match where name=
	\'$large_object_name\'" result {set objOid [process_result result]}

     if {$lo_continue == "true"} {

          pg_lo_export $conn $objOid $filename
     } else {
          puts "No object associated with name \"$large_object_name\" found."
          pg_disconnect $conn
          return 0
     }

     pg_disconnect $conn
     return 1


}

proc process_result {arrName} {
global lo_continue
upvar $arrName result

     set lo_continue "true"
     set objOid $result(objoid)

     return $objOid
}



Output:

	NOTICE:  SIAssignBackendId: discarding tag 2147483553
	Connection to database failed
	FATAL 1:  Backend cache invalidation initialization failed




thanks,tim