Re: [GENERAL] Functions documentations

[Charset iso-8859-1 unsupported, filtering to ASCII...] > Hi !! > > I am looking for a complete list of functions we have under PostgreSQL. > > Where can I found this documentation ? > > If there is no documentation, I would be please to write one with samples. > In this case, send me your > ex

[GENERAL] efficient remote bulk uploads

Hi, I have some questions regarding how to efficiently upload quite large amounts of data into PostgresSQL remotely. The tables I will be loading will consist of rows containing a) 1 character column of no more than 20 or 30 characters. b) a timestamp c) lots of positive integers (20-40). the i

[GENERAL] Doas trigger functions see oid field...?

How can I read oid field from any table in trigger function... When I try to read oid... postgres says ... record old has no field oid Is this posible to read oid field from trigger function...? --Greg--

Re: [GENERAL] ld.so failed

Hello, > > Did you add your pg libraries path into /etc/ld.so.conf > > (/usr/local/postgres/libs is mine) and run ldconfig? > > I searched the whole tree from / for ld.so.conf but did not find one. Add the path in /etc/rc.conf to ldconfig_paths. Then reboot. Did not help. :-( C. -- C

Re: [GENERAL] ld.so failed

Hello, >From the command line as root run the following: /sbin/ldconfig -m /usr/local/pgsql/lib/ Did not help C. -- Carsten Huettl - pgp-key on request

Re: [GENERAL] ld.so failed

Hello, > I searched the whole tree from / for ld.so.conf but did not find one. freebsd doesn't really use one. you can manually add the path with "ldconfig -R /path" you can make the change permanent by adding the path to the ldconfig parameter int /etc/rc.conf. alternately, you can include

Re: [GENERAL] jdbc problem

>I am using postgresql under linux. Now that I need to >build up the jdbc driver for postgresql, when I make >under the directory /src/interfaces/jdbc.. I get an >error stating '(u' unexpected syntax... > >The version returned by the make is 1.0b4. The >makeVersion.java file returns jdbc0 as t