I use tomcat+linux_postgresql+jsp to develop
system.
I start postgresql with 1024 processes.
FE:
postmaster -i -S -N 1024 -B 2048 -D
/var/lib/pgsql/data
My jsp doesn't implement connection pool.It directly connects
postgresql by jdbc.
After I run the Ui some times, the UI(
So, I met such a problem: it's impossible to use NEW in a subselect
used in a (non-select) rule. The error is: . Is this a way to do that newertheless (without using of a
function, of course)?
Thanks in advance.
---(end of broadcast)---
TIP 9: the
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 *appli
Dmitry Tkach <[EMAIL PROTECTED]> writes:
> 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
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
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
Tom Lane wrote:
I put up a proposal in pgsql-hackers to change this behavior:
http://archives.postgresql.org/pgsql-hackers/2003-07/msg00818.php
If we made that change then the "wrong" way of defining the default
would fail in an obvious fashion --- the 'now' would get reduced to a
particular time
Oliver,
> CREATE VIEW my_view AS SELECT b,c
> (SELECT a, b FROM table2 WHERE b=1) my_ab,
> (SELECT c FROM table3, my_ab WHERE table3.a=my_ab.a) my_c;
This isn't possible in PostgreSQL, and I'm not sure it's possible anywhere.
HOWEVER, if you put your subselects in the FROM clause instead, like
Dmitry Tkach <[EMAIL PROTECTED]> writes:
> Why not get rid of 'now' alltogether? Are there any cases when it is
> actually useful as opposed to now()?
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 wo
On Wed, Jul 23, 2003 at 14:51:48 +0200,
[EMAIL PROTECTED] wrote:
> I want to use the result of a subselect as condition of another one.
The two selects you use ar both from items at the same level and hence can't
reference one another. In your example below you could just use a join.
> CREATE V
