BUG #4259: I don't understand this query

From: "kannan" <kannan_siva70(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4259: I don't understand this query
Date: 2008-06-23 05:07:27
Message-ID: 200806230507.m5N57Rth013499@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 4259
Logged by: kannan
Email address: kannan_siva70(at)yahoo(dot)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]

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2008-06-23 08:27:15 Re: BUG #4259: I don't understand this query
Previous Message Bill Thoen 2008-06-22 23:39:38 Re: Abnormal termination of PostgreSQL