From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #9202: C Functions crash database too easily |
Date: | 2014-02-13 16:24:30 |
Message-ID: | 1392308670918-5791875.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
rotten wrote
> While setting up a third party (commerical) provided C library functions
> I've observed PostgreSQL 9.3.2 to be very sensitive to simple typos.
>
> 1) If you create the function with a different number of arguments than
> the
> C function expects, the create works just fine. However, every time you
> do
> a select, the database chokes:
I would hope that the only typos you would be encountering in this use-case
are file-name typos which would correctly generate "file not found" errors.
Complain to the third-party that they are not making your installation easy
enough because they have not provided fully tested scripts for you to run to
setup their library - or ideally the capability to issue "CREATE EXTENSION".
As Tom said, sometimes the solutions are procedural/human in nature and not
something easily solved via technology; especially when portability is a
concern as it is in this project.
Not being a C programmer I cannot comment on how to improve usability in
these situations but the fact remains that as a developer you should be
testing these things in a controlled development environment; and as a user
you should expect it to work (and be provided tests to verify that) and also
to be able to install via file/extension name specification only.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/BUG-9202-C-Functions-crash-database-too-easily-tp5791841p5791875.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2014-02-13 16:40:29 | Re: BUG #9202: C Functions crash database too easily |
Previous Message | David Johnston | 2014-02-13 16:12:37 | Re: BUG #9198: psql -c 'SET; ...' not working |