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
-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 3
"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 PROTECTE
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 );
-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
"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
regard
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 is
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
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 ?
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. P
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 seeme
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 unr
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 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,
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 th
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
[-], -, or `forever'
Try
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 an
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?
# /etc/ini
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 O
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 p
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 i
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 Files/PostgreSQL/8.2/lib/plpython.dll
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 text
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
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 wrot
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 r
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
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
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 i
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 yo
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.
>
>> I
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, w
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 tru
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
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 PG
>>> 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 anywa
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 pro
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 ap
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 s
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
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
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
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 fo
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 <--
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
near
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 v
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 de
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 forei
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
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
filesy
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 0x420
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
> t
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
> > fac
"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 ca
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 day'::interval
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 m
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 inser
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 examp
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 examp
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
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, Sha
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, 2007-02
63 matches
Mail list logo
