Kevin Grittner wrote:
> *ukasz Brodziak wrote:
> > From: [email protected]
>
> >> Are you looking for statistics or the actual prior versions of
> >> rows?
>
> > I'm looking for actual versions of row data. What I want to
> > achieve as a final result is a kind of data change history.
Are you looking for statistics or the actual prior versions of
rows?
I'm looking for actual versions of row data. What I want to
achieve as a final result is a kind of data change history.
We just use ON DELETE rules on the tables where we want to maintain a history. In most
cases, we just co
*ukasz Brodziak wrote:
> I have a database from which I have to retrieve some history data
> for recovery purposes.
Ouch.
A quick search on pgfoundry shows a couple projects which might
help. (I've never used either of them.) Perhaps others will have
more ideas.
http://pgfoundry.org/proje
p.
Craig
> Date: Fri, 27 Aug 2010 10:04:39 -0700
> From: [email protected]
> To:
> Subject: Re: [ADMIN] Tuple changes from relfilenodes
>
> On 8/27/10 9:48 AM, ?ukasz Brodziak wrote:
> > I'm looking for actual versions of row data. What I want to ac
m; [email protected]
> Subject: Re: [ADMIN] Tuple changes from relfilenodes
>
> >> Are you looking for statistics or the actual prior versions of
> >> rows?
> >
> > I'm looking for actual versions of row data. What I want to
> > achieve as a final
Are you looking for statistics or the actual prior versions of
rows?
I'm looking for actual versions of row data. What I want to
achieve as a final result is a kind of data change history.
We just use ON DELETE rules on the tables where we want to maintain a history. In most
cases, we just co
What do You mean by history table? Creating such table is out of the question.
> Date: Fri, 27 Aug 2010 10:04:39 -0700
> From: [email protected]
> To:
> Subject: Re: [ADMIN] Tuple changes from relfilenodes
>
> On 8/27/10 9:48 AM, ?ukasz Brodziak wrote:
> >
[email protected]
> To: [email protected]; [email protected]
> Subject: Re: [ADMIN] Tuple changes from relfilenodes
> Are you looking for statistics or the actual prior versions of rows?
>
> -Kevin
>
> --
> Sent via pgsql-admin mailing list
*ukasz Brodziak wrote:
> From: [email protected]
>> Are you looking for statistics or the actual prior versions of
>> rows?
> I'm looking for actual versions of row data. What I want to
> achieve as a final result is a kind of data change history.
Well, unless you are suppressing th
I'm looking for actual versions of row data. What I want to achieve as a final
result is a kind of data change history.
> Date: Fri, 27 Aug 2010 08:25:26 -0500
> From: [email protected]
> To: [email protected]; [email protected]
> Subject: Re: [ADM
*ukasz Brodziak wrote:
> Just want to confirm something. I heard that data files containing
> tables also keep information on tuple(row) changes so is it true
> and if so how to get this data from the files?
Are you looking for statistics or the actual prior versions of rows?
-Kevin
--
Sent
Hello,
Just want to confirm something. I heard that data files containing tables also
keep information on tuple(row) changes so is it true and if so how to get this
data from the files?
Hello all,
I am running PostgreSQL-7.0.3. I changed the value of BLCKSZ (in
"include/config.h" to 16384, recompiled and reinstalled the sources. After
having restarted the backend I tried to create a table with three
varchar(5000)-columns and tried to add three character-values with each 4000
cha
Hi,
PostgreSQL has this limitation. The max row size is
8K.
You can recompile Postgres with max row size of 32K
(not more). This limitation is removed in PgSQL 7.1
which is not released yet. It's in beta phase.
regards,
Rumen
--- Bogdan Paduraru <[EMAIL PROTECTED]> wrote:
> Hello folks,
>
> I h
Hello folks,
I have a web-tool that inputs text in a Postgresql table. This text is
in a form.
The problem is when I have a big text, I get this error :
ERROR: Tuple is too big: size 13924, max size 8140
Can you help me?
Thanx,
Bogdan,
>
Hi,
Using phorum (www.phorum.org) based on PHP, I am getting the following error
when trying to insert a message in the PosgreSQL 6.5.3 database:
ProcessQuery
ERROR: Tuple is too big: size 12440
AbortCurrentTransaction
(obtained from the log). Can anybody tell me where to find proper
documenta
I am connecting to postgres 6.4.2 through microsoft access97 using an obdc
driver. I am converting some access files into postgres. I have a certain
field that contains NOTES (a text datatype), and some of them can contain
quite a bit of data! Well, as I am pulling the info into postgres, ce
17 matches
Mail list logo
