On Aug 13, 2007, at 9:50 AM, Tom Lane wrote:
"Terri Reid" <treid@xxxxxxxxxxxxxxxxxxx> writes:
I have data that is being updated in a table that I need to export
to a flat
file via a database trigger on insert or update. The user
performing the
update will not be a superuser. I've tried to use COPY TO, but
that doesn't
work for non-superusers.
It will if invoked in a trigger function that's marked SECURITY
DEFINER
and owned by a superuser.
Also/Or, make sure the that the correct filesystem write permissions
are set on the file/directory to which you're writing for which ever
user whose permissions the trigger function is executed as.
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
