hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> of course i can make myself a function which will check if pid exists, but
> it would generally be better if there was some way to fix the problem in
> postgresql itself.
Try updating to PG 8.1 ...
2005-08-09 17:14 tgl
* src/backen
On 12/14/05, Chris Browne <[EMAIL PROTECTED]> wrote:
The only answer I have been able to come to is that restarting thepostmaster will clear this all up.
this is actually not an option for me.
of course i can make myself a function which will check if pid exists,
but it would generally be better if
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> That said, you need to be careful about testing this using psql. I
> believe psql is what's converting the timestamp to your local timezone.
Certainly not; psql doesn't even know what a timestamp is. If you get
different results in a different client i
Greg Stark <[EMAIL PROTECTED]> writes:
> What runtime penalty? It seems likely that strcoll is implemented by the
> equivalent of calling strxfrm twice internally anyways.
Only by a very incompetent implementor.
regards, tom lane
---(end of broadca
Jim Nasby wrote:
> > I too have had issues with "stuck" entries in the pg_stat_activity view --
> > > the real pid is long gone but postgres still thinks the process is there.
> >
> > It would be real sweet to have a way of cleaning this table with bringing >
> > postgres off-line.
>
> Rather
Tom Lane <[EMAIL PROTECTED]> writes:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > But then I thought of another idea. What if Postgres just used strxfrm()
> > instead of strcoll everywhere? Then it ought to never produce inconsistent
> > results. At least if strxfrm() doesn't just return randomly
On Wed, Dec 14, 2005 at 02:02:02PM -0800, Gregory S. Williamson wrote:
> I too have had issues with "stuck" entries in the pg_stat_activity view --
> the real pid is long gone but postgres still thinks the process is there.
>
> It would be real sweet to have a way of cleaning this table with brin
First, I don't think the epoch conversion has anything to do with this,
so it'd be better to focus on simple timestamps.
That said, you need to be careful about testing this using psql. I
believe psql is what's converting the timestamp to your local timezone.
If you test this using a different int
Greg Stark <[EMAIL PROTECTED]> writes:
> But then I thought of another idea. What if Postgres just used strxfrm()
> instead of strcoll everywhere? Then it ought to never produce inconsistent
> results. At least if strxfrm() doesn't just return randomly varying results
> for the same inputs.
AFAICS
Tom Lane <[EMAIL PROTECTED]> writes:
> Non-self-consistent comparison results can lead to an index that is
> either actually or effectively corrupt (because index searches proceed
> down the wrong tree path and thus fail to find items that should be
> found). So the observation that only index s
Hi Tom,
Am 2005-12-15 11:29:12, schrieb Tom Lane:
> Michelle Konzack <[EMAIL PROTECTED]> writes:
> > Now if I chante my php5 scripts on my Webserver to point to the 8.0
> > PostgreSQL I get only connect errors.
>
> What errors exactly? Without details it's impossible to solve this.
Some of my q
On Wed, Dec 14, 2005 at 11:52:19AM -0800, Ale Raza wrote:
> Hi,
>
> I am writing a user defined data type in C and want to debug the lib
> I am creating for this data type. Wondering if somebody knows how to
> link and debug this lib or any document which can help me to do this?
> Can I debug thi
Hello Tom,
Am 2005-12-15 11:19:03, schrieb Tom Lane:
> Michelle Konzack <[EMAIL PROTECTED]> writes:
> > Since some days we become SPAMed.
>
> > How can this happen, if the list is subscriber only?
>
> Marc accidentally turned off the subscribers-only filter for a few days :-(
> It's been fixed,
**
* Do not Cc: me, because I am on THIS list, if I write here *
* Keine Cc: am mich, bin auf DIESER Liste wenn ich hier schreibe *
**
Hello,
are the certificates
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> The problem is that the rpm substitutes in a Makefile that does not
> install the language. If you hack it so that plpgsql is installed
> (pg_regress --load-languge=plpgsql ...)
> then all the tests pass. (Dunno what's with the rpm's Makefile.
> It app
Problem solved.
On 12/15/2005 09:55:08 AM, Tom Lane wrote:
Please note also that this is not a generic breakage. What you need
to
be asking is what in your particular environment is causing this
failure.
The problem is that the rpm substitutes in a Makefile that does not
install the language.
Dear Steve,
I have had the same problem related SuSE 8.2. A thing that additionally can be wrong is
the LC_CTYPE setting in the environment. Running a SuSE system this can be set in
/etc/sysconfig/language. I am using RC_LANG="de_DE.UTF-8", but other valid
values should be fine, too.
For SuSE
Michelle Konzack wrote:
Am 2005-12-07 18:16:43, schrieb Richard Huxton:
Um - not sure what this has to do with PostgreSQL. You'll probably have
more luck at one of the many PHP developer sites. I shouldn't be
surprised if there was something available in the PEAR repository too.
I do not get
UPDATE
I was trying to create a demo table, because I cannot send our
confidental data. I have found weird result.
# drop table common_logins;
DROP TABLE
$ psql < ../cl.sql
SET
SET
SET
SET
SET
SET
CREATE TABLE
setval
203650
(1 row)
ALTER TABLE
CREATE INDEX
CREATE IN
On 12/15/2005 09:55:08 AM, Tom Lane wrote:
I'm inclined to guess that it's specific to "make check"'s temporary
installation. Have you tried "make installcheck" to run against a
non-temp installation?
'make installcheck' gets the same errors (and the same
regression.diffs file (except for th
On Thu, 15 Dec 2005, Tom Lane wrote:
Michelle Konzack <[EMAIL PROTECTED]> writes:
Please note, that I use "hostssl" only.
You might have forgotten to set up the SSL key files?
I'm having some trouble with a 8.0 on Debian on Intel. My development
SPARC version works OK with SSL connections.
One thing you might consider is the 'Base' application from
openoffice. I'm not sure it's what you want, but it might work... In
any case it's likely worth looking at.
> > I prefer major (A status) programming language using classification from
> > http://www.tiobe.com/tpci.htm
... wandering of
Michelle Konzack <[EMAIL PROTECTED]> writes:
> Now if I chante my php5 scripts on my Webserver to point to the 8.0
> PostgreSQL I get only connect errors.
What errors exactly? Without details it's impossible to solve this.
> Please note, that I use "hostssl" only.
You might have forgotten to se
Jaime Casanova <[EMAIL PROTECTED]> writes:
> On 12/15/05, Csaba Nagy <[EMAIL PROTECTED]> wrote:
>> Ok, that explains then the problem... but the index is arguably corrupt
>> in this case, with the important difference that it's not even fixable
>> by reindex...
>>
>> I guess what the OP really wan
Hello,
I have 3 identicaly Sun/Sparc SMP machines which are working fine
with Debian GNU/Linux architecture SPARC.
On the first I have Woody 3.0 with PostgreSQL 7.4.5 which is working
perfectly. The whole Database is around 160 GByte where the main
table is around 90 GByte.
Now I have installed
On 12/15/05, Csaba Nagy <[EMAIL PROTECTED]> wrote:
> Ok, that explains then the problem... but the index is arguably corrupt
> in this case, with the important difference that it's not even fixable
> by reindex...
>
> I guess what the OP really wants is a solution to his problem.
MAGE was reproduc
Hello *,
Since some days we become SPAMed.
How can this happen, if the list is subscriber only?
I have this question, because <[EMAIL PROTECTED]> and
<[EMAIL PROTECTED]> are two servers where I do not filter
SPAM (wast of resources because they are subscriber only)
Greetings
Michelle
Am 2005-1
Am 2005-12-07 18:16:43, schrieb Richard Huxton:
> Um - not sure what this has to do with PostgreSQL. You'll probably have
> more luck at one of the many PHP developer sites. I shouldn't be
> surprised if there was something available in the PEAR repository too.
I do not get the right QUERY for
Andrus wrote:
Andrus wrote:
I want to create editable grid (client application) for large Postgres
table:
At startup this grid show first screenful of records and allows to edit
them.
When user presses page down key, this grid should read next screenful of
records and allow to edit them etc.
Pg
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> I don't believe it's just the 'make check' case. Plpgsql is not
> in template1 after installation.
It's not supposed to be --- at least, not unless you install it there
manually.
Please note also that this is not a generic breakage. What you need to
On 12/15/2005 09:45:12 AM, Tom Lane wrote:
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> I reproduced the same...
rpath problem? It would be useful to look at the postmaster log to
see
why it's failing to create the language in the 'make check' case.
I don't believe it's just the 'make check'
Mage <[EMAIL PROTECTED]> writes:
>> lc_collate | hu_HU
>> lc_ctype | hu_HU
>> server_encoding| LATIN2
Hm, are those settings actually compatible? You need to check your
system documentation to find out what encoding "hu_HU" expects.
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> I reproduced the same...
rpath problem? It would be useful to look at the postmaster log to see
why it's failing to create the language in the 'make check' case.
The other odd thing is, if the createlang step fails, you'd think that
pg_regress would co
Ok, that explains then the problem... but the index is arguably corrupt
in this case, with the important difference that it's not even fixable
by reindex...
I guess what the OP really wants is a solution to his problem. If the
table is not too big, a quick fix would be to just drop the index.
Then
Hi,
On Thu, 2005-12-15 at 15:24 +, Karl O. Pinc wrote:
> ===
> 5 of 98 tests failed.
> ===
regression.diffs for this is at:
http://www.gunduz.org/postgresql/regression.diffs
I reproduced the same...
--
The PostgreSQL Company - Command Prompt, Inc
Richard Huxton writes:
> But "like" without any wildcards should be the same as "=", but it isn't
> in the original post.
I'm too lazy to go look at the code right now, but I think that the
reduction of "x LIKE constant-pattern" to "x = constant-pattern" is
part of the LIKE index optimization co
Richard Huxton writes:
> Csaba Nagy wrote:
>> Based on the 3rd query of the OP, where the direct comparison results in
>> "true" for all the rows which matched the "like", I would exclude the
>> localisation issues variant... unless = is not equals in all cases ;-)
> Well spotted Csaba - that _wo
Mage wrote:
./configure --prefix=/usr/local/pgsql --with-python
client_encoding| LATIN2
lc_collate | hu_HU
lc_ctype | hu_HU
lc_messages| en_US
lc_monetary| en_US
lc_numeric | en_
Hi,
I don't know what to make of this.
I installed the rpms for 8.1.1 on a RH 4 es system
and did initdb with LC_TYPE=C and LC_COLLATE=C (and
I also tried without changing these locale variables):
cd /usr/lib/pgsql/test
gmake check
gets:
rm -rf ./testtablespace
mkdir ./testtablespace
/bin/sh
Well, then I have the disease. The database is UNICODE:
gex_runtime=# select gex_clientname from gex_clients where gex_clientname =
'HomeHappinesses';
gex_clientname
--
HomeGain
(1 row)
gex_runtime=# select gex_c
=?UTF-8?B?0JDQvdC00YDQtdC5?= <[EMAIL PROTECTED]> writes:
> Please tell - how to enable SSL on PostgreSQL 8.1 server. When
> setting option "ssl = on" in postgresql.conf - server even doesn't want
> to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from
> .msi, downloaded from w
Jaime Casanova wrote:
I tried it in two databases (dump and load to another one), so I don't
think that we have corrupted indexes.
the problem persist after a dump a reload? then there is not because
an index corruption... can you send part of the data that reproduces
the bug?
I can
Gregory S. Williamson wrote:
I am puzzled by the lack of a "%" in the LIKE query. When I try this on
postgres 7.4 and 8.0 I get no rows when I am missing it; including it works as expected.
The names have been changed to protect the guilty ;-} but the core of it is true -- no
"%" means wierdn
Csaba Nagy wrote:
[snip]
If that makes a difference then I'd guess you have one of two things:
1. A corrupt index (check the REINDEX command)
2. (perhaps more likely) Some localisation issues.
What encoding/locale settings are you using?
Based on the 3rd query of the OP, where the direct c
>
> I tried it in two databases (dump and load to another one), so I don't
> think that we have corrupted indexes.
>
the problem persist after a dump a reload? then there is not because
an index corruption... can you send part of the data that reproduces
the bug?
> I can try on a newer version of
>
> If you look my 3rd query, you will see that there are no spaces, however:
>
> select *, length(username), length('potyty') from common_logins where
username like 'potyty';
> uid | username | password | lastlogin | status |
usertype | loginnum | length | length
> ---
Hi,
On Wed, 2005-12-14 at 08:16 -0500, Jerry LeVan wrote:
> Oh well, I chickened out and rm'ed the existing rpms and noted which
> dependencies were deleted via pencil and paper.
>
> I then installed the new rpms and reinstalled the previous dependencies.
Why didn't you use rpm -Uvh? That wou
Csaba Nagy wrote:
[snip]
even is that is true i think you need the "comodin characters" (ie: %.
_) to make "like" behave different from simple comparisons
Not entirely true, if the database was initialized in a different locale
than C, then the direct comparison will probably go for a
A. Kretschmer wrote:
select *, length(username), length('potyty') from common_logins where username
like 'potyty';
My guess:
select length(username) from common_logins where username like 'potyty';
is _NOT_ 6, there is a SPACE like 'potyty '.
If you look my 3rd query, you will see tha
[snip]
> If that makes a difference then I'd guess you have one of two things:
> 1. A corrupt index (check the REINDEX command)
> 2. (perhaps more likely) Some localisation issues.
> What encoding/locale settings are you using?
Based on the 3rd query of the OP, where the direct comparison resu
On 12/15/05, Csaba Nagy <[EMAIL PROTECTED]> wrote:
> [snip]
> > even is that is true i think you need the "comodin characters" (ie: %.
> > _) to make "like" behave different from simple comparisons
>
> Not entirely true, if the database was initialized in a different locale
> than C, then the direc
Mage wrote:
online=# select * from common_logins where username = 'potyty';
online=# select * from common_logins where username like 'potyty';
It's probably worth seeing whether these have different plans (EXPLAIN
ANALYSE...) and if the = is using an index but like isn't.
If so, try issuing "s
[snip]
> even is that is true i think you need the "comodin characters" (ie: %.
> _) to make "like" behave different from simple comparisons
Not entirely true, if the database was initialized in a different locale
than C, then the direct comparison will probably go for an index on
username, while
David Rysdam wrote:
David Rysdam wrote:
Tom Lane wrote:
David Rysdam <[EMAIL PROTECTED]> writes:
Just finished building and installing on *Sun* (also
"--without-readline", not that I think that could be the issue):
Works fine. So it's something to do with the SGI build in particular.
On 12/15/05, A. Kretschmer <[EMAIL PROTECTED]> wrote:
> am 15.12.2005, um 14:12:23 +0100 mailte Mage folgendes:
> > online=# select * from common_logins where username = 'potyty';
> > uid | username | password | lastlogin | status | usertype | loginnum
> > -+--+--+---+
am 15.12.2005, um 14:12:23 +0100 mailte Mage folgendes:
> online=# select * from common_logins where username = 'potyty';
> uid | username | password | lastlogin | status | usertype | loginnum
> -+--+--+---++--+--
> (0 rows)
>
> online=# select
Андрей wrote:
Richard Huxton wrote:
Andrei wrote:
Hello!
Please tell - how to enable SSL on PostgreSQL 8.1 server. When
setting option "ssl = on" in postgresql.conf - server even doesn't
want to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed
from .msi, downloaded from
online=# select * from common_logins where username = 'potyty';
uid | username | password | lastlogin | status | usertype | loginnum
-+--+--+---++--+--
(0 rows)
online=# select * from common_logins where username like 'potyty';
uid | username
Richard Huxton wrote:
Andrei wrote:
Hello!
Please tell - how to enable SSL on PostgreSQL 8.1 server. When
setting option "ssl = on" in postgresql.conf - server even doesn't
want to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed
from .msi, downloaded from www.posgtresql.
Андрей wrote:
Hello!
Please tell - how to enable SSL on PostgreSQL 8.1 server. When
setting option "ssl = on" in postgresql.conf - server even doesn't want
to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from
.msi, downloaded from www.posgtresql.org.
If the server isn'
Hello!
Please tell - how to enable SSL on PostgreSQL 8.1 server. When
setting option "ssl = on" in postgresql.conf - server even doesn't want
to startup. I'm using PostgreSQL 8.1 on Windows 2000, installed from
.msi, downloaded from www.posgtresql.org.
On Donnerstag, Dez 15, 2005, at 12:11 Europe/Berlin, Tino Wildenhain
wrote:
Marc Brünink schrieb:
Hi list,
...
Now I'l try a custom dump. Perhaps this will suffice. But I guess
it's impossible for a dump to be as fast as a cp. So if a cp would
be possible I would favour it. Oh, and did I
Marc Brünink schrieb:
Hi list,
...
Now I'l try a custom dump. Perhaps this will suffice. But I guess it's
impossible for a dump to be as fast as a cp. So if a cp would be
possible I would favour it. Oh, and did I tell: Everything have to be
done tommorow. *sigh*
Actually its faster.
This link explains lot of useful techniques for backup and restore
http://www.postgresql.org/docs/8.1/static/backup.html
On 12/15/05, Marc Brünink <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> I know this was asked a lot of times on this mailing list. But actually
> no reply satisfied me :-)
> Howeve
Hi list,
I know this was asked a lot of times on this mailing list. But actually
no reply satisfied me :-)
However: I've a running postgres database. It's about 6 GB big. Now I
want to copy this database to another host. Clearly pg_dumpall comes to
the mind. But there're 2 problems:
1. The n
In article <[EMAIL PROTECTED]>,
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> On Dec 15, 2005, at 0:29 , Jimmy Rowe wrote:
>> select * from catalog where file_name like 'abc%def%.200[2-5]%';
>> The following select keeps returning "(0 rows)".
> LIKE doesn't consider [2-5] to be a range, but r
On 15.12.2005, at 9:10 Uhr, Brendan Duddridge wrote:
What about Sequoia? Is that better or worse than pgpool?
That looks interesting, I haven't seen it yet. Has anyone experiences
to share?
cug
smime.p7s
Description: S/MIME cryptographic signature
Hi Guido / Richard / Scott,
What about Sequoia? Is that better or worse than pgpool?
Thanks
Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL PROTECTED]
ClickSpace Interactive Inc.
Suite L100, 239 - 10th Ave. SE
Calgary, A
68 matches
Mail list logo