Hi,
I doing a log to my DB. For this, I writing a trigger that inserts in a
log table the user, date, table changed and values changed.
I was trying to do a generic procedure and use it on all tables, like
this:
create function sp_log() returns opaque as '
declare
Em 10 Jul 2001, Raymond Chui escreveu:
In other database systems, such as Informix, Sybase, etc. The database
is stored
in the raw disk partitions, you can config the database system into
different
partitions, different disks, slice into different trunks, etc. But
PostgreSQL
Em 05 Apr 2001, Cedar Cox escreveu:
To this I say, remember that you are using a database! I would split this
into 3 tables (people, exams, answers). Then only the 'answers' table
would contain 3M records. Should be a bit faster. You don't want to have
to store the person and
Hi all,
I wrote a function that call another functions, like this:
FUNCTION (...) AS '(...)BEGIN
PERFORM FUNCTION1();
PERFORM FUNCTION2();
(...)
END;' LANGUAGE 'PLPGSQL';
The problem is that takes a long time to execute (I stoped after three
days executing). To see