Re: [HACKERS] How to allocate a global variable (to implement virutal databases)

2006-04-29 Thread Juan Manuel Diaz Lara
Thanks, but from the vail site "windows sorry"... I am working in windows.   I was thinking in a simply implementation, with only global variables used with the rule system.   I can write the c code for this.Tom Lane <[EMAIL PROTECTED]> wrote: Juan Manuel Diaz Lara <[EMAI

[HACKERS] How to allocate a global variable (to implement virutal databases)

2006-04-29 Thread Juan Manuel Diaz Lara
I would like to implement a row-level security for application-level-user (the user is not a postgresql user), I wish to restrict access to rows in diferent tables based on this application-level-user. My idea is to use rules to rewrite queries based on the contents of a global variable that is set

[HACKERS] Problem compiling from cvs, mingw

2006-04-14 Thread Juan Manuel Diaz Lara
I get the following error:   gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Winline -fno-strict-aliasing -I. -I../../../src/include -I./src/include/port/win32 -DEXEC_BACKEND  "-I../../../src/include/port/win32" -DBUILDING_DLL  -c -o bootparse.o bootparse.cbootparse.y:101:10: "b4_file_name" i

[HACKERS] How to implement oracle like rownum(function or seudocolumn) ?

2006-04-08 Thread Juan Manuel Diaz Lara
I need a rownum column, like Oracle. I have searched the mailing lists and I don't see a satisfactory solution, so I was wondering write a UDF to implement it, the requirements are:   1. Need to preserve state between calls to the function (the rowcount). Maybe using a MemoryContext with a lifesp

[HACKERS] Rigth toolset to compile under mingw?

2006-04-05 Thread Juan Manuel Diaz Lara
I have tried to compile 8.1.3 with mingw but I am receiving come errors, I do not know with versions are the correct one.   Could some body tell me the right versions ? and url's to download from ? please. I searched the mainling lists but it is not clear.   Thanks.Atte.Juan Manuel Díaz Lara

[HACKERS] Problem compiling with mingw

2006-04-01 Thread Juan Manuel Diaz Lara
I run configure (no complains about bison o flex), after a few seconds I receive the next errors:   make[4]: Leaving directory `/pgsql/src/backend/access/nbtree'make -C transam SUBSYS.omake[4]: Entering directory `/pgsql/src/backend/access/transam'make[4]: `SUBSYS.o' is up to date.make[4]: Leavin