| From: | PostgreSQL Server <postgres(at)alfa(dot)lci(dot)ulsa(dot)mx> |
|---|---|
| To: | Mario Simeone <mario(dot)simeone(at)tin(dot)it> |
| Cc: | pgsql-admin(at)postgreSQL(dot)org |
| Subject: | Re: [ADMIN] Triggers on postgres |
| Date: | 2000-02-17 19:25:24 |
| Message-ID: | Pine.OSF.4.10.10002171250170.27370-100000@alfa.lci.ulsa.mx |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
hello!!
If you already have created the triggers functions, the correct
description of this is in the file:
/postgres/postgresql-6.4.2/contrib/spi/REAME
Depending on the type of trigger or integrity to applY , you must
create functions only on the administrator account (.
To create triggers in other database, in other account:
First, you must give priviledges on the tables where the triggers
will be create. So, you can do it with the sentence CREATE TRIGGER ....
note: before create triggers, you must create the indexes of
database, because the integrity is supported on.!
PS: mY ENGLISH IN NOT GOOD! SORRY!
try it!
if experience any problem , tell us!!
Liliana vicente&o Loya
Universidad La Salle Mex.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bob Zoller | 2000-02-17 21:19:59 | mysql to pgsql |
| Previous Message | list | 2000-02-17 18:46:18 |