[BUGS] BUG #4259: I don't understand this query

[kannan]

The following bug has been logged online:

Bug reference:  4259
Logged by:  kannan
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 2005
Operating system:   Windows 2003 Server
Description:I don't understand this query
Details: 

create table [dbo].[olapobjects] (
[id] [varchar] (36) collate 
sql_latin1_Genenral_Cp1_Ci_As not null,
[parent id] [varchar] (36) collate 
sql_latin1_genenral_cp1_ci_As not
null,
[objectname] [varchar] (150) collate 
sql_latin1_genenral_cp1_ci_As not
null,
[classtype] [int] not null,
[object definition] [ntext] collate 
sql_latin1_genenral_cp1_ci_As null,
[lastupdated] [datetime] null,
[changed] [bit] nill,
[version] [int] null
) on [primary] textimage_on [primary]

Go

create Table [dbo].[server] (
[objectdefinition] [ntext] collate 
sql_latin1_genenral_cp1_ci_As null,
) on [primary] textimage_on [primary]

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Upgrade to 7.1.2 problem

[Kannan The Barbarian]

hi

i recently upgraded to postgresql-7.1.2 but when i start the service, i get the 
folllowing error message!

An old version of the database format was found.\nYou need to upgrade the data format 
before using PostgreSQL.\nSee /
usr/share/doc/postgresql-7.1.2/README.rpm-dist for more information.

As far as i know the old databases have been upgraded! Whatsover, if there are any 
other databases in there and i dont want any of those older databases, what do i do!

thanks in advance


Get 250 color business cards for FREE!
http://businesscards.lycos.com/vp/fastpath/

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster