Re: [HACKERS] Login/logout

2005-06-18 Thread Juan Pablo Espino
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

2005-06-18 Thread Juan Pablo Espino
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

2005-06-18 Thread Juan Pablo Espino
Hello all I want to register in an audit table the date and time of the login/logout of a database user. I have been looking for some function in the code but I didn't find something like that. Can you give me some ideas to implement it?. I'm ready to program if it is necessary. Thanks in advanc

[HACKERS] C array from SQL array?

2005-05-19 Thread Juan Pablo Espino
Hello hackers At the moment I need to pass from a SQL array to a C array. I have the following table: CREATE TABLE emps ( name text, array int4[] ) For example, array have this values: {4000,1,0,0} I wrote this function for test in order to see something that could help me: extern Datum

[HACKERS] Returning the name of a primary key

2005-05-16 Thread Juan Pablo Espino
Hello all I need to write a function that retrieve the name of at least one table primary key, if it exists. The only argument passed to the function is the table name. I have thought something like this: char * give_pkey(char * table_char) TupleDesc tupdesc; Form_

[HACKERS] Understanding Rule System

2005-05-11 Thread Juan Pablo Espino
Hello all I have been studying the rule system in Postgres. I understand that the original query tree is the input at the rewrite, and then this query tree is modified by the rewrite in case that there is a rule. SQL query > Parser > Rewrite > Planner > Executor

Re: [HACKERS] Another history question

2005-03-23 Thread Juan Pablo Espino
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

2005-03-22 Thread Juan Pablo Espino
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]

2005-03-17 Thread Juan Pablo Espino
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]

2005-03-17 Thread Juan Pablo Espino
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