From: | 100(dot)179370(at)germanynet(dot)de (Martin Jacobs) |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Cc: | Pruner Jan <pruner(at)cekia(dot)cz> |
Subject: | RE: Re: Replace MSSQL by PostgreSQL ? |
Date: | 2001-06-16 20:09:06 |
Message-ID: | Pine.LNX.4.33.0106162203260.3356-100000@Schnecke.Windsbach.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 28 May 2001, Pruner Jan wrote:
> Hi, Pieter,
> there is no problem with ODBC, but
> you have to move your database architecture to PostgreSQL.
> There are some problems with the the lack of SQL compatibleness between MS &
> PG (of course - no standard).
>
> MS use getdate() to get current_timestamp etc.
>
> I stopped porting because I have table 'name' on MS, but on PG is it
> impossible.
Hi,
The reason is PG's built in data type 'name'. As your
databases superuser you may drop this data type, then you can
create tables named 'name' :-)
If you don't need type 'name' do
DROP TYPE name;
Then you can do
CREATE table name (...);
> ...
--
Dipl-Ing. Martin Jacobs * Windsbach * Germany
Registered Linux User #87175, http://counter.li.org/
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Jacobs | 2001-06-16 20:33:50 | Re: Changing path to /tmp/.s.PGSQL.5432 file and the .lock file |
Previous Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2001-06-16 18:49:27 | Re: Unable to --rebuild postgresql-7.1.2-4PGDG.src.rpm |