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

Re: RE

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Reshat Sabiq <sabiq(at)purdue(dot)edu>
Cc: mperez(at)whgrp(dot)com, pgadmin-support(at)postgresql(dot)org
Subject: Re: RE
Date: 2003-11-10 09:04:40
Message-ID: 3FAF54A8.5030407@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-support
Reshat Sabiq wrote:

>
>
> 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?
>
No, this is a plain PostgreSQL SQL issue. Depending on the column types, 
you have to typecast explicitely, as the message suggests.

This is *not* the list for generic SQL questions, use pgsql-sql instead.

Regards,
Andreas



In response to

  • Re: RE at 2003-11-09 20:51:53 from Reshat Sabiq

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-11-10 09:09:25
Subject: Re: More on connetions to SSL enabled servers
Previous:From: Andreas PflugDate: 2003-11-10 08:56:31
Subject: Re: Large tables, copy-and-paste, default sql

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