On 2/28/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
select procpid, usename, now()-query_start from pg_stat_activity where
current_query like '%IDLE%' and now()-query_start > interval '5
minutes';
to list all the users that have been idle over the interval in the
list. Using some kind of scr
In Postgresql 7.3, a datatype can be int, text, etc, and also
pseudo-types like RECORD, any, etc.
These pseudo types are mainly used in CREATE FUNCTIONs, but what if it's
used in a CREATE TABLE, esp. when the name of another table is used as a
datatype?
e.g.
-- Just for illustration:
CREATE T
Christopher Browne wrote:
In the last exciting episode, [EMAIL PROTECTED] (David Link) wrote:
Why does adding SUM and GROUP BY destroy performance?
When you use SUM (or other aggregates), there are no short cuts to
walking through each and every tuple specified by the WHERE clause.
Er... not in
Christopher Browne wrote:
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] wrote:
MySQL can tell you from it's index because it doesn't care if it gives you the
right number or not.
Under what circumstances would MySQL give the wrong number?
It would give the wrong number under _e
Dennis Gearon wrote:
Isn't HKSC one of the languages supported by UNICODE? I thought they had
every langauge past and present in it.
You'll have to map HKSCS to UNICODE yourself before the data hits
postgresql, and data out of postgresql would be in UNICODE, and up to
you to convert back to HKS
CY wrote:
I wanted a auto-increasement function, similar to sequence, to increase
a field. I cannot use CREATE SEQUENCE because it cd_line_no will start
again with a new coursedetail.
CREATE TABLE coursedetail
(
cd_cf_id char(30),
cd_line_no smallint default auto_increment b
On 3/19/06, Hrishikesh Deshmukh <[EMAIL PROTECTED]> wrote:
> Can somebody please tell me where i can find rpms for postgesql on OpenSuse
> 10.0?
opensuse10 comes with PostgreSQL 8.0.1, installable once you configure
the installation sources correctly. (See
http://en.opensuse.org/Mirrors_Released_V
On Mon, Oct 13, 2008 at 11:57 AM, Mikkel Høgh <[EMAIL PROTECTED]> wrote:
> In any case, if anyone has any tips, input, etc. on how best to configure
> PostgreSQL for Drupal, or can find a way to poke holes in my analysis, I
> would love to hear your insights :)
It'd be more accurate to configure
On Tue, Oct 14, 2008 at 8:56 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> On Tue, Oct 14, 2008 at 3:40 AM, Ivan Sergio Borgonovo
> <[EMAIL PROTECTED]> wrote:
>> On Mon, 13 Oct 2008 20:45:39 -0600
>> "Joshua Tolley" <[EMAIL PROTECTED]> wrote:
>>
>> Premise:
>> I'm not sustaining that the "default"
On Tue, Oct 14, 2008 at 10:05 PM, Martin Gainty <[EMAIL PROTECTED]> wrote:
> MG>comments prefixed with MG>
> MG>What about INNODB is Drupal forgetting the default engine for 5.x?
I don't use MySQL for drupal myself except for testing, but Drupal
just uses the default storage engine for MySQL, whi
10 matches
Mail list logo