Sunday, June 22, 2008

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

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]

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

No comments: