On 19 Oct 2006 02:49:23 -0700, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:3. The last question is, is there any debbuger to debugg triggers in
plpgsql? This could be very usefull.You can try EnterpriseDB, to test/debug your triggers, and then port it back to your 7.xx version (assuming you do not
binberati wrote:
Hi,
I have a strange problem running Django on a GrokThis.net shared
hosting account:
Environment:
--
Apache/2.0.59 (Unix)
mod_fastcgi/2.4.2
PostgreSQL 8.1.3
--
settings.py
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/06/06 23:02, Joshua D. Drake wrote:
> On Thursday 06 July 2006 19:55, Ron Johnson wrote:
>> Being an HP/Compaq shop, I'm looking at an Opteron-and-SATA-based
>> DL145 G2 and an MSA20 SATA enclosure with a U320 interface to use
>> with RHES4 and P
Ritesh Nadhani wrote:
Hello
Just trying to play around with PostgreSQL. Some commands and their
result are:
test=# create table ncbi ( id serial, title varchar(50), abstract text,
primary key(id));
NOTICE: CREATE TABLE will create implicit sequence "ncbi_id_seq" for
serial column "ncbi.id"
am Thu, dem 19.10.2006, um 2:49:23 -0700 mailte [EMAIL PROTECTED] folgendes:
> Hi,
> I have a question connected with postgres procedural langauge. Version
> of Postgres:
>
> "PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc"
Outdated.
>
> I have a table on which I have created man
Maurice Yarrow wrote:
In fact, the only thing I cannot find is a recent copy (for
8.1.5 located in /usr/local/pgsql) of an init.d startup script
for the postgres, equivalent to the currently running
/etc/rc.d/init.d/postgresql(which is about 250 lines
of shell).
If you download the sourc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 15:22, Martijn van Oosterhout wrote:
> On Thu, Oct 19, 2006 at 04:18:50PM -0400, Joseph Shraibman wrote:
>> I'm running postgres 8.0.8. I have a table that is updated very
>> rapidly, so I vacuum it every 10 minutes. The problem is that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 14:34, kbajwa wrote:
> Do I need to remove mySQL or leave it installed?
It certainly won't *hurt* to leave it there, but it's always *smart*
to purge un-needed systems from a server.
As for installing the _A_P porrtions of LAMP, if "lamp"
"Karl O. Pinc" <[EMAIL PROTECTED]> writes:
> I would expect that because a row exists, even
> though the value assigned is NULL, FOUND would
> be TRUE. Are my expectations wrong?
No, but I think your code is. Please provide a test case demonstrating
this behavior.
regard
On Thu, Oct 19, 2006 at 09:31:40PM +0530, Sandeep Kumar Jakkaraju wrote:
> I use postgis to wipe my ASS ...
> no good documentation ...
If you find the documentation lacking then please consider posting
to postgis-users with suggestions for improving it. Even better,
submit a patch :-)
> in what
Hi,
The docs say:
A SELECT INTO statement sets FOUND true if it returns a row,
false if no row is returned.
I'm running a plpgsql procedure from a trigger and
am doing a "SELECT INTO foo bar ..." where a row
matches the selection criteria, but the value of
that row's bar column is NULL. The
"John D. Burger" <[EMAIL PROTECTED]> writes:
> I'm having trouble figuring out when (if) the planner inlines sql
> functions (I'm running 7.4). I was assuming that pure sql functions
> are kind of like views with parameters, but I can't seem to see any
> cases where functions that select fro
I'm having trouble figuring out when (if) the planner inlines sql
functions (I'm running 7.4). I was assuming that pure sql functions
are kind of like views with parameters, but I can't seem to see any
cases where functions that select from a table get inlined. For
instance:
create func
On Thu, 2006-10-19 at 19:05 -0500, Ritesh Nadhani wrote:
> Thanks.
>
> So the implicit value means that PG gave it a name?
>
Right, when you declare a column to be a primary key, PostgreSQL must
create an index to enforce the unique constraint. This index must have
some kind of name, so PostgreS
Joseph S writes:
> But if the tuple in question was created and then deleted after the
> transaction, the transaction should still not need to see it.
No, because it might have taken a snapshot during the interval where the
tuple was good.
regards, tom lane
Thanks.
So the implicit value means that PG gave it a name?
Jeff Davis wrote:
On Thu, 2006-10-19 at 18:32 -0500, Ritesh Nadhani wrote:
Hello
Just trying to play around with PostgreSQL. Some commands and their
result are:
test=# create table ncbi ( id serial, title varchar(50), abstract tex
On Thu, 2006-10-19 at 18:32 -0500, Ritesh Nadhani wrote:
> Hello
>
> Just trying to play around with PostgreSQL. Some commands and their
> result are:
>
> test=# create table ncbi ( id serial, title varchar(50), abstract text,
> primary key(id));
> NOTICE: CREATE TABLE will create implicit seq
Maurice Yarrow <[EMAIL PROTECTED]> writes:
> I am hoping that there is an equivalent
> upgraded init.d/postgresql startup/shutdown script available
> for the postgres 8.1 tree.
The Postgres project proper doesn't maintain system-specific start
scripts. Look in the RPM distributions instead --- e
Hello
Just trying to play around with PostgreSQL. Some commands and their
result are:
test=# create table ncbi ( id serial, title varchar(50), abstract text,
primary key(id));
NOTICE: CREATE TABLE will create implicit sequence "ncbi_id_seq" for
serial column "ncbi.id"
NOTICE: CREATE TABLE
Hello Postgres-General users
I currently am upgrading from PostgreSQL 7.3.4-RH to
PostgreSQL 8.1.5. Everything fine so far: have
installed 8.1.5 into /usr/local/pgsql, of course, and am
running 8.1.5 on port 5433,
while still running 7.3.4 (in /var/lib/... and /usr/bin/pg...)
Then (also, witho
But if the tuple in question was created and then deleted after the
transaction, the transaction should still not need to see it.
Martijn van Oosterhout wrote:
On Thu, Oct 19, 2006 at 04:25:09PM -0400, Joseph S wrote:
The problem is that the "old" transaction can see effects of later
started t
On Oct 19, 2006, at 8:19 AM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
I want to upgrade a system from 7.3.8 ro 8.1.5
I am new to Psql and looking for handy hints
Any known problems or pit-falls ?
You'll need to dump the database and reload (pg_dump and pg_restore),
8.1 uses a diffe
On Thu, Oct 19, 2006 at 04:25:09PM -0400, Joseph S wrote:
> >The problem is that the "old" transaction can see effects of later
> >started transactions, so VACUUM can't delete the later stuff either...
>
> How can it see effects of transactions that started after it?
Check the documentation for t
Martijn van Oosterhout wrote:
Sure, don't keep transactions open for so long. Is there a particular
reason you do that?
Because I have a leak somewhere? Even if the transaction isn't that old
it will still cause me some table bloat in the meantime.
The problem is that the "old" transaction
On Thu, Oct 19, 2006 at 04:18:50PM -0400, Joseph Shraibman wrote:
> I'm running postgres 8.0.8. I have a table that is updated very
> rapidly, so I vacuum it every 10 minutes. The problem is that I
> sometimes have transactions that hang out for a long time without doing
> anything. These tra
I'm running postgres 8.0.8. I have a table that is updated very
rapidly, so I vacuum it every 10 minutes. The problem is that I
sometimes have transactions that hang out for a long time without doing
anything. These transactions are preventing VACUUM from cleaning up
tuples that were created
> Do I need to remove mySQL or leave it installed?
>
> Kirt
If you don't need itremoveit
leonel
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Do I need to remove mySQL or leave it installed?
Kirt
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Leonel Nunez
Sent: Thursday, October 19, 2006 4:02 PM
To: kbajwa
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Ubuntu Help
> Hello:
>
>
>
> I
kbajwa wrote:
Hello:
I am going to install Ubuntu OS under their LAMP installation. This LAMP
installation installs mySQL. Is there any way I can install postgreSQL
instead of mySQL? Has anybody created a LAMP to install Ubuntu, Apache,
postgreSQL & PHP?
Kirt
I don't know about a preco
> Hello:
>
>
>
> I am going to install Ubuntu OS under their LAMP installation. This LAMP
> installation installs mySQL. Is there any way I can install postgreSQL
> instead of mySQL? Has anybody created a LAMP to install Ubuntu, Apache,
> postgreSQL & PHP?
>
>
>
> Kirt
>
>
>
after instalation do
Hello:
I am going to install Ubuntu OS under their LAMP
installation. This LAMP installation installs mySQL. Is there any way I can install
postgreSQL instead of mySQL? Has anybody created a LAMP to install Ubuntu,
Apache, postgreSQL & PHP?
Kirt
thank you very much, we will test it
br,
Peter
2006/10/19, Jim C. Nasby <[EMAIL PROTECTED]>:
On Thu, Oct 19, 2006 at 01:57:56PM +0200, Peter Bauer wrote:
In the update statement, don't wrap the ID values in quotes. At best
it's extra work; at worse it will fool the planner into not using the
in
Bernard Grosperrin wrote:
I wants to make a view giving me some statistics.
I am not sure to understand why something like this
SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) /
(sold_parts_amount_dly + sold_labor_amount_dly) from sales
give me a division by zero error?
If
> I want to upgrade a system from 7.3.8 ro 8.1.5
> I am new to Psql and looking for handy hints
> Any known problems or pit-falls ?
> Anything we need to do in preparation ?
The Postgresql manual is a good place to start:
http://www.postgresql.org/docs/8.1/interactive/install-upgrading.html
http:/
Hi,
I have a strange problem running Django on a GrokThis.net shared
hosting account:
Environment:
--
Apache/2.0.59 (Unix)
mod_fastcgi/2.4.2
PostgreSQL 8.1.3
--
settings.py:
-
I wants to make a view giving me some statistics.
I am not sure to understand why something like this
SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) /
(sold_parts_amount_dly + sold_labor_amount_dly) from sales
give me a division by zero error?
If that is not the way to go,
Hi,
I have a question connected with postgres procedural langauge. Version
of Postgres:
"PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC gcc"
I have a table on which I have created many triggers on the same event
BEFORE UPDATE.
I have 3 these triggers. In each of this trigger I have a st
I want to upgrade a system from 7.3.8 ro 8.1.5
I am new to Psql and looking for handy hints
Any known problems or pit-falls ?
Anything we need to do in preparation ?
Cheers
CraigW
---(end of broadcast)---
TIP 3: Have you checked our extensive F
I am migrating a database from 7.4 in SQL_ASCII encoding to 8.1 in UTF8.
I made a pg_dump of the 7.4 database. I had difficulty (there are
invalid UTF8 characters in the original database, like 0xb9) going
straight into 8.1 with UTF8, so I tried importing it in a temporary 8.1
cluster that I set to
On 10/19/06, DANTE Alexandra <[EMAIL PROTECTED]> wrote:
Hello Robin, hello List,
Can I use it on RHEL4-AS ? I also tried to find the rpm sources on the
Red Hat web site, without success...
Download the source and try. rpmbuild --rebuild *.src.rpm. If it
doesn't work at least you have .spec fi
Chris Browne <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Tom Lane) writes:
>> What I'm tempted to do is add this to pg_getaddrinfo_all (in
>> src/backend/libpq/ip.c):
>> ...
> That seems to work fine, too. And that seems somewhat more
> portable/elegant/something.
OK, patch applied as far b
[EMAIL PROTECTED] (Tom Lane) writes:
> Chris Browne <[EMAIL PROTECTED]> writes:
>> Is there a more elegant way of setting the requested port to 0 than my
>> 2-liner?
>
> What I'm tempted to do is add this to pg_getaddrinfo_all (in
> src/backend/libpq/ip.c):
>
> {
> /* not all versions of ge
Chris Browne <[EMAIL PROTECTED]> writes:
> Is there a more elegant way of setting the requested port to 0 than my
> 2-liner?
What I'm tempted to do is add this to pg_getaddrinfo_all (in
src/backend/libpq/ip.c):
{
/* not all versions of getaddrinfo() zero *result on failure */
*r
Thanks Woody
Bob
- Original Message -
From:
Woody Woodring
To: 'Bob Pawley' ; 'Postgresql'
Sent: Thursday, October 19, 2006 8:18
AM
Subject: Re: [GENERAL] PostGIS
Here is their web page:
http://postgis.refractions.net/
I am probably not the best to
[EMAIL PROTECTED] (Tom Lane) writes:
> Chris Browne <[EMAIL PROTECTED]> writes:
>> [EMAIL PROTECTED] (Tom Lane) writes:
>>> Chris Browne <[EMAIL PROTECTED]> writes:
(gdb) print addr->ai_addr->sa_data
$18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
>>>
>>> Hmm, that looks a b
Thanks Jim
Bob
- Original Message -
From:
James Cradock
To: Postgresql
Cc: Bob Pawley
Sent: Thursday, October 19, 2006 8:35
AM
Subject: Re: [GENERAL] PostGIS
On Oct 19, 2006, at 11:08 AM, Bob Pawley wrote:
Can anyone point me to an overview of P
[EMAIL PROTECTED] (Tom Lane) writes:
> Brad Nicholson <[EMAIL PROTECTED]> writes:
>> On Wed, 2006-10-18 at 15:59 -0400, Tom Lane wrote:
>>> Also, do regular connections to this postmaster work across TCP/IP?
>>> If getaddrinfo() is broken I'd expect there to be problems binding
>>> to the postmast
On Thu, Oct 19, 2006 at 01:57:56PM +0200, Peter Bauer wrote:
In the update statement, don't wrap the ID values in quotes. At best
it's extra work; at worse it will fool the planner into not using the
index.
> shared_buffers = 1000 # min 16 or max_connections*2, 8KB each
This is *way* to
Chris Browne <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] (Tom Lane) writes:
>> Chris Browne <[EMAIL PROTECTED]> writes:
>>> (gdb) print addr->ai_addr->sa_data
>>> $18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
>>
>> Hmm, that looks a bit odd --- what's the full declaration of str
I use postgis to wipe my ASS ...no good documentation ...in what units is the result of distance(geometry,geometry)..what is distance_sphere(geometry,geometry).. when u give same geometry as both parameters it gives a non-zero value
On 10/19/06, James Cradock <[EMAIL PROTECTED]> wrote:
On Oct
On Thu, Oct 19, 2006 at 10:36:29AM -0400, AgentM wrote:
> Only if each message is contained in its own transaction since now()
> is effectively a constant throughout a transaction. In this case, I
> would choose a surrogate key since it is likely that the table will
> be referenced.
See time
On Thu, Oct 19, 2006 at 07:51:17AM -0300, Rodrigo Sakai wrote:
> I?m developing a specialist application that needs a different kind of
> referential integrity! I need interval referential integrity where the
> bounds of the referenced interval must overlaps (or be equal) the bounds of
> the refe
On Oct 19, 2006, at 11:08 AM, Bob Pawley wrote:Can anyone point me to an overview of PostGIS and how it is being used??? Bob, PostGIS provides extensions to PostgreSQL's procedural language and geometric data types so that it can store geo-referenced data, and so that you can query this data using
thank you, so we will perform the tests with such a vacuum configuration,
br,
Peter
2006/10/19, Tom Lane <[EMAIL PROTECTED]>:
"Peter Bauer" <[EMAIL PROTECTED]> writes:
> There is a table called tableregistrations where per day about
> 1 million rows are INSERTed
> 2 SELECTs should be perfor
Hi,
the drbd device can only be active and mounted on one machine, so the
other is just in standby.
Regards,
Peter
2006/10/19, Richard Huxton :
Peter Bauer wrote:
> - Two of these clusters are using the same PostgreSQL installation to
> share the data
Just checking - you're not sharing the sa
Here is their web page:
http://postgis.refractions.net/
I am probably not the best to answer how it is used because
we use it just to allow index on spatial data (coordinates). You may ask
on the postgis mailing list.
Woody
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
Can anyone point me to an overview of PostGIS and how it
is being used???
Bob Pawley
[EMAIL PROTECTED] (Tom Lane) writes:
> Chris Browne <[EMAIL PROTECTED]> writes:
>> (gdb) print addr->ai_addr->sa_data
>> $18 = "\000\001\177\000\000\001\000\000\000\000\000\000\000"
>
> Hmm, that looks a bit odd --- what's the full declaration of structs
> sockaddr and sockaddr_in on that machine?
On Oct 19, 2006, at 10:30 , John D. Burger wrote:
cckramer wrote:
I have table for online chat system that keep messages sent
between users.
Question: is it okay to use timestamp as primary key, or there is
possibility of collision? (Meaning two processes may INSERT into
table
within s
On Thu, 19 Oct 2006 06:14:46 -0600, Rick Gigger wrote:
> I think we've got it figure out though. We were able to patch up the
> db enough to extract the data with some help from google and old postings
> from Tom.
It would be really great if you put down the specifics of what you
googled/old post
cckramer wrote:
I have table for online chat system that keep messages sent between
users.
Question: is it okay to use timestamp as primary key, or there is
possibility of collision? (Meaning two processes may INSERT into table
within same millisecond.) It is a web application.
tometzky wr
Peter Bauer wrote:
- Two of these clusters are using the same PostgreSQL installation to
share the data
Just checking - you're not sharing the same data files between two
machines here, are you? Because that's not good.
--
Richard Huxton
Archonet Ltd
---(end of b
Joe Kramer wrote:
Hello,
I have table for online chat system that keep messages sent between users.
CREATE TABLE chat_message
(
message_time timestamp without time zone NOT NULL DEFAULT now(),
Hmm - timestamp without time zone. So you don't actually care when the
message was sent? Or you kn
On Thu, Oct 19, 2006 at 01:42:48AM -0700, Georgi Petrov wrote:
> Is it better to install pg on Solaris from packages or
> build it from source?
Define "better." I prefer to build from source so I know I'm using
the same source code the developers are using and so I can control
the configure setti
Hello Robin, hello List,
I have also spent "several minutes" searching the src.rpm, but the only
rpm source that I found was for Fedora Core...
For example, in the site
http://rpm.pbone.net/index.php3/stat/4/idpl/2919466/com/perl-rrdtool-1.2.13-1.fc3.rf.x86_64.rpm.html,
the rpm source availabl
"Peter Bauer" <[EMAIL PROTECTED]> writes:
> There is a table called tableregistrations where per day about
> 1 million rows are INSERTed
> 2 SELECTs should be performed on it
> 1 UPDATEs should be performed where about 100 rows are updated
> with each execution
> 1 DELETEs should be per
Hi,
its just a vacuumdb --all. We already learned that full vacuums are
evil because the database was carrupted after some time.
Regards,
Peter
2006/10/19, Tomasz Ostrowski <[EMAIL PROTECTED]>:
On Thu, 19 Oct 2006, Peter Bauer wrote:
> A vaccum of the whole database is performed every 10 minu
On 10/19/06, DANTE Alexandra <[EMAIL PROTECTED]> wrote:
My problem is that I have not found any RPM for "perl-rrdtool" and
"rrdtool" for IA64 and RHEL4-AS (for the others, it's OK).
Does someone know where I can find them or tell me where I can find the
associated "tar.gz" archive ?
Download t
Hello List,
I work with PostgreSQL 8.1.3 on an IA64 server with Red Hat Enterprise
Linux 4 AS and I try to install Munin 1.2.4.
To do that, I downloaded these RPM from Sourceforge :
- munin-1.2.4-8rhel4.noarch.rpm
-munin-node-1.2.4-8rhel4.noarch.rpm
and "munin-plugins-postgresql-0.3.tar.tar" fr
On Thu, 19 Oct 2006, Peter Bauer wrote:
> A vaccum of the whole database is performed every 10 minutes with
> cron
What is the command you use? Maybe you are vaccuming with "-f" and
locking the whole table.
Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
mo
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful.
Hi all,
we are struggling for some time now with PostgreSQL 8.1.4 and the
situation is pretty critical so please help with whatever comes to
your mind.
We even did an upgrade from version 7.4.13, tried different vacuum
configurations and optimized the configuration.
There is a table called table
On Thu, 19 Oct 2006, Joe Kramer wrote:
> Question: is it okay to use timestamp as primary key, or there is
> possibility of collision? (Meaning two processes may INSERT into table
> within same millisecond.) It is a web application.
If your insert fail you can always try again after some random s
Hello,
I have table for online chat system that keep messages sent between users.
CREATE TABLE chat_message
(
message_time timestamp without time zone NOT NULL DEFAULT now(),
message_body text,
user_id_from bigint,
user_id_to bigint,
CONSTRAINT chat_message_pkey PRIMARY KEY (message_time)
)
Hello all,
I’m developing a specialist application
that needs a different kind of referential integrity! I need interval
referential integrity where the bounds of the referenced interval must overlaps
(or be equal) the bounds of the referencing interval!
For example,
-
Hi,
I am using and installing pg on many servers running
FreeBSD and it works perfect.
Now I need to install a brand new Solaris 10 ( from
opensolaris.org) on amd64 (Opteron) and install pg on
it.
Till now I installed pg from source (on FreeBSD and
many linux systems).
My first question :
Is it
76 matches
Mail list logo
