That usually indicates that, for whatever reason, plpgsql.so is from a different version of PostgreSQL than the
databaseserver. If you installed PostgreSQL from source, make sure you configured the server to look in the same lib
diras its libs were installed to; if you've installed from package management of some kind (RPM?) make sure you have
thesame versions of all postgres-related packages.
You should also upgrade, if possible. 7.3 is effectively obsolete (37 releases old); there are a number of bugfixes
andperformance improvements in more recent versions.
-Owen
-----Original Message-----
From: Henry Ortega [mailto:juandelacruz@gmail.com]
Sent: Friday, February 17, 2006 2:06 PM
To: Owen Jacobson
Subject: Re: [SQL] Given 02-01-2006 to 02-28-2006, output all days.
This sounds good. I don't have plpgsql loaded though.
I am trying to load plpgsql and it's giving me:
ERROR: Load of file /usr/lib/pgsql/plpgsql.so failed: /usr/lib/pgsql/plpgsql.so: undefined symbol: xlateSqlType
createlang: language installation failed
I have pgsql 7.3.2
I am googling and can't seem to find the answer. Any help would be appreciated.
On 2/17/06, Owen Jacobson <ojacobson@osl.com> wrote:
Henry Ortega wrote:
(question about set of all days between two dates)
I don't know of a builtin way to do it off the top of my head, but it's a pretty simple function to write:
create function days (start date, finish date) returns setof date as $$
declare curdate date;
begin curdate := start; while (curdate <= finish) loop return next curdate; curdate := curdate + 1; end loop;
return;
end;
$$ language plpgsql;
# select * from days ('2006-02-01', '2006-02-07'); days
------------
2006-02-01
2006-02-02
2006-02-03
2006-02-04
2006-02-05
2006-02-06
2006-02-07
(7 rows)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings