Hello Devrim, hello List,
No problem to share with you the RPM.
Yesterday afternoon, I built the 8.2.3 RPM for RHEL4-AS and IA-64.
I propose to work off-list with you Devrim, so you could take the RPM
and check them.
Is it OK ?
Regards,
Alexandra
Devrim GUNDUZ wrote:
Hello,
On Mon,
Hi,
On Tue, 2007-02-20 at 09:14 +0100, DANTE Alexandra wrote:
I propose to work off-list with you Devrim, so you could take the RPM
and check them.
Is it OK ?
Ok for me :)
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services,
On Tue, 2007-02-20 at 03:43, Tom Lane wrote:
Nonsense. pg_stat_activity + kill -TERM should solve this problem
reasonably well. Some of us don't trust kill -TERM 100%, which is why
it's not currently exposed as a standard function, but if you're using
a reasonably recent PG release it's
I have problems with queries over tsearch index.
I have a table of books, with 120 registers. I have created an GIST
index over the title and subtitle,
CREATE INDEX idxts2_titsub_idx ON public.libros USING gist
(idxts2_titsub);
My problems started when i execute my queries.
For example, i
Use GIN index instead of GiST
I have a table of books, with 120 registers. I have created an GIST
index over the title and subtitle,
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
I have problems with queries over tsearch index.
I have a table of books, with 120 registers. I have created an GIST
index over the title and subtitle,
CREATE INDEX idxts2_titsub_idx ON public.libros USING gist
(idxts2_titsub);
My problems started when i execute my queries.
For example, i
On Wed, 14 Feb 2007, Peter Eisentraut wrote:
By installing functions or operators with appropriate signatures in
other schemas, users can then redirect any function or operator
call in the function code to implementations of their choice
[snip]
The proper fix for this problem is to insert
On 2/19/07, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
# select ((now() - '1 day'::interval)::timestamp - now()) 0;
?column?
--
f -- looks busted to me
(1 row)
If you'd casted to timestamptz then I'd agree this is busted.
As-is, it might have
All of these statements produce 'f' for me as well, via 8.2.1 on RHEL 4.
select ((now() - '1 day'::interval)::timestamp - now()) 0;
select ((now() - '1 day'::interval)::timestamptz - now()) 0;
select ('-1 days'::interval) 0;
But all of these return 't':
select ((now() - '1
Merlin Moncure [EMAIL PROTECTED] writes:
On 2/19/07, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
# select ((now() - '1 day'::interval)::timestamp - now()) 0;
?column?
--
f -- looks busted to me
(1 row)
If you'd casted to timestamptz then I'd
Added to TODO for Win32:
o Check .pgpass file permissions
---
Shane Ambler wrote:
Michael Schmidt wrote:
Fellow PostgreSQL fans,
1. I don't see that this would pose a major security risk. In
fact, in
On 2/18/07, Chris [EMAIL PROTECTED] wrote:
Toby Tremayne wrote:
Hi all,
I'm just experimenting with tsearch2 - I have it all working fine but I
was wondering if there's a way to create indexes containing vector
columns from multiple tables? Or if not, how do people usually manage
this
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc
Are we sure we want to do this? (Sorry, didn't notice this thread last
time)
The default on *all* windows versions since NT 4.0 (which is when the
directory we use was added) will put this file in a protected directory.
The only case when it's not protected by default is if you're usnig FAT
On 2/17/07, Rick Schumeyer [EMAIL PROTECTED] wrote:
This may be bad design on my part, but...
Not at all. Very common scenario
I have three tables of interest...Account, Employee, and
AccountEmployeeRelation. There is a many-to-many relationship between
accounts and employees. The join
Am 19.02.2007 um 17:49 schrieb Jan Wieck:
Oh, this one wasn't about raw speed of trivial single table
statements like all the others?
No, it wasn't. They also tested the insert performance of a system
without foreign keys and without transactions (MySQL MyISAM) against
systems with
Magnus Hagander wrote:
Are we sure we want to do this? (Sorry, didn't notice this thread last
time)
The default on *all* windows versions since NT 4.0 (which is when the
directory we use was added) will put this file in a protected directory.
The only case when it's not protected by default
On Tue, 2007-02-20 at 08:55, Marek Lewczuk wrote:
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
I don't know what that means, but which 8.2 version? 8.2.3 is the
latest 8.2
Hello Tom,
Thanks for the response. My replies inline...
On 2/18/07, Tom Lane [EMAIL PROTECTED] wrote:
CAJ CAJ [EMAIL PROTECTED] writes:
We have 2 servers running postgres database 8.0.3 serving a web
application.
You do realize we are up to 8.0.12 in that branch? You're missing
nearly two
On 2/20/07, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
On 2/19/07, Tom Lane [EMAIL PROTECTED] wrote:
Merlin Moncure [EMAIL PROTECTED] writes:
# select ((now() - '1 day'::interval)::timestamp - now()) 0;
?column?
--
f -- looks busted to me
(1 row)
No I didn't.
I just need an expert in Slony-I
My application needs critically an slony-I master to run correctly.
In my incursions Slony-I appears quite difficult. I need someone to
make a configuration step-by-step (in msn messenger) configuration.
The documentation of Robert does not work
Marek Lewczuk wrote:
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
Are there C functions, or anything interesting which we should know
about your database?
--
Alvaro Herrera
Marek Lewczuk wrote:
Hello,
after upgrade to 8.2 version, PostgreSQL throws following warnings:
WARNING: TupleDesc reference leak: TupleDesc 0x42051d90 (16425,-1)
still referenced
WARNING: TupleDesc reference leak: TupleDesc 0x41f60ad0 (16425,-1)
still referenced
WARNING: TupleDesc
One nice CMS package -- it doesn't force you to use Postgresql, but that is
(IIRC) the default -- and python:
http://www.djangoproject.com/
HTH--
-frank
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I want to be able to build complex search and reporting capabilities in
to our PHP5 application. We want to be able to save searches for later
use. We also want to build queries from virtually any field in certain
tables from our PHP app. I hope to do as much within postgresql as
possible. Then I
On Tue, 2007-02-20 at 11:26, Robert Fitzpatrick wrote:
I want to be able to build complex search and reporting capabilities in
to our PHP5 application. We want to be able to save searches for later
use. We also want to build queries from virtually any field in certain
tables from our PHP app.
Bruce Momjian wrote:
Magnus Hagander wrote:
Are we sure we want to do this? (Sorry, didn't notice this thread last
time)
The default on *all* windows versions since NT 4.0 (which is when the
directory we use was added) will put this file in a protected directory.
The only case when it's not
The default on *all* windows versions since NT 4.0 (which is when the
directory we use was added) will put this file in a protected directory.
The only case when it's not protected by default is if you're usnig FAT
filesystem, in which case there is nothing you can do about it anyway.
On
Tom Lane wrote:
Michael Schmidt [EMAIL PROTECTED] writes:
... Regarding how I concluded
that PGPASSFILE was deprecated for pg_dump, I offer the following.
1. The documentation for pg_dump in the manual (Section VI) includes a
section labeled Environment. This lists PGDATABASE,
Magnus Hagander wrote:
Are we sure we want to do this? (Sorry, didn't notice this thread last
time)
The default on *all* windows versions since NT 4.0 (which is when the
directory we use was added) will put this file in a protected directory.
Is there truly such a thing on a windows PC? All
Tony Caduto wrote:
Magnus Hagander wrote:
Are we sure we want to do this? (Sorry, didn't notice this thread last
time)
The default on *all* windows versions since NT 4.0 (which is when the
directory we use was added) will put this file in a protected directory.
Is there truly such a
Magnus Hagander [EMAIL PROTECTED] writes:
Tony Caduto wrote:
What about having a wallet type system where the user can create a pass
phrase to protect a generated key that would get
loaded once per session. That is how KDE allows users to store passwords.
If we wanted to do that, we could
Tom Lane wrote:
Magnus Hagander [EMAIL PROTECTED] writes:
Tony Caduto wrote:
What about having a wallet type system where the user can create a pass
phrase to protect a generated key that would get
loaded once per session. That is how KDE allows users to store passwords.
If we wanted to
Magnus Hagander wrote:
Just to make things clear, this wouldn't be about another auth method.
Windows has an API to store arbitrary passwords in a secure way. At
least it does in XP+, not sure if it was in 2000.
Would it really solve Tony's problem though? I'm not familiar with the
API you're
Hi,
Postgresql 8.1.
I'm trying to come up with a generic way
of inserting into a view, particularly regards
error testing and the generation of complicated
foreign keys. I don't seem to be having much luck.
(I also want to update and delete, but haven't gotten
that far.)
I thought that, for
Dave Page wrote:
Magnus Hagander wrote:
Just to make things clear, this wouldn't be about another auth method.
Windows has an API to store arbitrary passwords in a secure way. At
least it does in XP+, not sure if it was in 2000.
Would it really solve Tony's problem though? I'm not
Magnus Hagander wrote:
Dave Page wrote:
Magnus Hagander wrote:
Just to make things clear, this wouldn't be about another auth method.
Windows has an API to store arbitrary passwords in a secure way. At
least it does in XP+, not sure if it was in 2000.
Would it really solve Tony's problem
On 2/20/07, Justin Dearing [EMAIL PROTECTED] wrote:
Hello,
I need a way to sync a postgres view with a table on a Windows CE device.
The table will be read only on the mobile device. I am seeking to replace an
access database that syncs a table with a pocket pc table via active sync. I
would
I have updated the encode() documentation to not mention ASCII, and to
be more specific about what 'escape' does. Backpatched to 8.2.X.
---
Michael Fuhr wrote:
On Thu, Jan 25, 2007 at 02:28:38PM -0500, Michael Artz wrote:
On 2/21/07, Guido Neitzer wrote:
It would be more or less the same, if you compare copy against insert
performance on PostgreSQL and state that insert should be as fast as
copy without saying why.
Btw: these guys claim to be database consultants.
Guess one should consider oneself lucky not to
Hi everyone,
I'm trying to write a PL/pgSQL function which execute an insert, I encounter
a problem when I try to insert NULL value into an integer field.
The following code is for reproducing:
CREATE TABLE test(
bh INT8
);
CREATE OR REPLACE FUNCTION testinsertion(intornull bigint) RETURNS
resurrection
Ok so i am having trouble installing plpython, and found this thread.
Howevre, after adding postgresql/bin to the path and the python lib
directory to the path i still get:
createlang: language installation failed: ERROR: could not load library C:/Pro
gram
On 02/20/2007 03:45:55 PM, Yonatan Ben-Nes wrote:
Hi everyone,
I'm trying to write a PL/pgSQL function which execute an insert, I
encounter
a problem when I try to insert NULL value into an integer field.
RETURN 'INSERT INTO test (bh) VALUES ('||COALESCE(intornull,
'NULL')||')';
And
Bruce Momjian wrote:
Hard to argue with that.
Is it a strong enough argument to add a TODO?
I'm thinking some sort of TODO might be called for.
Perhaps two TODOs?
* Use the OS's priority features to prioritize
backends (and document that it might work
better with OS's that support
On Tue, 20 Feb 2007, Yonatan Ben-Nes wrote:
Hi everyone,
I'm trying to write a PL/pgSQL function which execute an insert, I encounter
a problem when I try to insert NULL value into an integer field.
The following code is for reproducing:
CREATE TABLE test(
bh INT8
);
CREATE OR REPLACE
This is probably a question more appropriate on a gentoo mailing list,
but I'll ask anyway as it obviously has to do with postgresql and I've
a feeling someone will probably know: can anyone explain what is it
that happens here when I try to stop the postmaster? What can I do
about it?
#
I am trying to use the crosstab function of the contrib tablefunc.
Reading the README, I believe I am supposed to be using crosstab(sql, N)
for my situation and wondering if the SQL can be based on a view? I have
this view created that gives me each sales rep and their total number of
units sold
On 2/21/07, Tomi N/A [EMAIL PROTECTED] wrote:
# /etc/init.d/postgresql stop
* Stopping PostgreSQL ...
start-stop-daemon --stop --pidfile /var/lib/postgresql/data/postmaster.pid
--retry -TERM//-INT//-QUIT --oknodo
/sbin/start-stop-daemon: invalid schedule item (must be
[-]signal-name,
Hello,
Is there a way to revoke all privileges of a role without actually
specifying the whole list of items.
Like if a role has privileges on FUNCTIONs, is there a REVOKE all FUNCTIONS.
Is there a way to check if it has a GRANT in a particular type (CONNECT,
FUNCTION, TRIGGER) before calling
On 2/20/2007 3:51 PM, Andrej Ricnik-Bay wrote:
On 2/21/07, Guido Neitzer wrote:
It would be more or less the same, if you compare copy against insert
performance on PostgreSQL and state that insert should be as fast as
copy without saying why.
Btw: these guys claim to be database consultants.
Hello
I have a friend that ask me why postgresql is better than mysql.
I personally prefer posgresql, but she need to give in her work 3 or 4
strong reasons for that. I mean not to much technical reasons. Can you
give help me please ?
Thank you,
Gustavo
--
On Feb 19, 2007, at 1:19 PM, Jeff Davis wrote:
You told PostgreSQL that you have 900MB available for
maintenance_work_mem, but your OS is denying the request. Try
*lowering*
that setting to something that your OS will allow. That seems like an
awfully high setting to me.
900MB isn't that
I have postgres running on W2K, version 8.2.1 which I am upgrading to
8.2.3 but when I run the upgrade I get an error as follows:
The installer has encountered an unexpected error
installing this package. This may indicate a problem with
this package. The error code is 2803.
The install seemed
We've settled upon a method for gathering raw statistics from widely
scattered data centers of creating one sequence per-event, per minute.
Each process (some lapp, some shell, some python, some perl etc) can
call a shell script which calls ssh-psql to execute a nextval('event')
sequence.
On 2/20/07, gustavo halperin [EMAIL PROTECTED] wrote:
Hello
I have a friend that ask me why postgresql is better than mysql.
I personally prefer posgresql, but she need to give in her work 3 or 4
strong reasons for that. I mean not to much technical reasons. Can you
give help me please ?
http://developersoven.blogspot.com/
--
Tony Caduto
AM Software Design
Home of Lightning Admin for PostgreSQL and MySQL
http://www.amsoftwaredesign.com
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
one last thing mysql team doesn't afraid to change behaviours between
minor releases, look at this thread
That is so true, all the differences between minor versions made creating
Lightning Admin for MySQL a pain in the rear...
After I did the port I really appreciated how clean PostgreSQL
Ezequias Rodrigues da Rocha [EMAIL PROTECTED] writes:
I just need an expert in Slony-I
This is the wrong forum for discussing Slony ... you will be much more
likely to find experts in the Slony lists:
http://gborg.postgresql.org/mailman/listinfo/slony1-general
regards,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/20/07 15:25, gustavo halperin wrote:
Hello
I have a friend that ask me why postgresql is better than mysql.
I personally prefer posgresql, but she need to give in her work 3 or 4
strong reasons for that. I mean not to much technical
I'm not apologizing for their past mistakes.. But the issue
you cite is no longer true:
As of 5.0.2, the server requires that month and day values
be legal, and not merely in the range 1 to 12 and 1 to 31,
respectively.
mysql use test
Database changed
mysql create table test ( td DATE );
Adam Rich [EMAIL PROTECTED] writes:
I'm not apologizing for their past mistakes.. But the issue
you cite is no longer true:
As of 5.0.2, the server requires that month and day values
be legal, and not merely in the range 1 to 12 and 1 to 31,
respectively.
Really?
[EMAIL PROTECTED] ~]$
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/20/07 23:59, Adam Rich wrote:
I'm not apologizing for their past mistakes.. But the issue
you cite is no longer true:
As of 5.0.2, the server requires that month and day values
be legal, and not merely in the range 1 to 12 and 1 to 31,
Jim Nasby wrote:
On Feb 19, 2007, at 1:19 PM, Jeff Davis wrote:
You told PostgreSQL that you have 900MB available for
maintenance_work_mem, but your OS is denying the request. Try *lowering*
that setting to something that your OS will allow. That seems like an
awfully high setting to me.
63 matches
Mail list logo
