Re: [GENERAL] Help with storing spatial (map coordinates) data?

John Tregea schrieb: Hi, I have recently switched to PostgreSQL and had no problem bringing our existing (my)SQL databases and data into the environment. I am now extending the functionality of our databases and want to start storing spatial information. The information is made up of latitu

[GENERAL] Help with storing spatial (map coordinates) data?

Hi, I have recently switched to PostgreSQL and had no problem bringing our existing (my)SQL databases and data into the environment. I am now extending the functionality of our databases and want to start storing spatial information. The information is made up of latitude and longitude coord

Re: [GENERAL] can i use a string in where clause such as "id in (str)"

am 12.06.2006, um 0:05:07 +0300 mailte Yavuz Kavus folgendes: > hi every body. > i have a pl/pgsql function (i want to form it to run correctly) : > > CREATE OR REPLACE FUNCTION "public"."ftest" () RETURNS boolean AS > $body$ > declare >f boolean; >str varchar(100); > begin >

[GENERAL] GnuPG / PGP signed checksums for PostgreSQL 8.1.4, 8.0.8, 7.4.13, and 7.3.15

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Source code MD5 and SHA1 checksums for PostgreSQL 8.1.4 For instructions on how to use this file, please see: http://www.gtsm.com/postgres_sigs.html ## Created with md5sum: a65bdc5d833169d28bf6fbaaa8d57fcf postgresql-8.1.4.tar.bz2 7ba24eaa31237e

Re: [GENERAL] TOAST not working

Ahhh... thank you. This clarifies TOAST for me. I see how TOAST applies to individual columns that exceed the 8k page size. Postgres specs state it's possible to have 2GB rows and up to 1,600 columns. Can you tell me what data type would get to fill this spec. I wouldn't normally push to this limi

Re: [GENERAL] Pgpool-committers unsubscribe notification

Tatsuo Ishii <[EMAIL PROTECTED]> writes: > Please forgive me if this is slightly off topic to the list, but I > couldn't find any suitable *mail based* forum. pgsql-www is probably the right place to report this sort of problem. regards, tom lane -

Re: [GENERAL] Pgpool-committers unsubscribe notification

Please forgive me if this is slightly off topic to the list, but I couldn't find any suitable *mail based* forum. I got following mail and it seems the only solution is re-subscrive to Pgpool-committers (and do it again and again because the system will kick off them again). -

Re: [GENERAL] Ever increasing OIDs - gonna run out soon?

"John Sidney-Woollett" <[EMAIL PROTECTED]> wrote > > It looks like the db is using them at the rate of 1.5 million per day. > At what value will I hit a wraparound, and what options do I have to > identify/fix the (impending) problem. > The Oid will wraparound when it reaches the 32bits unsigned

Re: [GENERAL] Disk corruption detection

"Florian Weimer" <[EMAIL PROTECTED]> wrote > > Anyway, how would be the chances for PostgreSQL to detect such a > corruption on a heap or index data file? It's typically hard to > detect this at the application level, so I don't expect wonders. I'm > just curious if using PostgreSQL would have h

Re: [GENERAL] Insert into partition table hangs

""Nikola Ivanov"" <[EMAIL PROTECTED]> wrote > Database is running on Windows 2003 Advanced Server and it is PostgreSQL > 8.1.3. > > On 6/9/06, Tom Lane <[EMAIL PROTECTED]> wrote > > > > Buggy SysV semaphore support in the kernel, maybe? What platform is > > this exactly? > > Yes, there is a bug

[GENERAL] can i use a string in where clause such as "id in (str)"

hi every body. i have  a pl/pgsql function (i want to form it to run correctly) :   CREATE OR REPLACE FUNCTION "public"."ftest" () RETURNS boolean AS$body$declare   f boolean;   str varchar(100);begin str := '1,5,10'; if exists(    select 1 from tb_categories where cat_id in ( str )

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

On Fri, Jun 09, 2006 at 09:54:56AM -0700, [EMAIL PROTECTED] wrote: > Lots of great conversation here. Thanks to all for participating. > > David, you wrote: > >Be aware that Pascal, along with Date and Darwen, are...how do I put > >this gently...cranks. They've been getting more strident and > >i

[GENERAL] Disk corruption detection

We recently had a partially failed disk in a RAID-1 configuration which did not perform a write operation as requested. Consequently, the mirrored disks had different contents, and the file which contained the block switched randomly between two copies, depending on which disk had been read. (In

[GENERAL] Ever increasing OIDs - gonna run out soon?

Back in April 2006 I emailed about high OIDs in a 7.4.6 database. I've just added new tables to the database (and the slony-relication set) and I'm seeing much higher OID values for the new tables. In April I added a table, it was assigned an OID value of 94198669 (94 million). I've just adde

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

On Sun, Jun 11, 2006 at 11:03:57AM -0400, Merlin Moncure wrote: > On 6/8/06, Chris Browne <[EMAIL PROTECTED]> wrote: > >[EMAIL PROTECTED] (Scott Marlowe) writes: > >> To me, the real argument is, "Is SQL so lacking that it should be > >> replaced". In what REAL measurable ways is SQL lacking so ba

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully implementing the relational model

On 8 Jun 2006 05:21:07 -0700, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I'm reading, and enjoying immensely, Fabial Pascal's book "Practical Issues in Database Management." Some questions: 1) Is PostgreSQL more faithful to relational theory? If so, do you find yourself using the additional fu

Re: [GENERAL] Fabian Pascal and RDBMS deficiencies in fully

On 6/8/06, Chris Browne <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] (Scott Marlowe) writes: > To me, the real argument is, "Is SQL so lacking that it should be > replaced". In what REAL measurable ways is SQL lacking so badly we > should toss it and start over? It's not perfect, that's for sur

Re: [GENERAL] Manual Installation of PostgreSQL on Windows

Thanks, It looks like a possible solution Mic andrey dmitrenko wrote: > Hello. > I think this short manual can help you > http://archives.postgresql.org /pgsql-hackers-win32/2005-07/msg00022.php > > I've installed version

[GENERAL] Invitation to EuroPython conference

Python and PostgreSQL are a match made in heaven. That will be one of more then 100 talks at the EuroPython 2006 in CERN, Switzerland.Up to 2006-06-11 you can register at around 20% discount.Best wishes, HaraldSoftware developers from around the world will gather July 3-5 inGeneva, Switzerland for

Re: [GENERAL] Questions about indexes

Alan Hodgson <[EMAIL PROTECTED]> schrieb: > On Saturday 10 June 2006 13:30, "Pat Maddox" <[EMAIL PROTECTED]> wrote: > > I've got a table with that has 5 fields. Nearly every query I make to > > this table is of the form > > SELECT * FROM table1 WHERE field1='foo' AND field2=7; > > > > It's always