CSN wrote:
I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?
Yes: www.anisite.com (see http://www.anisite.com/state.php?state=FL). I
am using it to serve dynamic layers for UMN Mapserver. Setup was fairly
easy, and it
Douglas McNaught [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] writes:
are there any way to make them global for all the instances?
Put them in shared memory. This probably isn't trival, as all the
shared memory is allocated up front and used for existing purposes (at
least, as I understand
To the Advocacy Group:
I'll add my thoughts to the discussion by sharing with you a note I just
sent to the EnterpriseDB network, including customers, partners, and
friends. Best,
Andy
clip here
As many of you have heard, Oracle recently purchased Innobase, the
company
Hi,
I have several java jdbc client applications that
connect to my Postgres 8.0.4 server.
"After some days" the server rejects the
connections. There are nomessage in the log file.Only the local
connections are permitted.
I have tryed to make a connection with EMS
postgresql and I
Francisco Reyes wrote:
Ever since I installed a particular program, PHPWiki, I am seeing idle
postgres sessions.. even days old. Is it safe to delete them?
For example:
postmaster: wiki simplicato_wiki [local] idle (postgres)
Ultimately I will either switch wiki or take the time and find the
Hi,
We are using GUIDS as primary keys. At the moment were
using a varchar 32. Wed like to use varchar 16 but had some problems
with the generated chars; we were using UNICODE locale (were now using
WIN1251). Should we use bytea, retry varchar 16 (with the new local), or some
other column
Hi All,
I have a small problem in using nested
transactions while working on Postgres 8.0.
Ex: I have a function A() which in turn
calls functions b() and c() , if i want commit something in b or c. i have to
use
start transaction read write;
-- set of sql statements and then say
Francisco Reyes wrote:
Ever since I installed a particular program, PHPWiki, I am seeing idle
postgres sessions.. even days old. Is it safe to delete them?
I wouln't do that. These seems to be php persistent connections, and
they are idle for the moment but reused for new wiki requests.
Yes, we are using PostGIS with JUMP GIS.
http://www.jump-project.org/
http://openjump.org
CSN schrieb:
I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?
Thanks,
CSN
__
Hi,
On Sun, 16 Oct 2005, CSN wrote:
I've been meaning to try out PostGIS and see what it
is capable of. Is anybody using it? Do you have
accompanying URLs?
There are mailing lists for PostGIS-related questions.
See http://www.PostGIS.org for the details.
Regards,
--
Devrim GUNDUZ
Kivi
On Mon, 17 Oct 2005, Richard Huxton wrote:
At a guess, PHPWiki is using persistent connections to PG, so you'll get one
connection per Apache backend.
Thanks for the info. That may well be the problem.
Alternatively, a small change in PHPWiki's code should clear it too (start
with a search
Stefano B. [EMAIL PROTECTED] writes:
I have several java jdbc client applications that connect to my Postgres
8.0.4 server.
After some days the server rejects the connections. There are no message
in the log file. Only the local connections are permitted.
I have tryed to make a connection
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I don't think that PostgreSQL is really on Oracle's radar at the moment.
Please don't make this assumption. PostgreSQL is *very* much on their radar,
and probably represents the biggest long-term threat to their core database
business at the
Jim C. Nasby wrote:
pg_dump handles table ordering properly.
Maybe I missed something then, because it didn't last time I tried to
move some data. I had to drop my foreign keys before I could reload it.
Dan
--
Daniel Armbrust
Biomedical Informatics
Mayo
You are talking about a shmem block using by the backend, right? Or about my
own shmem block?. I'm very interested in the implementation of a
constants like functionality to pgsql, but I don't know where to start
with... Any help or ideas?
-Original Message-
From: Tom Lane [mailto:[EMAIL
On 10/16/2005 12:40 PM, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Actually, perhaps an even more restricted version would be better.
Lowercase quoted identifiers only if they are all uppercase. So then:
No, I think the original proposal was better. This one doesn't fix
Jan Wieck [EMAIL PROTECTED] writes:
What is bad about leaving pg_catalog all lower case and expect everyone
to query the catalog quoted?
The fact that it will break every nontrivial client currently in
existence. Those quotes aren't there in the clients and we can't
suddenly mandate them to
Francisco Reyes wrote:
How about when one needs to reload to read new postgresql.conf files.
Will iddle connections prevent the server from reloading?
http://www.postgresql.org/docs/8.0/static/app-pg-ctl.html
Also, in the future if other programs do the same, is it safe to kill
these and
On 10/17/2005 10:16 AM, Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What is bad about leaving pg_catalog all lower case and expect everyone
to query the catalog quoted?
The fact that it will break every nontrivial client currently in
existence. Those quotes aren't there in the
Please don't make this assumption. PostgreSQL is *very* much on their radar,
and probably represents the biggest long-term threat to their core database
business at the moment. We got a hint of that during the .org bidding, but
for now it is in Oracle's interest not to call attention to
Hi all,
I wonder what caused the error we just got on a postgres 8.0.3 data base
(using JDBC to connect, but I guess that's not really relevant for this
error):
[snip stack trace]
Caused by: org.postgresql.util.PSQLException: ERROR: could not access
status of transaction 0
[snip]
Could it be
OK, I should have included the postgres log this in the first place
beside only the JDBC log:
ERROR: could not access status of transaction 0
DETAIL: could not create file /postgresdata/pg_subtrans/04E7: Die
Datei existiert bereits
The german text means the file exists already.
Any advice of
Dan Armbrust [EMAIL PROTECTED] writes:
Jim C. Nasby wrote:
pg_dump handles table ordering properly.
Maybe I missed something then, because it didn't last time I tried to
move some data. I had to drop my foreign keys before I could reload
it.
What version was this? Older versions
If you need user-accessible shared variables, you could take a look at
how Veil http://pgfoundry.org/projects/veil/ achieves this.
Veil provides a limited number of shared variables with an API for SQL
access. The variables may only be set during initialisation or reset to
avoid system state
Hello,
An autovacuum deamon has been installed as a Windows service during
the setup of my PG 8.0.3 server on WinXP. I am surprised because I
believed that autovacuum was only available in 8.1 server. There is
no autovacuum_XXX parameters in postgresql.conf... How can I be sure
that autovacuum
Last night I upgraded my three DB servers from 7.4.8 to 8.0.4 (RPM from
the PostgreSQL site). This morning I found my servers very busy from
three queries that were two hours old:
The following query ran in a fraction of a second on 7.4.8:
SELECT receipt_date, process_date, callsign AS
Douglas McNaught [EMAIL PROTECTED] writes:
Dan Armbrust [EMAIL PROTECTED] writes:
Maybe I missed something then, because it didn't last time I tried to
move some data. I had to drop my foreign keys before I could reload
it.
What version was this? Older versions definitely had some problems
IMHO, Veil is very strange project. Instead of concentrating on good
support of updatable views, developers are trying to reinvent the
wheel. Actually, if restriction-and-projection views would be
updatable w/o overhead (such as creating rules), there'll no need in
such project. It's one of the
On Mon, 2005-10-17 at 09:46, Christopher Kings-Lynne wrote:
Please don't make this assumption. PostgreSQL is *very* much on their radar,
and probably represents the biggest long-term threat to their core database
business at the moment. We got a hint of that during the .org bidding, but
On Sun, Oct 16, 2005 at 10:08:41AM -0700, Jeff Davis wrote:
jeff sacksteder wrote:
The sign doesn't concern me. I am storing a value that is unsigned and 16
bits wide natively. I'll have to just use an int4 and waste twice the space
I actually need.
Are you sure you'd really save space
In the query below, if I replace:
(SELECT TRUE FROM archivejb WHERE ( (callsign = gen.callsign AND
license_status = 'A' AND prev_callsign = gen.vanity_callsign)
OR (callsign =
gen.vanity_callsign AND licensee_id =
Noticed this in one of my pg logs last Friday:
LOG: could not fsync segment 0 of relation 1663/16387/22359: Input/output error
ERROR: storage sync failed on magnetic disk: Input/output error
This relation corresponds to a table, which receives thousands of inserts via
COPY every couple of
Jan Wieck wrote:
On 10/17/2005 10:16 AM, Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What is bad about leaving pg_catalog all lower case and expect
everyone to query the catalog quoted?
The fact that it will break every nontrivial client currently in
existence. Those quotes
Tom Lane wrote:
Chris Travers [EMAIL PROTECTED] writes:
I make the following assumptions:
1) All backend references to identifiers are treated as quoted by the
backend as mentioned in a previous thread.
2) Same with official clients like psql.
3) We don't guarantee complete
On Mon, 2005-10-17 at 22:46 +0800, Christopher Kings-Lynne wrote:
And they probably read every word we write ;)
...and it will certainly slow them down :-)
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On Sun, Oct 16, 2005 at 11:03:52AM +0200, Sim Zacks wrote:
create function uint_in(val cstring) returns uint2 as
$$
declare thisval int4;
begin
thisval=val::int4
if thisval between 0 and 65535 then
return (thisval-32768)::int2;
else
return 0;
end if;
end
$$ language 'plpgsql';
[EMAIL PROTECTED] (Tom Lane) writes:
I've been trying to figure out what it is that Oracle gets out of
this, assuming that they don't see MySQL as a serious threat to
their core business. The most they can do is force MySQL AB to
waste a year or so reimplementing something equivalent to
You can't do subtransactions in PostgreSQL, but you can use savepoints:
http://www.postgresql.org/docs/8.0/interactive/sql-savepoint.html.
Previously, you couldn't do any transactional stuff from inside
functions. I'm not sure if you can do savepoint-related stuff from
inside functions in 8.0 or
Google for 'postgresql uuid' will reveal some options.
On Mon, Oct 17, 2005 at 09:03:17AM +0100, Paul Newman wrote:
Hi,
We are using GUIDS as primary keys. At the moment we're using a varchar
32. We'd like to use varchar 16 but had some problems with the generated
chars; we were using
Scott Marlowe wrote:
I'd bet they read plenty, but don't necessarily understand a lot,
judging by their pitiful fud campaign when Afilias proposed using
postgresql as a database behind .org. They tried to say PostgreSQL
didn't support transactions. So, while we may be on their screens, and
Thanks for the reply. I'm using 8.0.3. I'm using
something similiar to the example you gave. My
postgresql install is on offline developement box and
I would have to type it all out longhand.
Shouldn't = also return Carols records since she
contains records GREATER THAN 1? This is the
On Fri, Oct 14, 2005 at 02:28:52PM -0700, Joshua D. Drake wrote:
But what if they came in sideways and bought Command Prompt?
Well then I would be sitting on a beach in New Zealend with an umbrella
drink :)
(As an
example.) You could do a lot more to destroy PostgreSQL's market
Those two queries aren't the same. The first one can only return 0 or 1 rows;
the second one can return 0, 1, or 2 rows.
An explain analyze of each should show why one is much faster than the
other.
On Mon, Oct 17, 2005 at 10:29:43AM -0700, Dean Gibson (DB Administrator) wrote:
In the query
Bricklen Anderson [EMAIL PROTECTED] writes:
Noticed this in one of my pg logs last Friday:
LOG: could not fsync segment 0 of relation 1663/16387/22359: Input/output
error
ERROR: storage sync failed on magnetic disk: Input/output error
That's a hardware problem. Run some disk diagnostics,
Nikolay,
I think I must be missing your point. Even if updatable views existed,
I would still have created Veil. The real point of Veil is to control
each type of operation (insert, update, etc) on each record.
With updatable views, you could avoid a lot of the tedium of creating
the instead-of
Chris Browne wrote:
[EMAIL PROTECTED] (Tom Lane) writes:
I've been trying to figure out what it is that Oracle gets out of
this, assuming that they don't see MySQL as a serious threat to
their core business. The most they can do is force MySQL AB to
waste a year or so reimplementing
Alright, what about with ANY?
--- Joe Conway [EMAIL PROTECTED] wrote:
Matthew Peter wrote:
Shouldn't = also return Carols records since she
contains records GREATER THAN 1? This is the
problem I'm having, there's no errors, just no
records
matching the (gt) part. Only exact
Matthew Peter wrote:
Shouldn't = also return Carols records since she
contains records GREATER THAN 1? This is the
problem I'm having, there's no errors, just no records
matching the (gt) part. Only exact matches.
Look again at your query:
SELECT * FROM sal_emp WHERE 1 = ALL
Jim C. Nasby [EMAIL PROTECTED] writes:
You can't do subtransactions in PostgreSQL, but you can use savepoints:
http://www.postgresql.org/docs/8.0/interactive/sql-savepoint.html.
Previously, you couldn't do any transactional stuff from inside
functions. I'm not sure if you can do
Matthew Peter [EMAIL PROTECTED] writes:
Shouldn't = also return Carols records since she
contains records GREATER THAN 1?
You seem to be reading the construct backwards.
x = ALL (array)
is true if x = every member of the array. This is clearly false
for x = 1 and array =
Dean Gibson (DB Administrator) [EMAIL PROTECTED] writes:
The following query ran in a fraction of a second on 7.4.8:
...
On 8.0.4, it runs for hours (stopped after two hours). Here's the plan:
Do you have the plan used by 7.4?
BTW, this is not really on-topic for pgsql-general; pgsql-perform
On Mon, Oct 17, 2005 at 11:20:00AM -0700, elein wrote:
The scenario that no one has mentioned wrt postgresql and oracle is
that oracle can take the source code, branch it or not and support it.
If they branch, it will have less credibility and it will become
interesting.
But support money
On Mon, 17 Oct 2005, Matthew Peter wrote:
Thanks for the reply. I'm using 8.0.3. I'm using
something similiar to the example you gave. My
postgresql install is on offline developement box and
I would have to type it all out longhand.
Shouldn't = also return Carols records since she
Thanks. That syntax didn't look right to find values
gte 1. But thanks everyone!
--- Tom Lane [EMAIL PROTECTED] wrote:
Matthew Peter [EMAIL PROTECTED] writes:
Yes. I did read it wrong. I wanted to find all
records
that contained x where x = 1
Then flip it around:
Yes. I did read it wrong. I wanted to find all records
that contained x where x = 1
I am using ANY in my query on my test box I copied the
ALL from example query in the docs, which still isn't
working for me.
--- Tom Lane [EMAIL PROTECTED] wrote:
Matthew Peter [EMAIL PROTECTED] writes:
NOT TRUE!
The second query is effectively (SELECT TRUE ...WHERE ... LIMIT 1) OR
(SELECT TRUE ...WHERE ... LIMIT 1) AS ...
The first portion in parentheses can return either a single row of TRUE,
or no row (NULL). Ditto for the second portion. The OR means that you
logically combine TRUEs
Chris Browne [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] (Tom Lane) writes:
I've been trying to figure out what it is that Oracle gets out of
this, assuming that they don't see MySQL as a serious threat to
their core business.
[ snip ]
Of course, if the ability to support R/3 requires
I have it backwards huh? Since the variables are
switched around in a ANY search
I want a SELECT * FROM table WHERE arrcol = 1
How do I write it to get those results?
--- Tom Lane [EMAIL PROTECTED] wrote:
Matthew Peter [EMAIL PROTECTED] writes:
Shouldn't = also return Carols records
Matthew Peter [EMAIL PROTECTED] writes:
Yes. I did read it wrong. I wanted to find all records
that contained x where x = 1
Then flip it around:
contain x where 1 = x
1 = ANY (array)
For syntactic reasons, there's no ANY(array) = x construct,
so you have to write
Let me also say that I'm retarded. No excuses from me.
I'm officially retarded.
--- Matthew Peter [EMAIL PROTECTED] wrote:
Thanks. That syntax didn't look right to find values
gte 1. But thanks everyone!
--- Tom Lane [EMAIL PROTECTED] wrote:
Matthew Peter [EMAIL PROTECTED]
Jim C. Nasby [EMAIL PROTECTED] writes:
Of course, Oracle could tank the market by offering support at
un-competitive prices, but I can't think of a reason for them to do that
off the top of my head.
They might hope that they could drive the existing support companies out
of business (assuming
I stand corrected; I read through the example too quickly.
As I said, explain analyze would show what the difference is between the
two queries. I suspect that the planner doesn't know these are
equivalent, because in the general case of selecting more than just TRUE
they wouldn't be.
No idea
I don't have the plan for the original query under 7.4, but you will
note I've posted a work-around for 8.0.4 that runs in a fraction of a
second on 8.0.4, and here's the plan for that:
Sort (cost=2393.24..2393.25 rows=2 width=114)
Sort Key: _Pending.receipt_date,
elein wrote:
The scenario that no one has mentioned wrt postgresql and oracle is
that oracle can take the source code, branch it or not and support it.
If they branch, it will have less credibility and it will become interesting.
But support money from a big name company (Oracle) should be
Is there a way to get the ip address of the connections listed in
pg_stat_activity?
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
I was needing something similar last week, not to throw an error,
but to catch an error when 99% of my column's data is real, but some
is not (e.g. '1.2-1.4' or '32.7'). I wanted to do it in pure
SQL, but settled on this. Is there a way to do this in pure
SQL (so it will be faster)?
Declare x
Tom Lane wrote:
(BTW, has anyone looked lately to see how far away Postgres is from
being able to run SAP?)
It runs OpenMFG just fine ;-)
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
Tom Lane wrote:
Chris Browne [EMAIL PROTECTED] writes:
Of course, if the ability to support R/3 ...
Ah-hah. *Now* it's all clear: an alternative to Oracle for SAP...
Speaking of SAP...
Jeff Nolan, a Venture Capitalists from SAP Ventures
On Oct 17, 2005, at 9:34 AM, Dan Armbrust wrote:
Jim C. Nasby wrote:
pg_dump handles table ordering properly.
Maybe I missed something then, because it didn't last time I tried
to move some data. I had to drop my foreign keys before I could
reload it.
This is my experience as well.
Is there a way to get the ip address of the connections
listed in pg_stat_activity?
It is - in 8.1 :)
Until then, I think you'll need to do a netstat -nap or such a command
and match the pids. Manually.
//Magnus
---(end of broadcast)---
TIP
Dean Gibson (DB Administrator) [EMAIL PROTECTED] writes:
I don't have the plan for the original query under 7.4, but you will
note I've posted a work-around for 8.0.4 that runs in a fraction of a
second on 8.0.4, and here's the plan for that:
Dean, you're wasting our time with the
Hi,
On Wed, 12 Oct 2005, Brian Mathis wrote:
Also, are there any rpms for this setup? I looked in the binary section for
rpms, but all the directories were empty.
We currently don't have a x86_64 server that runs RHEL 4. That's why
there are no RPMs for that arch (I've uploaded RPMs for
[EMAIL PROTECTED] wrote on 10/17/2005 01:44:24 PM:
snip
(BTW, has anyone looked lately to see how far away Postgres is from
being able to run SAP?)
Uh, Tom? Are you in the habit of waiving red capes in front of bulls? :)
I assume the question was rhetorical, due to MySQL's capability gap
Tom Lane wrote:
They might hope that they could drive the existing support companies out
of business (assuming they didn't get convicted of antitrust violations
first --- which would be an open-and-shut case, but with the Republicans
in office they probably wouldn't get prosecuted :-().
Sort
Devrim GUNDUZ wrote:
We currently don't have a x86_64 server that runs RHEL 4. That's why
there are no RPMs for that arch (I've uploaded RPMs for many platforms
BTW). If someone wants to assist us to build RPMs for that platform,
please contact me. We'll give you all the necesarry
CSN,
We use PostGIS extensively on our DataDoors product
[http://www.datadoors.net].
- Onyx
---
Onyx Mueller
Software Engineer
i-cubed : information integration imaging LLC
201 Linden Street : Third Floor
Fort Collins, CO 80524
970-482-4400 voice
970-482-4499 fax
www.i3.com
-Original
* Tom Lane ([EMAIL PROTECTED]) wrote:
Matthew matthew@zeut.net writes:
Is it worth having a GUC variable that enables / disable this?
That's a given, I think. We're certainly not going to make smash-to-
lower-case the only available behavior.
A GUC variable for this would be quite nice..
I gave Rekall a try - and I was disappointed that it crashed with such
regularity.
I was more disappointed in the fact that when the Wizard is used to
build a Database connection to Postgresql the information box text
informs the user that the Postgresql is not as fast as MySql, but does
Johan Wehtje [EMAIL PROTECTED] writes:
I was more disappointed in the fact that when the Wizard is used to
build a Database connection to Postgresql the information box text
informs the user that the Postgresql is not as fast as MySql, but does
have support for transactions and Stored
Thanks VERY VERY much for Teodor Sigaev help,and my next problem is which is more suitable
for index chinese words, TSearch2 OR Lucene? My matessaid to me that Lucene is more effifent
because of its way of "Inverse Order OF Idexing",and "The GiST Tree is well for larting lan but doesn't for
Hi,
Thanks for the reply ,
I got it working using another begin and end with in a function.
getting in to detail i have done something like this.
create function functionName() return void as '
declare
:
:
begin
:
:
begin
-- perform some transactions say creation of a sequence or tables or
Title: RE: [GENERAL] fine tuned database dump/reload?
-Original Message-
From: [EMAIL PROTECTED] on behalf of Vivek Khera
Sent: Mon 10/17/2005 3:35 PM
To: Postgres General
Subject: Re: [GENERAL] fine tuned database dump/reload?
On Oct 17, 2005, at 9:34 AM, Dan Armbrust wrote:
82 matches
Mail list logo