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
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,
.
Hi,
I want to extract images from a database.
I am currently trying to use the following script
The point is if I get more than 1 image returned, how can I write it to
different output files.
As you can see, I've tried using '$dbh->func'
use DBI;
$dbh = DBI->connect("dbi:Pg:dbname=luke") or die
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,
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? W
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 hav
http://php.net/pg_getlastoid
This is the *ONLY* time you should actually use OIDs -- To get the unique
value you just inserted.
--
WARNING [EMAIL PROTECTED] address is an endangered species -- Use
[EMAIL PROTECTED]
Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm
Volunteer
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
Hi,
If this was better posed in a different postgres group, please let me
know.
I'm having problems when running pg_dumpall from a perl script.
Here's the line that's executing the backup.
`pg_dumpall -o |bzip2 -z -c > $os_bkup_loc/byt_pgdump_full.bz2` or warn
"Error while running probably
Hello,
I have a table "refers_to"
individual_id int4
book_id int4
and another "individual"
individual_id int4 nextval('individual_serial')
name varchar
forename varchar
If the individual exists then get his id. If he doesn't allready exist
write his names to the table and get the newly create
On Wed, 10 Oct 2001, Ian Barwick wrote:
> I'm doing some work for a smallish company which conducts
> its business largely online. Currently they have a legacy
> mishmash of Oracle and MySQL databases which they wish
> to unify one one platform (RDBMS with client access via
> browser and custom s
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
I'm Having a hard time with this statement:
Select Jobs.*, ProjectedDates.* FROM Jobs, ProjectedDates WHERE (Plotted =
False) And (JobName = 'Boulder Valley') AND (BuilderName = 'Elliott Homes')
AND (Jobs.JobID = ProjectedDates.JobID)
Can anyone see why? the record and field names certainly do e
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 connecti
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 comma
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,
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
> >> 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.:
> >>
> >>
>
>http://groups.google.com/groups?q=vacuum&hl=en&group=comp.databases.postgresql.hackers&rnum=1&sel
> >> 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.:
> >>
> >>
>
>http://groups.google.com/groups?q=vacuum&hl=en&group=comp.databases.postgresql.hackers&rnum=1&sel
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
20 matches
Mail list logo
