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
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
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
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.
-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
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
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,
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
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
Hello,
Are the indexes inherited during table inheritance ?
Thanks
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
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
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
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])
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)
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
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).
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
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
18 matches
Mail list logo