That usually indicates that, for whatever reason, plpgsql.so is from a different version of PostgreSQL than the database server. If you installed PostgreSQL from source, make sure you configured the server to look in the same lib dir as its libs were installed to; if you've installed from package management of some kind (RPM?) make sure you have the same 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 and performance improvements in more recent versions. -Owen -----Original Message----- From: Henry Ortega [mailto:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
