:03 AM
To: r...@iol.ie
Cc: Thom Brown; Carlos Mennens; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Adding a New Column Specifically In a Table
On 14 October 2010 12:07, Raymond O'Donnell wrote:
> Indeed - as others have said, depending on a specific column ordering in the
> data
On 10/14/2010 04:32 AM, Thom Brown wrote:
> On 13 October 2010 23:19, Raymond O'Donnell wrote:
>> On 13/10/2010 19:04, Carlos Mennens wrote:
>>>
>>> OK so I have read the docs and Google to try and find a way to add a
>>> new column to an existing table. My problem is I need this new column
>>>
On 14 October 2010 09:51, Rajesh Kumar Mallah wrote:
> Dear Carlos,
>
> In old version of postgresql attnum colmn of pg_catalog.pg_attribute
> system catalog
> could be modified to get desired results. I am not sure if it should
> be done anymore.
That will only make the column names swap round,
On 14 October 2010 12:07, Raymond O'Donnell wrote:
> Indeed - as others have said, depending on a specific column ordering in the
> database is asking for trouble.
Yes, it certainly is (in fact, 1NF says that there should be no order
to the columns), but it still annoys me that I cannot re-order
On 14/10/2010 11:32, Thom Brown wrote:
..and indexes, triggers, rules, views and every other dependency.
It's a potentially tricky solution to something which shouldn't really
be a problem.
Indeed - as others have said, depending on a specific column ordering in
the database is asking for tro
On 13 October 2010 23:19, Raymond O'Donnell wrote:
> On 13/10/2010 19:04, Carlos Mennens wrote:
>>
>> OK so I have read the docs and Google to try and find a way to add a
>> new column to an existing table. My problem is I need this new column
>> to be created 3rd rather than just dumping this ne
Or create view with your desired order on this table.
Regards,
Vijay
- Original Message -
From: Thomas Kellerer
Date: Thursday, October 14, 2010 3:09 pm
Subject: Re: [GENERAL] Adding a New Column Specifically In a Table
To: pgsql-general@postgresql.org
> Carlos Mennens, 13.10.2010 20
On 13/10/2010 19:04, Carlos Mennens wrote:
OK so I have read the docs and Google to try and find a way to add a
new column to an existing table. My problem is I need this new column
to be created 3rd rather than just dumping this new column to the end
of my table. I can't find anywhere how I can
On 13/10/2010 19:06, Carlos Mennens wrote:
On Wed, Oct 13, 2010 at 2:04 PM, Carlos Mennens
wrote:
OK so I have read the docs and Google to try and find a way to add a
new column to an existing table. My problem is I need this new column
to be created 3rd rather than just dumping this new colu
;select col1, col3, col5, col2, ...".
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Carlos Mennens
Sent: Wednesday, October 13, 2010 2:07 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Adding a New Col
Dear Carlos,
application code should not depend on column positions.
the requirement is not good.
regds
rajesh kumar mallah.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Dear Carlos,
In old version of postgresql attnum colmn of pg_catalog.pg_attribute
system catalog
could be modified to get desired results. I am not sure if it should
be done anymore.
Rajesh Kumar Mallah.
On Wed, Oct 13, 2010 at 2:06 PM, Carlos Mennens
wrote:
> On Wed, Oct 13, 2010 at 2:04 PM, C
Carlos Mennens, 13.10.2010 20:06:
OK so I have read the docs and Google to try and find a way to add a
new column to an existing table. My problem is I need this new column
to be created 3rd rather than just dumping this new column to the end
of my table. I can't find anywhere how I can insert m
On 13 October 2010 19:06, Carlos Mennens wrote:
> On Wed, Oct 13, 2010 at 2:04 PM, Carlos Mennens
> wrote:
>> OK so I have read the docs and Google to try and find a way to add a
>> new column to an existing table. My problem is I need this new column
>> to be created 3rd rather than just dumpin
Carlos Mennens wrote:
OK so I have read the docs and Google to try and find a way to add a
new column to an existing table. My problem is I need this new column
to be created 3rd rather than just dumping this new column to the end
of my table. I can't find anywhere how I can insert my new column
On 13 October 2010 19:04, Carlos Mennens wrote:
> OK so I have read the docs and Google to try and find a way to add a
> new column to an existing table. My problem is I need this new column
> to be created 3rd rather than just dumping this new column to the end
> of my table. I can't find anywhe
On Wed, Oct 13, 2010 at 2:04 PM, Carlos Mennens
wrote:
> OK so I have read the docs and Google to try and find a way to add a
> new column to an existing table. My problem is I need this new column
> to be created 3rd rather than just dumping this new column to the end
> of my table. I can't find
OK so I have read the docs and Google to try and find a way to add a
new column to an existing table. My problem is I need this new column
to be created 3rd rather than just dumping this new column to the end
of my table. I can't find anywhere how I can insert my new column as
the 3rd table column
18 matches
Mail list logo
