Matthew,
Gee thanks ..
I just read over Stephan's Set Returning Function last night ..
I was trying to see how I could use it.
> Hope that is what you were after!
Indeed it is. Your 'rough and ready solution' solution is a
mighty fine place to begin.
Thanks aplenty to you and Achilleus for ta
Hi Rudi,
You can't trigger on a SELECT, but you could wrap your SQL in a set
returning function...
http://techdocs.postgresql.org/guides/SetReturningFunctions
Here is a rough and ready solution:
CREATE TABLE access_log ( id int not null );
CREATE TABLE datatable (
id int not null prim
Achilleus,
Thanks - I'll look into that.
Cheers
Regards
Rudi.
> Rudi, i would suggest using a proved framework
> for logging.
>
> Why dont you try to build a function in PHP
> that acts as syslog.
> .i.e you have
> facility (name of your app/page)
> priority (usually e.g. info in your case)
> a
Rudi, i would suggest using a proved framework
for logging.
Why dont you try to build a function in PHP
that acts as syslog.
.i.e you have
facility (name of your app/page)
priority (usually e.g. info in your case)
action (what to do with the message, file, apache log, pgsql insert etc..)
Then in
Thanks Achilleus,
I know there's a couple of ways I could do this.
In my first email I can see a senario of 1 select plus 100 inserts.
Another may be 1 select plus 1 insert.
For example;
In a table of 3000 rows a user submits a query which returns 100 rows.
I could loop through the result se
Thats why people who want entreprise apps
must use enterprise frameworks.
In J2EE for instance you could use LOG4J
which is sorta equivalent of syslog for java.
See if there is a logging module for PHP.
PgSQL has no clue of who the user is.
I dont think delegating this logging task
to pgSQL is
Hi,
I have an application where user's can view records in a short form with
their first select
and view a long form with a second select.
The first view I term an impression.
The second view I term a click.
I'd like to log the impression's and click's.
I'm wondering which is the most effiecient
