Tom Lane writes:
So pg_dump seems off the hook. Can you run the query, attach to the
backend with gdb, and see what it's doing?
As stated on another message tried a ktrace and got nothing.
Trying with gdb.
Is this what you need?
(gdb) bt
#0 0x0811a0a9 in ExecMakeFunctionResult ()
#1
On Fri, Sep 15, 2006 at 02:44:33PM -0800, Poul Jensen wrote:
The other problem I posted is worse and is what's really keeping me
stuck. Why are my text strings considered unacceptable non-integer
constants? Here are the relevant lines of code:
snip
That's because your query is expanding to:
Thank you for your replies. My next attempt was:
for (i=0; iNVARS; i++)
{
sprintf(stmt,SELECT %s FROM beamdata GROUP BY %s;,vars[i],vars[i]);
EXEC SQL EXECUTE IMMEDIATE :stmt;
n_occ[i] = sqlca.sqlerrd[2];
}
It works, but throws error message too few parameters every time. I
need to
On Sat, Sep 16, 2006 at 03:47:28AM -0800, Poul Jensen wrote:
Thank you for your replies. My next attempt was:
for (i=0; iNVARS; i++)
{
sprintf(stmt,SELECT %s FROM beamdata GROUP BY %s;,vars[i],vars[i]);
EXEC SQL EXECUTE IMMEDIATE :stmt;
n_occ[i] = sqlca.sqlerrd[2];
}
I've never
Hi, looking for a little advice...
Nightly, I run a script that does the following (in a nutshell): drop
most of the indexes in a particular schema; load a large amount of data
into this schema; finally recreate the indexes.
The create index process seems to be CPU-bound. The server has four
Am 2006-09-11 10:23:25, schrieb Csaba Nagy:
You can eliminate such things by checking
the Subject line for Re: AW: SV: and such.
:0
* ! ^Subject:.*Re:
* ^Subject:.*(subscribe|subscribel|suscribe)
/dev/null
... which still doesn't cover RE translated in most of the world's
[EMAIL PROTECTED] wrote on 15/09/2006 04:40:04 a.m.:
I wasn't able to find anything the article worth discussing. If you
give up A, C, I, and D, of course you get better performance- just
like
you can get better performance from a wheel-less Yugo if you slide it
down a luge track.
Hi All,
I have SUSE 10.1 and selected LDAP as logon and all works except for
postgresql will not start when the system boots are stop when the
system shutdowns. The system hangs on starting or stopping postgresql
and only a hard reset will do. I do not have this problem with SUSE
10.0.
What does
Thanks for all of your help. I backed up the table and used the PgAdmin
tool to create Insert statements. It did it in two sets. I reran the
first set and it solved the problem.
Seede
Andrews, Chris wrote:
Dunno about quickly, but I usually do something like this (before slapping
myself in
I found in my youth that a mini slides better on it roof than on it's
wheels.
I can top that :). I hit a telephone pole at 135MPH in a 66 Cuda :)
If it hadn't been for the gravel around that corner, I would have beat
the other car too.
I used to dream of hitting 70mph in the mini. I
it returns nill now
or nuthing
and it is very very very slow
Stijn Vanroye wrote:
a schreef:
this doesnt work
SELECT DISTINCT on link *, rank(ts_vec, to_tsquery('default', $qtxt))
FROM feed_entry WHERE ts_vec @@ to_tsquery('default', $qtxt) ORDER
BY rank(ts_vec,
However, keep in mind that Debian Sarge (stable) is currently at
PostgreSQL 7.3. If you're running Sarge, you'll either have to add
Etch (testing) repositories or download the PostgreSQL packages
from Etch repositories. Since Etch is nearing release (which could
mean anything in the Debian
Francisco Reyes [EMAIL PROTECTED] writes:
Trying with gdb.
Is this what you need?
Unfortunately you're not getting anything very sane, which is a common
result with non-debug-enabled builds. Can you rebuild postgres with
--enable-debug (all other options the same) and try again?
Tom Lane writes:
Unfortunately you're not getting anything very sane, which is a common
result with non-debug-enabled builds. Can you rebuild postgres with
--enable-debug (all other options the same) and try again?
Will do.
Should I go with 8.1.4? Since I have to recompile I could install
Francisco Reyes [EMAIL PROTECTED] writes:
Should I go with 8.1.4? Since I have to recompile I could install the
latest. This particular installation has 8.1.3
Sure, use 8.1.4, just be careful not to change any configure options
from what you had.
regards, tom lane
Has nobody an idea what could have happened?
thx,
Peter
-- Weitergeleitete Nachricht --
Subject: Multiple entries of same table in pg_class
Date: Dienstag, 12. September 2006 13:19
From: Peter Bauer [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Hi all,
after extensive
Martijn van Oosterhout wrote:
for (i=0; iNVARS; i++)
{
sprintf(stmt,SELECT %s FROM beamdata GROUP BY %s;,vars[i],vars[i]);
EXEC SQL PREPARE mystmt FROM :stmt;
EXEC SQL EXECUTE mystmt INTO wherever;
n_occ[i] = sqlca.sqlerrd[2];
}
Apologies. I already read this in the docs, but also
Peter Bauer [EMAIL PROTECTED] writes:
after extensive logfilechecking we found out that there are 70 entries
for the same table in pg_class which are identical.
Hm, could we see
select ctid,xmin,cmin,xmax,cmax,oid from pg_class where relname = whatever
regards, tom
Am 2006-09-15 08:41:00, schrieb Alvaro Herrera:
Why didn't it truncate Michelle's but did truncate yours?
From the Mutt-Manual:
``All mail clients suck. This one just sucks less.'' -me, circa 1995
Thats why I love it (even it has no GUI) and it is very strong
RFC-Compliant plus resolving
**
* Do not Cc: me, because I am on THIS list, if I write here *
* Keine Cc: an mich, bin auf DIESER Liste wenn ich hier schreibe *
**
Hello *,
I have a Very big
On Thu, Sep 14, 2006 at 03:41:06AM -0700, Dhanaraj M wrote:
Is there any utility in postgresql which can do the following?
Moving to pgsql-general, which is the appropriate list for this.
The utility must update the table whenever there is any change in the
text file.
COPY command helps to
Jim C. Nasby wrote:
On Thu, Sep 14, 2006 at 03:41:06AM -0700, Dhanaraj M wrote:
The utility must update the table whenever there is any change in the
text file.
Can it be automated?
There's nothing in the database that could do this directly.
I've seen examples where someone did this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/14/06 16:03, [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote on 15/09/2006 04:40:04 a.m.:
[snip]
As a comment on his points though, isn't it better to use the right tool
for the job rather than try to force one tool to do everything? I've
23 matches
Mail list logo