Re: [GENERAL] More details on Database corruption

1998-08-13 Thread Dimitri
It seems to be the same for me... But I can see "tasks" table after restarting of psql, so it doesn't crash the data files. What can be usefull is the messages in the server.log file: Too Large Allocation Request ... File: mcxt.c Line: 232 I don't know the code of PG, but we can ask PG "gurus"

[GENERAL] More details on Database corruption

1998-08-13 Thread George Kousi
Hi, I managed to recreate a simple example that's crashing postgres. I am running on a DEC Alpha with Digital Unix Version 4.0d and Postgres 3.2. I tried this example several times, on several databases and it crashes every time. We also re-built Postgres and still did not work. Here's the ex

[GENERAL] More Details (cont.)

1998-08-13 Thread George Kousi
Sorry, Another piece of useful information on my previous posting is that removing the default from all the fields in the table seems to solve the problem. Thank you. George K.

Re: [GENERAL] Pricing

1998-08-13 Thread Glenn Sullivan
Thanks for your responses to my question about the price of using PostgreSQL. Glenn

[GENERAL] Database corruption

1998-08-13 Thread George Kousi
Hi there, I'm using LibPQ from C++ to access a database and I am doing an update on a table with two primary keyes but my where clause is only using one of these keys. I am somehow corrupting the database and after that, the backend dies every time I try to access that table. Any ideas on what

Re: [GENERAL] Postgresql Full text search?h

1998-08-13 Thread Bruce Momjian
> Does PostgreSQL support full text search? > > 6.4, beta September 1, will have a contrib module to do just that. -- Bruce Momjian | 830 Blythe Avenue [EMAIL PROTECTED] | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 3

[GENERAL] Postgresql Full text search?

1998-08-13 Thread Oosterloo, Robert-Jan
Does PostgreSQL support full text search?

[GENERAL] lower(varchar)

1998-08-13 Thread Maarten Boekhold
Hi, I just tried to create a functional index on a varchar column, which failed, cos lower() is not defined on varchars. I guess it's only supported for text columns (aren't they treated the same way internally?). So, I figured, let's cast the varchar to a text type: create index product_arti

[GENERAL] Client for DOS environment

1998-08-13 Thread alfio su allnet
I know this question could sound silly, but it is possible to use postgresql with a DOS Client ?   I was looking for a solution for old machine still working !   Regards Alfio MANTINEO