pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Dmitry Tkach <dmitry@openratings.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Denis Zaitsev <zzz@anda.ru>
Cc: pgsql-sql@postgresql.org
Subject: Re: Very strange 'now' behaviour in nested triggers.
Date: Mon, 28 Jul 2003 13:06:27 -0400
Message-ID: <3F255813.1000401@openratings.com> (raw)
In-Reply-To: <15184.1059411161@sss.pgh.pa.us>
References: <20030726193947.B1636@natasha.ward.six>
	<9412.1059229904@sss.pgh.pa.us>
	<20030727020104.A19865@natasha.ward.six>
	<4629.1059320950@sss.pgh.pa.us>
	<3F2552BF.5060100@openratings.com>
	<15184.1059411161@sss.pgh.pa.us>

>
>
>Data entry.  You don't necessarily have the option to invoke a function,
>as opposed to just sending a string for the datetime input parser.
>(It would be rather difficult for an application to allow this one case
>without permitting SQL-injection attacks, I'd think.)
>
>  
>
Does it mean that the *application* (not the database) user would then 
have to know the exact specific way to represent the current time in his 
data entry form?
Such an application looks like (how do I say it politely?) not a very 
user-friendly one to me :-)

Dima





view thread (17+ messages)  latest in thread

Message-ID: <3F255813.1000401@openratings.com>
Permalink:  ../3F255813.1000401@openratings.com/
Also on:    postgresql.org/message-id/3F255813.1000401@openratings.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: dmitry@openratings.com, tgl@sss.pgh.pa.us, zzz@anda.ru
  Subject: Re: Very strange 'now' behaviour in nested triggers.
  In-Reply-To: <3F255813.1000401@openratings.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox