Re: [GENERAL] Query to get column-names in table via PG tables?

2008-01-15 Thread Tino Wildenhain
Ken Johanson wrote: I am looking for expertise on how to program the equivalent to this query, but using the pg_catalog tables, which I understand have fewer security restrictions than information_schema in some cases: SELECT column_name FROM information_schema.columns WHERE table_catalog=? AND

Re: [GENERAL] ECPG problem with 8.3

2008-01-15 Thread Michael Meskes
On Mon, Jan 14, 2008 at 10:57:45AM -0500, Tom Lane wrote: > I'm concerned about this too. We'll at least have to call this out as > an incompatibility in 8.3, and it seems like a rather unnecessary step > backwards. I thought I had send an email asking for comments back when this was implemented.

[GENERAL] insert into ... select ... and column order

2008-01-15 Thread Tore Halset
Hello. One of our users tried a "insert into ... select ..." that gave a strange error message. After digging into the issue, the problem seem to be that the order of the columns in the select statement must match the table definition. Here is a way to reproduce this case. -- a source tab

Re: [GENERAL] insert into ... select ... and column order

2008-01-15 Thread Richard Huxton
Tore Halset wrote: Hello. One of our users tried a "insert into ... select ..." that gave a strange error message. After digging into the issue, the problem seem to be that the order of the columns in the select statement must match the table definition. Here is a way to reproduce this case.

[GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Hannes Dorbath
Crash happens about 7 minutes after issuing the UPDATE statement with current CVS HEAD. The table has around 5 million rows. It's always reproducible. ISpell dict used: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-german-compound.tar.gz (iconved to UTF-8) Welcom

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-15 Thread Mayuresh Nirhali
Josh Harrison wrote: My question is abt the data migration. Im not sure how to try this with an online oracle database. We are required to run both postgres and oracle database simultaneously for a couple of months (atleast till we decide whether we are going to shut down oracle for good !!!)

Re: [GENERAL] insert into ... select ... and column order

2008-01-15 Thread Albe Laurenz
Tore Halset wrote: > One of our users tried a "insert into ... select ..." that gave a > strange error message. After digging into the issue, the problem seem > to be that the order of the columns in the select statement must match > the table definition. Here is a way to reproduce this case.

Re: [GENERAL] insert into ... select ... and column order

2008-01-15 Thread Tore Halset
On Jan 15, 2008, at 12:16 , Albe Laurenz wrote: Because the SQL standard says so. ISO/IEC 9075-2, Chapter 14.8, Syntax Rule 9: "If the is omitted, then an that identifies all columns of T in the ascending sequence of their ordinal positions within T is implicit." You want an explicit : I

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Alvaro Herrera
Hannes Dorbath wrote: > test=# UPDATE test SET tsv = to_tsvector(text); > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > Jan 15 11:32:50 brainchild postmaster[14815] general protection ri

Re: [GENERAL] insert into ... select ... and column order

2008-01-15 Thread Tino Wildenhain
Tore Halset wrote: Hello. One of our users tried a "insert into ... select ..." that gave a strange error message. After digging into the issue, the problem seem to be that the order of the columns in the select statement must match the table definition. Here is a way to reproduce this case.

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Oleg Bartunov
It'd be nice to have text string which cause segfault and sql script for configuration. Oleg On Tue, 15 Jan 2008, Hannes Dorbath wrote: Crash happens about 7 minutes after issuing the UPDATE statement with current CVS HEAD. The table has around 5 million rows. It's always reproducible. ISpell

Re: [GENERAL] COUNT() with ORDER BY

2008-01-15 Thread T.J. Adami
On 14 jan, 17:02, "Andrus" <[EMAIL PROTECTED]> wrote: > create temp table test (col char); > select count(col) from test order by col; > > causes > > ERROR: column "test.col" must appear in the GROUP BY clause or be used in > an aggregate function > SQL state: 42803 > > How to fix this ? > This st

[GENERAL] Postgres installation on Leopard; database on Mac-User-Level

2008-01-15 Thread Stefan Schwarzer
Hi there, I want to create my database not under /etc/ but under or within my Mac-user level, that is /Users/schwarzer/ Now, it seems somewhat complicated - at least for me -, due to the different read-write permissions, to do that. It worked before, but now, after re-installing t

Re: [GENERAL] Forgot to dump old data before re-installing machine

2008-01-15 Thread Stefan Schwarzer
I re-installed my machine and "forgot" to dump my database(s). I naturally still have the whole database folders. For the moment I installed the "old" postgres version (8.1) to be able to read my data. But how can I read them? It seems that it doesn't work that I just overwrite the new database

Re: [GENERAL] backup and restore

2008-01-15 Thread T.J. Adami
On 14 jan, 10:36, hiddenhippo <[EMAIL PROTECTED]> wrote: > Having recently jumped ship from MSSQL to Postgres I'm finding it a > little difficult getting onto the 'correct path.' Basically I have a > live database and I want to take a copy of that and then restore it > onto a backup server. > > Fi

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Hannes Dorbath
Alvaro Herrera wrote: Can you please provide a backtrace from gdb? I hope that contains it: http://theendofthetunnel.de/backtrace.log It'd be nice to have text string which cause segfault and sql script for configuration. Yes, I'll try to catch the row. -- Best regards, Hannes Dorbath -

Re: [GENERAL] Locking & concurrency - best practices

2008-01-15 Thread Merlin Moncure
On Jan 15, 2008 12:03 AM, Adam Rich <[EMAIL PROTECTED]> wrote: > > Advisory locks would work here (better that than table lock), but I > > don't think that's the right approach. Transaction 2 should simply do > > a > > select * from parent_tbl > > where id=1 for update; > > > > at the start of the

Re: [GENERAL] count(*) and bad design was: Experiences with extensibility

2008-01-15 Thread Alban Hertroys
On Jan 9, 2008, at 8:07 PM, Scott Marlowe wrote: I could see a use for an approximate count(*) with where clause, just like I could see a use for the ability to retrieve random rows from a table without using order by random() on it. And those are both things that would require some form of hack

Re: [GENERAL] count(*) and bad design was: Experiences with extensibility

2008-01-15 Thread Ivan Sergio Borgonovo
On Tue, 15 Jan 2008 14:43:35 +0100 Alban Hertroys <[EMAIL PROTECTED]> wrote: > You need to scroll to the last row to find the size of the result > set, but after that it's pretty easy to return random rows by > scrolling to them (and marking them 'read' in some way to prevent > accidentally

Re: [GENERAL] Forgot to dump old data before re-installing machine

2008-01-15 Thread Richard Huxton
Stefan Schwarzer wrote: I re-installed my machine and "forgot" to dump my database(s). I naturally still have the whole database folders. For the moment I installed the "old" postgres version (8.1) to be able to read my data. But how can I read them? It seems that it doesn't work that I just over

Re: [GENERAL] Query to get column-names in table via PG tables?

2008-01-15 Thread Merlin Moncure
On Jan 15, 2008 1:15 AM, Ken Johanson <[EMAIL PROTECTED]> wrote: > The output of this is very verbose and broken into multiple queries > making joins difficult for me to understand, I'm afraid; my current > experience level likely will not reliably produce a single-query > equivalent to the above.

Re: [GENERAL] Postgres installation on Leopard; database on Mac-User-Level

2008-01-15 Thread Stefan Schwarzer
Now, it seems somewhat complicated - at least for me -, due to the different read-write permissions, to do that. It worked before, but now, after re-installing the machine, I really don't get it going... The commands would be like this: /usr/local/pgsql/bin/initdb -D /Users/schwarzer/Docu

Re: [GENERAL] ERROR: shared buffer hash table corrupted

2008-01-15 Thread T.J. Adami
On 14 jan, 09:08, [EMAIL PROTECTED] (Ashish Karalkar) wrote: > Hello list members, > I hav a table with 140M rows. While I am trying to select the count from the > table > I am getting following error > ERROR: shared buffer hash table corrupted > Can anybody please suggest me wht had gone wrong a

Re: [GENERAL] Postgres installation on Leopard; database on Mac-User-Level

2008-01-15 Thread Richard Huxton
Stefan Schwarzer wrote: Hi there, I want to create my database not under /etc/ but under or within my Mac-user level, that is /Users/schwarzer/ The data directory shouldn't ever end up in /etc - are you sure that's what it's doing? Now, it seems somewhat complicated - at least for

Re: [GENERAL] Forgot to dump old data before re-installing machine

2008-01-15 Thread Martijn van Oosterhout
On Tue, Jan 15, 2008 at 02:42:05PM +0100, Stefan Schwarzer wrote: > Thanks a lot for this. Still trying. But although the postmaster did > run at one time, now, after copying back and forth, it doesn't want to > do anything anymore... Gush, getting really frustrated... If it really doesn't wor

Re: [GENERAL] backup and restore

2008-01-15 Thread Richard Huxton
T.J. Adami wrote: On 14 jan, 10:36, hiddenhippo <[EMAIL PROTECTED]> wrote: Having recently jumped ship from MSSQL to Postgres I'm finding it a little difficult getting onto the 'correct path.' Basically I have a live database and I want to take a copy of that and then restore it onto a backup s

Re: [GENERAL] Postgres installation on Leopard; database on Mac-User-Level

2008-01-15 Thread Richard Huxton
Stefan Schwarzer wrote: There's no reason why you *have* to run the server as user postgres though. It's perfectly possible to do the above as user schwarzer. If the database system is intended just for that one user, that might make sense too. Oh, make sure the logfile is in a directory writ

Re: [GENERAL] Forgot to dump old data before re-installing machine

2008-01-15 Thread Stefan Schwarzer
I re-installed my machine and "forgot" to dump my database(s). I naturally still have the whole database folders. For the moment I installed the "old" postgres version (8.1) to be able to read my data. But how can I read them? It seems that it doesn't work that I just overwrite the new database

[GENERAL] Prepared statement's planning

2008-01-15 Thread Vyacheslav Kalinin
Hello, I would appreciate if someone explained me how exactly prepared parametrized statements are planned, i.e. what kind of assumptions planner makes on param values, selectivity, expected row count etc. that affect in particular whether indexes will be used or not. For instance consider the fol

Re: [GENERAL] Forgot to dump old data before re-installing machine

2008-01-15 Thread Tom Lane
Stefan Schwarzer <[EMAIL PROTECTED]> writes: > Ok, did what you said: stopping server, deleting "newly" created > "data" directory, re-running initdb, starting the server, stopping the > server. > Renamed "empty" data directory. > Restarting server: NOT COMPLAINING "you need to run initdb" or

[GENERAL] an simple way to get count of SQL statements per some interval

2008-01-15 Thread Pavel Stehule
Hallo all Is it possible on 8.2 database? Thank you Pavel Stehule ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can ge

Re: [GENERAL] Forgot to dump old data before re-installing machine

2008-01-15 Thread Stefan Schwarzer
Ok, did what you said: stopping server, deleting "newly" created "data" directory, re-running initdb, starting the server, stopping the server. Renamed "empty" data directory. Restarting server: NOT COMPLAINING "you need to run initdb" or something else Although it's saying that it st

Re: [GENERAL] backup and restore

2008-01-15 Thread T.J. Adami
On 15 jan, 12:29, [EMAIL PROTECTED] (Richard Huxton) wrote: > > It's quite simple to have problems with pgAdmin's backup procedure. > > Hmm - shouldn't be, and if so then please let the pgAdmin people know! > They're always working to improve the package and it's > I think the same. We (company I

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Hannes Dorbath
Hannes Dorbath wrote: Yes, I'll try to catch the row. I just slammed a BEFORE UPDATE FOR EACH ROW trigger with RAISE NOTICE on the table to catch the row ID where it fails. The row ID is never the same. Neither can I reproduce it when I use the last reported row ID. Is NOTICE logging / pr

Re: [GENERAL] Prepared statement's planning

2008-01-15 Thread Tom Lane
"Vyacheslav Kalinin" <[EMAIL PROTECTED]> writes: > QUERY PLAN > Bitmap Heap Scan on t1 (cost= 151.74..5307.59 rows=5000 width=8) > Recheck Cond: ((val > $1) AND (val < $2)) > -> Bitmap Index Scan on idx_t1 (cost=0.00..150.49 rows=5000 width=0) > Index Cond: ((val > $1) AND (val < $2)

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Alvaro Herrera
Hannes Dorbath wrote: > Hannes Dorbath wrote: >> Yes, I'll try to catch the row. > > I just slammed a BEFORE UPDATE FOR EACH ROW trigger with RAISE NOTICE on > the table to catch the row ID where it fails. > > The row ID is never the same. Neither can I reproduce it when I use the > last reported

[GENERAL] bulk copy

2008-01-15 Thread blackwater dev
Hello all, I'm pulling in a csv file nightly and need to pump in into my db. My plan is to pump it into a temp table and then to an update or insert from the temp table to the real table. I'm having an issue, however, with the copy. Here is a my syntax. COPY cars FROM 'cars04.txt'

[GENERAL] varchar sort ordering ignore blanks

2008-01-15 Thread Luca Arzeni
Hi there, I have a table with a single column, pk of varchar type The table contains few names, say: A C B In the first two records there is a between the and the following letter A and C while, the third one has a B immediately following the (without blanks). In post

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Tom Lane
Hannes Dorbath <[EMAIL PROTECTED]> writes: > Hannes Dorbath wrote: >> Yes, I'll try to catch the row. > I just slammed a BEFORE UPDATE FOR EACH ROW trigger with RAISE NOTICE on > the table to catch the row ID where it fails. > The row ID is never the same. Neither can I reproduce it when I use t

Re: [GENERAL] varchar sort ordering ignore blanks

2008-01-15 Thread Tom Lane
Luca Arzeni <[EMAIL PROTECTED]> writes: > That is: the sort order in postgres 8.1.9 seems to ignore the blank. This is expected behavior in most non-C locales. > In all cases I'm using locale LATIN9 during DB creation, but I tested also > with ASCII, UTF8 and LATIN1 encoding. LATIN9 isn't a loc

Re: [GENERAL] bulk copy

2008-01-15 Thread Martijn van Oosterhout
On Tue, Jan 15, 2008 at 12:18:18PM -0500, blackwater dev wrote: > Ok, fair enough, in theory, I don't want to simply trust the file to have > clean data so will want to put the data into a huge array (php) which I can > clean and then pump into the db. What is the best way to pump all this data >

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Teodor Sigaev
I tryed to reproduce the bug but without success. Could you provide a dump of text column? Hannes Dorbath wrote: Crash happens about 7 minutes after issuing the UPDATE statement with current CVS HEAD. The table has around 5 million rows. It's always reproducible. -- Teodor Sigaev

[GENERAL] out of memory with INSERT INTO... SELECT...

2008-01-15 Thread Shane Ambler
Not real sure if this is an issue but from what I figure there is too much RAM being chewed up from this. The end result is an out of memory error (I haven't delved deeper as yet) So I am replicating what someone else is failing to get working in sqlite to see what pg can do. The end scenar

Re: [GENERAL] Prepared statement's planning

2008-01-15 Thread Vyacheslav Kalinin
On Jan 15, 2008 7:58 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > If that really is the behavior you want, and not a typo It is, most of parameters passed to a plpgsql function are in fact parts of the filter and if certain filter item is null it is considered unknown and we don't want it to affect th

Re: [GENERAL] out of memory with INSERT INTO... SELECT...

2008-01-15 Thread Tom Lane
Shane Ambler <[EMAIL PROTECTED]> writes: >SELECT generate_series(1,100) AS idx > , substring('abcdefghijklmnopqrstuvwxyz0123456789' from > cast((random()*36)as integer) for 1) > ||substring('abcdefghijklmnopqrstuvwxyz0123456789' from > cast((random()*36)as integer) for 1) > ||substring('a

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Tom Lane
Hannes Dorbath <[EMAIL PROTECTED]> writes: > Crash happens about 7 minutes after issuing the UPDATE statement with > current CVS HEAD. The table has around 5 million rows. It's always > reproducible. This is not the same test data as in your previous concurrent-index problem, then? I still had

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Tom Lane
Hannes Dorbath <[EMAIL PROTECTED]> writes: > Alvaro Herrera wrote: >> Can you please provide a backtrace from gdb? > I hope that contains it: http://theendofthetunnel.de/backtrace.log Hmmm --- one thing that jumps out at me is that SplitToVariants assumes (in four places) that the SplitVar.stem a

Re: [GENERAL] Online Oracle to Postgresql data migration

2008-01-15 Thread David Fetter
On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote: > Thanks > > On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote: > > > On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote: > > > Hi > > > We have an Oracle production database with some terbytes of data. We > >

Re: [GENERAL] LIKE and REGEX optimization

2008-01-15 Thread Chris Browne
Kico Zaninetti <[EMAIL PROTECTED]> writes: > Hi all. > > I have a database with 62 million registers and I have to make a > SELECT using LIKE. > > This is my select: > SELECT * FROM phone WHERE name LIKE = '%ZANINETTI%' AND city = 'SAO > PAULO' AND state = 'SP' > > I have an index created like this

[GENERAL] Clearing old user ids completely

2008-01-15 Thread Justin Pasher
PostgreSQL 7.4.17 My situation is basically like the one states in the archives: http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php We have some tables that used to be owned by a user (user id 117) that no longer exists. Because the user no longer exists, when the database is dumpe

Re: [GENERAL] Clearing old user ids completely

2008-01-15 Thread Erik Jones
On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote: PostgreSQL 7.4.17 My situation is basically like the one states in the archives: http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php We have some tables that used to be owned by a user (user id 117) that no longer exists. Because t

Re: [GENERAL] LIKE and REGEX optimization

2008-01-15 Thread Scott Marlowe
On Jan 15, 2008 2:29 PM, Chris Browne <[EMAIL PROTECTED]> wrote: > Kico Zaninetti <[EMAIL PROTECTED]> writes: > > Hi all. > > > > I have a database with 62 million registers and I have to make a > > SELECT using LIKE. > > > > This is my select: > > SELECT * FROM phone WHERE name LIKE = '%ZANINETTI%

Re: [GENERAL] Clearing old user ids completely

2008-01-15 Thread Justin Pasher
Erik Jones wrote: On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote: PostgreSQL 7.4.17 My situation is basically like the one states in the archives: http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php We have some tables that used to be owned by a user (user id 117) that no longer

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Hannes Dorbath
Tom Lane wrote: This is not the same test data as in your previous concurrent-index problem, then? I still had a copy of that, so I tried the case, and it doesn't crash on that data ... Teodor Sigaev wrote: I tryed to reproduce the bug but without success. Could you provide a dump of text col

Re: [GENERAL] 8.3-beta4, analyze and db owner

2008-01-15 Thread Alvaro Herrera
Clodoaldo escribió: > > > fahstats=> analyze; > > > WARNING: skipping "pg_authid" --- only table or database owner can > > > analyze it > The problem with that warning message is that it implies that the db > owner can analyze them which can not be done according to your > comment. The message,

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008-01-15 Thread Alvaro Herrera
Clodoaldo escribió: > I guess the samples above are not very useful. If you think it would > help, i can upload the database dump, along with the source txt files > and the insert script, to some web directory, so you can see it > working. Its bziped size is 914MB so I will only upload it if you s

Re: [GENERAL] Clearing old user ids completely

2008-01-15 Thread Erik Jones
On Jan 15, 2008, at 4:53 PM, Justin Pasher wrote: Erik Jones wrote: On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote: PostgreSQL 7.4.17 My situation is basically like the one states in the archives: http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php We have some tables that use

[GENERAL] autovacuum vs. createdb

2008-01-15 Thread Ben
I'm noticing a problem where autovacuum touching template1 when createdb is run is making createdb fail. That's easy to work around when doing things by hand (just run it again), but when running createdb with a script, it's not so clear to me how to keep things working all the time. One thoug

Re: [GENERAL] Clearing old user ids completely

2008-01-15 Thread Tom Lane
Erik Jones <[EMAIL PROTECTED]> writes: > You can build and EXECUTE the ALTER TABLE commands in a function of a > few lines. With regards to removing the faulty permissions, will > REVOKE not work if the user doesn't exist in the system anymore (I > honestly don't know much about pre-8.0 beha

Re: [GENERAL] Clearing old user ids completely

2008-01-15 Thread Justin Pasher
Erik Jones wrote: On Jan 15, 2008, at 4:53 PM, Justin Pasher wrote: Erik Jones wrote: On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote: PostgreSQL 7.4.17 My situation is basically like the one states in the archives: http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php We have s

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008-01-15 Thread Clodoaldo
2008/1/15, Alvaro Herrera <[EMAIL PROTECTED]>: > Clodoaldo escribió: > > > I guess the samples above are not very useful. If you think it would > > help, i can upload the database dump, along with the source txt files > > and the insert script, to some web directory, so you can see it > > working.

Re: [GENERAL] autovacuum vs. createdb

2008-01-15 Thread Tom Lane
Ben <[EMAIL PROTECTED]> writes: > I'm noticing a problem where autovacuum touching template1 when createdb > is run is making createdb fail. That's easy to work around when doing > things by hand (just run it again), but when running createdb with a > script, it's not so clear to me how to keep

[GENERAL] advocacy: drupal and PostgreSQL

2008-01-15 Thread Ivan Sergio Borgonovo
Hi, Among Drupal developer there is such kind of discussion over and over recently: http://drupal4hu.com/node/64 I'd be too PostgreSQL biased to comment further... my point of view is not too different from the one expressed by Steve Rude at the bottom of the page. Furthermore I think that deve

Re: [GENERAL] autovacuum vs. createdb

2008-01-15 Thread Ben
On Tue, 15 Jan 2008, Tom Lane wrote: Ben <[EMAIL PROTECTED]> writes: I'm noticing a problem where autovacuum touching template1 when createdb is run is making createdb fail. That's easy to work around when doing things by hand (just run it again), but when running createdb with a script, it's n

Re: [GENERAL] advocacy: drupal and PostgreSQL

2008-01-15 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 16 Jan 2008 01:12:07 +0100 Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote: > Hi, > > Among Drupal developer there is such kind of discussion over and over > recently: > > http://drupal4hu.com/node/64 I commented here. > I'd ask to all th

Re: [GENERAL] advocacy: drupal and PostgreSQL

2008-01-15 Thread Greg Smith
On Wed, 16 Jan 2008, Ivan Sergio Borgonovo wrote: Furthermore I think that developing in such a MySQLish centric way will make MUCH harder to support any other DB not only PostgreSQL and freedom of choice is very important to me. Having helped out a bit getting Postnuke working better with Pos

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Tom Lane
I think I found at least one part of the problem. I was able to reproduce a crash similar to yours by running the german_ispell dictionary against long random words, and what I found out is that it's possible to overrun the fixed-length "buf" buffer declared at line 1542 of spell.c. Run till exit

Re: [GENERAL] ERROR: shared buffer hash table corrupted

2008-01-15 Thread T.J. Adami
with extraordinary success in his ministry, in the conversion of many souls. He had five harvests, as he called them. The first was about 57 years ago; the second about 53; the third about 40; the fourth about 24; the fifth and last about 18 years ago. Some of these times were much more remarkable

Re: [GENERAL] COUNT() with ORDER BY

2008-01-15 Thread T.J. Adami
fervent with love. Princes abandoned their pomp; maidens suffered martyrdom. Whence came this influence? The Messiah was come. These were the effect and sign of His coming. 773. Destruction of the Jews and heathen by Jesus Christ: Omnes gentes venient et adorabunt eum.156 Parum est ut,157 etc. Pos

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Hannes Dorbath
believe that matters were reversed? In short, as we often dream that we dream, heaping dream upon dream, may it not be that this half of our life, wherein we think ourselves awake, is itself only a dream on which the others are grafted, from which we wake at death, during which we have as few princ

Re: [GENERAL] backup and restore

2008-01-15 Thread T.J. Adami
shall be sprinkled on his garments, so as to stain all his raiment. He will not only hate you, but he will have you in the utmost contempt: no place shall be thought fit for you, but under his feet to be trodden down as the mire of the streets. The misery you are exposed to is that which God wil

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Hannes Dorbath
to the rich, that, if they do it not in the sight of God, they depart from the command of religion. SECTION VI: THE PHILOSOPHERS 339. I can well conceive a man without hands, feet, head (for it is only experience which teaches us that the head is more necessary than feet).

Re: [GENERAL] backup and restore

2008-01-15 Thread T.J. Adami
the others in their vastness. For who will not be astounded at the fact that our body, which a little while ago was imperceptible in the universe, itself imperceptible in the bosom of the whole, is now a colossus, a world, or rather a whole, in respect of the nothingness which we cannot reach? He w

Re: [GENERAL] 8.2.4 serious slowdown

2008-01-15 Thread Sim Zacks
gave orders that the burning fiery furnace should be heated seven times hotter than it was before; doubtless, it was raised to the utmost degree of fierceness that human art could raise it. But the great God is also willing to show his wrath, and magnify his awful majesty and mighty power in the ex

Re: [GENERAL] 8.2.4 serious slowdown

2008-01-15 Thread Sim Zacks
who before had serious thoughts, had their awakenings and convictions greatly increased. There were many instances of persons who came from abroad on visits, or on business, who had not been long here, before, to all appearances, they were savingly wrought upon, and partook of that shower of divine

Re: [GENERAL] ECPG problem with 8.3

2008-01-15 Thread Peter Wilson
That it had been her opinion, till now, she was not guilty of Adam's sin, nor any way concerned in it, because she was not active in it; but that now she saw she was guilty of that sin, and all over defiled by it; and the sin which she brought into the world with her, was alone sufficient to condem

Re: [GENERAL] 8.2.4 serious slowdown

2008-01-15 Thread Sim Zacks
point beyond which our senses can no longer perceive anything, although by its nature it is infinitely divisible. Of these two Infinites of science, that of greatness is the most palpable, and hence a few persons have pretended to know all things. "I will speak of the whole," said Democritus. But

Re: [GENERAL] ECPG problem with 8.3

2008-01-15 Thread Peter Wilson
them. Every one can say this; every one can call himself a prophet. But I see that Christian religion wherein prophecies are fulfilled; and that is what every one cannot do. 694. And what crowns all this is prediction, so that it should not be said that it is chance which has done it? Whosoever,

Re: [GENERAL] LIKE and REGEX optimization

2008-01-15 Thread Chris Browne
fit to come to Christ; they are so wicked that Christ will never accept them. And then it may be they set themselves upon a new course of fruitless endeavors, in their own strength, to make themselves better, and still meet with new disappointments. They are earnest to inquire what they shall do. T

Re: [GENERAL] 8.2.4 serious slowdown

2008-01-15 Thread Sim Zacks
His agony? Do they not know how to paint a resolute death? Yes, for the same Saint Luke paints the death of Saint Stephen as braver than that of Jesus Christ. They make Him, therefore, capable of fear, before the necessity of dying has come, and then altogether brave. But when they make Him so tr

Re: [GENERAL] Segmentation fault with 8.3 FTS ISpell

2008-01-15 Thread Hannes Dorbath
with the imagination that it is, therefore, obscure and, on the contrary, that what is to prove it is clear, and so we understand it easily. 41. Epigrams of Martial.--Man loves malice, but not against one-eyed men nor the unfortunate, but against the fortunate and proud. People are mistaken in thi

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008-01-15 Thread Tom Lane
I went through this thread again, and noticed something that no one seems to have remarked on at the time: the vmstat numbers near the bottom of this post http://archives.postgresql.org/pgsql-general/2008-01/msg00161.php show close to 100% I/O wait time (either that or 50% idle 50% I/O wait, whic

Re: [GENERAL] advocacy: drupal and PostgreSQL

2008-01-15 Thread Robert Treat
On Tuesday 15 January 2008 21:00, Greg Smith wrote: > On Wed, 16 Jan 2008, Ivan Sergio Borgonovo wrote: > > Furthermore I think that developing in such a MySQLish centric way > > will make MUCH harder to support any other DB not only PostgreSQL and > > freedom of choice is very important to me. > >

Re: [GENERAL] advocacy: drupal and PostgreSQL

2008-01-15 Thread Joshua D. Drake
Robert Treat wrote: On Tuesday 15 January 2008 21:00, Greg Smith wrote: There's been a big move in the php community to push people towards php5 (one of which was EOL of php4), which has started to pay off. I'd guess that if they wanted to, they could switch to PDO with Drupal 7 and not hurt

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008-01-15 Thread Joshua D. Drake
Tom Lane wrote: I went through this thread again, and noticed something that no one seems to have remarked on at the time: the vmstat numbers near the bottom of this post http://archives.postgresql.org/pgsql-general/2008-01/msg00161.php show close to 100% I/O wait time (either that or 50% idle

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008-01-15 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > If we are sure that this issue is apparent actual row insertion it > should be easy to duplicate. I think you missed my point entirely: I believe it's specific to Clodoaldo's installation. Certainly I didn't have any luck reproducing a huge 8.2-to-

Re: [GENERAL] ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?

2008-01-15 Thread Joshua D. Drake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 16 Jan 2008 00:29:16 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > If we are sure that this issue is apparent actual row insertion it > > should be easy to duplicate. > > I think you missed my

Re: [GENERAL] Query to get column-names in table via PG tables?

2008-01-15 Thread Ken Johanson
Tino Wildenhain wrote: Ken Johanson wrote: I am looking for expertise on how to program the equivalent to this query, but using the pg_catalog tables, which I understand have fewer security restrictions than information_schema in some cases: SELECT column_name FROM information_schema.columns WH

Re: [GENERAL] Query to get column-names in table via PG tables?

2008-01-15 Thread Ken Johanson
Merlin Moncure wrote: On Jan 15, 2008 1:15 AM, Ken Johanson <[EMAIL PROTECTED]> wrote: The output of this is very verbose and broken into multiple queries making joins difficult for me to understand, I'm afraid; my current experience level likely will not reliably produce a single-query equivale

Re: [GENERAL] Query to get column-names in table via PG tables?

2008-01-15 Thread Ken Johanson
Merlin Moncure wrote: On Jan 15, 2008 1:15 AM, Ken Johanson <[EMAIL PROTECTED]> wrote: The output of this is very verbose and broken into multiple queries making joins difficult for me to understand, I'm afraid; my current experience level likely will not reliably produce a single-query equivale