Re: [GENERAL] FUNCTION problem

Sky wrote: HI everybody ! I have a problem, but I don't know the solution: CREATE TABLE person( user_id SERIAL NOT NULL, uid CHARACTER(20) NOT NULL, pwd CHARACTER(20) NOT NULL, PRIMARY KEY (user_id) ); OK, That's right... CREATE FUNCTION getuserid (CHARACTER(20),CHARACTER(20)) RETURNS SETO

Re: [GENERAL] 7.2.3-7.4.2 migration

Thanks for your advices. Christophe Le jeu 01/04/2004 à 17:28, Tom Lane a écrit : Richard Huxton <[EMAIL PROTECTED]> writes: > On Thursday 01 April 2004 12:12, Christophe Musielak wrote: >> First, is it possible to upgrade directly from 7.2.3 --> 7.4.2 : ie dump >> the 7.2.3 datas, upgrade t

Re: [GENERAL] FUNCTION problem

Sky <[EMAIL PROTECTED]> writes: > SELECT user_id FROM person WHERE uid=$1 AND pwd=$2; > ERROR: Unable to identify an operator '=$' for types 'character' and > 'integer You need spaces: SELECT user_id FROM person WHERE uid= $1 AND pwd= $2; This is fixed as of PG 7.4, IIRC. Prior to that it's

[GENERAL] FUNCTION problem

HI everybody ! I have a problem, but I don't know the solution: CREATE TABLE person( user_id SERIAL NOT NULL, uid CHARACTER(20) NOT NULL, pwd CHARACTER(20) NOT NULL, PRIMARY KEY (user_id) ); OK, That's right... CREATE FUNCTION getuserid (CHARACTER(20),CHARACTER(20)) RETURNS SETOF INTEGER AS

Re: [GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

ryan, did you do this? - edit config_vars.mk vi build/config_vars.mk add "-I/usr/local/pgsql/include" to the end of EXTRA_INCLUDES add "-lpq -L/usr/local/pgsql/lib" to the end of EXTRA_LIBS ? On Fri, Apr 02, 2004 at 12:49:43AM -0500, Ryan Riehle

Re: [GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

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] [mailto:[EMAIL PROTECTED] On Behalf Of joseph speigle Sent: Thursday, April 01, 2004 10:

[GENERAL] Loading text files into a text attribute

Hello folks, I have the following problem: I have a bunch of text files, I want to load them into a table where each file will be stored in one row. Question 1: Is there any way how to do this in psql? AFAIK the \copy command interprets \n as a new line and so I can't get it done what I want. S

Re: [GENERAL] Select Union

Randall Skelton <[EMAIL PROTECTED]> writes: > As you suggested, while this is much shorter in length, it is > considerably longer in execution. >> SELECT t1.timestamp FROM ( >> SELECT timestamp FROM cal_quat_1 UNION >> SELECT timestamp FROM cal_quat_2 UNION >> SELECT timestamp FROM cal_quat_3 UNI

Re: [GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

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] row-level security model

Marc, On Apr 1, 2004, at 4:21 PM, Marc Durham wrote: Do you think this would work? There are a lot of joins. And I assumed it would need to look up the parent's and teacher's usernames, and that your many-to-many relationships were in tables like students_parent_link. Thanks very much -- this

[GENERAL]

Trying to upgrade to Apache 2.0.49 and getting compile errors related to mod_auth_pgsql: make[1]: Entering directory `/usr/src/httpd-2.0.49' /usr/src/httpd-2.0.49/srclib/apr/libtool --silent --mode=link gcc -pthread -I/ =500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE -DAP_HAVE_DESIGNATED_INITIALI

[GENERAL] Problems compiling Apache 2.0.49 with mod_auth_pgsql

Hi All! Trying to upgrade to Apache 2.0.49 and getting compile errors related to mod_auth_pgsql, any clue?: make[1]: Entering directory `/usr/src/httpd-2.0.49' /usr/src/httpd-2.0.49/srclib/apr/libtool --silent --mode=link gcc -pthread -I/ =500 -D_BSD_SOURCE -D_SVID_SOURCE -D_GNU_SOURCE -DAP_HAVE