On Jan 13, 4:21 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
Nick nboutel...@gmail.com writes:
SELECT * FROM locations WHERE id = 12345 LIMIT 1
uses the primary key (id) index, but...
SELECT * FROM locations WHERE id = get_location_id_from_ip(641923892)
LIMIT 1
does not and is verrry slow
Still having problems installing the geos file when trying to install
postgis...have a printout of errors we are still getting
computer/compiler/postgis info
rhel 5,
gcc-4.1.2-46el14.4.1
postgis1.4.0
below is our process and the errors we are getting, can anyone tell us
where the issue is?
Trying to install postgis on LINUX machine, need to find the geos-
config file, as seems it is no where to be found after download of
postgis in the ./configure step, is there anyone that can give me a
clue on how to find this file? Ultimate goal is to get postgis working
so we can use geom data
to find more info so we can move on from install
stage. Any more ideas appreciated...Thanks, Nick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to find more info so we can move on from install
stage. Any more ideas appreciated...Thanks, Nick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to find more info so we can move on from install
stage. Any more ideas appreciated...Thanks, Nick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Dec 28, 8:22 pm, pie...@hogranch.com (John R Pierce) wrote:
Nick wrote:
'g++' or g++ says -bash g++: command not found
distro is red hat
Assuming thats RHEL5,
yum install gcc-c++
if its RHEL4 or earlier, use up2date instead. either of these will
require a RHN subscription
On Dec 29, 1:21 pm, Nick nick.uebel...@noaa.gov wrote:
On Dec 28, 8:22 pm, pie...@hogranch.com (John R Pierce) wrote:
Nick wrote:
'g++' or g++ says -bash g++: command not found
distro is red hat
Assuming thats RHEL5,
yum install gcc-c++
if its RHEL4 or earlier, use
On Dec 28, 8:22 pm, pie...@hogranch.com (John R Pierce) wrote:
Nick wrote:
'g++' or g++ says -bash g++: command not found
distro is red hat
Assuming thats RHEL5,
yum install gcc-c++
if its RHEL4 or earlier, use up2date instead. either of these will
require a RHN subscription
On Dec 29, 4:19 pm, j...@commandprompt.com (Joshua D. Drake) wrote:
On Tue, 2009-12-29 at 13:21 -0800, Nick wrote:
On Dec 28, 8:22 pm, pie...@hogranch.com (John R Pierce) wrote:
Nick wrote:
'g++' or g++ says -bash g++: command not found
distro is red hat
Assuming thats RHEL5
On Dec 29, 4:19 pm, j...@commandprompt.com (Joshua D. Drake) wrote:
On Tue, 2009-12-29 at 13:21 -0800, Nick wrote:
On Dec 28, 8:22 pm, pie...@hogranch.com (John R Pierce) wrote:
Nick wrote:
'g++' or g++ says -bash g++: command not found
distro is red hat
Assuming thats RHEL5
On Dec 29, 4:19 pm, j...@commandprompt.com (Joshua D. Drake) wrote:
On Tue, 2009-12-29 at 13:21 -0800, Nick wrote:
On Dec 28, 8:22 pm, pie...@hogranch.com (John R Pierce) wrote:
Nick wrote:
'g++' or g++ says -bash g++: command not found
distro is red hat
Assuming thats RHEL5
and we have a current
version of the gcc compiler on the computer
Thanks,
Nick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Dec 28, 7:20 pm, a...@squeakycode.net (Andy Colson) wrote:
On 12/28/2009 08:24 PM, Nick wrote:
Trying to install postgis on LINUX machine, need to find the geos-
config file, as seems it is no where to be found after download of
postgis in the ./configure step, is there anyone
On Nov 18, 12:43 pm, d...@archonet.com (Richard Huxton) wrote:
Nick wrote:
So now the only step I have left is actually connecting. Im trying to
connect a php script topgbouncerwith
$conn = pg_connect(host=127.0.0.1 dbname=bouncer1 port=6543
user=nboutelier password=password);
which
On Nov 18, 3:28 pm, d...@archonet.com (Richard Huxton) wrote:
Nick wrote:
lsof -i | greppgbouncer
results in no output.
Then it's either not running or not listening on a port (you did run
that as root, didn't you?). Does ps aux | greppgbouncer show it?
Yourpgbouncerlogfile should show
-11-17 03:10:29.528 24132 ERROR unconfigured_file: No such file or
directory
2009-11-17 03:10:29.863 24132 ERROR unconfigured_file: No such file or
directory
On Nov 14, 12:02 am, rikard.bosnjako...@gmail.com (Rikard Bosnjakovic)
wrote:
On Sat, Nov 14, 2009 at 00:17, Nick nboutel...@gmail.com wrote
On Nov 17, 3:38 am, d...@archonet.com (Richard Huxton) wrote:
Nick wrote:
Thanks Richard, I updated my users.txt file to include quotes (it
didn't) which fixed the broken auth file error, but now im getting
this...
1518 ERROR unconfigured_file: No such file or directory
which repeats
: Connection refused Is the server running on
host 127.0.0.1 and accepting TCP/IP connections on port 6543
Thanks for you help and patience. -Nick
On Nov 17, 3:38 am, d...@archonet.com (Richard Huxton) wrote:
Nick wrote:
Thanks Richard, I updated my users.txt file to include quotes (it
didn't
Im trying to set up pgbouncer. Installation seemed to go well but when
I try...
$ pgbouncer -d pgbouncer.ini
I get an error...
2009-11-13 02:02:35.170 7245 ERROR broken auth file
2009-11-13 02:02:35.170 7245 LOG File descriptor limit: 1024 (H:1024),
max_client_conn: 100, max fds possible: 110
= users.tx
admin_users = nboutelier
On Nov 13, 1:58 am, d...@archonet.com (Richard Huxton) wrote:
Nick wrote:
Im trying to set up pgbouncer. Installation seemed to go well but when
I try...
$ pgbouncer -d pgbouncer.ini
I get an error...
2009-11-13 02:02:35.170 7245 ERROR broken auth file
This is a very abbr version of my problem, but what would be the best
way to do this...
DECLARE
column_name_var TEXT;
BEGIN
RETURN NEW.column_name_var;
END;
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
SELECT TRUE WHERE '/steps/?step=10' ~ '^\/steps\/\?step=10$'
Im guessing its an escape issue, but where am I going wrong?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sep 18, 3:40 pm, spam_ea...@gmx.net (Thomas Kellerer) wrote:
Nick wrote on 18.09.2009 23:31: Is there a way to return a percentage of the
rows found? I tried
window functions but get an error...
ERROR: syntax error at or near OVER
SELECT id, cume_dist FROM (
SELECT id, cume_dist
Is there a way to return a percentage of the rows found? I tried
window functions but get an error...
ERROR: syntax error at or near OVER
SELECT id, cume_dist FROM (
SELECT id, cume_dist() OVER (ORDER BY id) FROM employees
) s
WHERE cume_dist 0.3
--
Sent via pgsql-general mailing list
Im trying to get all the text before the 'br' tag.
SELECT SUBSTRING('onebrtwobrthree','(^.*)br.*$');
returns onebrtwo
How do I get it to return one?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
messages (id, to_user, from_user, created)
1 | 1 | 2 | 2009-05-21
2 | 1 | 3 | 2009-06-21
3 | 1 | 4 | 2009-07-21
4 | 2 | 1 | 2009-05-10
5 | 2 | 3 | 2009-06-10
6 | 1 | 2 | 2009-07-10
How could I get the most recent message between two users?
--
Sent via pgsql-general mailing list
...@pinpointresearch.com (Steve Crawford)
wrote:
Nick wrote:
messages (id, to_user, from_user, created)
1 | 1 | 2 | 2009-05-21
2 | 1 | 3 | 2009-06-21
3 | 1 | 4 | 2009-07-21
4 | 2 | 1 | 2009-05-10
5 | 2 | 3 | 2009-06-10
6 | 1 | 2 | 2009-07-10
How could I get the most recent message between two
Is it possible to join two tables by the nearest date? For example how
could I find out where the user was on their birthday?
users (id, name, birthday)
1 | one | 2009-07-27
2 | two | 2009-07-28
3 | three | 2009-07-29
4 | four | 2009-07-30
5 | five | 2009-07-31
users_locations (id, user_id,
Thanks Merlin, do you know what the syntax would be? Can't seem to
find it anywhere and im getting an error using 8.3.7
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Im using the same...
FOR record_or_row IN query LOOP
at the beginning of a function and at the end of a function. Is there
a way to save the query results in a RECORD[] type so that I don't
have to run the query twice?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
I wont go into details about why im using this field as an array but
how would I select all the rows that have the first name 'Tom' out of
the 'names' field?
CREATE TABLE test (
id integer,
names character varying[]
);
INSERT INTO test VALUES (1, '{''Josh Berkus'',''Peter
Is there any way this query could be written that doesnt scan the
subquery table twice?
SELECT * FROM my_table
WHERE (one,two) NOT IN (SELECT sub_one, sub_two FROM my_sub_table)
AND (two,one) NOT IN (SELECT sub_one, sub_two FROM my_sub_table)
--
Sent via pgsql-general mailing list
) was
false.
Does this mean I have to branch out my control structures if I want
better speed? If the first part of the 'if' is rarely true, then I
might as well put the second control within the first.
-Nick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
corruption, or definitely a
run-time thing?
Any pointers (including you idiot, there's a password in your
backtrace! :-)) appreciated!
--
Nick Withers
email: n...@nickwithers.com
Web: http://www.nickwithers.com
Mobile: +61 414 397 446
signature.asc
Description: This is a digitally signed message part
On Thu, 2009-01-22 at 23:42 -0500, Tom Lane wrote:
Nick Withers n...@nickwithers.com writes:
I've been experiencing segfaults of PostgreSQL for quite a quite now
(since July 2008, PostgreSQL 8.3.3, perhaps?) on a FreeBSD 7 PowerPC
(7400) system (not sure if anyone really cares about
rows.
Best wishes,
Nick
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of Kevin Galligan
Sent: Thursday, 30 October 2008 7:18 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Slow query performance
I'm approaching the end
Wow, very good to know. That was driving me crazy.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have a weird scenario on a table when I run this query...
table1 has 1500 rows
table2 has 1200 rows
table2.id is a foreign key of table1.id
SELECT COUNT(*) FROM table1
WHERE id NOT IN (
SELECT id FROM table2
);
however, using NOT EXISTS works
SELECT COUNT(*) FROM table1
WHERE NOT EXISTS (
I have a VIEW that consists of two tables, of which contain a POINT
column. When trying to select from the view I get an error...
ERROR: could not identify an ordering operator for type point
HINT: Use an explicit ordering operator or modify the query.
Any suggestions??? -Nick
--
Sent via
;
create_date
---
2007-11-04 08:35:33.17-08
2007-11-03 21:35:36.09-07 -- why 07?
2007-11-04 20:35:36.38-08
2007-11-05 08:35:36.67-08
Nick
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Wed, 7 Nov 2007, Tom Lane wrote:
Nick Johnson [EMAIL PROTECTED] writes:
I'm using PostgreSQL 8.2.3 and seeing this behaviour with timezones:
[snip]
Shouldn't that second row have been in the results of the second query?
Huh? Those results look perfectly sane to me.
Ah, you're
Just wondering, if it is possible to do the following
create function foo() RETURNS Record(int, varchar, int)
then inside of the function return a set int, varchar, int.
Then be able to call the function
select * From foo()
instead of having to write
select * from foo() as (int, varchar,
);
lastday
2007-04-26
(1 row)
The second parameter is the day of the week that you want, which has the
same spec as EXTRACT(dow FROM...). Values are from 0-6 where 0 is Sunday.
Enjoy!
Nick
---(end of broadcast)---
TIP 9: In versions
+
2007-04-10 | 2007-04-26
Nick
---(end of broadcast)---
TIP 6: explain analyze is your friend
and functions will be executed in the
postgres process assigned to the connection that invokes them, and
therefore each will have its own copy of the global variable?
- How can I get a session-scoped MemoryContext to allocate nodes out of?
Thanks,
Nick Johnson
---(end of broadcast
On 7/2/07, Tom Lane [EMAIL PROTECTED] wrote:
Nick Johnson [EMAIL PROTECTED] writes:
I want to write a contrib module that exports a couple of functions
that PLs (that don't natively support this) can use to set/get
session-local variables.
Um, why do you need to do anything? Don't
Hi there,
I'm having trouble creating a function using plpgsql. I cannot pass the
array 'productids' to the ANY construct of the IN EXECUTE SELECT
statement. Any ideas on what I'm doing wrong would be most appreciated.
Here's the function:
CREATE OR REPLACE FUNCTION search_products(metalparam
William Leite Araújo wrote:
2006/10/25, Richard Huxton dev@archonet.com mailto:dev@archonet.com:
Nick Rowlands wrote:
Hi there,
I'm having trouble creating a function using plpgsql. I cannot
pass the
array 'productids' to the ANY construct of the IN EXECUTE
?
If however I'm forced to sub-sample the grid, what rule of thumb should I be
looking to be constrained by?
Thanks for any pointers, Nick
PS - Feel free to throw in any other ideas of grid-suitable databases :)
---(end of broadcast)---
TIP 4: Have
Thanks - but what do you call big?
My application is satellite data btw so the reference could be useful.
On Tue, 5 Sep 2006 01:40 pm, Oleg Bartunov wrote:
Nick,
if you need very fast spatial queries (spherical) you may use our
Q3C module for POstgreSQL (q3c.sf.net). We use it for providing
dump always returns an empty dump.
pg_restore --schema foo --table bar returns the table foo.bar, though.
Does anyone know why this is?
-Nick
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
on failure?
Thanks,
Nick
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
On 14/03/2006, at 12:05 AM, Michael Fuhr wrote:
On Mon, Mar 13, 2006 at 10:45:47PM -0800, Nick Johnson wrote:
Can anyone provide me with some direction on how to write a function
I can load into postgres that will execute a function specified by
OID (or regproc/regprocedure) at runtime
On 14/03/2006, at 10:26 AM, Michael Fuhr wrote:On Tue, Mar 14, 2006 at 07:21:51AM -0800, Nick Johnson wrote: On 14/03/2006, at 12:05 AM, Michael Fuhr wrote: Why do you need to do this? What problem are you trying to solve? I want to associate Postgres functions with rows of a table (eg, a table
(and won't be done, unless I develop a need or someone else wants it ) is determining when function calls are compatible even though they're not identical (eg, through use of polymorphic functions and ANYELEMENT/ANYARRAY).-Nick Johnson
?
Thanks
Nick
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Mon, 17 Jan 2005, Tom Lane wrote:
Nick Burch [EMAIL PROTECTED] writes:
Quite a lot, I'm seeing lines like:
2005-01-17 13:11:15 LOG: duration: 4688.108 ms statement: commit;begin;
Is there any way to find out what exactly got executed here?
A whole lot of deferred-until-transaction
?
thanks,
Nick
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
.
Standard or not, it is very usefull.
Is there a way to catch the insert error. For example...
INSERT INTO related_products (product_id,related_product_id) VALUES
(?,?);
IF (???error: duplicate key???) THEN
UPDATE related_products SET related_counter = related_counter + 1;
END IF;
-Nick
. -Nick
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
in
functionality between these versions? or is this a bug?
thanks,
Nick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
-performance/2004-01/msg00059.php
Nick
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
,
functionschema (or maybe vice versa).
Or when you make the calls in the web app use the following:
SELECT function_schema.function1(arg1, arg2);
instead of just:
SELECT function1(arg1, arg2);
But like Peter said have a schema per client/instance of your database.
Nick
the query that you would need to execute to get
the column names ;-)
HTH
Nick
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
wrong then you are going to have to
dropdb/createdb and then run in the schema again. I hope you have that
schema in a file.
Nick
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail
the
guesstimate in the first set of brackets of 41, and compare with the
actual result in the second set of 2362. Have you vacuum analyzed recently?
HTH
Nick
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
to guarentee the order of the rows that come back, especially when using the LIMIT/OFFSET clauses.
Nick
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
;
HTH
Nick
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
('temp_zorder_num_seq'), ...);
---
All you have to change is the setval at the top of the script. Make sure
you drop the sequences though ;-).
HTH
Nick
---(end of broadcast)---
TIP 6: Have you searched our list archives
+0'::timestamp order by tq1.timestamp;
As far as I know, and someone please correct me, this allows the planner
the most flexibility when figuring out the optimum plan.
Thanks
Nick
---(end of broadcast)---
TIP 7: don't forget to increase your
Ben-Nes Michael wrote:
- Original Message -
From: Nick Burrett [EMAIL PROTECTED]
Ben-Nes Michael wrote:
But still the greatest question is what FS to put on ?
I heard Reiesref can handle small files very quickly.
Switching from ext3 to reiserfs for our name servers reduced the time
the data will be
much slower than the time taken to fetch the data off disk.
--
Nick Burrett
Network Engineer, Designer Servers Ltd. http://www.dsvr.co.uk
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
Tom Lane wrote:
Nick Burrett [EMAIL PROTECTED] writes:
$ pg_dumpall full.db
pg_dump: WARNING: ShmemAlloc: out of memory
pg_dump: Attempt to lock table vs_dfa554862ac failed. ERROR:
LockAcquire: lock table 1 is out of memory
pg_dumpall: pg_dump failed on bandwidth, exiting
Looks like you need
Tom Lane wrote:
Nick Burrett [EMAIL PROTECTED] writes:
Tom Lane wrote:
We don't normally hear of people needing that --- is there anything
unusual about the schema of this database?
Not particularly. The database consists of around 3000 tables created
using this:
CREATE TABLE vs_foo (date
techdocs at the moment but the page you want to be
looking at is 10.2. Statistics Used by the Planner, and the page name is
planner-stats.html.
Hope that helps
Nick
- Original Message -
From: Robert Wille [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 8:19 PM
Subject
try this:
http://gborg.postgresql.org
-Nick
-
Nick Fankhauser
Business:
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/
Personal:
[EMAIL
suggestion is the best way *if* your
development environment supports something similar.
-Nick
-
Nick Fankhauser
Business:
[EMAIL PROTECTED] Phone 1.765.965.7363 Fax 1.765.962.9788
doxpop - Court records at your fingertips - http
need to turn the
tcpip_socket on in the .conf file, or change the first script to not specify
a host.
-Nick
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, September 21, 2001 2:25 PM
To: [EMAIL PROTECTED]
Subject
/update is not supported, or (more likely) I'm using the wrong
approach. Can anyone tell me whether this is supported, or how I can get the
job done using a different approach?
Thanks!
-Nick
-
Nick Fankhauser
Business:
[EMAIL PROTECTED
Sounds like the answer is to upgrade to v7+
Much thanks to Tom Lane and Len Morgan for the helpful responses!
-Nick
update one set b = (select d from two where one.a = two.c);
s (convert from Oracle) and to JDBC, so I'm
open to any suggestions, don't assume I've already thought of the
"obvious" solutions!
Thanks
------
---
Nick Fankhauser
Business: [EMAIL PROTECTED] Phone
; solutions!
Thanks
------
Nick Fankhauser
Business: [EMAIL PROTECTED] Phone 1.765.935.4283 Fax 1.765.962.9788
Ray Ontko Co. Software Consulting Services http://www.ontko.com/
Personal: [EMAIL PROTECTED] http://www.infocom.com/~nickf
of data
comingled with smaller chunks.
-Nick Fankhauser
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of John Pilley
Sent: Wednesday, November 01, 2000 12:10 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Newbie Question
Is there an upper limit on the size
101 - 184 of 184 matches
Mail list logo