Re: [GENERAL] PostgreSQL 8.0.0 Release Candidate 4

On Fri, 2005-01-07 at 17:04, Marc G. Fournier wrote: > [...] > A current list of *known* supported platforms can be found at: > > http://developer.postgresql.org/supported-platforms.html > > We're always looking to improve that list, so we encourage anyone that is > running a platform not

Re: [GENERAL] PostgreSQL users on webhosting

I'd just like to add that having all the users in one database has another minor disadvantage: If you want to make use of PITR for your clients, and client A shares a postgres instance with client B, and client A asks to be time warped, then you have to time warp both, since both are in the same d

Re: [GENERAL] Postgres 8 release

The current schedule is that the code will be packaged Monday night (EST) and the official announcement will be made Wednesday morning. On Mon, Jan 10, 2005 at 03:58:15AM -0200, brunotavila wrote: > When is the next release 8.00 will became stable or available? > > Bruno > > ___

[GENERAL] Postgres 8 release

When is the next release 8.00 will became stable or available? Bruno __ Acabe com aquelas janelinhas que pulam na sua tela. AntiPop-up UOL - É grátis! http://antipopup.uol.com.br/ ---(end of broadc

[GENERAL] could not open relation No such file or directory after alter table

This is Postgresql 8 RC 1 on freebsd 5.3. I changed the type of a column from varchar(128) to varchar(256), and right after that I got the following messages when doing inserts on the table in question. <41e0e2c3.fd54>ERROR: SMgrRelation hashtable corrupted <41e0e2c3.fd54>STATEMENT: commit <4

Re: [GENERAL] PostgreSQL users on webhosting

You might be interested to see a previous thread started by me on that very subject: I got one reply that was very informative by William White: The other reply

Re: [GENERAL] PostgreSQL users on webhosting

If you are using Linux and you want to do things these ways, you can take advantage loopback files systems. You can carve up a large disk this way and control the space requirements per client. Quoting Jeff Davis <[EMAIL PROTECTED]>: > I must not have been clear. In postgres you can limit people

Re: [GENERAL] how to optimize my c-extension functions

"TJ O'Donnell" <[EMAIL PROTECTED]> writes: > The only type of search will be of the type: > Select smiles,id from structure where oe_matches(smiles,'c1c1C(=O)N'); You haven't really said much about how you expect an index to be able to help you with this, but I think if any index type can he

Re: [GENERAL] how to optimize my c-extension functions

Let me first say that I will routinely be dealing with one million+ rows, so I want to take care to optimize my work as much as possible, and to consider carefully my design decisions. The only type of search will be of the type: Select smiles,id from structure where oe_matches(smiles,'c1c1C(=

Re: [GENERAL] how to optimize my c-extension functions

Well, first and easy thing you can do is create a column to store the parsed representation and update it via a trigger when the original, unparsed column is updated or inserted. Is this sufficiently "hidden from the user" for you ? I know it's not really hidden, but the fact that updating

Re: [GENERAL] configuration problems of postgresql under windows xp

> >my team and I have to work with postgresql, apache and the umn > >mapserver for > >a student project. The only problem is that not one of us has > >ever worked > >with postgresql and now, after having installed the rc2 > >Version for windows > >we don't know how to configure the software. Af

Re: [GENERAL] how to optimize my c-extension functions

To add to my last followup posting, the only way I use oe_mathces(smiles) is in something like the following: Select smiles,id from structure where oe_matches(smiles,'CCOC'); The match string 'CCOC' in this case, varies widely according to the needs of the user during that session. It is analogous

Re: [GENERAL] [OT] found nagios plugins for monitoring Dell server

For anyone who needs nagios plugins to monitor the state of their raid controllers and disk arrays for their Dell db servers There is a nagios plugin for the megaraid controllers at http://www.ibiblio.org/john/megaraid/ And a plugin for the accraid controllers at http://www.iamafreeman.com/projec

Re: [GENERAL] how to optimize my c-extension functions

Yes, my c function and it's sql counterpart, oe_matches(smiles) uses two steps (1) parse smiles (2) search parsed smiles. Parsing is expensive. The smiles has an external string representation, which is stored in a smiles column, but only the parsed form is actually searchable. The smiles represe

Re: [GENERAL] Regexp matching: bug or operator error?

Kenneth Tanzer <[EMAIL PROTECTED]> writes: > OK. I've been trying to get my mind around this, and think about ways > to improve the documentation (more about that below). I finally got around to revising the regex docs on the basis of this discussion: see patch at http://developer.postgresql.org

Re: [GENERAL] PYTHON, ODBC

due to the complicated nature of the database, and inability of zope Well, I've found that Zope is very good to do a few things, and very bad at the rest. to do what we need, and the problems with overhead we've been experiencing with rails due to the size of the database. Hope this I like p

Re: [GENERAL] PYTHON, ODBC

- Forwarded message from Matthew Story <[EMAIL PROTECTED]> - Date: Sun, 9 Jan 2005 12:40:36 -0600 From: Matthew Story <[EMAIL PROTECTED]> Reply-To: Matthew Story <[EMAIL PROTECTED]> Subject: Re: [GENERAL] PYTHON, ODBC To: Pierre-Frédéric Caillaud <[EMAIL PROTECTED]> we won

Re: [PORTS] [GENERAL] PostgreSQL 8.0.0 Release Candidate 4

Stuart Bishop <[EMAIL PROTECTED]> writes: > Marc G. Fournier wrote: > | A current list of *known* supported platforms can be found at: > | http://developer.postgresql.org/supported-platforms.html > I notice that Ubuntu is not yet on this list. I can confirm that > PostgreSQL 7.4.5 is supported

Re: [GENERAL] Get execution plan of dynamic query

"=?KOI8-R?Q?=E1=CC=C5=CB=D3=C5=CA =FB.?=" <[EMAIL PROTECTED]> writes: > How to get results of EXPLAIN of dynamic query maked up in PL/PGSQL function? Pretend that it's a prepared statement. For example, if your plpgsql function has declare x int; y int; begin

Re: [GENERAL] PostgreSQL 8.0.0 Release Candidate 4

On Fri, 2005-01-07 at 17:04, Marc G. Fournier wrote: > [...] > A current list of *known* supported platforms can be found at: > > http://developer.postgresql.org/supported-platforms.html > > We're always looking to improve that list, so we encourage anyone that is > running a platform not

Re: [GENERAL] configuration problems of postgresql under windows xp

>my team and I have to work with postgresql, apache and the umn >mapserver for >a student project. The only problem is that not one of us has >ever worked >with postgresql and now, after having installed the rc2 >Version for windows >we don't know how to configure the software. After searching

Re: [GENERAL] PYTHON, ODBC

completely proprietary front end written in python. Any help finding useful What does "a completely proprietary front-end in python" means ? ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] configuration problems of postgresql under windows xp

> my team and I have to work with postgresql, apache and the umn mapserver for > a student project. The only problem is that not one of us has ever worked > with postgresql and now, after having installed the rc2 Version for windows > we don't know how to configure the software. After searching th

[GENERAL] PITR questions

I have been experimenting with PITR (8.0 beta5), and I have a few questions. I started with a fresh cluster (did initdb on data). Then I did the following sequence of things: (01) Set in pg_hba.conf: archive_command = 'test ! -f /archive/%f && cp -f %p /archive/%f' (02) start pos

Re: [GENERAL] Books for experienced developers

Postgresql introductions and concepts by bruce momijan isn't bad, though it is severely out of date, but most of the concepts of postgresql have stayed the same, the text will not provide you with any how-tos for the newer functionality, though it should help you make the conceptual switch to postg

[GENERAL] PYTHON, ODBC

We're looking into building a front end for our database in python. The database in question is an educational database, that generates new tables for each teacher, class and student. Was wondering if anyone had any recommendations for similar projects to look at, resources, and general informati

[GENERAL] Get execution plan of dynamic query

How to get results of EXPLAIN of dynamic query maked up in PL/PGSQL function? I found option 'debug_print_plan', but it produces incomprehensible output. Is there an option to dump execution plan in EXPLAIN format? EXPLAIN return generic result set in client application, as 'SELECT' command do

Re: [GENERAL] PostgreSQL 8.0.0 Release Candidate 3

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Marc G. Fournier wrote: | A current list of *known* supported platforms can be found at: | | http://developer.postgresql.org/supported-platforms.html | | We're always looking to improve that list, so we encourage anyone that | is running a platform

[GENERAL] configuration problems of postgresql under windows xp

Hiya, my team and I have to work with postgresql, apache and the umn mapserver for a student project. The only problem is that not one of us has ever worked with postgresql and now, after having installed the rc2 Version for windows we don't know how to configure the software. After searching the