, but rather rolled back.
It's still a misleading message; in those circumstances, how about
returning NO ACTION instead?
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E
On Sat, 2004-10-09 at 05:35, Tom Lane wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
I tried to use regclass() in a plpgsql function to derive a tablename
from its oid so as to build a command string, but I am unable to use the
value returned because it cannot be cast to anything
work.
This seems overly restrictive. Would there be a problem in allowing
regclass() to be cast to text?
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E
+u2OJqagCg86ut
tsa/AXBfKtB12sCPBIwJAYc=
=G2DY
-END PGP SIGNATURE-
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Oliver Elphick
amounts of money in different currencies, even
if you convert to some base currency first.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664
-- but you couldn't sum mixed currencies. Or else it is
limited to the currency of the locale, which doesn't seem particularly
useful.
I think that it should be removed altogether.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight
for
doing it.
Oliver Elphick
---(end of broadcast)---
TIP 8: explain analyze is your friend
that modifies the database? Would that be a small
enough change to be allowed into 8.0?
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543
On Wed, 2004-08-04 at 19:16, Tom Lane wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
How about adding a logging option to put the transaction id on the log
for every statement that modifies the database? Would that be a small
enough change to be allowed into 8.0?
I think we could get
of the Unicode character range is invalid.
There is a Debian bug report from someone whose client is trying to
store characters in the excluded range. What would be needed to enable
support for it?
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight
at the function PQescapeString() in the libpq library?
Using that would seem to be a simpler way of solving this problem.
Libraries such as Perl DBI have similar functions built in.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http
On Wed, 2004-07-14 at 05:08, Tom Lane wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
...
The point of this explanation is that as Debian maintainer I would have
to disable any procedures that attempt to edit these conffiles, or at
least ensure that their operation is under package
is a
major part of the package maintainer's job.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
to correct the problem.)
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
On Mon, 2004-05-31 at 19:55, Tom Lane wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
1. There are regression failures on timestamptz and horology which seem
to have come about either on input or output of timestamps with
fractional seconds.
I believe I've fixed this.
All regression
char*
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
Thou
5342?
3. There is a compilation warning that a constant will not fit into a
long in adt.c. There are two more files where INT64CONST() is required
but not supplied. Patch attached.
--
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight
together. It wouldn't be an issue on most normal systems, but
might be of crucial importance for an ISP running numerous separate
clusters.
--
Oliver Elphick [EMAIL PROTECTED]
LFIX Ltd
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
?
http://alioth.debian.org
(It is due to be taken down for a few hours this week while it is moved
to a new machine.)
Oliver Elphick
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Following instructions on
http://developer.postgresql.org/docs/postgres/cvs.html does not
currently work:
$ cvs -d :pserver:[EMAIL PROTECTED]:/projects/cvsroot login
Logging in to
:pserver:[EMAIL PROTECTED]:2401/projects/cvsroot
CVS password:
cvs login: authorization failed: server
why
we go back to 4713BC instead of 4712BC.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
in foreign languages. For
example, I am unable to benefit from pages written in Russian; I would
like to exclude them from the search, but I see no means of doing that.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http
7.4.1 in unstable.
Unfortunately, this meant that packages didn't get built for other
architectures unless someone using those architectures did a build from
source, which apparently didn't happen with hppa.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
On Thu, 2004-01-01 at 17:58, Tom Lane wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
On Thu, 2004-01-01 at 03:22, Oliver Elphick wrote:
What is needed to provide spinlock support for linux on hppa?
Possibly nothing --- can you try CVS tip? Bruce has already committed
his patch
=1072828455file=logas=raw
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
The LORD
On Thu, 2004-01-01 at 03:22, Oliver Elphick wrote:
What is needed to provide spinlock support for linux on hppa?
I should add that 7.3.4 built OK.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG
On Sun, 2003-11-30 at 23:18, Neil Conway wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
The use of the word log in the directory name does tend to invite
this error, and some have acted on it without asking first. I think
initdb should put a README.IMPORTANT file in $PGDATA to say
is the best solution.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
difficult for people to find out what
they are. I therefore also attach a doc patch to add index entries for
those two files.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5
of the beta and rc releases. These have gone
into the experimental archive in Debian and are announced on Debian
lists. I even posted an announcement to pgsql-general, on 10th October
for example.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
On Mon, 2003-10-27 at 10:05, Neil Conway wrote:
On Sun, 2003-10-26 at 17:24, Oliver Elphick wrote:
If it were possible to have two separate versions of the PostgreSQL
packages installed simultaneously, it would be simple to do database
upgrades by dumping from the old version and uploading
operate only on running clusters - those for which
postmaster is running - for the current EUID
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C
mother-in-law from
Israel, so this bug never got dealt with at all :-( But I do have
problems with these character set bugs, since it took a long time to
find a way to see these characters correctly.
I can confirm it does not happen in 7.4beta4
--
Oliver Elphick[EMAIL
There is a bug in Unicode upper() which has been present since 7.2:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=139389
I had thought I had reported it before, but I can't find a record of it.
The attached Perl script illustrates the bug (the script needs DBI).
--
Oliver Elphick
intention of providing data integrity.
Having used both SQL and MV, I would not now design in any MV
implementation known to me a system whose data I valued.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG
a single command.
Therefore, you don't need to keep pg_encoding for my (the Debian
package's) sake.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D
On Mon, 2003-10-06 at 21:31, Tom Lane wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
I currently use pg_encoding in Debian's automatic upgrade script to
extract the existing default encoding from pg_database, thus:
$ psql -q -t -d template1 -c select encoding from pg_database where
,
timestamp, cidr and so on.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
use the -e option to psql to print the SQL commands
+ as they are run, so that it is easy to see precisely which commands are
+ causing errors.
/para
para
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http
using the very
same system as Oliver to compile.
Perhaps you should enclose your definition in
#ifndef __USE_GNU
#endif
src/include/port/linux.h now forces _GNU_SOURCE on, which in turn
defines __USE_GNU. Do you somehow override the definition of
_GNU_SOURCE?
--
Oliver Elphick
(). However, strndup() is also
declared in string.h, which is included by this file. If I rename this
function to estrndup() (and also where it is called, further down) the
compilation succeeds.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
Draw near to God and he
version.
I use both of them for the Debian packaging, to try to ensure that
upgrading goes seamlessly.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A
.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
And he said unto his disciples
be rewritten to show this, as the backend's ps
lines are rewritten?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
On Thu, 2003-02-13 at 23:06, mlw wrote:
Bruce Momjian wrote:
Can non-root write to /var/run?
Shouldn't be able too
But it should be able to write under /var/run/postgresql, which the
distribution will set up with the correct permissions.
--
Oliver Elphick
On Thu, 2003-02-13 at 22:53, Bruce Momjian wrote:
Oliver Elphick wrote:
What your comments strongly suggest to me is that projects like
PostgreSQL and pine, along with everything else, should comply with FHS;
then there will be no confusion because everyone will be following the
smae
On Fri, 2003-02-14 at 02:49, Tom Lane wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
I'm not entirely sure why SE Linux has a problem, seeing that postgres
needs read-write access to all the files in $PGDATA, but assuming the
need is verified, I could do this by moving the pid file from
(and therefore /etc/opt) are intended for the use of
vendors; so commercial packages designed to fit in with FHS should use
those. I don't think they are for locally built stuff.
No matter; it illustrates the main point, which is that these things
should be easily configurable.
--
Oliver Elphick
;
then there will be no confusion because everyone will be following the
smae standards. Messes arise when people ignore standards; we have all
seen the dreadful examples of MySQL and the Beast, haven't we?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
about the
default here. For distributions it should be /etc/postgresql; for local
builds it should be /usr/local/etc/postgresql, assuming you have root
access. If you don't, the -c configfile switch suggested elsewhere in
this debate would be needed.
--
Oliver Elphick
/5432.pid and similarly for
other ports. This would also have the benefit of being more FHS
compliant What do people think about that?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C
that initdb creates symlinks to /etc/postgresql/, as happens now.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
of the configuration file.)
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
On Thu, 2003-02-13 at 18:45, Bruce Momjian wrote:
Oliver Elphick wrote:
On Thu, 2003-02-13 at 17:52, Vince Vielhaber wrote:
Seems to me that if FHS allows such a mess, it's reason enough to avoid
compliance. Either that or those of you who build for distributions are
making an ill
.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
The earth is the LORD'S
? or is there no
connection?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
Make
or something?
Give each table in the hierarchy a foreign key reference to another
table which holds a unique list of the primary keys and a column that
says which table they are in. Use triggers to update this other table
and to prevent duplications in the hierarchy.
.
--
Oliver Elphick
' 1 2 3 15
should be:
trap 'stty echo /dev/null 21; exit 1' 1 2 3 15
or even
trap 'stty echo /dev/null 21' EXIT
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C
places
on output but I am not sure if that would affect the primary benefit of using
it, speed.
A money type needs to specify what currency is held. The current one
changes the currency with the locale, which makes nonsense of existing
data.
--
Oliver Elphick[EMAIL
. There were 2 on Postgresql, and only one copy of
each.
I'd be interested to know what the commercial PostgreSQL companies think
about it
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C
if the plpgsql.so language file is not in the directory
specified by `pg_config --pkglibdir'. That directory's path is
substituted for '$libdir' by the backend.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG
the running postmaster and open a new postmaster using a
different port, so that normal connection attempts will fail because
there is no postmaster running on the normal port.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http
seconds. That should make brute
force cracking unfeasible unless someone gets very lucky or the password
is particularly weak.
Zero the entry for a username as soon as there is a good connection.
Is it worth doing?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight
with the release announcement?
All is ready for when the new tar.gz appears. Once I have downloaded
it, it should only take 10 minutes or so to package.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG
will be replaced by one that looks for libpq.so.3. But I think
that, unless the API of libecpg changes, its version should stay the
same.
If you change it with libpq, you must also change it with all the other
libraries it links in, like libkrb5 and libdb3. That is clearly
impracticable.
--
Oliver
the old library around for
the benefits of applications that have not yet been recompiled, while
newly compiled applications can use the new library
So please change it.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http
chosen by the linker is the one
linked to libpq.so.
--
Oliver Elphick [EMAIL PROTECTED]
LFIX Limited
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
, a bogus line number is going to make
debugging very tricky. I tried following this in gdb, but haven't
managed to track it through the fork of the new backend.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk
, it feels safe. We need to make PostgreSQL
familiar. That's why we need marketing.
--
Oliver Elphick [EMAIL PROTECTED]
LFIX Limited
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister
On Sun, 2002-12-08 at 22:27, Vince Vielhaber wrote:
On 8 Dec 2002, Oliver Elphick wrote:
If something is familiar, it feels safe. We need to make PostgreSQL
familiar. That's why we need marketing.
Then why wasn't mysql in the list? It's familiar.
To PHBs?
MySQL doesn't have anything
wanting packages for other aarchitectures should build
from source and let me know what (if anything) goes wrong.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839
datatype, you would also have to edit the table definition to use a
pre-created sequence. There is no means of specifying a max_value using
SERIAL.
--
Oliver Elphick [EMAIL PROTECTED]
LFIX Limited
---(end of broadcast)---
TIP 3: if posting/reading
=# select nextval('foo_seq');
nextval
-
1
(1 row)
junk=# select setval('foo_seq', 99);
ERROR: foo_seq.setval: value 99 is out of bounds (1,3000)
--
Oliver Elphick [EMAIL PROTECTED]
LFIX Limited
On Wed, 2002-11-20 at 21:35, Robert Treat wrote:
On Wed, 2002-11-20 at 03:53, Oliver Elphick wrote:
On Mon, 2002-11-18 at 15:45, Thomas Aichinger wrote:
Hi,
I recently installed pg 7.2.3 on my linux box and discovered that
there are some problems with datatype serial and sequence
it in a mailing list search.
Can anyone give me a URL for that, or have I sdreamed it?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
to be covered by the GNU General Public
License. This exception does not however invalidate any other
reasons why the executable file might be covered by the GNU
General Public License.
--
Oliver Elphick
--with-pam --with-openssl --with-gnu-ld
--with-tclconfig=/usr/lib/tcl8.3 --with-tkconfig=/usr/lib/tk8.3
--with-includes=/usr/include/tcl8.3
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C
than the start of the
transaction.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
. It is quite
likely that the table was dropped and recreated after the view was
created.
In fact, the view no longer works:
ERROR: Relation sales_forecast with OID 26246751 no longer exists
so that must be what happened.
--
Oliver Elphick[EMAIL PROTECTED]
Isle
debuild
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
Bring ye all
On Wed, 2002-09-18 at 05:02, Bruce Momjian wrote:
Oliver Elphick wrote:
I'm unhappy because I know that I will get bug reports that I will have
to deal with. They will take time and effort and would not be necessary
if we had a seamless upgrade path.
This last line gave me a chuckle
On Wed, 2002-09-18 at 11:18, [EMAIL PROTECTED] wrote:
Greetings,
Does anyone know a function that strips ANY occurence of a given character
from a TEXT?
It sounds like a job for a PL/Perl function.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
, but I would like it to become a goal of the project. It
has always been my goal as Debian maintainer, but I don't think I can
achieve it for this release.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
from any older version to the current one
could be done by pg_upgrade.
Is this even worth considering?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A
On Thu, 2002-09-12 at 00:52, Philip Warner wrote:
At 12:31 PM 9/09/2002 +0100, Oliver Elphick wrote:
3. A view is being created before one of the tables it refers to.
Should not views be created only at the very end?
This would be trivial (and we already put several items at the end), but I
be restored OK into 7.3.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
Let
to rewrite or cast the expression
3. A view was created before one of the tables to which it referred.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A
On Wed, 2002-09-11 at 14:59, Tom Lane wrote:
Oliver Elphick [EMAIL PROTECTED] writes:
Let me reiterate. I got these problems dumping 7.2 data with 7.3's
pg_dumpall:
1. The language handlers were dumped as opaque; that needs to be
changed to language_handler.
Okay, we need to do
On Wed, 2002-09-11 at 08:20, Dave Page wrote:
-Original Message-
From: Oliver Elphick [mailto:[EMAIL PROTECTED]]
Sent: 11 September 2002 07:29
To: Tom Lane
Cc: Lamar Owen; Bruce Momjian; Philip Warner; Laurette
Cisneros; [EMAIL PROTECTED]
Subject: Re: [HACKERS
!
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
I am crucified
I'll try
it tomorrow.
Why can't we do the remapping in the SQL grammar and remove the
remapping in 7.4?
Surely you will have to leave the remapping in for the benefit of anyone
who jumps from = 7.2 to = 7.4
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
for my using a page cost of 1 on the
assumption that no disk reads would be needed?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
uses template0
itself.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
that an upgrade will fail and will requre the dump script to be
edited. There are some issues in pg_dump / pg_dumpall that need
addressing before final release.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
On Tue, 2002-09-10 at 23:09, Bruce Momjian wrote:
Oliver Elphick wrote:
edited. There are some issues in pg_dump / pg_dumpall that need
addressing before final release.
OK, can you specifically list them?
Message yesterday to pgsql-hackers
Subject: [HACKERS] pg_dump problems
3. A view is being created before one of the tables it refers to.
Should not views be created only at the very end?
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0
.
---
Five successive runs:
random_page_cost = 0.947368
random_page_cost = 0.894737
random_page_cost = 0.947368
random_page_cost = 0.894737
random_page_cost = 0.894737
linux 2.4.18 SMP
dual Athlon MP 1900+
512Mb RAM
SCSI
--
Oliver
: [archiver (db)] could not execute query: ERROR: function
plpgsql_call_handler() does not return type language_handler
Any ideas?
At the moment, you have to edit the dump. Where the language handler
function is declared, change RETURNS opaque to RETURNS
language_handler.
--
Oliver Elphick
complex and more difficult to
understand.
--
Oliver Elphick[EMAIL PROTECTED]
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
1 - 100 of 222 matches
Mail list logo
