Re: [GENERAL] PostgreeSQL C header files

2004-01-12 Thread joseph speigle
hi, I have done work on sourceforge for my c++ cgi library. It is at http://sourceforge.net/projects/cgiutils2/ It is built up of 3 separate libraries, the cgi library which parses post requests and gets form values and such, a session library, and a template library which uses a custom parse

Re: [GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

2004-04-01 Thread joseph speigle
hi ryan, I think something is wrong with your --with-module line in the configure. Syntax should be --with-module=module-type:module-file Enable module-file in the modules/ but it's not in modules/aaa {just downloaded this from their site} [EMAIL PROTECTED] httpd-2.

Re: [GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

2004-04-01 Thread joseph speigle
M -0500, Ryan Riehle wrote: > I'm using mod_auth_pgsq, version 2.0.1... it's for use with apache 2.0.x got > it from their site: http://www.giuseppetanzilli.it/mod%5Fauth%5Fpgsql2/ > > -Ryan > > > -Original Message- > From: [EMAIL PROTECTED] > [ma

[GENERAL] korean encoding, sort order off anyhow

2004-06-16 Thread joseph speigle
hi, To see the query results in native language see http://database.sarang.net/?inc=read&aid=5368&criteria=pgsql&subcrit=qna&id=&limit=20&keyword=&page=1 the simpler url is http://database.sarang.net/?criteria=pgsql becase there is no korean postgresql list. poster is "joesp" basically the c

Re: [GENERAL] mysql2postgres has no documentation?

2004-06-30 Thread joseph speigle
> I have dump my databases qith mysqldump and put the > result in a file ( named basisdata ). > > In order to make it be possible to be reloaded with > psql, I want to convert the file with > "mysql2pgsql.perl" tool. > > But I don't know the syntax. > > I tried this : > " > mysql2pgsql.perl basi

[GENERAL] substring syntax with regexp

2004-06-30 Thread joseph speigle
hi, Does anybody know offhand what is the correct way to use substr to extract the domain name from a client_referer column as logged by mod_pgsqllog (httpd module), by correcting the following: the file 'hostname.sql' is pl/pgsql main=> \e hostname.sql ERROR: syntax error at or near "http"

Re: [GENERAL] How to add an userA to login postgresadmin

2004-07-02 Thread joseph speigle
stephen, try adding the user like you normally would. Did you know the system users and database users are not necessarily the same person? With that in mind, after adding the user, create an alias in .bashrc like alias psql='/usr/local/psql -U postgresadmin -d my_db_name' Furthermore, in /hom