[ADMIN] import limited to 1000 tuples

I am migrating data from msaccess. Using msaccess own export function I was able to export to an odbc data source -- I chose the postgres odbc source. The export went fine except it only save 1000 tupples from the access data source. These are not real big tables, but they do have almost 2000 tuppl

[ADMIN] New Virus

Hello All, I have already seen this virus at a client's. Please pay VERY close attention to the characteristics of the email that you are reading. Do NOT click on a link unless you know, EXACTLY to what the link connects. Please read the attached article. If you have any questions please feel

Re: [ADMIN] [SQL] upper/lower for german characters

Hi, Andrei, On Tue, 9 Nov 2004 16:58:27 +0200 "Andrei Bintintan" <[EMAIL PROTECTED]> wrote: > Hi to all, I have the problem that: > select lower('MöBÜEL') or select upper('MöBÜEL') are not working well. > > I read on some forums that there is some locale setting that needs to > be done here, bu

Re: [ADMIN] server crash

"Medora Schauer" <[EMAIL PROTECTED]> writes: > PG: 7.3 I hope you meant "7.3.8", or at least something later than original 7.3 ;-) > PANIC: link from /data/database/pg_xlog/000100D9 to > /data/database/pg_xlog/000100E1 (initialization of log file 1, > segment 225) failed: No su

[ADMIN] server crash

OS: linux 2.4.18 h/w: moto 5100 SBC PG: 7.3   We have a recurring problem with the pg server crashing.  It doesn’t happen often (once every couple of months or so) but we require 24/7 up time.  Attached is the  pg.log from the last time it crashed.  The stuff towards the end seems to in

Re: [ADMIN] Where is postgresql??

Geoffrey escribió: Francisco Jose Bernabe Pellicer wrote: Hello everybody, I have a computer with Scientific Linux. From a repository I downloaded the packages rh-postgresql-* with the command apt-get install... The thing is that after installing all the packages, I cannot enable postgresql, be

[ADMIN] upper/lower for german characters

Hi to all, I have the problem that: select lower('MöBÜEL') or select upper('MöBÜEL') are not working well. I read on some forums that there is some locale setting that needs to be done here, but could not fix this. I am using the ASCII encoding.   Please advice. Thakx.Andy.

Re: [ADMIN] [PERFORM] poor performance in migrated database

Dear Tom, thanks for your information. Where can I learn more about the explain and analyze?? One view that is giving a lot of problems is vkardex_3 which is used most of the time... The explain analyze I sent is one of the views that conform this one. Thanks in advance. Carlos Lopez Linares ---

Re: [ADMIN] Replication Options.

Chris Browne wrote: [EMAIL PROTECTED] (Pallav Kalva) writes: I need to implement the following the replication scenario in postgres database. Here are the details of what we are looking to implement. Lets say I have 2 nodes Node1(US) and Node2(Canada), Node1: tableA , tableB Node2: tableB , t

Re: [ADMIN] Where is postgresql??

Francisco Jose Bernabe Pellicer wrote: Hello everybody, I have a computer with Scientific Linux. From a repository I downloaded the packages rh-postgresql-* with the command apt-get install... The thing is that after installing all the packages, I cannot enable postgresql, because there's no /e

[ADMIN] Where is postgresql??

Hello everybody, I have a computer with Scientific Linux. From a repository I downloaded the packages rh-postgresql-* with the command apt-get install... The thing is that after installing all the packages, I cannot enable postgresql, because there's no /etc/init.d/postgresql file (even not /e