From: Josh Berkus <josh@agliodbs.com>
To: plist@horistjr.com
To: pgsql-sql@postgresql.org
Subject: Re: SQL Statements question, why I get errors...
Date: Sun, 23 Feb 2003 14:57:47 -0800
Message-ID: <200302231457.47596.josh@agliodbs.com> (raw)
In-Reply-To: <1519.192.168.100.1.1046038673.squirrel@mail.horistjr.com>
References: <1519.192.168.100.1.1046038673.squirrel@mail.horistjr.com>
"Plist,"
> I work a software company and our software is run on databases.. We have
> no problem using MS SQL, DB2, ect... One of my customers wanted to try
> and use POSTGRESQL.. He tried it and is having problems, so I downloaded
> it and am running it on my Red Hat 7.3 box.. I am running version 7.3.2
> of Postgresql.. I hope this is the right place to ask this.. When we
> first launch our program we create several tables... Here is an example
> of one table we create:
You're in for a long, painful process if you think you can port a production
application to PostgreSQL (or between *any* two database platforms) without
an expert DBA. Perhaps you should consider a consultant?
> create table test (f1 int, f2 char(30), f3 char(30), f4 char(30))
> create unique index itest on test (f1 asc)
Some databases (MSSQL) require seperate indexes for ascending (ASC) and
descending (DESC) sorts. Postgresql does not; since 7.2.0, we have been able
to use the same index for both types of sorts. As such, Postgresql does not
support the "ASC" syntax in index creation. Simply change your statement to:
create unique index itest on test (f1);
... and it will work.
--
Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, plist@horistjr.com
Subject: Re: SQL Statements question, why I get errors...
In-Reply-To: <200302231457.47596.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox