Re: [BUGS] BUG #5688: ALTER TABLE ALTER col TYPE newtype fails if col is named in an UPDATE OF col trigger

2010-10-01 Thread Tom Lane
"Daniel Grace" writes: > Description:ALTER TABLE ALTER col TYPE newtype fails if col is named > in an UPDATE OF col trigger Hmm, definitely a missed case (and defensive programming saves the day again). There are actually two cases as of 9.0 where a trigger could depend on a column:

[BUGS] BUG #5688: ALTER TABLE ALTER col TYPE newtype fails if col is named in an UPDATE OF col trigger

2010-10-01 Thread Daniel Grace
The following bug has been logged online: Bug reference: 5688 Logged by: Daniel Grace Email address: dgr...@wingsnw.com PostgreSQL version: 9.0.0 Operating system: Windows XP 32-bit Description:ALTER TABLE ALTER col TYPE newtype fails if col is named in an UPDATE OF c

Re: [BUGS] Facing problems with postgres 9.0.0

2010-10-01 Thread Kevin Grittner
Sekhar chakka wrote: > We have installed Postgres 9.0.0 on ubuntu 10.04 LTS 64 bit > machine. It was working untill you restart the server. Once the > server is rebooted the database is not starting Is there a service configured to start on reboot which runs it? > "psql: could not connect to

[BUGS] Facing problems with postgres 9.0.0

2010-10-01 Thread Sekhar chakka
Hi, We have installed Postgres 9.0.0 on ubuntu 10.04 LTS 64 bit machine. It was working untill you restart the server. Once the server is rebooted the database is not starting and we are getting this error mention below, "psql: could not connect to server: No such file or directory Is the se

Re: [BUGS] BUG #5685: Installer Error

2010-10-01 Thread Dave Page
On Fri, Oct 1, 2010 at 4:21 AM, Craig Ringer wrote: > On 10/01/2010 05:01 AM, quiksilver5...@hotmail.com wrote: >>  > regsvr32 %systemroot%\system32\vbscript.dll >>  > >>  > You should see a messagebox which says something like: >>  > >>  > DllRegisterServer in vbscript.dll succeeded. >> >> >> Tha