[GENERAL] is there a function/variable with remote host addr?

2001-09-03 Thread David Ford
As the subject says, is there a function or variable in pg I can use as a default insert/update value on a column that represents the IP or hostname of the current session's remote client? David ---(end of broadcast)--- TIP 6: Have you searched

[GENERAL] How to select using LIKE with bytea?

2001-09-03 Thread David Ford
First a row, then the question. archives=# select * from archives; listname | received_date | header_date | subject | author | | headers

Re: [GENERAL] speed of communication and pgsql development

2001-08-25 Thread David Ford
Bruce Momjian wrote: >We are on #postgresql on Efnet. Have been for years, and mentioned in >the FAQ. Very good for getting development help. I was working with >the PAM patch author there today. > Ugg. I'd rather setup a bot to relay to irc.openprojects.net. EFnet is a sickly beast that ca

Re: MySQL's (false?) claims... (was: Re: [GENERAL] PL/java?)

2001-08-25 Thread David Ford
Sean Chittenden wrote: >>Has anyone seen this page on Mysql.org comparing PostgreSQL to MySQL: >> >> http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_features.html >> > > Yeah, I've had a few developers show it to me... the best part >of this is though, when I tried to post a comment, I g

[GENERAL] A lock to fit a key..

2001-08-19 Thread David Ford
I need to figure out a way to allow users to only be able to update a certain column in a table. Does anyone have any ideas to start with? David ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster