On Mar 31, 2009, at 6:41 PM, Harald Fuchs wrote:
In article <437faa9f-df2d-429e-9856-eb2026b55...@solfertje.student.utwente.nl
>,
Alban Hertroys writes:
You could add the columns you're sure that you need and put the rest
in an XML field.
If you have a problem and want to solve it using X
In article <437faa9f-df2d-429e-9856-eb2026b55...@solfertje.student.utwente.nl>,
Alban Hertroys writes:
> On Mar 30, 2009, at 5:39 PM, A B wrote:
>> Hi,
>> In the next project I'm going to have a number of colums in my tables,
>> but I don't know how many, they change. They all use integers as
>>
On Mar 30, 2009, at 5:39 PM, A B wrote:
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change. They all use integers as
datatype though.. One day, I get 2 new columns, a week later I loose
one column, and so on in a random pattern.
I
suggested?
-Will
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of A B
Sent: 30 March 2009 14:51
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] [GENEAL] dynamically changing table
Well, the requirement is: keep a lot of
On Mon, Mar 30, 2009 at 08:50:59PM +0200, A B wrote:
> Well, the requirement is: keep a lot of data stored, don't loose any
> of it, and you will not know what you will have to store (changing
> number of fields and of different types)
As you've not said anything about getting said data back; it d
2009/3/31 A B :
> One option is, put it in a db as a huge text (or in textfiles, one
> per object) and parse it when you need it. That might also work.
>
> Why are you demanding sanity? I need crazy ideas to get this to work ;-)
Heh ... sorry, but "dynamic table" just SCREAMS "design flaw!!" ...
On Mon, Mar 30, 2009 at 11:04:06AM -0700, David Fetter wrote:
> On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
> > Hi,
> > In the next project I'm going to have a number of colums in my tables,
> > but I don't know how many, they change.
>
> Stop right there. You need to get some sanity int
2009/3/30 David Fetter :
> On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
>> Hi,
>> In the next project I'm going to have a number of colums in my tables,
>> but I don't know how many, they change.
>
> Stop right there. You need to get some sanity into your project,
> either by changing that
From: michaelblack75...@hotmail.com
To: gentosa...@gmail.com
Subject: RE: [GENERAL] [GENEAL] dynamically changing table
Date: Mon, 30 Mar 2009 16:05:52 +
The simplest way is to plan for the maximum number of columns that will be
required (say 14 - 2 weeks of data assuming that is
On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
> Hi,
> In the next project I'm going to have a number of colums in my tables,
> but I don't know how many, they change.
Stop right there. You need to get some sanity into your project,
either by changing that requirement, or by not using an RD
> Well, not as such. Except that deleting a column doesn't really delete
> it, it hides it, so it never really goes away. So the number of
> "columns" in your table will only go up and eventually you're going to
> reach the point (around 1600 IIRC, probably earlier) where it will
> simply stop work
On Mon, Mar 30, 2009 at 05:39:19PM +0200, A B wrote:
> Hi,
> In the next project I'm going to have a number of colums in my tables,
> but I don't know how many, they change. They all use integers as
> datatype though.. One day, I get 2 new columns, a week later I loose
> one column, and so on in a
IMHO one of the possible solutions is to review the table and storage
externaly the
stable columns. So when you run 'alter table ' it was less
expensive (i never
test this, but maybe its true :P )
So the mutable columns will be separated from the others and the
phisical structure
could be more
Without knowing to much currently..
can you create one table with enough columns?
Then create a view to query the table and 'reflect' the changes and
correct column names.
Using rule you could also even simulate the update to the view and
update to the correct columns.
This so that you don't
Hi,
In the next project I'm going to have a number of colums in my tables,
but I don't know how many, they change. They all use integers as
datatype though.. One day, I get 2 new columns, a week later I loose
one column, and so on in a random pattern.
I will most likely have a few million rows of
15 matches
Mail list logo
