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

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)

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

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) ?

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?

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

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

Re: [HACKERS] Login/logout

Hi, thanks for the response. On 6/18/05, Rod Taylor <[EMAIL PROTECTED]> wrote: > On Sat, 2005-06-18 at 11:46 -0500, Juan Pablo Espino wrote: > > Thanks for the quick response. Yes I want to retrieve the > > login/logout info, but I want to insert this info in a table that

Re: [HACKERS] Login/logout

Thanks for the quick response. Yes I want to retrieve the login/logout info, but I want to insert this info in a table that I use as an audit table. Regards Juan P. Espino On 6/18/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Sat, Jun 18, 2005 at 11:11:31AM -0500, Juan Pablo Esp

[HACKERS] Login/logout

Thanks in advance, regards Juan P. Espino ---(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 get through to the mailing list cleanly

[HACKERS] C array from SQL array?

s 137606808 I wanted that n1 collects the data of the SQL array. I really appreciate any suggestions, thanks in advance, regards. Juan P. Espino PS. I ignore if the term I'm using SQL array is correct. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] Returning the name of a primary key

} return pstrdup(NameStr(att->attname)); } Sorry, I don't have much experience in c programming, thanks in advance for any suggestions, regards, Juan P. Espino ---(end of broadcast)--- TIP 9: the planner will ignore your d

[HACKERS] Understanding Rule System

ce code it's implemented. Any comments are welcome, thanks in advance. Juan P. Espino ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Developer Community

Jim, So I interpret that simply proposing work and doing it are all the requirements needed. Thank you. Regards, -- Juan Jose Costello Levien E-Mail: [EMAIL PROTECTED] Web: http://jcostello.ath.cxOn 4/27/05, Jim C. Nasby <[EMAIL PROTECTED] > wrote:See http://www.postgresql.or

[HACKERS] Developer Community

Hello, My name is Juan, and I am interested in being a PostgreSQL Developer. I would like to contribute with items in the TODO list. I am new to the list, and would like to know if you have reservations or beliefs applicated to the members of the developer community, so if I can enter to it or I

[HACKERS] Case Sensitivity

Is there a way to set case sensitivity on?   Thanks in advance juan

Re: [HACKERS] Another history question

Thanks for the explanation. Then, Can I say that PostgreSQL and Informix are cousins? On Tue, 22 Mar 2005 17:36:28 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Juan Pablo Espino <[EMAIL PROTECTED]> writes: > > My question is if the architecture of postgreSQL were inhe

[HACKERS] Another history question

I know that postgres was a project directed by Michael Stonebraker in Berkeley (1986-1994) and that soon Jolly Chen and Andrew Yu did postgres95. I understand that the main change in postgres95 was to implement SQL instead of POSTQUEL. Then after the appearance of postgres95 postgreSQL 6.0 arises

Re: [HACKERS]

Sorry it was for [EMAIL PROTECTED] On Thu, 17 Mar 2005 18:08:03 -0500, Juan Pablo Espino <[EMAIL PROTECTED]> wrote: > set pgsql-hackers nomail > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please s

[HACKERS]

set pgsql-hackers nomail ---(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 get through to the mailing list cleanly

[HACKERS] Label Security

know if someone has working in a similar way and your opinion about my comment.  Thanks a lot and sorry for my not very well english,   Juan Espino

[HACKERS] segment default

do it. Sorry for my english but only spoke spanish -- L.I. JUAN PATRICIO FLORES HERNANDEZ Desarrollador Departamento de Tecnologias de la Informacion EDICIONES TRATADOS Y EQUIPOS S.A. DE C.V. ETESA Vista Hermosa No. 100 Col. Lomas del Estadio Jalapa, Veracruz CP 91090 Tel:+52 228 841 7000 ext 2217,

[HACKERS] Problem with postgres's date

How is posible show the date in european format. By defalut it's ISO. I can show with "SET datestyle=postgres" but is validate from one sesion only. Thanks ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.

[HACKERS] Error: files pg_psort.*

¿What is this file? ¿what can I do? One of this file is of 2.6 Bbytes the DB is of 50 Mb Is urgent. Thanks you. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere"

[HACKERS] Error: file pg_psort*

¿What is this file? ¿what can I do? One of this file is of 2.6 Gb the DB is of 50 Mb Is urgent. Thanks you. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl