pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
error since upgrading to 9.3.3 plpgsql 2+ messages / 2 participants [nested] [flat]
* error since upgrading to 9.3.3 plpgsql @ 2014-02-21 05:46 Gregory Gincley <rollenwiese@fastmail.net> 0 siblings, 1 reply; 2+ messages in thread From: Gregory Gincley @ 2014-02-21 05:46 UTC (permalink / raw) To: pgsql-admin Greetings, Since upgrading to 9.3.3 on Arch Linux, I have been receiving an error whenattempting to execute or recreate plpgsql functions in mydatabase. I'm not clear if this is an error with the compilation by the Arch package manager or an error with Postgres, or some problem with my database permissions/configuration/plpgsql extension that has not been brought into focus until now. When attempting to execute or create I receive: ERROR: could not load library "/usr/lib/postgresql/plpgsql.so": /usr/lib/postgresql/plpgsql.so: undefined symbol: CheckFunctionValidatorAccess SQL state: 58P01 The does exist in my filesystem. Thanks, Greg -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: error since upgrading to 9.3.3 plpgsql @ 2014-02-21 06:11 Tom Lane <tgl@sss.pgh.pa.us> parent: Gregory Gincley <rollenwiese@fastmail.net> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2014-02-21 06:11 UTC (permalink / raw) To: Gregory Gincley <rollenwiese@fastmail.net>; +Cc: pgsql-admin Gregory Gincley <rollenwiese@fastmail.net> writes: > Since upgrading to 9.3.3 on Arch Linux, I have been receiving an error > whenattempting to execute or recreate plpgsql functions in mydatabase. > ERROR: could not load library "/usr/lib/postgresql/plpgsql.so": > /usr/lib/postgresql/plpgsql.so: undefined symbol: > CheckFunctionValidatorAccess > SQL state: 58P01 You didn't actually restart the server, so you're still running 9.3.2 server, with which 9.3.3 plpgsql.so will not work. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-02-21 06:11 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2014-02-21 05:46 error since upgrading to 9.3.3 plpgsql Gregory Gincley <rollenwiese@fastmail.net> 2014-02-21 06:11 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox