Re: SQL safe input?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: operationsengineer1(at)yahoo(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL safe input?
Date: 2005-08-27 23:54:13
Message-ID: 20050827235413.GA11234@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, Aug 27, 2005 at 16:22:51 -0700,
operationsengineer1(at)yahoo(dot)com wrote:
>
> if bad data is submitted, is there something going on
> "behind the scenes" to scrub the bad data and cause
> the query to fail instead of run with the bad data?
> how does the the system know the data is bad data?

The type input routines will reject bad data. I wouldn't feel too safe about
handling really large strings without a problem in all cases, but invalid
syntax shouldn't cause anything but the transaction to abort.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-08-28 01:55:54 Re: SQL safe input?
Previous Message operationsengineer1 2005-08-27 23:22:51 Re: SQL safe input?