Hi there,
I wonder if anyone can shed some light on a very frustrating problem.
I'm running a debian linux 3.0 "woody" server, nothing special, with
the latest version of postres that apt-get will allow me, which I
*think* it;s 7.1 something, I don't know how to figure out the
postgres version. Anywho - I'm trying to backup my databases, which I
did at one point, but I have no idea what happened, could have been an
upgrade. My Dbs have large objects in them, so I would do the
following as per the man pages:
pg_dump -S postgres -Ft -b mydb > mydb.tar
But i'd always get the following error message:
pg_dump: handler procedure for procedural language plpgsql not found
And even with the most simple of pg_dumps, I would still get that
error, with a 0 sized file to show for it.
Does anyone have any ideas on how to fix this?
Thanks,
Mark 4 4442 mm****@brocku.c a (Mark Mikulec) writes: But i'd always get the following error message: pg_dump: handler procedure for procedural language plpgsql not found
Do you have any functions written in plpgsql? (I'm guessing not, or you
would have other problems besides pg_dump not working.) If not, you can
just delete the pg_language entry for plpgsql:
DELETE FROM pg_language WHERE lanname = 'plpgsql';
If you do have any such functions, you should drop them first.
(Alternatively, let pg_dump find them for you, and drop them in response
to its complaints.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Unfortunately,
That didn't work.
Thanks anyway.
----- Original Message -----
From: "Tom Lane" <tg*@sss.pgh.pa .us>
To: "Mark Mikulec" <mm****@badger. ac.brocku.ca>
Cc: <pg***********@ postgresql.org>
Sent: Tuesday, August 12, 2003 9:54 AM
Subject: Re: [GENERAL] Help! Can't pg_dump anything: handler procedure for
procedural language plpgsql not found mm****@brocku.c a (Mark Mikulec) writes: But i'd always get the following error message: pg_dump: handler procedure for procedural language plpgsql not found
Do you have any functions written in plpgsql? (I'm guessing not, or you would have other problems besides pg_dump not working.) If not, you can just delete the pg_language entry for plpgsql:
DELETE FROM pg_language WHERE lanname = 'plpgsql';
If you do have any such functions, you should drop them first. (Alternatively, let pg_dump find them for you, and drop them in response to its complaints.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Ok,
I'm really getting the impression that something is fishy about my version
of Postgres.
So I created the language using createlang, (BTW - I'd create it with a user
that has the ability to create db's and users, not the super Postgres -
should I always do it with the superuser postgres?) - it ended up giving an
error of: ERROR: Zero-Length delimited identifier.
Tried pg_dump - still didn't work. So I took tom lane's suggestion, only I
used the droplang command and after that, it succeeded! Ok, so try to
restore, I dropped my test database, created it again, then called
pg_restore on my tar, and I got:
pg_restore: [archiver (db)] could not execute query: ERROR: function
plpgsql_call_ha ndler already exists with same argument types
Which doesn't makes to sense to me, because I dropped the language! I'm
connecting as a superuser I created, into a newly created database. How
could this be?
Thanks in advance,
Mark
----- Original Message -----
From: "Richard Huxton" <de*@archonet.c om>
To: "Mark Mikulec" <mm****@badger. ac.brocku.ca>;
<pg***********@ postgresql.org>
Sent: Tuesday, August 12, 2003 4:35 AM
Subject: Re: [GENERAL] Help! Can't pg_dump anything: handler procedure for
procedural language plpgsql not found On Tuesday 12 August 2003 01:41, Mark Mikulec wrote: Hi there,
I wonder if anyone can shed some light on a very frustrating problem.
I'm running a debian linux 3.0 "woody" server, nothing special, with the latest version of postres that apt-get will allow me, which I *think* it;s 7.1 something, I don't know how to figure out the postgres version. psql --version
Anywho - I'm trying to backup my databases, which I did at one point, but I have no idea what happened, could have been an upgrade. My Dbs have large objects in them, so I would do the following as per the man pages:
pg_dump -S postgres -Ft -b mydb > mydb.tar
But i'd always get the following error message:
pg_dump: handler procedure for procedural language plpgsql not found
You presumably have a plpgsql function defined but have lost the
definitions to handle this (I can't think how). Try a "createlang plpgsql mydbname"
(man createlang for details).
If you use apt-get to update PG's code, I'd recommend dumping databases
before the upgrade, just in case. -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
"Mark Mikulec" <mm****@brocku. ca> writes: Tried pg_dump - still didn't work. So I took tom lane's suggestion, only I used the droplang command and after that, it succeeded! Ok, so try to restore, I dropped my test database, created it again, then called pg_restore on my tar, and I got:
pg_restore: [archiver (db)] could not execute query: ERROR: function plpgsql_call_ha ndler already exists with same argument types
Which doesn't makes to sense to me, because I dropped the language!
Sounds to me like you have a definition (possibly a broken one) in
the template1 database, where it will be copied by CREATE DATABASE.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Dave |
last post by:
After following Microsofts admonition to reformat my system before doing a
final compilation of my app I got many warnings/errors upon compiling an rtf
file created in word. I used the Help Workshop program: hcw.exe that's
included with Visual Basic. This exact same file compiled perfectly with no
notes, warnings or errors prior to...
|
by: Sarir Khamsi |
last post by:
Is there a way to get help the way you get it from the Python
interpreter (eg, 'help(dir)' gives help on the 'dir' command) in the
module cmd.Cmd? I know how to add commands and help text to cmd.Cmd
but I would also like to get the man-page-like help for classes and
functions. Does anyone know how to do that? Thanks.
Sarir
|
by: Woody Splawn |
last post by:
For reasons I have not yet identified I am having problems with the help
system in VS.net 2003. It seems as though it was working all right in the
past but it's not now. First of all I can't seem to get my search and help
icons to stay on the screen when in VS. In order to access the search
dialog I have to access the help menu and then...
|
by: Colin J. Williams |
last post by:
Python advertises some basic service:
C:\Python24>python
Python 2.4.1 (#65, Mar 30 2005, 09:13:57) on
win32
Type "help", "copyright", "credits" or "license" for more information.
>>>
With numarray, help gives unhelpful responses:
|
by: Bruce Dodds |
last post by:
I recently started using Access 2003 for the first time. I wanted to
pass on some comments about the Help system to Access MVPs who frequent
this board. I'm doing this in the hope that some of what I say may be
passed on to Microsoft.
Microsoft has implemented a combination local and web based help system
in Access 2003. The local Help...
| |
by: Tim Marshall |
last post by:
I'm putting together my first help file (using Easy Help,
http://www.easyhelp.com/). So far, so good. I'm able to use the Help
File and Help Context ID to have things from my help file pop up when F1
is pressed.
But how do I do this when my Access App screen is empty? A hidden form?
Also, how do I have a menu item that pulls up the...
|
by: stuart_white_ |
last post by:
I've just upgraded from Python 2.3.3 to Python 2.4.2, and, although the
new version of Python seems to be running correctly, I can't seem
access the help from the interpreter.
On Python 2.3.3
---------------
Python 2.3.3 (#51, Dec 18 2003, 20:22:39)
on win32
Type "help", "copyright", "credits" or "license" for more information.
>>>...
|
by: JJ |
last post by:
Ok I have now got to grips with HTML help workshop and created my help
files, TOC etc.
Now how do I integrate this with my application? I have added an
errorprovider to my form and pointed it to my hhp file, but I am not sure
which is the correct next step.
Specifically my questions are:
1. How do I get the index, table of contents menu...
|
by: trunxnirvana007 |
last post by:
'UPGRADE_WARNING: Array has a new behavior. Click for more: 'ms-help://MS.VSCC.v80/dv_commoner/local/redirect.htm?keyword="9B7D5ADD-D8FE-4819-A36C-6DEDAF088CC7"'
'UPGRADE_WARNING: Couldn't resolve default property of object Label. Click for more:...
|
by: PaulS |
last post by:
new to Fedora7, typed python in interactive interpreter, then help(). Then
modules to get a list of modules. Then module name to get info on a module
but no help file. What is the help file name? Is there an environmental
variable I have to set? Thanks,
Paul
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |