Re: SQL safe input? - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: SQL safe input?
Date
Msg-id 20050827235413.GA11234@wolff.to
Whole thread Raw
In response to Re: SQL safe input?  (<operationsengineer1@yahoo.com>)
Responses Re: SQL safe input?  (<operationsengineer1@yahoo.com>)
List pgsql-novice
On Sat, Aug 27, 2005 at 16:22:51 -0700,
  operationsengineer1@yahoo.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.

pgsql-novice by date:

Previous
From:
Date:
Subject: Re: SQL safe input?
Next
From:
Date:
Subject: Re: SQL safe input?