Re: Migration from SQLServer

On Fri, 16 May 2003, Tapan Trivedi wrote:

> Thanks for the quick response.
>
> a. I have to put the table names in double quotes since postgreSQL
> throws out Relation ".." not found error. The only way I can access the
> tables are by including them in quotes and maintaining the case.
>
> b. Create script. Let me explain - I generated the script from MSSQL and
> it gave a whole lot of issues (for SQL statements and types) . When I
> resolved all of them, I encountered Relation ".." not found error. The
> only way I could resolve it was by giving the table names in quotes. I
> guess I should have converted all table names in lowercase and then all
> would be OK.
>
> What I am trying to find out now is - Is there anyway I can avoid
> dropping the database and recreating it ??

Sure, take a look at relname in pg_class and typname in pg_type. The other
columns in those table will help you decide who owns what and what schema
they're in so you can change only those ones you want to.

I don't think there's any more tables that hold the names but it's worth
checking. It'll be safer to reload your functions, views, tirggers? and
possibly rules having done this and amended them as appropiate.

>
> Nigel J. Andrews wrote:
>
> >On Fri, 16 May 2003, Tapan Trivedi wrote:
> >
> >>Hi All:
> >>
> >>I have just started my migration activity from MS SQLServer to postgreSQL.
> >>
> >>While the initial setup and tests are working, I had to put all my table names within quotations.
> >
> >You don't say _why_ you had to put all your table names in double quotes. I
> >presume it's because they are mixed or upper case.
> >
> >
> >
> >>Is there something I have missed in configuration or does postgreSQL work like this ?
> >
> >PostgreSQL folds identifiers to lower case, where other systems fold to upper,
> >unless they are enclosed in double quotes in which case case is preserved.
> >
> >>I have to go thru code now and make changes. (I might have to do that after all this if the data types are not matching - Over all not a great day since I found this out and LAL lost today
> >
> >If you had to quote your table names in your create scripts how come you're
> >having to also change the code to use quote marks? Surely you changed the
> >create scripts because the code was already using them.
> >

--
Nigel J. Andrews