PgSql

Creating a VIEW with a POINT column
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 ... 26 Jun 2008 08:25

Planner creating ineffective plans on LEFT OUTER joins
Hi, After pondering on the problem for quite some time and discussing it on IRC with RhodiumToad I thought the most sensible thing is to post the problem here (as RhodiumToad suggested as well). The original (although already quite reduced) problematic query and the related plan: http://anarazel.de/postgre... 27 Jun 2008 13:10

the un-vacuumable table
Andrew Hammond wrote: I found this error message in my log files repeatedly: Error: failed to re-find parent key in "ledgerdetail_2008_03_idx2" for deletion target page 64767 I though "hmm, that index looks broken. I'd better re-create it." So, I dropped the index and then tried to create a new o... 7 Jul 2008 18:41

CVS Head psql bug?
Hi, I'm getting following error while envoking psql: $ psql psql: symbol lookup error: /usr/lib/libreadline.so.5: undefined symbol: BC This is Linux glibc 2.3.4 and readline 5.1. -- Tatsuo Ishii SRA OSS, Inc. Japan -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes ... 26 Jun 2008 21:50

proposal for smaller indexes on index-orderedtables
>>> On Tue, Jun 24, 2008 at 4:54 PM, in message <7020.1214344479(a)sss.pgh.pa.us>, Tom Lane <tgl(a)sss.pgh.pa.us> wrote: "Jeffrey Baker" <jwbaker(a)gmail.com> writes: Creating the table in this case takes half an hour and then indexing it requires almost an hour. These numbers seem to me to be pretty st... 24 Jun 2008 18:31

proposal for smaller indexes on index-ordered tables
On Tue, Jun 24, 2008 at 4:34 PM, Jeffrey Baker <jwbaker(a)gmail.com> wrote: Supposing the table is generally or strictly ordered by the column to be indexed, it would be more compact if the index stored ranges of tuples. Instead of storing the TID of every tuple with that value, the index would store a first ... 25 Jun 2008 05:45

MSVC 2003 compile error with pg8.3.3
Hello, I am trying to compile libpq.dll with MSVC 2003 on windows, using postgresql-8.3.3, but I get the following compile error: Creating library .\Release\libpqdll.lib and object .\Release \libpqdll.exp libpq.lib(dirmod.obj) : error LNK2019: unresolved external symbol __dosmaperr r ferenced in fun... 27 Jun 2008 13:10

Git Repository for WITH RECURSIVE and others
Folks, With lots of help from Greg Sabino Mullane, I've set up a git repository for the WITH RECURSIVE patches on <http://git.postgresql.org/>. What other patches would people like to try maintaining this way until commitfest? It looks like gitosis is a good way to grant write access to git repositories, b... 7 Jul 2008 14:33

Testing pg_terminate_backend()
Can we conclude this has been tested enough for 8.4? --------------------------------------------------------------------------- Magnus Hagander wrote: Bruce Momjian wrote: Magnus Hagander wrote: It looks pretty good from here. I have an output of about 50 million lines, and the only FATAL... 23 Jun 2008 19:56

Timely reporting of COPY errors
Added to TODO: o Allow COPY to report errors sooner http://archives.postgresql.org/pgsql-hackers/2008-04/msg01169.php --------------------------------------------------------------------------- Martijn van Oosterhout wrote: -- Start of PGP signed section. Hi, I notice that wh... 23 Jun 2008 18:55