Emi Lu wrote:
PostgreSQL 8.0.15.
Is there a way that I can easily alter column type from varchar(32) to
varchar(255) but do not have to worry about views dependent on it?
You should test it carefully and it is considered a bad practice -
I'll probably get sued for recommending this :-), but yo
I wonder if this works:
update stock s set s_superceded = true
where s.s_updated < (select max(t.s_updated) from stock t where t.s_vin =
s.s_vin)
On Thu, May 14, 2009 at 7:27 AM, Gary Stainburn <
gary.stainb...@ringways.co.uk> wrote:
> I know I should be able to do this but my brain's mashed
I know I should be able to do this but my brain's mashed today
I have a stock table with
s_stock_no varchar primary key
s_vin varchar
s_updated timestamp
s_supercededboolean
It is possible for the same vin to exist on stock if we have s
Good morning,
Can pg_dump or other command could dump all views definition in one schema.
I was trying to alter column types for several tables, and I have very
complicated view dependencies.
What I try to do is:
(1). Back all views def
(2). alter columns
(3). re-create views from (1)
I'd li
