Re: [GENERAL] postgresql and web application

2000-03-24 Thread Oleg Broytmann
L PROTECTED] The list is not very active, and I'd be glad inviting more contributors :) Oleg. Oleg Broytmannhttp://members.xoom.com/phd2.1/[EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

Re: [GENERAL] locale & mb support

2000-03-07 Thread Oleg Broytmann
define it before invoking psql or other client (similar to what you'll find in locale tests)... Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

Re: [GENERAL] order by

2000-03-01 Thread Oleg Broytmann
recompile Postgres with locale support, and run it with correct locale settings. Look more docs on locale support in Postgres sourses and documentation. Oleg. ---- Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

[GENERAL] Re: [HACKERS] Poll: Databases for Linux

2000-03-01 Thread Oleg Broytmann
roaches and solutions - and I am satisfied with both DBs. There are niches for both of them. Finally I voted for Postgres - just because MySQL already has its votes :) Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

[GENERAL] Re: [HACKERS] New Search Engine ... UdmSearch

2000-01-06 Thread Oleg Broytmann
were down and you couldn't search anything... You are certailnly wrong, as htDig has a concept of "work files" (option -a). Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

Re: [GENERAL] Trouble with Innstalling PostGreSQL 6.5.2 on Win NT

1999-10-01 Thread Oleg Broytmann
jects. To speed things up some internal parts had been rewritten in C, but I don't know how this work on NT (on UNIX it is pretty good). http://www.chordate.com/gadfly.html > > jeff Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] P

Re: [GENERAL] Does Apache has PostgreSQL module?

1999-07-08 Thread Oleg Broytmann
On Thu, 8 Jul 1999, Albert Chen wrote: > I know there is a ApacheMysql module. Has ApachePostgres module? Do you mean postgres authentication module? It is called mod_auth_pgsql, and you can hunt for this on http://modules.apache.org. Works pretty fine for me. > -Albert Oleg.

Re: [GENERAL] Compiling libpq

1999-06-08 Thread Oleg Broytmann
add some libs (-lcrypt, e.g.)... > Fabian. Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

RE: [GENERAL] Optimal indicies

1999-04-21 Thread Oleg Broytmann
re clauses on that table. Should these indicies be created as compound index (CREATE INDEX myindex ON TABLE mytable (field1, field2)) or separated ( CREATE INDEX myindex1 ON TABLE mytable (field1) CREATE INDEX myindex2 ON TABLE mytable (field2) ) ? > -DEJ Oleg. ---- Ol

Re: [GENERAL] Case insensitive searches?

1999-04-12 Thread Oleg Broytmann
> head with it. Make all things lowercase: SELECT * FROM mytable WHERE lower(mycolumn) = 'mylowercasedata' For regexp searching use ~* (case insensitive regexp). > Mike. > > Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTE

Re: [GENERAL] dbase converter

1999-04-08 Thread Oleg Broytmann
field-name. (Only for dbf2msql, Postgres95 doesn't have a primary key) > > which of course PostgreSQL does. Anyone know of something more recent? I heared about some project called "xbase". Try to search FreshMeat for "xbase", "dbf postgres" or s

Re: [GENERAL] libpq linking problem

1999-04-02 Thread Oleg Broytmann
gmake: *** [test] Error 1 > bash$ > > What library am I missing? > It looks like a system library with the tcpip functions. > I ran 'configure' and recompiled libpq.a You haven't mention your OS, is it Solaris? -lsocket -lnsl (these are socket and name services)

Re: [GENERAL] Re: [SQL] sql 92 support in postgres

1999-03-26 Thread Oleg Broytmann
formation Technology Institute > Rice University, 6100 S. Main St., Houston, TX 77005 Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

[GENERAL] 8000 photos in a database

1999-03-25 Thread Oleg Broytmann
Hi! http://oslo.clickwalk.no/ http://lwn.net/1999/0325/a/clickwalk.html 8000 photos in PostgreSQL database. RedHat linux, Apache httpd, Java serlets. Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they

Re: [GENERAL] COPY with default values won't work?

1999-03-24 Thread Oleg Broytmann
ixed this in 6.5-beta a month ago. > Vadim > Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

Re: [GENERAL] Postgress case insensitive search on FreeBSD3.0

1999-03-09 Thread Oleg Broytmann
er settings were the same > as for FreeBSD. > > Can anybody clarify this situation ? > > Thanks in advance, and sorry for bad english. > > Vadim Valiakhmetov mailto:[EMAIL PROTECTED] > Sysadmin, SibLine Co. > > > Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

Re: [GENERAL] Problems compiling

1999-02-12 Thread Oleg Broytmann
oject I am working on and I cannot graduate if I dont get it done!:) ./configure --without-CXX This disables C++ completely, so you couldn't use libpq++. Oleg. ---- Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

Re: [GENERAL] New Software Database is Live ...

1999-02-09 Thread Oleg Broytmann
age"? Oleg. Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

[GENERAL] Z Object Publisher got Postgres adapter

1999-01-10 Thread Oleg Broytmann
o it a bit later... Oleg. ---- Oleg Broytmann http://members.tripod.com/~phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.

Re: [GENERAL] date_part bug?

1998-12-18 Thread Oleg Broytmann
ybody seen this before? I tried this and it works pretty good for me on Solaris. It looks like an error in postgres on glibc2-based linux platform. It is discussing now on pgsql-hackers list. The solution is not ready yet. I am working on this with a good deal of help from ot

[GENERAL] Re: permissions ..

1998-05-21 Thread Oleg Broytmann
lay with REVOKE, though... Oleg. Oleg Broytmann http://members.tripod.com/~phd2/ [EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN.