[ADMIN] request for feature - mixed case name handling

2004-11-10 Thread Ben Kim
I guess this may or may not belong here, but may I ask people's opinion on requesting an improvement. I have a database with mixed case table names (like "MixedCaseTable") and column names (like "MixedCaseColumn"). I have many tables so would like to use descriptive names, so chose to use mixed

Re: [ADMIN] nscd [was] how do you run postgres without dns server

2004-11-10 Thread S. C.
Do you got "hosts: files dns" in your nsswitch.conf? Otherwise , /etc/hosts won't be used. - # /etc/nsswitch.conf # # Example configuration of GNU Name Service Switch functionality. # If you have the `glibc-doc' and `info' packages i

Re: [ADMIN] Bad Timestamp Error with COPY

2004-11-10 Thread Stephan Szabo
On Wed, 10 Nov 2004, Sharon Schooley wrote: > I am new to Postgresql. I'm trying to load tables from SQLServer bcp > export, comma delimited. I'm loading datetime datatype into timestamp. > I've loaded one table successfully and failed on others with the same > error: > Bad timestamp external rep

[ADMIN] Bad Timestamp Error with COPY

2004-11-10 Thread Sharon Schooley
I am new to Postgresql. I'm trying to load tables from SQLServer bcp export, comma delimited.  I'm loading datetime datatype into timestamp. I've loaded one table successfully and failed on others with the same error: Bad timestamp external representation ''.   The table that loaded successf

Re: [ADMIN] nscd [was] how do you run postgres without dns server

2004-11-10 Thread Ivan Dimitrov
Yes that is true too. I've checked it all. It apears that postgres tries to resolve only through dns'...:( I think that the problem is in the postgresql, but I can't reproduce the problem anymore, because I was forced to install a caching dns server, and I'm not allowed to play with it anymore

Re: [ADMIN] how do you run postgres without dns server

2004-11-10 Thread Oliver Elphick
On Wed, 2004-11-10 at 12:15 +0200, Ivan Dimitrov wrote: > Yes, it is there > 127.0.0.1localhost > but when i strace postmaster on startup it never looks in /etc/hosts Look at the "hosts:" line in /etc/nsswitch.conf. It needs to have the word "files" in there. -- Oliver Elphick

Re: [ADMIN] These Lists Are Being Cut To FOUR

2004-11-10 Thread Oliver Elphick
On Wed, 2004-11-10 at 07:59 +, Mike Cox wrote: > Hello. My name is Mike Cox. I think this offensive mail was forged; please do not attribute it to the real Mike Cox unless he affirms it. Here is the first Received header at svr1.postgresql.org; and note the message id also contains the string

Re: [ADMIN] These Lists Are Being Cut To FOUR

2004-11-10 Thread Sander Steffann
Hi, > Hello. My name is Mike Cox. I am in charge of the changing of these > postgresql lists. I have decided that we are going to drop most of the > lists from the vote. We will only be making 4 lists into real Usenet > newsgroups if we win the election. The rest of the lists are crap and > they t

Re: [ADMIN] how do you run postgres without dns server

2004-11-10 Thread Ivan Dimitrov
Yes, it is there 127.0.0.1localhost but when i strace postmaster on startup it never looks in /etc/hosts На 10.11.2004 12:05 вие написахте: > localhost should be defined in your hosts file, which in most unixoid > environments is /etc/hosts. It is not an error. > > Hal > > On Wed, 10 Nov

Re: [ADMIN] how do you run postgres without dns server

2004-11-10 Thread Halford Dace
localhost should be defined in your hosts file, which in most unixoid environments is /etc/hosts. It is not an error. Hal On Wed, 10 Nov 2004, Ivan Dimitrov wrote: > I have a database on a machine that does not know what localhost is. Yes, I > have 127.0.0.1, but I can't resolve localhost to i

[ADMIN] how do you run postgres without dns server

2004-11-10 Thread Ivan Dimitrov
I have a database on a machine that does not know what localhost is. Yes, I have 127.0.0.1, but I can't resolve localhost to it. I don't want to start a caching dns, and don't want to change resolve.conf. Upon starting, postgres gives error cannot bind to localhost. then starts accepting connect

[ADMIN] How to support German, French and other characters.

2004-11-10 Thread Andrei Bintintan
  Hi to all,   We are using pgsql as a "multilanguage" database. But I noticed yesterday a strange problem with the german umlaut characters. I cannot convert the in upper case in lowercase. Probably there are also other bad functionalities.   Now. I searched the internet for answers but th

[ADMIN] These Lists Are Being Cut To FOUR

2004-11-10 Thread Mike Cox
Hello. My name is Mike Cox. I am in charge of the changing of these postgresql lists. I have decided that we are going to drop most of the lists from the vote. We will only be making 4 lists into real Usenet newsgroups if we win the election. The rest of the lists are crap and they take up too much