(Maybe this thread is dead now, but here goes anyway)
Suggestion: have an environment variable or a PostgreSQL parameter to
indicate where to write the temp-table to. This way, you could easily direct
it to a RAM disk (if small enough) or to a drive other than your main
database. Default could be
> "jj" == jake johnson <[EMAIL PROTECTED]> writes:
jj> I'm trying to install (from source) DBD::Pg v1.01 after having
jj> installed (from source) DBI v1.19 on FreeBSD 4.3 (Release) and I
jj> encounter this error in the 'make test' step:
jj> dell_box# make test
jj> PERL_DL_NONLAZY=1 /usr/bin/
playpen=# select a, sum(b) as dsum from taba where dsum > 5 group by(a);
ERROR: Attribute 'dsum' not found
Why can we GROUP BY on an alias but not do a WHERE on an alias? I have a subselect
that
explain shows is being run twice if I have to put it in the WHERE clause.
--
Joseph Shraibman
[E
Christopher Sawtell wrote:
>
> On Fri, 24 Aug 2001 06:52, Zot O'Connor wrote:
> > Other SQL servers have the concept of stored procedures having different
> > permissions.
> >
> > For instance a procedure that can update a table.
> >
> > Since a web site typically connects as the webuser (or equi
23 Aug 2001 11:52:25 -0700, Zot O'Connor
> Other SQL servers have the concept of stored procedures having different
> permissions.
>
> For instance a procedure that can update a table.
>
> Since a web site typically connects as the webuser (or equiv postgres
> user), I do not want to offer
