Re: [GENERAL] Best practices for migrating a development database

2004-09-13 Thread Csaba Nagy
Beside version controlled schema files we have a guy who writes migration scripts based on the old schema and the new (development) schema (frozen e.g. by branching in CVS). Usually there are 3 steps involved: - a pre-migration script, which prepares the data base for the new schema, by adding

Re: [GENERAL] Best practices for migrating a development database

2004-09-13 Thread Julian North
Hi, We manage a number of high-volume databases that require 24/7 uptime (pretty much) and deal with this problem a lot. The solution we employ is that once a database is in production the only way to alter the database is using a change script that deals with any data migration issues as

Re: [GENERAL] View efficiency questions

2004-09-13 Thread Phil Endecott
Hi Tom, Thanks for writing. On Saturday I had a query that took 3000 ms but reduced to only 1200 ms when I took out the date formatting functions from the views. Now it takes only 700 ms with or without the functions. Perhaps an ANALYZE in the meantime has changed everything. Anyway, thanks

[GENERAL] Questions about Postgresql 8.0

2004-09-13 Thread John Allgood
Hello All I have been following the list in regards to Postgresql 8.0. I am very excited about this release and what it brings to the Postgres World. Our company has been converting from Progress 7.3E Database to Postgres and one of the things that Progress has is roll-forward recovery.

Re: [GENERAL] Questions about Postgresql 8.0

2004-09-13 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Mon, 13 Sep 2004, John Allgood wrote: I have been following the list in regards to Postgresql 8.0. I am very excited about this release and what it brings to the Postgres World. Our company has been converting from Progress 7.3E Database to

[GENERAL] Autonomous transaction

2004-09-13 Thread Daniel Daoust
Hi, knowing that autonomous transaction (Oracle concept of) are not yet implemented in PostgreSQL, has anyone found a work-around. I need to preserve database states from a potential rollback and then log them inside database tables. What about: 1) using memory structures to hold the info, then

Re: [GENERAL] Autonomous transaction

2004-09-13 Thread John Sidney-Woollett
My understanding is that this feature won't be available even in v8 of postgres. Nested transactions will roll back with the main transaction when it's rolled back... You could take a look at contrib/dblink because apparantly you can open a connection to another (and probably the same) DB,

Re: [GENERAL] problems returning a resultset from a function

2004-09-13 Thread Jim Wilson
Leo Martin Orfei said: hi. I have a problem with postgres functions. I need return a resultset from a postgres function and browse the resultset in a java app. I try with this simple function: create function test() returns catalog.refcursor as' declare aux refcursor; BEGIN OPEN

Re: [GENERAL] Autonomous transaction

2004-09-13 Thread Dan Sugalski
At 11:18 AM -0400 9/13/04, Daniel Daoust wrote: Hi, knowing that autonomous transaction (Oracle concept of) are not yet implemented in PostgreSQL, has anyone found a work-around. I need to preserve database states from a potential rollback and then log them inside database tables. What I use for

[GENERAL] Index inheritance

2004-09-13 Thread Fabien
Hello, Are the indexes inherited during table inheritance ? Thanks ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[GENERAL] ANNOUNCE: Bricolage 1.8.2 Released

2004-09-13 Thread David Wheeler
The Bricolage development team is pleased to announce the release of Bricolage 1.8.2. This maintenance release addresses quite a large number of issues in Bricolage 1.8.1. The most important changes were to enhance Unicode support in Bricolage. Bricolage now internally handles

Re: [GENERAL] Autonomous transaction

2004-09-13 Thread Greg Stark
Daniel Daoust [EMAIL PROTECTED] writes: Hi, knowing that autonomous transaction (Oracle concept of) are not yet implemented in PostgreSQL, has anyone found a work-around. I need to preserve database states from a potential rollback and then log them inside database tables. Postgres goes to

Re: [GENERAL] Index inheritance

2004-09-13 Thread Phil Endecott
Are the indexes inherited during table inheritance ? No. --Phil. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

[GENERAL] Building plpython on Mac OSX...

2004-09-13 Thread Jerry LeVan
Have any configure experts looked at building plpython.so on mac os x lately? The standard configure key --with-python fails miserably (libpython is not a shared lib error message). I found help on the macosxguru site, Basically one has to change the python_libspec to (in Makefile.global)

[GENERAL] Number of Active Connections

2004-09-13 Thread MaRCeLO PeReiRA
Hi guys, How can I know about the number of active connections?? (not the maximum allowed, but the number of open connections). Regards, Marcelo Pereira Brasil __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around

Re: [GENERAL] Number of Active Connections

2004-09-13 Thread elein
select count(*) from pg_stat_activity; for detailed info use: select * from pg_stat_activity; On Mon, Sep 13, 2004 at 02:49:36PM -0300, MaRCeLO PeReiRA wrote: Hi guys, How can I know about the number of active connections?? (not the maximum allowed, but the number of open connections).

Re: [GENERAL] Number of Active Connections

2004-09-13 Thread MaRCeLO PeReiRA
Hi Elein, Thanks!! It was exactly what I was looking for!!! Regards, Marcelo Pereira Brasil --- elein [EMAIL PROTECTED] escreveu: select count(*) from pg_stat_activity; for detailed info use: select * from pg_stat_activity; On Mon, Sep 13, 2004 at 02:49:36PM -0300, MaRCeLO PeReiRA

Re: [GENERAL] Number of Active Connections

2004-09-13 Thread Gaetano Mendola
MaRCeLO PeReiRA wrote: Hi guys, How can I know about the number of active connections?? (not the maximum allowed, but the number of open connections). If you have enough permission: select count(*) from pg_stat_activity; Regards Gaetano Mendola ---(end of