[HACKERS] UNSUBSCRIBE

UNSUBSCRIBE ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[HACKERS] Sorry/spam - how do you unsubscribe?

---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[HACKERS] Unsubscribe

---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] PostgreSQL and Windows2000 and defunct processes

t, mandrake, SuSe) and it works fine BUT Win is a much more used OS and one has to take that into account. More advice/help would be appreciated. Cheers, Steven. -- ******* Steven Vajdic (BSc/Hon, MSc) Senior Software Engineer Motorola Australia Softwa

[HACKERS] PostgreSQL and Windows2000 and defunct processes

Problem: Win2000 and Cygwin/postgresql-7.1 produce "defunct" processes after each run which can ONLY be killed by Win Task Manager. If you allow too many "defunct" processes your database requests slow down and your number of connections increases, i.e. if you have 32 connections specified in y

[HACKERS] PostgreSQL 7.1.3 installation on Windows platforms

Dear all, I am trying to install PostgreSQL 7.1.3 on Win98 with APACHEand PHP (both installed and running), andam getting errors with "make" and "make install" (see below). What are the differences in installations for Win98, WinNT and Win2000?There are so many procedures around and none is

Re: [HACKERS] [GENERAL] Postgres 7.1.3. installation on Windows platforms

input.o stringutils.o mainloop.o copy.o startup.o > >prompt.o variables.o large_obj.o > >print.o describe.o tab-complete.o -L../../../src/interfaces/libpq -lpq > >-L/usr/local/lib -g -lz -lcrypt -lreadline -lcygipc -o psql > > > >tab-complete.o(.text+0x2a36):tab-complete.c: undefined reference to > >`filename_completion_function' > > > >collect

[HACKERS] Postgres 7.1.3. installation on Windows platforms

r/src/postgresql-7.1.3/src/bin/psql' make[2]: *** [all] Error 2 make[2]: Leaving directory `/usr/src/postgresql-7.1.3/src/bin' make[1]: *** [all] Error 2 make[1]: Leaving directory `/usr/src/postgresql-7.1.3/src' make: *** [all] Error 2 --

[HACKERS] Integer to float function

integer n bytes long, in normal cases you probably > want to use int4(). > Einar, Much obliged. int4() has done a job. Why is that NOT documented under "Matematical functions"? Regards, Steven. -- ******* Steven Vajdic (BSc/Hon

[HACKERS] Is this a bug in 7.0.2

bles and "attr-xxx"s are SQL table attributes. The "integer(float_expression)" is more complicated then written above BUT it all DOES work in 6.5 and DOES NOT in 7.0.2. Any ideas, please? Much obliged, Steven. -- *** Steven Vajdic (B

[HACKERS] Migration - Linux/pgSQL/PHP (type,version)

objective" Pros/Cons for Linux type/version in terms of pgSQL use - my order of preferences Debian, Mandrake, Suse, RedHat. Much obliged, Steven. -- ***** Steven Vajdic (BSc/Hon, MSc) Senior S