Larry Rosenman [EMAIL PROTECTED] writes:
I noticed today that pg_dumpall from current CVS does *NOT*
dump a password assiged to the postgres user.
I consider this BAD, since if one has to restore from
a pg_dumpall, one may forget to reset the password.
I'm unconvinced. The pg_dumpall
Larry Rosenman [EMAIL PROTECTED] writes:
The planregress.sh tests generate errors. Attached is a tar of the
planregress directory...
Have you examined the diffs to see whether any represent real problems,
as opposed to trivial changes in output tuple order?
regards,
No I hadn't.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972 414 9812 (voice) Internet: [EMAIL PROTECTED]
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Monday,
From: Horst Herb [EMAIL PROTECTED]
Date: Mon, 1 Jan 2001 10:09:52 +1100
create table a (
id serial primary key,
something text
);
create table b (
morething text
) inherits (a);
create table c (
trouble int references b;
);
NOTICE: CREATE TABLE
* Tom Lane [EMAIL PROTECTED] [010101 13:16]:
Larry Rosenman [EMAIL PROTECTED] writes:
I noticed today that pg_dumpall from current CVS does *NOT*
dump a password assiged to the postgres user.
I consider this BAD, since if one has to restore from
a pg_dumpall, one may forget to reset
I do not believe that. In fact, I'll go further and say "Horsepucky!"
The GPL applies to works that "contain or are derived from" a GPL'd
program. Linking to a separately distributed library does not cause
psql either to contain or to be derived from libreadline.
Some very
See bytea, though its presentation format leaves something to be desired IMHO
how would someone be expected to store, say, a GIF image in a TOAST text?
One would not. A TOASTed bytea is the appropriate column type.
thanks -- that's EXACTLY what i needed.
bytea was not really
Yes, please send them over to the PHP folks. Thanks.
On Wed, Dec 27, 2000 at 12:56:26AM -0500, Bruce Momjian wrote:
I have been asked by the major PHP developer Rasmus Lerdorf to see if
the PostgreSQL/PHP interface needs any improvements.
Is the current PostgreSQL interface module in
This is interesting. I always wondered how the persistent connection
stuff handled this, and not I see that it doesn't.
[ Charset ISO-8859-1 unsupported, converting... ]
The only problem we have run into (and I have heard of others having this
problem also) is with persistent connections.
It was obviously designed with MySQL's "Nobody needs transactions for
webwork" type of situation in mind.
This is interesting. I always wondered how the persistent connection
stuff handled this, and not I see that it doesn't.
[ Charset ISO-8859-1 unsupported, converting... ]
The only
At my work we were happily cruising along using PHP/Postgres persistent
connections. This was all happy until we installed Phorum. Phorum has its
own database abstraction layer, quite separate to all our own database
classes.
Now what happens is if someone browses the phorums for a little
21:30
http://www.heartlight.org/cgi-shl/todaysverse.cgi?day=20010101
===
Created by Mail2Sig - http://pdunford.godzone.net.nz/software/mail2sig/
"Christopher Kings-Lynne" [EMAIL PROTECTED] writes:
Now what happens is if someone browses the phorums for a little while, and
then switches to pages that use our own db classes, you get random slowdowns
(ie. a select occurs, and then times out after 2 mins or so).
If you use psql, and
Larry Rosenman [EMAIL PROTECTED] writes:
The planregress.sh tests generate errors. Attached is a tar of the
planregress directory...
Have you examined the diffs to see whether any represent real problems,
as opposed to trivial changes in output tuple order?
Is the tuple order
* Tom Lane [EMAIL PROTECTED] [010101 23:16]:
[snip]
there are a couple of them that I *THINK* have more tuples on one side
or the other of the Diff. I'll try and narrow them... (or shouldn't I
bother? )
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812
Larry Rosenman [EMAIL PROTECTED] writes:
* Tom Lane [EMAIL PROTECTED] [010101 23:16]:
[snip]
there are a couple of them that I *THINK* have more tuples on one side
or the other of the Diff. I'll try and narrow them... (or shouldn't I
bother? )
That would certainly be a bug, if so, so do
For anyone interested,
I have posted my multi-threaded version of PostgreSQL here.
http://www.sacadia.com/mtpg.html
It is based on 7.0.2 and the TAO CORBA ORB which is here.
http://www.cs.wustl.edu/~schmidt/TAO.html
Myron Scott
[EMAIL PROTECTED]
I thought about this UNDER/INHERITS stuff months ago and wrote this file:
http://www.comptechnews.com/~reaster/pgoo.html
It might have something of value to someone. I'm not sure everything in the
file is correct though.
I remember the idea of UNDER is to be compatible with storing data from
I am strongly inclined to rip out the pseudo-UNDER clause and support
only the old-style INHERITS syntax for 7.1. UNDER is adding no
functionality and I think we will eventually regret using an SQL keyword
for non-SQL semantics.
I agree with you, Hannu, et al. If it isn't making a good
Does this requested chagne have to do with Apache or PostgreSQL?
w wrote:
I have been asked by the major PHP developer Rasmus Lerdorf to see
if
the PostgreSQL/PHP interface needs any improvements.
Is the current PostgreSQL interface module in PHP adequate?
I have a line in a PHP script that looks like this:
$set=pg_exec($dbconn, "SET DATESTYLE TO 'European'"); //Set date format
Since my ISP updated their server, this appears to be ignored as pgsql
always returns dates in ISO format.
1. What is the default format of dates returned that
On Mon, 1 Jan 2001, Myron Scott wrote:
For anyone interested,
I have posted my multi-threaded version of PostgreSQL here.
http://www.sacadia.com/mtpg.html
How you solve locks? Via original IPC or you rewrite it to mutex (etc).
Karel
Alfred Perlstein [EMAIL PROTECTED] writes:
One trick that may help is calling sched_yield(2) on a lock miss,
it's a POSIX call and quite new so you'd need a 'configure' test
for it.
The author of the current s_lock code seems to have thought that
select() with a zero delay would do the
"Patrick Dunford" wrote:
I have a line in a PHP script that looks like this:
$set=pg_exec($dbconn, "SET DATESTYLE TO 'European'"); //Set date format
Since my ISP updated their server, this appears to be ignored as pgsql
always returns dates in ISO format.
1. What is the
* Bruce Momjian [EMAIL PROTECTED] [010101 23:59] wrote:
Alfred Perlstein [EMAIL PROTECTED] writes:
One trick that may help is calling sched_yield(2) on a lock miss,
it's a POSIX call and quite new so you'd need a 'configure' test
for it.
The author of the current s_lock code seems
spinlocks rewritten to mutex_
locktable uses sema_
some cond_ in bufmgr.c
Myron
Karel Zak wrote:
On Mon, 1 Jan 2001, Myron Scott wrote:
For anyone interested,
I have posted my multi-threaded version of PostgreSQL here.
http://www.sacadia.com/mtpg.html
How you solve locks?
26 matches
Mail list logo
