On Wed, Sep 01, 2004 at 11:52:05PM -0400, Tom Lane wrote:
> David Garamond <[EMAIL PROTECTED]> writes:
> > I'm pretty clueless in regard to the PostGIS situation. Will it be
> > integrated with PostgreSQL in the future?
>
> No. Wrong license.
If the license were changed to be BSD compatible, are
On Sep 1, 2004, at 10:27 PM, Matthew T. O'Connor wrote:
Number of rows is irrelevant, but the number of tables might not be.
It could be that the process of checking it's list of tables against
the server might be slow when used with lots of tables. Does this cpu
spike happen every other loop?
David Garamond <[EMAIL PROTECTED]> writes:
> I'm pretty clueless in regard to the PostGIS situation. Will it be
> integrated with PostgreSQL in the future?
No. Wrong license.
> What are the benefits of using
> the builtin geometry types (since they don't have R-tree indexes)?
Some of 'em do.
Anony Mous wrote:
Great, I found the part of the docs referring to this (ch 27.11) however, it
refers to creating this file in the user's home directory. It seems this
part of the documentation is assuming I'm using *nix. In Windows, where
should this file be located? Also, .pgpass is an invalid
Thomas F.O'Connell wrote:
Well, I don't have a lot of databases, but I do have tens of thousands
of tables, many of which have hundreds of thousands of rows. I don't
know if that plays into things.
Number of rows is irrelevant, but the number of tables might not be. It
could be that the process
I'm pretty clueless in regard to the PostGIS situation. Will it be
integrated with PostgreSQL in the future? What are the benefits of using
the builtin geometry types (since they don't have R-tree indexes)?
--
dave
---(end of broadcast)---
TIP 4: D
Wow, I have no idea why that is failing. I just fixed some VC problems
for someone but they were actual bugs related to path.c. Your failure
looks like a build tools problem.
---
Dann Corbit wrote:
> U:\postgresql-8.0.0be
OK, I see your problem is the compilation of psql, which I am not sure
has been tested yet. I saw a few problems:
libpq bcc linked path.c while it was not needed
psql bcc and vc linked in path.c but didn't create a
pg_config_paths.h with the proper values.
The pg
Great, I found the part of the docs referring to this (ch 27.11) however, it
refers to creating this file in the user's home directory. It seems this
part of the documentation is assuming I'm using *nix. In Windows, where
should this file be located? Also, .pgpass is an invalid file name in Win.
On Wed, 2004-09-01 at 16:12, Doug McNaught wrote:
> "Anony Mous" <[EMAIL PROTECTED]> writes:
>
> > A few days ago there was a fellow that had trouble connecting remotely to
> > the 8.0 beta win port. I had the same problem, but have since found the
> > solution. In postgresql.conf file, ensure t
On Sep 1, 2004, at 5:09 PM, Matthew T. O'Connor wrote:
This is the first report I have heard of pg_autovacuum causing cpu
usage spikes. When pg_autovacuum wakes up, it loops through all the
databases checking for recent activity and decides if it is time to do
something. I would think that pg_
"Anony Mous" <[EMAIL PROTECTED]> writes:
> If so, why not set the listen_addresses to '*' right away?
Security. It was difficult enough to get people to accept the current
liberalized default --- I don't think they'll go for defaulting to -i,
which is essentially what you're asking for. It's see
"Anony Mous" <[EMAIL PROTECTED]> writes:
> A few days ago there was a fellow that had trouble connecting remotely to
> the 8.0 beta win port. I had the same problem, but have since found the
> solution. In postgresql.conf file, ensure the line "listen_addresses" is
> set to '*', ie,
>
> listen_a
Has anyone gotten VISIO setup to see the the pg system tables? I have
Visio 2003 and i am not sure of the driver version!
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I get this in the logs for every database open by pg_autovacuum:
Sep 1 14:02:45 cerberus pg_autovacuum: nss_ldap: could not connect to
any LDAP server as (null) - Can't contact LDAP server
This is produced by the bind_to() call in libnss-ldap. This is invoked
when /etc/nss_switch.conf specifies
"Russ Brown" <[EMAIL PROTECTED]> writes:
> Is there any difference between these queries in terms of the speed of
> planning or the quality of the plan untimately used?
http://www.postgresql.org/docs/7.4/static/explicit-joins.html
http://www.postgresql.org/docs/7.3/static/explicit-joins.html
htt
Is it legal syntax to use <> instead of != in a Postgres query?
I didn't see it listed on:
http://www.postgresql.org/docs/7.4/static/sql-syntax.html
but wanted to ask to make sure.
--
Greg Donald
---(end of broadcast)---
TIP 3: if posting/re
Russ Brown wrote:
> >> SELECT * FROM a, b WHERE a.x=b.x;
> >> SELECT * FROM a JOIN b ON a.x=b.x;
> That being the case, would it be true to say that with recent versions of
> PostgreSQL they both perform identically, meaning the second could be
> considered preferable due to its self-documenting
John Sidney-Woollett wrote:
Does anyone know if there is a postgres shorthand for Oracle's (+)
notation to denote an outer join?
eg
SELECT * from a, b where a.x = b.x (+)
Just the standard LEFT JOIN ... afaik
--
Richard Huxton
Archonet Ltd
---(end of broadcast)
Does anyone know if there is a postgres shorthand for Oracle's (+)
notation to denote an outer join?
eg
SELECT * from a, b where a.x = b.x (+)
John Sidney-Woollett
Richard Huxton wrote:
Russ Brown wrote:
I have always written queries with ordinary joins in this manner:
SELECT * FROM a, b WHERE a.
Hi, thanks for your reply,
On Wed, 1 Sep 2004 08:10:52 -0400, <[EMAIL PROTECTED]> wrote:
NOTE: The first way cannot support OUTER joins, the second way can.
Hence sometimes one has to use
the second way for at least some of the joins.
Yes, I've always done OUTER joins the second way. I suppose
Russ Brown wrote:
I have always written queries with ordinary joins in this manner:
SELECT * FROM a, b WHERE a.x=b.x;
However I recently saw an laternative syntax:
SELECT * FROM a JOIN b ON a.x=b.x;
Is there any difference between these queries in terms of the speed of
planning or the quality of
Thank you for the response Pierre,
select category, sum(amount) as sum_amount, extract (month from date)
as month
from all_accounts where (extract(year from date)=2003)
group by category,month order by category,month
is certainly much faster than what I am doing but as you pointed out,
I want t
NOTE: The first way cannot support OUTER joins, the second way can. Hence sometimes
one has to use
the second way for at least some of the joins.
PREVIOUSLY: The second way can allow one to tell the planner a "better way" to join
the tables.
Likewise it can also enable the programmer to force t
Hello all,
Recently a post on this list made me think a bit about the way in which I
write my queries.
I have always written queries with ordinary joins in this manner:
SELECT * FROM a, b WHERE a.x=b.x;
However I recently saw an laternative syntax:
SELECT * FROM a JOIN b ON a.x=b.x;
Is there any
Dear my friends
I created a column with datatype bytea. The name of
the column is emoicon
I did like this:
kv=# insert into salesreport (salesid, custid,
emoicon) values('13', '4531',
lo_import('/localhome/patrixlinux/arsip/proyek/qt/kv/client/images/1.png'));
ERROR: column "emoicon" is of
Nick schrieb:
Otherwise is there an recognised dump file in the same way that Oracle has
and if so how do I create it?
Hi Nick,
you should look at
pg_dump or pg_dumpall in the docs.
(or pg_dump --help)
restore the dumped database with psql.
Daniel
---(end of broadcast)--
Steve Crawford wrote:
I want to monitor inserts to table "foo":
guid: integer not null default nextval('public.guid'::text)
end_time: integer
[snip]
I expected the guid to match. Unfortunately there are no matching
guids between the two tables. It appears that the sequence is being
called twice
Checkout http://www.hentzenwerke.com/wp/cron_explained.pdf
Look for the MAILTO="" command which you can use to suppress the mailing
of cron job output.
And try redirecting std output to /dev/null, and/or send the output from
psql to a file.
John Sidney-Woollett
Ron St-Pierre wrote:
Is there a w
Use psycopg, it's a hell of a lot faster anyway.
On Tue, 31 Aug 2004 23:25:35 -0400, Jerry LeVan <[EMAIL PROTECTED]>
wrote:
Is it possible to build the python postgresql support library
on Mac OSX 10.3.5 with the default python install?
Adding "--with-python" gets an error message about libp
Your query looks suspiciously complicated...
Why not process all 12 months in one shot with something like this :
- only one subquery
- no join
- date between can make an index scan on date
select category, sum(amount) as sum_amount, extract (month from date) as
31 matches
Mail list logo
