Re: [GENERAL] Insert ImageFile in PostgreSQL

Johan, Try the link below for a sample project clip which you should customise for PostgreSQL. If you need further assistance feel free to contact me. http://www.shepherdhill.biz/downloads/image.zip Cheers. Tope Akinniyi CEO ShepherdHill Software Lagos, Nigeria ---(end

[GENERAL] Trigger Variables

I must commend the efforts of the developers and users of PostgreSQL for new innovations and development. Thank you for giving us such a wonderful DB. I really was impressed with the set of Trigger variables that make internal workings of trigger accessible to users. Of note is an easier way of pe

[GENERAL] The cost of SET search_path TO

Hi, I will appreciate it if anyone can educate me on the cost of using SET search_path TO for schemas at runtime. In particular, for .NET data operations where there may be high rate of connection/disconnection and reconnection for initial data fetching and subsequent updating. Best regards Top

[GENERAL] ~/pgpass

I tried the password file and could not get it to work on both Windows XP and Fedora Core 4. ~/pgpass permission is 0600 on Fedora and I tested using psql and pg_dump commands. The two commands prompted for password and target database which I expected should not be. Please, I seek for clarificat

[GENERAL] SSL Certificate Strictness

I have installed a working SSL Certificates on Windows XPSP2 and Fedora Core 4. The PostgreSQL 8.0.3 Documentation states the following in the creation of SSL certificates for SSL connection: "Fill out the information that openssl asks for. Make sure that you enter the local host name as "Common

Re: [GENERAL] ~/pgpass

Martijn van Oosterhout wrote: >> It's ~/.pgpass the dot is important. > > Thanks. Just a typo error in the mail. I did put the dot in the file name. The file on Fedora is ~/.pgpass and on Windows it is in %APPDATA%/postgresql as pgpass.conf. It did not work in Windows and Fedora. Tope A

Re: [GENERAL] ~/pgpass

Andreas wrote: > On Fedora: wrong file permissions? > Btw.: ~/.pgpass is only supported in 7.3 and later. Thanks. The permission is 0600 on Fedora. But must the file (~/.pgpass) be owned by postgres? Also what could explain the reason why it is not working on Windows XP where permission is no

[GENERAL] SSL Certificate

Hi, I have installed working SSL Certificates on Windows XPSP2 and Fedora Core 4. The PostgreSQL 8.0.3 Documentation states the following in the creation of SSL certificates for SSL connection: "Fill out the information that openssl asks for. Make sure that you enter the local host name as "Comm

Re: [GENERAL] ~/pgpass

> > >>> > On Fedora: wrong file permissions? >>> > Btw.: ~/.pgpass is only supported in 7.3 and later. >> >> >> >> Thanks. >> >> The permission is 0600 on Fedora. But must the file >> (~/.pgpass) be owned by postgres? Also what could explain the >> reason why it is not working on Windows X

[GENERAL] Are these normal?

Hi, I am sorry if I have to post this the third term having not recieved any response on the earlier two posts. I had also checked the archive for a possible answer but could get any. I installed a working SSL Certificate on Windows XPSP2 and Fedora Core 4. The PostgreSQL 8.0.3 Documentation s

[GENERAL] Function Parameters

Hi, Compliments of the season. I tried to create a function with about 60 input parameters and got an error message that a function cannot take more than 32 parameters. Is there a way around this? Or Am I in error? Best regards. Tope -- ---(end of broadcast)--

[GENERAL] PLPHP

Hi, Do we have a Windows version of plPHP? Best regards. Tope. -- ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can ge

[GENERAL] SSL

Hi, The SSL section contains this: If the server demands a client certificate, libpq will send the certificate stored in file .postgresql/postgresql.crt within the user's home directory. A matching private key file .postgresql/postgresql.key must also be present, and must not be world-readabl

[GENERAL] What is the difference?

This SELECT 1 WHERE '95b5a221aeba15c' IN (E'\'' || replace('95b5a221aeba15c+fb4e7219ab898ce+b08586cb81059f9','+',''',''') || E'\'') returns no row while SELECT 1 WHERE '95b5a221aeba15c' IN ('95b5a221aeba15c','fb4e7219ab898ce','b08586cb81059f9') returns a row. What is the difference between E

[GENERAL] Posts not showing

Hi, I wonder why my posts from db.subscripti...@shepherdhill.biz is no longer showing. I had to subscribe with my hotmail again in order to be able to reach the list. I had unsubscribed and subscribed again with nothing has changed. I also mailedpgsql-gene...@postgresql.org but not response.