Neal Clark wrote:
my $sth = $dbh-prepare(qq{SOME_QUERY});
$sth-execute;
while (my $href = $sth-fetchrow_hashref) {
# do stuff
}
[...]
So with mysql, I can just say $dbh-{'mysql-use-result'} = 1, and
then it switches so that the fetchrow_hashref calls are actually
fetching
David,
you need http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch_snowball_82.gz -
patch for 8.2 release, which updates snowball API.
You need it only for the new stemmers from sbowball site !
I'm not sure if it will apply for 8.1.8.
Oleg
On Sun, 11 Mar 2007, David Gama
Le samedi 10 mars 2007 06:32, Oleg Bartunov a écrit :
On Fri, 9 Mar 2007, Jean-Michel Pour? wrote:
Le vendredi 09 mars 2007 ЪЪ 10:58 +0100, Magnus Hagander a ЪЪcrit :
No idea. Assuming you want to do it beforehand. otherwise, just create
the index and see how large it got?
Thank you for
Hi.
I wrote a simple c stored procedure that accepts only one text parameter
that i want to convert to a c string.
The problem is that i obtain the C string correctly but with spurious
characters at the end... I use these calls to obtain the c string:
text *t_myfield = PG_GETARG_TEXT_P(0);
char
Albe Laurenz [EMAIL PROTECTED] writes:
So there is no automatic way of handling it.
You will probably have to consider it in your code and use
SELECT-Statements
with a LIMIT clause.
Either that, or explicitly DECLARE a CURSOR and use FETCH from that
cursor in batches. You can do this in
On Sat, 10 Mar 2007 00:37:08 -0500, [EMAIL PROTECTED] (Tom Lane) wrote:
in [EMAIL PROTECTED]
Stefan Berglund [EMAIL PROTECTED] writes:
Below is a small test case that illustrates what I'm attempting which is
to provide a comma separated list of numbers to a procedure which
subsequently uses
I am running 8.1.4 and the o.* notation works.
Thanks again,
Sorin
Need Mail bonding?
Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=listsid=396546091
Hi-
Below is a small test case that illustrates what I'm attempting which is
to provide a comma separated list of numbers to a procedure which
subsequently uses this list in a join with another table.
My questions are is this a set based solution and is this the best
approach in terms of using
Le samedi 10 mars 2007 à 08:32 +0300, Oleg Bartunov a écrit :
btw, we're working on new FTS feature of PostgreSQL, it's basically
tsearch integrated into the pg core. But it has some new features and
new SQL commands for configuring of FTS, so if the matter is not
pressing I'd recommend
to
On Sat, 10 Mar 2007 08:26:32 +0300 (MSK), oleg@sai.msu.su (Oleg
Bartunov) wrote:
in [EMAIL PROTECTED]
I don't know if you could change your schema. but I'd consider your
problem as a overlapping arrays task and use contrib/intarray for that.
Oleg
I can very definitely change my schema at this
Am Montag, 12. März 2007 12:47 schrieb Denis Gasparin:
I wrote a simple c stored procedure that accepts only one text parameter
that i want to convert to a c string.
The problem is that i obtain the C string correctly but with spurious
characters at the end... I use these calls to obtain the c
Hi,
The PostgreSQL of a customer database (running on Windows 2003) crashed
and wrote the messages below in the logfile. According to the customer
the drives are working OK, partitions are not full and nothing has
changed in the permissions. The customer could restart the PostgreSQL
service
On Mon, Mar 12, 2007 at 02:20:44PM +0100, Joost Kraaijeveld wrote:
Hi,
The PostgreSQL of a customer database (running on Windows 2003) crashed
and wrote the messages below in the logfile. According to the customer
the drives are working OK, partitions are not full and nothing has
changed in
On Mon, 2007-03-12 at 14:39 +0100, Magnus Hagander wrote:
What version of PostgreSQL is this?
Oh, forgotten: 8.1.x with no upgrade option (company policy)
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
web:
On Mon, Mar 12, 2007 at 02:46:22PM +0100, Joost Kraaijeveld wrote:
On Mon, 2007-03-12 at 14:39 +0100, Magnus Hagander wrote:
What version of PostgreSQL is this?
Oh, forgotten: 8.1.x with no upgrade option (company policy)
It looks to me that you may be a victim of the bug patched in
Peter Eisentraut ha scritto:
Am Montag, 12. März 2007 12:47 schrieb Denis Gasparin:
I wrote a simple c stored procedure that accepts only one text parameter
that i want to convert to a c string.
The problem is that i obtain the C string correctly but with spurious
characters at the end...
On Mon, Mar 12, 2007 at 08:38:52AM -0400, Douglas McNaught wrote:
You are restricted to staying in a transaction while the cursor is
open, so if you want to work outside of transactions LIMIT/OFFSET
is your only way.
http://www.postgresql.org/docs/8.2/interactive/sql-declare.html
If WITH HOLD
Magnus Hagander [EMAIL PROTECTED] writes:
It looks to me that you may be a victim of the bug patched in
http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
Tom, whatever happened about a backpatch for that one?
It's applied.
On Mon, 2007-03-12 at 10:13 -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
It looks to me that you may be a victim of the bug patched in
http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
Tom, whatever happened about a backpatch for that one?
It's
On Mon, Mar 12, 2007 at 10:13:48AM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
It looks to me that you may be a victim of the bug patched in
http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
Tom, whatever happened about a backpatch for that one?
Stefan Berglund [EMAIL PROTECTED] writes:
On Sat, 10 Mar 2007 00:37:08 -0500, [EMAIL PROTECTED] (Tom Lane) wrote:
It looks pretty ugly to me too, but you haven't explained your problem
clearly enough for anyone to be able to recommend a better solution path.
Why do you feel you need to do
I need to increase the length of a string field using version 8.1
I was thinking to use ALTER TABLE since now altering a column type
should be supported by pg.
The column is currently varying(60) and I want to have it varying(120)
After executing
ALTER TABLE mytable ALTER COLUMN mycolumn TYPE
On Mon, 2007-03-12 at 15:37 +0100, Magnus Hagander wrote:
On Mon, Mar 12, 2007 at 10:13:48AM -0400, Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
It looks to me that you may be a victim of the bug patched in
Hi everyone,
I'm now used to using psql to manage my databases into a terminal, and
I found the very convenient \g | command that pipes query result in
any shell tool I want. But I still have hard time finding some columns
in some tables (that may have 300+ cols). I would like to pipe the
result
On 3/12/07, Guillaume Bog [EMAIL PROTECTED] wrote:
Hi everyone,
I'm now used to using psql to manage my databases into a terminal, and
I found the very convenient \g | command that pipes query result in
any shell tool I want. But I still have hard time finding some columns
in some tables (that
Hi, is there any way that I can track the number of actual disk
writes done by a particular database or database cluster? I already
sent this question last Friday and, while even I usually frown upon
reposts to lists and forums, I really need some kind of answer, even
if it's you can't in
Paolo Negri [EMAIL PROTECTED] writes:
I need to increase the length of a string field using version 8.1
8.1.what?
After executing
ALTER TABLE mytable ALTER COLUMN mycolumn TYPE varchar(120)
I can see the column definition correctly changes and I can insert
rows with longer data in mycolumn.
Erik,
on windows you can use performance monitor to filter down diskrequest.
With sysinternals tools you can also go down to disk accesses on
process basis.
google for sysinternals site:microsoft.com
on other platforms I have no information.
Harald
--
GHUM Harald Massa
persuadere et
On Mar 12, 2007, at 11:22 AM, Harald Armin Massa wrote:
Erik,
on windows you can use performance monitor to filter down diskrequest.
With sysinternals tools you can also go down to disk accesses on
process basis.
google for sysinternals site:microsoft.com
on other platforms I have no
Erik,
for solaris I think dtrace can be of help:
http://www.opensolaris.org/os/community/dtrace/
PostgreSQL 8.2 introduced dtrace-ability.
From what I read it is specifically created to do this kind of measurement.
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote:
Erik,
for solaris I think dtrace can be of help:
http://www.opensolaris.org/os/community/dtrace/
PostgreSQL 8.2 introduced dtrace-ability.
From what I read it is specifically created to do this kind of
measurement.
Hmm... That
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/12/07 12:16, Erik Jones wrote:
On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote:
Erik,
for solaris I think dtrace can be of help:
http://www.opensolaris.org/os/community/dtrace/
PostgreSQL 8.2 introduced dtrace-ability.
From
On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote:
Hi, is there any way that I can track the number of actual disk
writes done by a particular database or database cluster? I already
sent this question last Friday and, while even I usually frown upon
reposts to lists and
Jean-Michel Pouré wrote:
IMHO, it would be better if PostgreSQL parser was able to find Tseach
indexes alone, rewritting the query automatically. Maybe it is on the
radar list of hackers.
How would you rewrite a query automatically? PostgreSQL will find it
automatically when you attempt to do
We have a 7.4.6 cluster which has been running on an HP B.11.00
box for quite sometime. The IT group applied daylight savings
patches to the OS, but the cluster is still showing the
incorrect timezone:
$ psql -c select now()
now
---
On Monday March 12 2007 1:07 pm, Ed L. wrote:
Does this mean that we need to restart these clusters in order
to get the timezone updates from the OS? Are they cached in
the postmaster?
Nevermind. I just found it via googling.
Would I be correct in understanding that every pre-8.0 cluster
Martijn van Oosterhout wrote:
On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote:
Hi, is there any way that I can track the number of actual disk
writes done by a particular database or database cluster? I already
sent this question last Friday and, while even I usually frown
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thanks for all the replies everyone. Not really knowing what a cursor
is, I suppose I have some work to do. I can do the SELECT/LIMIT/
OFFSET approach but that seems like kind of a headache, esp. when its
hard to predict what # of rows will max
On Mar 12, 2007, at 1:31 PM, Martijn van Oosterhout wrote:
On Mon, Mar 12, 2007 at 11:14:14AM -0500, Erik Jones wrote:
Hi, is there any way that I can track the number of actual disk
writes done by a particular database or database cluster? I already
sent this question last Friday and, while
On Mar 12, 2007, at 1:15 PM, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/12/07 12:16, Erik Jones wrote:
On Mar 12, 2007, at 11:46 AM, Harald Armin Massa wrote:
Erik,
for solaris I think dtrace can be of help:
http://www.opensolaris.org/os/community/dtrace/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Okay, I don't have any postgresql tables big enough to verify this is
doing what I think it is (namely, only keeping one row from my result
set in memory at a time), and I still don't really know much about
cursors or pg, but this appears to be
Bradley Kieser wrote:
I hope that someone has cracked this one because I have run into a brick
wall the entire week and after 3 all-nighters with bad installations, I
would appreciate hearing from others!
I am looking for a decent OpenSource CRM system that will run with
Postgres. SugarCRM
Hi list,
Could someone tell me what libs are packed in the rpm
below ?
postgresql-libs-8.2.3-1PGDG.i686.rpm
We are concerned about the problem of compatibility with
Oracle and we prefer to check all the libs to not put the
Oracle system down.
I think it is just a metter of rpm -qa
Joost Kraaijeveld wrote:
It looks to me that you may be a victim of the bug patched in
http://archives.postgresql.org/pgsql-committers/2007-01/msg00214.php.
Tom, whatever happened about a backpatch for that one?
It's applied.
On Mon, Mar 12, 2007 at 01:13:42PM -0600, Ed L. wrote:
Would I be correct in understanding that every pre-8.0 cluster
must be restarted in order for the OS changes to take affect?!?
Possibly, I imagine many C libraries would cache the timezone data over
a fork and might not motice the
On Monday March 12 2007 4:08 pm, Martijn van Oosterhout wrote:
On Mon, Mar 12, 2007 at 01:13:42PM -0600, Ed L. wrote:
Would I be correct in understanding that every pre-8.0
cluster must be restarted in order for the OS changes to
take affect?!?
Possibly, I imagine many C libraries would
Hi list,
Could someone tell me what libs are packed in the rpm
below ?
postgresql-libs-8.2.3-1PGDG.i686.rpm
We are concerned about the problem of compatibility with
Oracle and we prefer to check all the libs to not put the
Oracle system down.
I think it is just a metter of rpm -qa
On Saturday 10 March 2007, Christian Schröder wrote:
Let's assume that the values in this table are some limits that are
given for different data (identified by the id). Some of the limits are
only valid after a given date, whereas other limits are valid all the
time. How would you put this
Neal Clark [EMAIL PROTECTED] writes:
comments?
Looks like the right idea. If you have a lot of rows to process,
you'll benefit by fetching in batches, e.g.
my $sth = $dbh-prepare(qq{FETCH FORWARD 1000 FROM my_cur});
# iterate through the result set here
-Doug
Martijn van Oosterhout kleptog@svana.org writes:
On Mon, Mar 12, 2007 at 01:13:42PM -0600, Ed L. wrote:
Would I be correct in understanding that every pre-8.0 cluster
must be restarted in order for the OS changes to take affect?!?
Possibly, I imagine many C libraries would cache the timezone
Erik Jones [EMAIL PROTECTED] writes:
Well, disk reads, cache hits, transactions commited, transactions
rolled back, index size and usage, etc. are all able to be tracked vi
the pg catalogue tables and views. But, I haven't seen anything that
will give me numbers on actual disk writes
Tom Lane wrote:
Erik Jones [EMAIL PROTECTED] writes:
Well, disk reads, cache hits, transactions commited, transactions
rolled back, index size and usage, etc. are all able to be tracked vi
the pg catalogue tables and views. But, I haven't seen anything that
will give me numbers on
http://devloop.org.uk/documentation/database-performance/
Any comments?
Regards,
Tadej
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane wrote:
One of the reasons you don't see that is that a large fraction of the
writes are triggered in background by the bgwriter process, which
operates at too low a level to participate in the stats collection
mechanism. I'm not sure what
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 03/12/07 22:57, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Tom Lane wrote:
One of the reasons you don't see that is that a large fraction of the
writes are triggered in background by the bgwriter process, which
operates at too
Tadej Kanizar [EMAIL PROTECTED] writes:
http://devloop.org.uk/documentation/database-performance/
Any comments?
Old news, see this thread:
http://archives.postgresql.org/pgsql-general/2007-02/msg00806.php
Most of us stopped reading about the place where they explained
that (a) they did zero
On 12.03.2007, at 22:46, Tom Lane wrote:
Most of us stopped reading about the place where they explained
that (a) they did zero tuning on each database, and (b) they were
comparing myisam to transactional engines.
What I don't like about things like that, is that some morons throw
something
57 matches
Mail list logo