Re: [HACKERS] TODO list comments

2005-08-25 Thread Oliver Elphick
id |name| address | del_addr ++---+-- 1 | Joe Bloggs | 1 Hindhead Villas,| 2 The Laurels, | Newport, | Swinkley, | Gwent

Re: [HACKERS] 8.0b4: COMMIT outside of a transaction echoes

2004-10-27 Thread Oliver Elphick
and not COMMIT is echoed here? > > Because the transaction was not committed, but rather rolled back. It's still a misleading message; in those circumstances, how about returning "NO ACTION" instead? -- Oliver Elphick [EMAIL PROTECTED

Re: [HACKERS] Inability to cast regclass is too restrictive

2004-10-08 Thread Oliver Elphick
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

[HACKERS] Inability to cast regclass is too restrictive

2004-10-08 Thread Oliver Elphick
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

Re: [HACKERS] NEW used in a query that is not in a rule

2004-09-14 Thread Oliver Elphick
zm37UpzwH2SGd4RAnObAKD4G6S6MdvaYsGxjS88sn+u2OJqagCg86ut > tsa/AXBfKtB12sCPBIwJAYc= > =G2DY > -END PGP SIGNATURE- > > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postg

Re: [HACKERS] monetary bug

2004-08-23 Thread Oliver Elphick
unit of money is very important, whereas the unit of length is not. You cannot meaningfully add amounts of money in different currencies, even if you convert to some base currency first. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight

Re: [HACKERS] monetary bug

2004-08-22 Thread Oliver Elphick
type? It seems to me a monetary type is a complex type consisting of currency code and amount -- 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 E

Re: [HACKERS] Does psql use nested transactions?

2004-08-19 Thread Oliver Elphick
epeat \i You certainly do not have to work in autocommit mode. It will be nice to have nested transactions, but this is not the compelling reason for doing it. Oliver Elphick ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] UNICODE characters above 0x10000

2004-08-07 Thread Oliver Elphick
On Sat, 2004-08-07 at 07:10, Tom Lane wrote: > Oliver Elphick <[EMAIL PROTECTED]> writes: > > glibc provides various routines (mb...) for handling Unicode. How many > > of our supported platforms don't have these? > > Every one that doesn't use glibc.

Re: [HACKERS] UNICODE characters above 0x10000

2004-08-06 Thread Oliver Elphick
any of our supported platforms don't have these? If there are still some that don't, wouldn't it be better to use the standard routines where they do exist? -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://ww

Re: [HACKERS] PITR - recovery to a particular transaction

2004-08-04 Thread Oliver Elphick
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 allowe

[HACKERS] PITR - recovery to a particular transaction

2004-08-04 Thread Oliver Elphick
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

[HACKERS] Unicode restriction

2004-08-03 Thread Oliver Elphick
f 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

Re: [HACKERS] Completed TODO item?

2004-07-22 Thread Oliver Elphick
--+---+--- address_id_seq | 8490 |1 | 9223372036854775807 | 1 | 1 | 0 | f | t Oliver Elphick ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Escaping metacharacters

2004-07-18 Thread Oliver Elphick
; > > $s = str_replace("\\", "", $s); > > return "'" . $s . "'"; Have you looked at the function PQescapeString() in the libpq library? Using that would seem to be a simpler way of solving this problem. Libraries such as Per

Re: [PATCHES] [HACKERS] Is "trust" really a good default?

2004-07-14 Thread Oliver Elphick
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 ens

Re: [HACKERS] Is "trust" really a good default?

2004-07-13 Thread Oliver Elphick
ged. Ensuring this is part of ensuring a smooth upgrade path, which is a major part of the package maintainer's job. -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver GPG:

Re: [HACKERS] CVS tip problems

2004-06-01 Thread Oliver Elphick
ficient for a patch 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 1E

Re: [HACKERS] CVS tip problems

2004-05-31 Thread Oliver Elphick
that returns 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 ===

Re: [HACKERS] CVS tip problems

2004-05-31 Thread Oliver Elphick
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. > >

[HACKERS] CVS tip problems

2004-05-30 Thread Oliver Elphick
host "localhost" and accepting TCP/IP connections on port 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

Re: [HACKERS] Tablespaces

2004-03-03 Thread Oliver Elphick
two back 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

Re: [HACKERS] Collaboration Tool Proposal

2004-03-01 Thread Oliver Elphick
on GForge similar to Sourceforge > exist ? 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]

[HACKERS] anoncvs problem

2004-02-29 Thread Oliver Elphick
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 anoncvs.postgre

Re: [HACKERS] documentation bug?

2004-01-05 Thread Oliver Elphick
27;J'); to_char - 1721388 (1 row) There is no year 0, so this ought to give an error. It may explain why we go back to 4713BC instead of 4712BC. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK

Re: [HACKERS] [GENERAL] Announce: Search PostgreSQL related resources

2004-01-05 Thread Oliver Elphick
cons. Could I suggest a filter to limit results 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 Wi

Re: [HACKERS] Spinlock support for linux-hppa?

2004-01-02 Thread Oliver Elphick
ead. The logjam only cleared in time for me to put 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

Re: [HACKERS] Spinlock support for linux-hppa?

2004-01-01 Thread Oliver Elphick
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? Bru

Re: [HACKERS] Spinlock support for linux-hppa?

2003-12-31 Thread Oliver Elphick
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

[HACKERS] Spinlock support for linux-hppa?

2003-12-31 Thread Oliver Elphick
p;arch=hppa&stamp=1072828455&file=log&as=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 =

Re: [HACKERS] initdb should create a warning message [was Re:

2003-12-01 Thread Oliver Elphick
agree that renaming the directories 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

Re: [HACKERS] initdb should create a warning message [was Re:

2003-12-01 Thread Oliver Elphick
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

[HACKERS] initdb should create a warning message [was Re: [ADMIN] Size on Disk]

2003-11-30 Thread Oliver Elphick
pg_xlog are not mentioned in the index to the documentation, which makes it more 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

Re: [HACKERS] Release cycle length

2003-11-18 Thread Oliver Elphick
s do anything until the final release ... I do in fact build debs 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

Re: [HACKERS] Proposed structure for coexisting major versions

2003-10-28 Thread Oliver Elphick
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 fro

[HACKERS] Proposed structure for coexisting major versions

2003-10-26 Thread Oliver Elphick
(with start) operate on active clusters for the current EUID -r operate only on running clusters - those for which postmaster is running - for the current EUID -- Oliver Elphick

[HACKERS] Unicode upper() bug still present

2003-10-19 Thread Oliver Elphick
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 El

Re: [HACKERS] Debian bug report about multibyte in 7.3.3

2003-10-19 Thread Oliver Elphick
ort is he couldn't duplicate it... It's more because I was away at the time fetching my 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 charac

Re: [HACKERS] Dreaming About Redesigning SQL

2003-10-18 Thread Oliver Elphick
than with a serious 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://ww

Re: [HACKERS] db encoding

2003-10-06 Thread Oliver Elphick
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 &

Re: [HACKERS] db encoding

2003-10-06 Thread Oliver Elphick
t $5}' SQL_ASCII so as to achieve the same result with only 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

Re: [HACKERS] minor view creation weirdness

2003-10-02 Thread Oliver Elphick
S a, 'world' AS b; There is no table behind the view, so there is no way for PostgreSQL to derive the column types of a and b. A quoted string (as supplied in the view definition) could be one of text, varchar, char, date, time, timestamp, cidr and so on. -- Oliver Elph

Re: [HACKERS] initdb failure (was Re: [GENERAL] sequence's plpgsql)

2003-09-26 Thread Oliver Elphick
ich commands are + causing errors. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C

Re: [HACKERS] ECPG interface: 7.4beta3 compile failure; CVS tip

2003-09-19 Thread Oliver Elphick
t it compiles fine for me despite 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

Re: [HACKERS] ECPG interface: 7.4beta3 compile failure; CVS tip

2003-09-18 Thread Oliver Elphick
On Thu, 2003-09-18 at 19:25, Tom Lane wrote: > Oliver Elphick <[EMAIL PROTECTED]> writes: > > Line 138 begins the definition of strndup(). However, strndup() is also > > declared in string.h, which is included by this file. If I rename this > > function to estrndup() (

[HACKERS] ECPG interface: 7.4beta3 compile failure; CVS tip compile failure

2003-09-18 Thread Oliver Elphick
rror: syntax error before "if" ...etc Line 138 begins the definition of strndup(). 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.

Re: [HACKERS] wish: limit number of connections per database

2003-09-10 Thread Oliver Elphick
e could be separately configured. -- 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 ===

Re: [HACKERS] pg_id and pg_encoding

2003-09-07 Thread Oliver Elphick
> Yes, I assume they would go away with a C 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: 10

[HACKERS] Debian packages of 7.4beta2

2003-09-03 Thread Oliver Elphick
will be welcome. -- 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 sai

Re: [HACKERS] The last configuration file patch (I hope!) This one

2003-02-19 Thread Oliver Elphick
s' trying to manage the same database. As such it should NOT be a configurable parameter. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0

Re: [HACKERS] location of the configuration files

2003-02-14 Thread Oliver Elphick
On Fri, 2003-02-14 at 15:35, Tom Lane wrote: > Here's a pretty topic for a flamewar: should it be /etc/postgres/ or > /etc/postgresql/ ? It should be configurable! Debian uses /etc/postgresql, if you want to stick to what quite a lot of people are familiar with. -- Oli

Re: [HACKERS] location of the configuration files

2003-02-14 Thread Oliver Elphick
d not the ps line 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 93

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
or /etc/postgresql, for static config information; I feel that /opt (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,

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
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

Re: [HACKERS] location of the configuration files

2003-02-13 Thread 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

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
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

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
ike PostgreSQL and pine, along with everything else, should comply with FHS; 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 Elp

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
a directory. -- 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 ear

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
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

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
pt, of course, the location 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

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
tgreSQL stays as it is, I will continue to have to ensure 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:

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
oving the pid file from $PGDATA/postmaster.pid to /var/run/postgresql/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

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Oliver Elphick
o root, I may only have > read-only access to /etc. The location should be configurable; I hope we're talking 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

Re: [HACKERS] pgbash-7.3 released

2003-02-11 Thread Oliver Elphick
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

Re: [HACKERS] UNIQUE not unique with inheritance (workaround?)

2003-02-08 Thread Oliver Elphick
it with a trigger 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. . -

[HACKERS] Cannot break out of createuser

2003-02-07 Thread Oliver Elphick
t;/dev/null 2>&1' 1 2 3 15 should be: trap 'stty echo >/dev/null 2>&1; exit 1' 1 2 3 15 or even trap 'stty echo >/dev/null 2>&1' EXIT -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK

Re: [HACKERS] [ANNOUNCE] PostgreSQL v7.3.2 Released

2003-02-05 Thread Oliver Elphick
On Wed, 2003-02-05 at 20:41, Laurette Cisneros wrote: > I was trying from the postgresql.org download web page and following the > mirror links there...and none of them that I was able to get to (some of > them didn't work) showed 7.3.2. I got it from mirror.ac.uk yesterday --

Re: [HACKERS] [SQL] Function for adding Money type

2003-01-26 Thread Oliver Elphick
the ability to specify the number of decimal 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 nons

Re: [HACKERS] Survey results from the PostgreSQL portal page

2003-01-19 Thread Oliver Elphick
Server and DB and several on MySQL. 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

Re: [HACKERS] 7.3.1 on linux

2003-01-14 Thread Oliver Elphick
e same. This will happen 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

Re: [HACKERS] Upgrading rant.

2003-01-03 Thread Oliver Elphick
ipts. I close 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

Re: [HACKERS] PostgreSQL Password Cracker

2002-12-31 Thread Oliver Elphick
. After 2 such failures, add 1 second sleep for each successive failure before responding to the next attempt for the same username. Max it at say 60 seconds. That should make brute force cracking unfeasible unless someone gets very lucky or the password is particular

Re: [HACKERS] What else needs to be done for 7.3.1?

2002-12-19 Thread Oliver Elphick
having packages > ready to coincide 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

Re: [HACKERS] a problem in authority

2002-12-18 Thread Oliver Elphick
On Wed, 2002-12-18 at 09:20, postgresql wrote: > 2. I change the pg_hba.conf and set the auth_type from 'trust' to > 'password' > > 3. Then I can not connect to server. Try using 'md5' instead of 'password' in pg_hba.conf.

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-14 Thread Oliver Elphick
like libkrb5 and libdb3. That is clearly impracticable. -- 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 ==

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-13 Thread Oliver Elphick
e from 7.3 or earlier. The library 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

Re: [HACKERS] PQnotifies() in 7.3 broken?

2002-12-13 Thread Oliver Elphick
cation of it. This is bad. If the major number changes, they can keep 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

[HACKERS] pg_hba.conf parse error gives wrong line number

2002-12-10 Thread Oliver Elphick
cated file, 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:/

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-08 Thread Oliver Elphick
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 fam

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

2002-12-08 Thread Oliver Elphick
mfortable about using it. If something is familiar, 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

[HACKERS] Debian pacakges of 7.3

2002-12-04 Thread Oliver Elphick
eople 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

Re: [HACKERS] [ADMIN] how to alter sequence.

2002-12-04 Thread Oliver Elphick
e's range, not its current value. junk=# create sequence foo_seq maxvalue 3000; CREATE SEQUENCE junk=# select nextval('foo_seq'); nextval - 1 (1 row) junk=# select setval('foo_seq',

Re: [HACKERS] [ADMIN] how to alter sequence.

2002-12-04 Thread Oliver Elphick
low max_value. If it were created from a SERIAL 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 b

Re: [HACKERS] [GENERAL] Bug with sequence

2002-11-20 Thread Oliver Elphick
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 > > >

[HACKERS] mislaid reference to update script for after 7.3 upgrade

2002-11-18 Thread Oliver Elphick
nd 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

Re: [HACKERS] PG functions in Java: maybe use gcj?

2002-11-01 Thread Oliver Elphick
t by itself cause the resulting executable 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. =========

[HACKERS] 7.3b3 Regression tests passed on i386 Debian

2002-10-30 Thread Oliver Elphick
ith-python --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: 1024

Re: [HACKERS] [SQL] [GENERAL] CURRENT_TIMESTAMP

2002-10-03 Thread Oliver Elphick
of first use within the transaction rather 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

Re: [HACKERS] pg_dump problems in upgrading

2002-09-21 Thread Oliver Elphick
question is larger than the oid of the view. 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. -- Oli

Re: [HACKERS] generating postgres core files on debian

2002-09-19 Thread Oliver Elphick
nstall devscripts fakeroot # needed for building anything cd postgresql-7.2.2 debuild -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG:

Re: [HACKERS] strip a character from text

2002-09-18 Thread Oliver Elphick
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

Re: [HACKERS] RPMS for 7.3 beta.

2002-09-17 Thread Oliver Elphick
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. >

Re: [HACKERS] RPMS for 7.3 beta.

2002-09-17 Thread Oliver Elphick
n an upgrade 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 E8

Re: [HACKERS] RPMS for 7.3 beta.

2002-09-17 Thread Oliver Elphick
currently be an unrealistic expectation, 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

Re: [HACKERS] OPAQUE and 7.2-7.3 upgrade

2002-09-12 Thread Oliver Elphick
On Thu, 2002-09-12 at 15:54, Tom Lane wrote: > Oliver Elphick <[EMAIL PROTECTED]> writes: > > On Thu, 2002-09-12 at 15:31, Tom Lane wrote: > >> Does anyone see a cleaner answer than re-allowing OPAQUE for PL > >> handlers? > > > Can't you just speci

Re: [HACKERS] OPAQUE and 7.2-7.3 upgrade

2002-09-12 Thread Oliver Elphick
x27;s all that is needed to let them 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 E

Re: [HACKERS] pg_dump problems in upgrading

2002-09-12 Thread Oliver Elphick
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 sev

Re: [HACKERS]

2002-09-11 Thread Oliver Elphick
't be surprised > > if my main installation falls over as well. If I get a chance 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 any

Re: [HACKERS] - pg_dump issues

2002-09-11 Thread Oliver Elphick
is going to be a total pain! -- 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 ===

Re: [HACKERS]

2002-09-11 Thread Oliver Elphick
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 > > C

  1   2   3   >