Phil Campaigne wrote:


According to the docs you need it if you are going to create your own
functions, however the documentation is a bit *vague*. "If you plan to
do any server-side program development (such as custom functions or data
types written in C), then you may want to install the entire PostgreSQL
include tree into your target include directory." I am working under the
assumption that "custom functions" include any functions you create in
plpgsql, sql, c, etc and not just C functions. I would recommend using
this if you will be working with the database a lot, because you will
probably eventually want to create some of your own functions.


Some of our databases were originally encoded using SQL-ASCII and we
still occasionally have problems when someone enters a character with an
accent (eg in cafe). The jdbc driver won't convert it and the app
'breaks' wrt that data set. So I would recommend that you UNICODE, I
don't believe that it really adds much in the way of overhead, etc.


I suppose that's okay. My very limited understanding of these
directories is that they are used during startup/shutdown to ensure that
services are started and stopped correctly and in the proper order.


Please respond to the list for more questions and cc me (or vice versa)
if you have more questions. This way if anyone else is in a similar
predicament they can read this, and others can contribute and/or correct
me.

Ron



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org