Skip site navigation (1) Skip section navigation (2)

Re: ERROR: invalid datatype 'FILE'

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: Michael Wood <esiotrot(at)gmail(dot)com>
Cc: Andrej <andrej(dot)groups(at)gmail(dot)com>, Amish <amish(dot)pandya(at)in(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: ERROR: invalid datatype 'FILE'
Date: 2011-02-02 13:38:55
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Michael Wood wrote:
> I'll have to object to the "bug free" comment :)
> You don't check if the fopen() call succeeded.
> Also, if this code is run as root (e.g. from a cron job) then a local
> user could convince it to overwrite any arbitrary file just by
> creating a symlink in /tmp pointing to the file to overwrite (assuming
> /tmp/aaa doesn't exist before the malicious user creates the symlink,
> of course.)
You are correct, I admit my programming sins. With two bugs in two lines 
of code, I am as good as Microsoft or Oracle. I'll have to start making 
contributions to the Postgres community.

Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251 

In response to


pgsql-novice by date

Next:From: Michael WoodDate: 2011-02-02 14:08:13
Subject: Re: ERROR: invalid datatype 'FILE'
Previous:From: Michael WoodDate: 2011-02-02 07:56:58
Subject: Re: ERROR: invalid datatype 'FILE'

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group