BUG #4259: I don't understand this query - Mailing list pgsql-bugs

From kannan
Subject BUG #4259: I don't understand this query
Date
Msg-id 200806230507.m5N57Rth013499@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4259: I don't understand this query  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4259
Logged by:          kannan
Email address:      kannan_siva70@yahoo.com
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]

pgsql-bugs by date:

Previous
From: Bill Thoen
Date:
Subject: Re: Abnormal termination of PostgreSQL
Next
From: Craig Ringer
Date:
Subject: Re: BUG #4259: I don't understand this query