Re: lo_import

Mi amigo:

Según el manual:

<<<<
28.4. Server-Side Functions
There are two built-in server-side functions, lo_import and lo_export, for
large object access, which are available for use in SQL commands. Here is an
example of their use:

CREATE TABLE image (
name text,
raster oid
);

INSERT INTO image (name, raster)
VALUES ('beautiful image', lo_import('/etc/motd'));

SELECT lo_export(image.raster, '/tmp/motd') FROM image
WHERE name = 'beautiful image';These functions read and write files in
the server's file system, using the permissions of the database's owning
user. Therefore, their use is restricted to superusers. (In contrast, the
client-side import and export functions read and write files in the client's
file system, using the permissions of the client program. Their use is not
restricted.)

>>>>

Con gusto,

Mauricio Zea

----- Original Message -----
From: "Roberto Cesar Najera" <rob(at)dcaa(dot)unam(dot)mx>
To: <pgsql-es-ayuda(at)postgresql(dot)org>
Sent: Monday, May 23, 2005 3:11 PM
Subject: [pgsql-es-ayuda] lo_import

> Hola lista, como se le hace para que desde un usuario normal purde
> ejecutar
> la funcion lo_import
>
> me marca el siguiente error
>
> ERROR: must be superuser to use server-side lo_import()
> HINT: Anyone can use the client-side lo_import() provided by libpq.
>
> como cambio este valor para que cualquier usuario o uno en especifico lo
> pueda ejecutar ?
>
> De antemano gracias !
>
>
> ---------------------------(fin del mensaje)---------------------------
> TIP 4: No hagas 'kill -9' a postmaster