Re: [GENERAL] Re: "LockRelease: locktable lookup failed, no lock"

2000-03-01 Thread Wim Aarts
Hi Steve, Have you checked for inserts in the message field larger then 8k? Cheers Wim. Steve Wolfe wrote: > Grr > > Although I'm no longer getting lock releases on this table, a daily > vaccum analyze still shows: > > NOTICE: Rel reef: Uninitialized page 492 - fixing > NOTICE: Rel r

[GENERAL] Simple problem?

2000-03-01 Thread Stan Jacobs
Hi there, I must be confusing my syntax somehow, because I'm having trouble doing a simple update with returned id... As in I have two tables: an order table and an orderitems table. I need to write the order record, then use the order_id from the order record in the insert to the orderite

Re: [GENERAL] psql 7.0.0 beta

2000-03-01 Thread Tomaz Borstnar
At 04:17 PM 01/03/00, Bruce Momjian wrote the following message: >Your OS should have pid_t defined in an include file. Findit, and add >the #include to miscadmin.h. Then, tell us so we can add it here. #include seemed to help > > At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message:

[GENERAL] PostgreSQL ODBC and Crystal Reports

2000-03-01 Thread Timothy Grant
Yet some more questions. Does anyone know of any issues regarding the PostreSQL ODBC driver and Crystal Reports? I am running report that Groups by a column that may have several words in it. It appears that Crystal's grouping system is dropping everything after the first space. I am trying to d

Re: [GENERAL] More newbie question: Restructuring a table

2000-03-01 Thread Karel Zak - Zakkr
On Wed, 1 Mar 2000, Timothy Grant wrote: > Hi again, > > Is there a quick and dirty way that I am missing for creating a new > database with a slightly different schema than the old db? > > For example, I have a table with a DATETIME field that I really need to > change to a DATE field. > > I

[GENERAL] More newbie question: Restructuring a table

2000-03-01 Thread Timothy Grant
Hi again, Is there a quick and dirty way that I am missing for creating a new database with a slightly different schema than the old db? For example, I have a table with a DATETIME field that I really need to change to a DATE field. I can create a new table with that field defined as a DATE, bu

Re: [GENERAL] psql 7.0.0 beta

2000-03-01 Thread Bruce Momjian
Your OS should have pid_t defined in an include file. Findit, and add the #include to miscadmin.h. Then, tell us so we can add it here. > At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message: > >P.S.: Ah, there was another problem, but I wasn able to reproduce it; > > after compili

[GENERAL] Re: "LockRelease: locktable lookup failed, no lock"

2000-03-01 Thread Steve Wolfe
Grr Although I'm no longer getting lock releases on this table, a daily vaccum analyze still shows: NOTICE: Rel reef: Uninitialized page 492 - fixing NOTICE: Rel reef: Uninitialized page 498 - fixing NOTICE: Rel reef: Uninitialized page 499 - fixing The database is a fledgling mai

Re: [GENERAL] "LockRelease: locktable lookup failed, no lock"

2000-03-01 Thread Steve Wolfe
> > > I'm getting "LockRelease: locktable lookup failed, no lock" trying to > > > insert a row into a database. > > > > Well, I think I tracked down the problem - an index on a "text" field. > > Once I removed the index, everything works well. The odd thing is that not > > *all* inserts would

Re: [GENERAL] Performance on WindowsNT

2000-03-01 Thread The Hermit Hacker
On Wed, 1 Mar 2000, Erwin Selg wrote: > Also I read it was a Java database, so my question: Is it a Java > database or is it done in C++? Where did you read this? The server itself is written completely in C, while there are JDBC, ODBC, C++, tcl, etc interfaces available ...

[GENERAL] Performance on WindowsNT

2000-03-01 Thread Erwin Selg
Hello,   right now I'm evaluating the PostgreSQL and it seems to be the big bang for us. But also it is quite important to have a good performance on several platforms i.e. WindowsNT , Linux etc.   My question now is: Is there a difference in performance? I read on Windows it is running us

Re: [GENERAL] psql 7.0.0 beta

2000-03-01 Thread Tomaz Borstnar
At 11:06 AM 28/02/00, Ulf Mehlig wrote the following message: >P.S.: Ah, there was another problem, but I wasn able to reproduce it; > after compiling, "make install" did not install "initdb"; after > repeating the install, everything was in place (Redhat 6.1); > another install

Re: [GENERAL] order by

2000-03-01 Thread Oleg Broytmann
On Tue, 29 Feb 2000, Adrian Perez Camarena wrote: > is there a file of postgres that I can change to tell postgres > that the language that I need to order by name correctly is > spanish? (or something like that) If I do understand your problem, the solution is here - you should recompile Post

[GENERAL] Re: [HACKERS] Poll: Databases for Linux

2000-03-01 Thread Oleg Broytmann
On Wed, 1 Mar 2000, The Hermit Hacker wrote: > As Jeff mentioned earlier today, there is a poll going on at > http://www.linux.com that asks: > > Several high-quality databases are available for Linux. Which database, > if any, does your company primarily use with its Linux servers? > > Right n