Skip site navigation (1) Skip section navigation (2)

Re: RE

From: Reshat Sabiq <sabiq(at)purdue(dot)edu>
To: mperez(at)whgrp(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: RE
Date: 2003-11-09 20:51:53
Message-ID: 3FAEA8E9.9050302@purdue.edu (view raw or flat)
Thread:
Lists: pgadmin-support

Mark Perez wrote:

>Can someone help me? I have a large database that I have been working on in MS Access and then placed it on a Red Hat Server. It works awesome with PGAdmin and PostgreSQL. I then needed to take the code and database both an Access based import and a pgdump. When I installed the beta version, I restored the dump and all the tables appeard and they were empty. All the data was gone. So, I then imported the tables one by one, having a total of 275 tables. After importing using the Wizard, I then tried to perform SQL's, however, I had NO data listed in any of the Sequels, unless I did a SELECT * FROM [table_name], etc. All the data was there with that. But for complex issues such as CASE WHEN's and =, +, >, <, etc. No data would result from them and was told that I would have to name "explicit typecasts. I am trying to find out why, but most importantly, HOW I can proceed. I, then, went one step forward and purchased the box set of Red Hat 7.1 and after installation of the Operat
> ing System, I still cannot get it to work. Unfortunatey, Linux is so cumbersome that I just gave up. Is there anyone out there who knows how I can get around this? Becasue, I am now returning my Linux and reinstalling my Windows 2000 Server, which I should have never given up in the first place. I LOVE PostgreSQL and the performance is exceptional and this I do not want to change, but just wish that it was more of a Windows based Database Server, rather than Linux. Thank you all and if there is any advise you can give me, please do.
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>               http://www.postgresql.org/docs/faqs/FAQ.html
>
>  
>
Could that be an encoding issue?

-- 
Sincerely,
Reshat.

-------------------------------------------------------------------------------------------
If you see my certificate with this message, you should be able to send me encrypted e-mail. 
Please consult your e-mail client for details if you would like to do that.

In response to

  • RE at 2003-11-09 19:08:29 from Mark Perez

Responses

  • Re: RE at 2003-11-10 09:04:40 from Andreas Pflug

pgadmin-support by date

Next:From: Dave PageDate: 2003-11-10 08:44:33
Subject: Re: Large tables, copy-and-paste, default sql
Previous:From: Mark PerezDate: 2003-11-09 19:08:29
Subject: RE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group