[GENERAL] lo_commands and SU privs

2001-10-15 Thread Bell John
Under PostgreSQL 7.1.3 (RH Linux 7.1 platform) I get the following whenever trying to manipulate large objects either from psql or sql oriented API's (eg. PoPy, psycopg, pypgsql (DPAPI kit)): You must have Postgres superuser privilege to use server-side lo_import. Anyone can use the client-side

Re: [GENERAL] VACUUM, 24/7 availability and 7.2

2001-10-15 Thread Denis Gasparin
More importantly, what is the situation on VACUUM for release 7.2? It seems from the pgsql-hackers list that there are plans for a none-exclusively locking VACUUM, e.g.:

Re: [GENERAL] VACUUM, 24/7 availability and 7.2

2001-10-15 Thread Denis Gasparin
More importantly, what is the situation on VACUUM for release 7.2? It seems from the pgsql-hackers list that there are plans for a none-exclusively locking VACUUM, e.g.:

[GENERAL] how to use cursors in plpgsql (7.2)???

2001-10-15 Thread hubert depesz lubaczewski
hi can anybody post a short example on how to use cursors (cursor-returning functions to be exact) from postgresl 7.2? depesz -- hubert depesz lubaczewski http://www.depesz.pl/ ... vows are spoken

[GENERAL] Problem in installing Postgresql-7.1.2

2001-10-15 Thread Thirumoorthy Bhuvneswari
Hi, I am new to this mailing-list. I am having Postgresql-7.0.2 installed on RedHat Linux-6.2. I wanted to install Postgresql-7.1.2, since it supports RedHat Linux6.2 and downloaded the rpms. While installing, it ended up with the following error: Failed dependencies: libpg.so.2, libcrypto.so.0,

[GENERAL] lztext

2001-10-15 Thread t . ngockhoi
Il like lztext because it make a fast database with some big text fields. I d'ont know why it removed in lastest release ?. Any body can help me tu get and use it ? Ngoc-Khoi TO. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [GENERAL] Any Good Way To Do Sync DB's?

2001-10-15 Thread Joseph Koenig
Your solution sounds very interesting (Not the throw away NT part...)...does anyone else have any input on this? Would it work well? Any idea as to what amount of traffic it would be capable of handling? If apache is only running in two instances, would that really keep the number of ODBC

[GENERAL] writing flushing C extensions

2001-10-15 Thread John P. Looney
I'm trying to write a few functions in C for postgres. But, when I change some code, I'm never sure that it'll be flushed when I do a; DROP FUNCTION test(); CREATE FUNCTION test() RETURNS text AS '/var/lib/pgsql/functions/test.so' LANGUAGE 'c'; Is there a way to make sure ? Even restarting

Re: [GENERAL] Newbie

2001-10-15 Thread Henshall, Stuart - WCP
Did you use speech marks around the column names when creating the tables? If so that makes them case sensitive and you'll always need them (unless there all lower case) - Stuart -Original Message- From: William Winter [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 12, 2001 4:29 AM

Re: [GENERAL] PG mailing list problems (was Re: Support issues)

2001-10-15 Thread Culley Harrelson
I have the exact opposite problem-- I keep turning off direct mailing for pgsql-general (with successfull confirmation) and it keeps sending me mail anyway! haha culley --- David Link [EMAIL PROTECTED] wrote: Jim Caley wrote: Has anyone heard any more about this problem? I also haven't

Re: [GENERAL] Any Good Way To Do Sync DB's?

2001-10-15 Thread Gordan Bobic
On Monday 15 Oct 2001 13:35, Joseph Koenig wrote: Your solution sounds very interesting (Not the throw away NT part...) That is where a signifficant part of the performance improvement would come from, if performance was what you were after... ...does anyone else have any input on this?

Re: [GENERAL] Embedded postgres ?

2001-10-15 Thread Henning Follmann
On Wed, 10 Oct 2001 14:18:41 + (UTC), John P. Looney [EMAIL PROTECTED] wrote: How well is postgres suited for small applications ? I don't know it's architecture too well, though even with a very small database, it seems to use a huge number of files, which are all quite large, for

[GENERAL] SSL

2001-10-15 Thread Jelle Ouwerkerk
Question: If the postmaster has been enabled to support TCP/IP connections using SSL, how do I need to modify my postgreSQL client app in order to conduct an encrypted conversation? Currently, my app uses the postgreSQL C API (libpq). Is the SSL functionality already supported in libpq? Thanks,

Re: [GENERAL] VACUUM, 24/7 availability and 7.2

2001-10-15 Thread tek1
where in the postgres dox can we find info abt the vacuum feature? thx... ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org