f



Update from 7.3.3 to 7.3.6

Hi,

We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red
Hat). However, we are having a number of problems importing the database
schema. Some of the SPs are written in TCL and it would seem that the
library has changed.

In the dump of the schema we have (comments removed for brevity):

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;

CREATE FUNCTION pltcl_call_handler () RETURNS language_handler
    AS '$libdir/pltcl', 'pltcl_call_handler'
    LANGUAGE c;

CREATE TRUSTED PROCEDURAL LANGUAGE pltcl HANDLER pltcl_call_handler;

However, when importing we get:

ERROR:  stat failed on file '$libdir/pltcl': No such file or directory

What is the best way of sorting this out?

Cheers & TIA

Mike



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

0
mike
8/9/2004 3:14:43 PM
comp.postgresql.admin 1725 articles. 0 followers. ashok (20) is leader. Post Follow

1 Replies
1817 Views

Similar Articles

[PageSpeed] 32

"Mike Bell" <mike.bell@hashdefine.co.uk> writes:
> We are in the process of moving from PostgreSQL 7.3.3 to 7.3.6 (Red
> Hat). However, we are having a number of problems importing the database
> schema. Some of the SPs are written in TCL and it would seem that the
> library has changed.

> ERROR:  stat failed on file '$libdir/pltcl': No such file or directory

Hmm.  The most obvious question is did you remember to install the
postgresql-tcl RPM?

"pg_config --pkglibdir" will tell you what directory $libdir expands to,
and you can look in there to see if there's a pltcl.so or not.  It
appears from the above that the answer will be "not".

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

0
tgl
8/9/2004 3:54:41 PM
Reply:

Similar Artilces:

GnuPG / PGP signed checksums for PostgreSQL 7.4.5, 7.4.4, 7.3.7, 7.3.6, 7.3.5. 7.2.5
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 This is a PGP-signed copy of the checksums for following PostgreSQL versions: 7.4.5 7.4.4 7.3.7 7.3.6 7.3.5 7.2.5 The latest copy of the checksums for these and other versions, as well as information on how to verify the files you download for yourself, can be found at: http://www.gtsm.com/postgres_sigs.html ## Created with md5sum: 97e750c8e69c208b75b6efedc5a36efb postgresql-7.4.5.tar.bz2 bffc3fe775c885489f9071e97f43ab9b postgresql-base-7.4.5.tar.bz2 548a73c898e65f901dbc06d622a2bc63 postgresql-docs-7.4.5.tar.b...

Upgrading 7.3 to 7.3.3
We've had a 7.3 PG installation running for awhile now, and would like to upgrade to 7.3.3. The doc implies that you can do something other than dump your existing database, set up the new installation, and reload the dump, if you're upgrading within the 7.3 'line.' But after looking around for awhile, I don't see any guidance on how to do this. Is it anything more than moving the existing installation out of the way, installing the new one in the usual way, then copying the old PGDATA directory? (Instead of doing the initdb.) That would certainly save some...

Problem installing postgresql 7.3.6 on Redhat 7.3
Dear group, I would like to know where I could find rpms for Redhat 7.3. I have looked at the downloads page and I see only source rpms and rpms for Redhat 9 and FC1. I did download the src rpm and when I run the rpm -ba postgresql.spec I get the following error message: configure: error: could not find function 'krb5_encrypt' required for Kerberos 5 error: Bad exit status from /var/tmp/rpm-tmp.93268 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.93268 (%build) How do I get over this. Regards, Shan. -------...

A problem during restoring database from PostgreSql 6.5.3/7.1.3 to 7.4
Hello �� I can dump data from old dababase(Postgresql 6.5.3), but new problem came out when I restore the data to postgresql 7.4. It went out during the COPY command, if I do it in such command lines: 1. pg_dump news -f pgsql-database-news.sql #in old system with postgresql 6.5.3 2. su - postgres #in new system with postgresql 7.4 3. createdb -T template0 news 4. psql news < pgsql-database-news.sql ------ ERROR: missing data for column "user_id" CONTEXT: COPY newses, line 1: ------ But if I do it in such command line, it works well : 1. pg_d...

User-defined SQL Function has slower query in 7.3.3 than 7.1.3 postgresql server
I have this QUERY (below) that PostgreSQL 7.3.X servers run MUCH slower than the 7.1.3 server does. It makes sense that both servers have to do a sequential scan over the ZIPCODE column. There are over 7,500 rows in the LOCATIONS table. Does anyone know what changed in the planner or optimizer? Can I change the postgresql.conf file to improve 7.3.3 performance? Situation --------- Here is the situation... PG 7.1.3 returns QUERY in about 4 seconds. The EXPLAIN plan says it uses the index on country. PG 7.3.3 simply does not return QUERY. I've waited over 3 minutes. With...

After install 7.3.4, I got a 7.3.3 ver. no?
After install PostgreSQL 7.3.4, I got a 7.3.3 version no? $ psql template1 Welcome to psql 7.3.3, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit template1=# select version(); version ---------------------------------------------------------------------------- ---- --------- PostgreSQL 7.3.3 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 ...

(S)RPMs for PostgreSQL 7.2.6, 7.3.8 and 7.4.6 are ready
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, (S)RPMs for new point releases (per http://archives.postgresql.org/pgsql-announce/2004-10/msg00010.php) have been built for Fedora Core 1&2, Red Hat Linux 9 and Red Hat Enterprise Linux 3. They are (or will be after sync) available in the PostgreSQL FTP site and its mirrors. Check http://www.PostgreSQL.org/mirrors-ftp.html for the nearest FTP mirror. Also, bittorent users can download the latest, greatest sources and RPMs from http://bt.postgresql.org/ . (Thanks to David Fetter) Regards, - -- Devrim GUNDUZ d...

pgsql: Update release history for releases 7.4.6, 7.3.8, 7.2.6.
Log Message: ----------- Update release history for releases 7.4.6, 7.3.8, 7.2.6. Modified Files: -------------- pgsql/doc/src/sgml: release.sgml (r1.301 -> r1.302) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/release.sgml.diff?r1=1.301&r2=1.302) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend ...

Problem installing matplotlib 1.3.1 with Python 2.7.6 and 3.3.3 (release candidate 1)
Hello, I tried to install matplotlib 1.3.1 on the release candidates of Python 2.7.6 and 3.3.3. I am on Mac OS X 10.6.8. Although the installation gave no problems, there is a problem with Tcl/Tk. The new Pythons have their own embedded Tcl/Tk, but when installing matplotlib it links to the Frameworks version of Tcl and TK, not to the embedded version. This causes confusion when importing matplotlib.pyplot: objc[70648]: Class TKApplication is implemented in both /Library/Frameworks/Python.framework/Versions/2.7/lib/libtk8.5.dylib and /Library/Frameworks/Tk.framework/Versions/8.5/Tk....

[RELEASED] Release candidates for Python 2.6.8, 2.7.3, 3.1.5, and 3.2.3
We're pleased to announce the immediate availability of release candidates for Python 2.6.8, 2.7.3, 3.1.5, and 3.2.3 . The main impetus for these releases is fixing a security issue in Python's hash based types, dict and set, as described below. Python 2.7.3 and 3.2.3 include the security patch and the normal set of bug fixes. Since Python 2.6 and 3.1 are maintained only for security issues, 2.6.8 and 3.1.5 contain only various security patches. The security issue exploits Python's dict and set implementations. Carefully crafted input can lead to extremely long computation...

[RELEASED] Release candidates for Python 2.6.8, 2.7.3, 3.1.5, and 3.2.3
We're pleased to announce the immediate availability of release candidates for Python 2.6.8, 2.7.3, 3.1.5, and 3.2.3 . The main impetus for these releases is fixing a security issue in Python's hash based types, dict and set, as described below. Python 2.7.3 and 3.2.3 include the security patch and the normal set of bug fixes. Since Python 2.6 and 3.1 are maintained only for security issues, 2.6.8 and 3.1.5 contain only various security patches. The security issue exploits Python's dict and set implementations. Carefully crafted input can lead to extremely long computation times a...

[RELEASED] Second release candidates for Python 2.6.8, 2.7.3, 3.1.5, and 3.2.3
We're chuffed to announce the immediate availability of the second release candidates for Python 2.6.8, 2.7.3, 3.1.5, and 3.2.3. The only change from the first release candidates is the patching of an additional security hole. The security issue fixed in the second release candidates is in the expat XML parsing library. expat had the same hash security issue detailed below as Python's core types. The hashing algorithm used in the expat library is now randomized. A more thorough explanation of the "hash attack" security hole follows. The main impetus for these rele...

[RELEASED] Second release candidates for Python 2.6.8, 2.7.3, 3.1.5, and 3.2.3
We're chuffed to announce the immediate availability of the second release candidates for Python 2.6.8, 2.7.3, 3.1.5, and 3.2.3. The only change from the first release candidates is the patching of an additional security hole. The security issue fixed in the second release candidates is in the expat XML parsing library. expat had the same hash security issue detailed below as Python's core types. The hashing algorithm used in the expat library is now randomized. A more thorough explanation of the "hash attack" security hole follows. The main impetus for these releases is fi...

Web resources about - Update from 7.3.3 to 7.3.6 - comp.postgresql.admin

Saturday Night Live Weekend Update Thursday - Wikipedia, the free encyclopedia
Saturday Night Live Weekend Update Thursday is an American limited-run series broadcast on NBC . It is a political satire news show spin-off ...

Gizmodo.com Updates
Nobody should have to use a pay phone , natural disaster or no natural disaster. So if your gadgets are out of juice after Sandy, here’s a tiny ...

Lifehacker.com Updates
By Whitson Gordon Ever run into a situation where you have multiple wireless networks available, but one is clearly better than the other? WiFi ...

Facebook Messenger For Android Update Includes Conversation Shortcuts
Facebook released an update to its Android Messenger application that incorporates the group -creation and message forwarding features in last ...

Why the feature-light iOS 9.2.1 security update matters
Three days ago Apple released an iOS 9.2.1 update with seemingly arbitrary ‘security updates and bug fixes’ listed in the release notes. As we’ve ...

Moving Day: Exercise update
Since we have so many guys and gals getting on the heavy-duty fitness bandwagon, here's my update. Friday is mostly Heavy Calisthenics Day for ...

Status Update – Persistent Issues Require More Troubleshooting
... status recap: In order to solve the “page link” issue for the controls at the bottom of the page, the theme support folks told me to update ...

Apple could be making a big change to the way it updates iPhone software
Apple made a big deal out of the latest update to its mobile operating system, iOS 9.3, which, traditionally, would have been a smaller, more ...

First Hill Streetcar launch party planned — only question is when — UPDATE: SATURDAY SOFT LAUNCH
As of last Wednesday, Seattle Department of Transportation officials have a plan for the event to launch the First Hill Streetcar including a ...

Undertale adds mysterious new content in latest update
Undertale has received an update which adds new content and dialogue, even though the patch was said to only "fix bugs and increase compatibility." ...

Resources last updated: 1/24/2016 5:35:44 AM