[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

[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

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 2004, Ivan Dimitrov

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 take

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] 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

[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

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

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

[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