I have an application in which I want it
_not_ to be possible to work out which
rows of a table are being/have been updated.
I can think of these different compromise scenarios:
(a) Hacker can connect to the database to
execute queries.
The severity depends on which database user
the
Excerpts from Gordon Shannon's message of mié may 19 23:32:07 -0400 2010:
>
> alvherre wrote:
> >
> > n_live_tup and n_dead_tup corresponds to the current numbers,
> > whereas "last analysis tuples" are the values from back when the
> > previous analyze ran. These counters keep moving per update
alvherre wrote:
>
> n_live_tup and n_dead_tup corresponds to the current numbers,
> whereas "last analysis tuples" are the values from back when the
> previous analyze ran. These counters keep moving per updates, deletes,
> inserts, they are not static.
>
>
OK. Do you know how can I get th
On Wed, May 19, 2010 at 8:57 PM, Joshua Tolley wrote:
> On Wed, May 19, 2010 at 1:46 PM, Hernan Danielan
> wrote:
>> Yes, the most interesting thing is that the log says
>> unexpected EOF on client connection or could not send data to client:
>> Broken pipe
>
> That log mostly just says somethin
On Wed, May 19, 2010 at 1:46 PM, Hernan Danielan
wrote:
> Yes, the most interesting thing is that the log says
> unexpected EOF on client connection or could not send data to client:
> Broken pipe
That log mostly just says something disconnected uncleanly, but
doesn't say PostgreSQL closed the c
Hello all,
I am programming in Windows environment. Previously, we are using MBCs
(http://msdn.microsoft.com/en-us/library/5z097dxa%28VS.71%29.aspx), in order to
support language other than English.
The following function still can be used, as long as we are setting the
database to correct enc
Excerpts from Gordon Shannon's message of mié may 19 18:02:51 -0400 2010:
> I'm sorry, I'm not following you. Are you saying that "last analysis
> tuples" is "number of dead + live tuples from the previous anlyze"? If so,
> that would really confuse me because X would always be 0:
>
> X = lt +
alvherre wrote:
>
> Excerpts from Gordon Shannon's message of mié may 19 11:49:45 -0400 2010:
>
>> at: last analysis tuples = pg_class.reltuples
>>
>> I'm the least confident about the last one -- tuples as of last analyze.
>> Can anyone confirm or correct these?
>
> In 8.4 it's number
On May 19, 2010, at 11:41 AM, Little, Douglas wrote:
> Hi,
>
> I have a fairly large data warehouse in Greenplum, and am having trouble
> tracking object changes.
> I need to
> 1.Know when an object was changed, by who.
> 2. Have some logging about when an object was dropped – e
On Wed, 2010-05-19 at 13:41 -0500, Little, Douglas wrote:
> Hi,
>
>
>
> I have a fairly large data warehouse in Greenplum, and am having
> trouble tracking object changes.
>
Depends on Greenplum I would assume. I don't know how compatible they
are with .Org anymore. You might look at table_
Yes, the most interesting thing is that the log says
unexpected EOF on client connection or could not send data to client:
Broken pipe
But this shouldn't be happening according to the code i sent because i do
NOT close the socket. Moreover the transaction only takes up a few seconds.
I read a p
Hi,
I have a fairly large data warehouse in Greenplum, and am having trouble
tracking object changes.
I need to
1.Know when an object was changed, by who.
2. Have some logging about when an object was dropped - especially drop
cascade.
Currently I'm having a problem with a set
On May 19, 2010, at 10:32 AM, Scot Kreienkamp wrote:
> Hi everyone,
>
> I have a column of type CIDR in a table that I am querying that contains
> the values of 10/8, 10.1/16,10.1.28/24, and 10.1.28.95. I am trying to
> return only the one record that's most specific compared to the IP
> addres
Hi everyone,
I have a column of type CIDR in a table that I am querying that contains
the values of 10/8, 10.1/16,10.1.28/24, and 10.1.28.95. I am trying to
return only the one record that's most specific compared to the IP
address I'm currently on as this is being done in a CGI script. If
there
Excerpts from Gordon Shannon's message of mié may 19 11:49:45 -0400 2010:
> at: last analysis tuples = pg_class.reltuples
>
> I'm the least confident about the last one -- tuples as of last analyze.
> Can anyone confirm or correct these?
In 8.4 it's number of dead + lives tuples that there
In an effort to fine-tune my table storage parameters so tables are analyzed
at the optimal time, I have written a query to show how soon my tables will
be auto-analyzed. But my results to not jive with what I see autovacuum
doing, i.e. there are tables that are millions of rows past the threshold
hi,
I would like to install postgresql into windows 7, but there is a dll to
add and I can't do this, there is an error; but I tried 2 methods:
1/ gacutil, this one : C:\Program Files (x86)\Microsoft
SDKs\Windows\v7.0A\Bin\x64, but I have this error :
Fa
Did anyone successfully integrate the TCL client library from
http://pgfoundry.org/projects/pgtcl/ ?
Even more helpful would be if someone did this on Solarix-x86, building
a 64-bit binaries.
Thanks,
Michael.
This email and any attachments are intended solely for the use of the
individu
From: BRUSSER Michael
Sent: Wednesday, May 19, 2010 10:06 AM
To: 'pgsql-general@postgresql.org'
Subject: TCL client interface
Did anyone successfully integrate the TCL client library from
http://pgfoundry.org/projects/pgtcl/ ?
Even more helpful would be if someone did this on Solarix-x
On Wed, May 19, 2010 at 1:38 AM, A. Kretschmer
wrote:
> In response to Guillaume Lelarge :
>> > This is the default behavior I want. However, I am not sure whether this
>> > is always guarantee? Or shall I explicitly make the query in the following
>> > form?
>>
>> An you're right. It's not guar
Ahhh.
boolean isAutoIncerment = rsMetaData.isAutoIncrement(1);
if int4 and autoIncremented = serial
Sorry!!
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Malm Paul
Sent: den 19 maj 2010 08:44
To: pgsql-general
In response to Guillaume Lelarge :
> > This is the default behavior I want. However, I am not sure whether this is
> > always guarantee? Or shall I explicitly make the query in the following
> > form?
>
> An you're right. It's not guaranted. The only guaranted way is to use
> ORDER BY your_colum
22 matches
Mail list logo
