thanks for the response. you were right about setting the env variable.
that cleared up the 'bad appl version' error. subsequently, i got it to
the point where
the connection attempt just hung, and hitting C at the psql prompt
caused a "stop batch process?" msg. I stopped at that point.
we are
On Tuesday 06 June 2006 18:44, Leif B. Kristensen wrote:
> On Wednesday 7. June 2006 00:10, Jim C. Nasby wrote:
> >Moving to -general.
> >From the bottom of that page:
> >
> >SELECT * FROM sources INTO src WHERE source_id = $1;
> >
> >SELECT * is generally something to avoid. You end up shoving
On Tuesday 06 June 2006 19:29, Ilir Gashi wrote:
> Hello,
>
> My name is Ilir Gashi and I am a PhD student at the Centre for Software
> Reliability, City University, London, UK. I was wondering if anyone can
> help me with the following question:
>
> - Are the numbers of downloads of a particular r
Hi!
I need to make a plpgsql function and I only think on a multidimensional
array to make this function BUT I know that multidimensional arrays are
not supported in plpgsql so, I wanna to receive some ideas from this list.
Our system have a proprietary way to make his "ENCODING" , for exampl
I dont know the answer to your question, but I think that you forgot
somethingmost linux distributions have postgresql included.so,
(I dont know the number) some people that use it, didnt download from
postgresql site or mirrors...
Ilir Gashi wrote:
Hello,
My name is Ilir Gashi and I
Hello,
My name is Ilir Gashi and I am a PhD student at the Centre for Software
Reliability, City University, London, UK. I was wondering if anyone can
help me with the following question:
- Are the numbers of downloads of a particular release of the PostgreSQL
server recorded anywhere centra
On Wednesday 7. June 2006 00:10, Jim C. Nasby wrote:
>Moving to -general.
>From the bottom of that page:
>
>SELECT * FROM sources INTO src WHERE source_id = $1;
>
>SELECT * is generally something to avoid. You end up shoving around
> more data than needed. Granted, in this case it's only gettin
Moving to -general.
On Fri, Jun 02, 2006 at 10:45:14PM +0200, Leif B. Kristensen wrote:
> Don't know if it's relevant here, but I've recently launched the third
> article in a series on my transition from shrink-wrapped genealogy
> software on Windows to my own custom PostgreSQL/PHP application
John Sidney-Woollett <[EMAIL PROTECTED]> writes:
> I don't think that null values are indexed - you'll probably need to coalesce
> your null data value to some value if you want it indexed.
That is most definitely not true for Postgres. NULL values are included in the
index.
However NULLs sort
On 6/5/06, Martijn van Oosterhout wrote:
Yeah, I was working on it but got stuck on the planner/optimiser
changes. In the mean time the tree drifted and lack of interest, which
gets us where we are now...
Very bad news :-(
I were looking forward to this feature... So many troubles in my
proje
On Tue, Jun 06, 2006 at 12:27:33PM -0400, Carlos Oliva wrote:
> Thank for your response Alan. This indeed corrects the problem as long as
> we configure the database to enable_seqscan=false.
If you have to do that, something is still wrong. Do you have
accurate statistics? Is the planner mistak
Hello,I would like to know if it is possible to create a trigger function which does something likeCREATE OR REPLACE FUNCTION table_audit() RETURNS TRIGGER AS $table_audit$BEGIN INSERT INTO audit SELECT TG_OP, current_timestampmp, current_user, OLD, NEW;
RETURN NEW;END $table_audit$ LANGUAGE plp
I don't think that null values are indexed - you'll probably need to
coalesce your null data value to some value if you want it indexed.
You can coalesce those value back to null when you retrieve the data
from the query.
John
Carlos Oliva wrote:
Thank for your response Alan. This indeed c
Thank for your response Alan. This indeed corrects the problem as long as
we configure the database to enable_seqscan=false.
Perhaps, you can help me with a side effect of using this index: Rows with
null dates seem to fall off the index. When the ordschdte is null, the
query fails the rows of
The point is, it hangs around: in backup 'tapes' to begin with.
And if it's the case of postmaster history, there may be lots of other
people passwords to find. (So I generaly disable postmaster
psql_history, but that's a nuicence).
But as I said, it's a sort of a nuicence, not really an issue.
On June 6, 2006 07:59 am, "Carlos Oliva" <[EMAIL PROTECTED]> wrote:
> We are conducting a simple test to asses if the optimizer ever uses the
> index. The table has several columns and the select statement is as
> follows: select * from ord0007 order by prtnbr, ordschdte desc. The
> index that we
Are there any configurations/flags that we should re-set for
the database (v 7.4.x) in order to enable a backwards scan on an index?
We are trying to query a table in descending order. We added an index
that we were hoping would be scanned backwards but EXPLAIN never indicates that
the op
Rafal Pietrak <[EMAIL PROTECTED]> writes:
> psql clinet tool loggs issued commands into ~/.psql_history, which is
> VERY usefull. I exercise grep-ing the file extensively.
> But when it comes to command like "ALTER/CREATE USER ... PASSWORD" I'd
> rather have it NOT logged.
The history file is onl
> how about:
> create index nimib2 on firma1.klient(lower(nimi) varchar_pattern_ops);
> ^^^
Hakan, thank you.
Excellent.
It works.
Andrus.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subsc
David Fetter <[EMAIL PROTECTED]> writes:
> On Mon, Jun 05, 2006 at 07:03:59PM -0300, Daniel Henrique Alves Lima wrote:
>> Yes, i know, we are using a jurassic version of postgresql and we
>> should try to upgrade first, but that is the next step. Now we've to
>> make sure that 7.3.3 will work with
On Tue, 06 Jun 2006 09:37:16 -0400
Jacob Coby <[EMAIL PROTECTED]> wrote:
> Bill Moran wrote:
>
> > 2) require_once() and include_once() are truly evil.
>
> Can you elaborate a bit on this? Privately if you want since it's off
> topic for this list.
They're evil. They are a bad idea gone horri
Bill Moran wrote:
On Tue, 06 Jun 2006 09:19:10 -0400
Jacob Coby <[EMAIL PROTECTED]> wrote:
We recently upgraded from php 4.3.10 to 5.1.2, and the %system time has
skyrocketed:
Cpu(s): 42.8% us, 43.6% sy, 0.0% ni, 11.3% id, 2.2% wa, 0.2% hi, 0.0% si
Mem: 8312844k total, 7566168k used,
On Tue, 06 Jun 2006 09:19:10 -0400
Jacob Coby <[EMAIL PROTECTED]> wrote:
> We recently upgraded from php 4.3.10 to 5.1.2, and the %system time has
> skyrocketed:
>
> Cpu(s): 42.8% us, 43.6% sy, 0.0% ni, 11.3% id, 2.2% wa, 0.2% hi, 0.0% si
> Mem: 8312844k total, 7566168k used, 746676k fr
We recently upgraded from php 4.3.10 to 5.1.2, and the %system time has
skyrocketed:
Cpu(s): 42.8% us, 43.6% sy, 0.0% ni, 11.3% id, 2.2% wa, 0.2% hi, 0.0% si
Mem: 8312844k total, 7566168k used, 746676k free,22356k buffers
Swap: 2040244k total, 520k used, 2039724k free, 69203
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Will there need to be a new version of DBD::Pg released for 8.1.4?
No, DBD::Pg escapes everything with double quotes instead of a backslash,
and uses its own escaping routines, not the libpq ones. Therefore, the
existing version (latest is 1.49) s
Have you tried Druid (http://druid.sourceforge.net/index.html) ?
It does anything a good ERD designer do and it's free...
BTJ
On 5 Jun 2006 16:54:56 -0700
[EMAIL PROTECTED] wrote:
> tedia2sql for DIA seems pretty strange, in that it seems to require you
> to use UML diagrams, rather than ER Di
Maybe you should check that you're linking against the libraries you
think you are. For example, run ldd over both apache and the pgsql
module and check they have similar ideas as to which libraries they're
using.
Make sure you don't have multiple copies of postgres installed, or
multiple copies
Yavuz Kavus wrote:
hi everybody.
The problem is that:
my both table has 10 records.
when i run this query on first table :
select * from tb_section_phones;
it lasts 0.02 sec.
when i run this query on second table :
select * from tb_section_phones_temp;
it lasts 0.13 sec.
6.5 time
[EMAIL PROTECTED] wrote:
Seems like the open source data modeling tools aren't feature-rich
quite yet.
Disclaimer: this is probably *not* what you want, but I will throw it
out for completeness.
We have a non-graphical tool that builds databases out of text files
that resemble CSS, such a
tedia2sql for DIA seems pretty strange, in that it seems to require you
to use UML diagrams, rather than ER Diagrams, to forward engineer a
database - e.g. output DDL statements.
Am I misreading what tedia2sql does, or is does one have to use
repurpose UML diagrams to get DDL statements created?
Hi Andrus,
how about:
create index nimib2 on firma1.klient(lower(nimi) varchar_pattern_ops);
^^^
> explain analyze select nimi from firma1.klient where lower(nimi) like
> 'mokter%'
>
> "Total runtime: 0.877 ms"
> explain analyze se
>do you have an index on klient (lower(nimi))?
Yes. As I wrote in first message, I created index explicity for this test
sample:
create index nimib2 on firma1.klient(lower(nimi) bpchar_pattern_ops);
Andrus.
---(end of broadcast)---
TIP 1:
# [EMAIL PROTECTED] / 2006-06-06 11:58:26 +0300:
> How to force postgres to use index for the following query (I can change the
> query to equivalent if required)
>
> select nimi from klient where lower(nimi) like 'test%'
do you have an index on klient (lower(nimi))?
--
How many Vietnam ve
How to force postgres to use index for the following query (I can change the
query to equivalent if required)
select nimi from klient where lower(nimi) like 'test%'
Currently it does NOT use index:
create index nimib2 on firma1.klient(lower(nimi) bpchar_pattern_ops);
explain analyze select nimi
Just wondering,
psql clinet tool loggs issued commands into ~/.psql_history, which is
VERY usefull. I exercise grep-ing the file extensively.
But when it comes to command like "ALTER/CREATE USER ... PASSWORD" I'd
rather have it NOT logged.
This is not a major issue, since there are workarounds -
35 matches
Mail list logo
