On Tue, Aug 28, 2012 at 9:52 AM, Ing.Edmundo.Robles.Lopez <
erob...@sensacd.com.mx> wrote:
> Hi!
> We are using postgresql 8.3 in my work, and the need to migrate to a newer
> version became urgent :)
>
> I've been reading the release notes for versions 8.4 and 9.1, but is not
> clear to me which
On 29/08/12 02:29, mithun wrote:
Dear Sir,
We are gathering information regarding PostgreSQL open source product
quality and its community. Can you kindly help me to find following data.
1.Number of releases happened since last 12 months along with its
version numbers.
2.Number of Bugs
On 29/08/12 04:52, Ing.Edmundo.Robles.Lopez wrote:
Hi!
We are using postgresql 8.3 in my work, and the need to migrate to a
newer version became urgent :)
I've been reading the release notes for versions 8.4 and 9.1, but is
not clear to me which problems I can have with version 8.4 or 9.1 fro
I have a skeleton table tb_audit_event that has a bunch of descendant
tables.
I want to remove the pk column from this table and all of the descendant
tables, however issuing an ALTER TABLE tb_audit_event DROP COLUMN
audit_event drops the column only from the parent table.
The docs said that the d
2012/8/20 Merlin Moncure
> On Sun, Aug 19, 2012 at 8:14 AM, Dmitriy Igrishin
> wrote:
> >> For various reasons, this often goes the wrong way. Views are often
> >> the right way to go. +1 on your comment above -- the right way to do
> >> views (and SQL in general) is to organize scripts and to
On 08/28/2012 04:47 PM, Merlin Moncure wrote:
> On Tue, Aug 28, 2012 at 9:29 AM, mithun
> wrote:
>> Dear Sir,
>>
>> We are gathering information regarding PostgreSQL open source product
>> quality and its community. Can you kindly help me to find following data.
>
> Your questions are incredibl
On Tuesday, August 28, 2012 11:52:26 AM Ing.Edmundo.Robles.Lopez wrote:
> Please, could you help to give peace of mind to my boss and make sure
> that the version we choose to be as smooth as possible compatible with
> version 8.3?
>
All compatibility changes are indicated in the upgrade notes fr
Hi!
We are using postgresql 8.3 in my work, and the need to migrate to a
newer version became urgent :)
I've been reading the release notes for versions 8.4 and 9.1, but is not
clear to me which problems I can have with version 8.4 or 9.1 from a
dump 8.3
My boss thinks we would have fewer p
On Tue, Aug 28, 2012 at 8:33 AM, prashantbharucha
wrote:
> Hi Craig
>
> I got connection to pgbouncer,but how do i pass actual database parameter
> to connect .
>
> I attached my perl script and getting error : prepared statement
> "dbdpg_p27841_1"
That doesn't look like a complete error message
Hi Craig
I got connection to pgbouncer,but how do i pass actual database parameter
to connect .
I attached my perl script and getting error : prepared statement
"dbdpg_p27841_1"
Thanks
my $PGDBNAME = 'test';
my $PGDBSERVER = '172.16.40.19';
my $PGDBUSER = 'postgres';
my $PGDBPASSWD = 'post
Tom Lane, 28.08.2012 16:30:
In Oracle an index (entry) has the information about transactional visibility.
You sure about that?
Yes, although technically it's not the index *entry*, but the index *block*.
But the result is the same thing.
The visibility information is stored on data block le
On Tue, Aug 28, 2012 at 9:29 AM, mithun
wrote:
> Dear Sir,
>
> We are gathering information regarding PostgreSQL open source product
> quality and its community. Can you kindly help me to find following data.
Your questions are incredibly broad, so you're going to get some broad answers.
> 1.
Dear Sir,
We are gathering information regarding PostgreSQL open source product
quality and its community. Can you kindly help me to find following data.
1. Number of releases happened since last 12 months along with its
version numbers.
2. Number of Bugs fixed since last 12 mon
Thomas Kellerer writes:
> Martijn van Oosterhout, 28.08.2012 10:02:
>> I'm not sure how oracle avoids the same issues:
>> - The index has no visibility information, so you can't tell if an
>> index entry refers to a row you can actually see in your session.
>> The visibility map might help here in
Hi again,
I already fix the problem, thanks.
Regards
José Santos
> Date: Tue, 28 Aug 2012 21:44:00 +0800
> From: ring...@ringerc.id.au
> To: zpsant...@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] FGS - Postgresql server install
>
> On 08/28/2012 09:31 PM, José Pedro
On Mon, Aug 27, 2012 at 11:46 AM, EXT-Rothermel, Peter M
wrote:
> I thought that this was going to be tricky.
>
> Perhaps I could use rules to populate a shadow table that is like a INNER
> JOIN of the two tables. This would consolidate the Boolean on the separate
> table into the same table tha
Hello,
I had a similar question some time ago, with an answer by Tom lane:
http://archives.postgresql.org/pgsql-general/2012-03/msg00023.php
best regards,
Marc Mamin
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Sahagian, David
On Tue, Aug 28, 2012 at 6:04 AM, Craig Ringer wrote:
> On 08/28/2012 05:51 PM, Thomas Kellerer wrote:
>
>> Martijn van Oosterhout, 28.08.2012 10:02:
>>
>>> I'm not sure how oracle avoids the same issues:
>>> - The index has no visibility information, so you can't tell if an
>>>index entry ref
On 08/28/2012 09:31 PM, José Pedro Santos wrote:
Hi all,
I'm trying to install the fgs-postgresql-server-8.4.2-linux-i386.tar.gz
in FGS MAPSERVER distribution but I can't, I'm using the Linux Centos
version*. *Anyone know the command line to install the module? Is
because when I install the FGS
Using 9.1
Can somebody tell me the order in which the Unique Constraints of a table are
checked, like when an INSERT is done ?
It seems the the Primary is checked first, but what about the regular UCs ?
Thanks,
-dvs-
Craig Ringer, 28.08.2012 15:04:
In Oracle an index (entry) has the information about transactional visibility.
Wow. Doesn't that mean that indexes are insanely expensive to update,
since each index (and possibly also the table its self) needs
updating?
No, I don't think so.
It's the same me
Hi all,
I'm trying to install the fgs-postgresql-server-8.4.2-linux-i386.tar.gz in FGS
MAPSERVER distribution but I can't, I'm using the Linux Centos version. Anyone
know the command line to install the module? Is because when I install the FGS
version the module postgresql server don't came
Ah, thanks a lot for the Select .. For Update clue/reminder! The partitions
are actually going to arrive from different systems (lab reports coming
from lab equipment and nurses entering bedside data at the same time etc).
So I'll have to be defensive about concurrency.
Best regards
Seref
On Tue
On 08/28/2012 08:56 PM, Seref Arikan wrote:
Can I simply adopt the naive approach of updating an EHR metadata table
within a transaction in every partition addition/deletion operation?
Absolutely. That's a classic trade-off; pay the cost of maintaining a
materialized view at INSERT/UPDATE/DELE
On Tue, Aug 28, 2012 at 5:34 AM, wrote:
> Hi all,
>
> I´m not sure whether this is the appropriate place to post this but I don´t
> want to keep it back from you: We´re currently looking for a postgres DBA in
> our office in Berlin, Germany.
>
> Here is the link to the job posting:
> http://ww
On 08/28/2012 05:51 PM, Thomas Kellerer wrote:
Martijn van Oosterhout, 28.08.2012 10:02:
I'm not sure how oracle avoids the same issues:
- The index has no visibility information, so you can't tell if an
index entry refers to a row you can actually see in your session.
The visibility map m
Greetings,
I need to keep various information related to a parent entity (the
Electronic Health Record for a single patient) and its children (partitions
of the EHR, since it can get very big).
It is important that I know how many partitions exist for an EHR, and I'd
like to avoid a query that'll c
Hi all,
I´m not sure whether this is the appropriate place to post this but I don´t
want to keep it back from you: We´re currently looking for a postgres DBA in
our office in Berlin, Germany.
Here is the link to the job posting:
http://www.kaufda.de/corporate/jobs/offene-stellen/it/postgres-d
Martijn van Oosterhout, 28.08.2012 10:02:
I'm not sure how oracle avoids the same issues:
- The index has no visibility information, so you can't tell if an
index entry refers to a row you can actually see in your session.
The visibility map might help here in the future.
In Oracle an ind
Mouse Dresden wrote:
OK. I won't go into details about why I need them, since no one wants
a long story.
Simply put, I'm looking for odbc drivers for postgresql that will work with NT4.
I've been using 8.02.01.04 on NT4 app servers for an extended period,
look for psqlodbc.msi of the appropri
On Sun, Aug 26, 2012 at 11:01:31PM +0200, Thomas Kellerer wrote:
> I was inspired by this question on StackOverflow:
> http://stackoverflow.com/questions/12128501/fastest-way-to-count-the-rows-in-any-database-table/12128545#12128545
>
> Which shows Oracle's behaviour with an index scan for the cou
31 matches
Mail list logo