Re: [HACKERS] RFC: Security documentation

2004-05-09 Thread Nigel J. Andrews
that -- because I'd like to know what we can do to get some documentation included in the next release. I don't feel that having zero documentation on this subject is acceptable. Are you saying here you _do_ have some documentation to contribute? -- Nigel J. Andrews ---(end

Re: [HACKERS] feature request... case sensitivity without double

2004-01-18 Thread Nigel J. Andrews
FORTRAN does to one's brain after a while of trying to read it. -- Nigel J. Andrews ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Use of 'cp -r' in CREATE DATABASE

2003-12-11 Thread Nigel J. Andrews
it with postgresql. -- Nigel J. Andrews ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Nigel J. Andrews
On Fri, 28 Nov 2003, Tom Lane wrote: Darcy Buskermolen [EMAIL PROTECTED] writes: On November 28, 2003 12:33 pm, Tom Lane wrote: Whoa. Try the following test program. Then send it in to your friendly local BSD hackers I've been running this code on a pair of FreeBSD (i386) boxen,

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Nigel J. Andrews
On Fri, 28 Nov 2003, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: On an Intel Linux 2.4.18 I get them quite often, 25 in 1'45, but they are all just a microsecond. What do you mean by just a microsecond? I mean it's always a out of order tv_usec... line and the difference

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Nigel J. Andrews
On Fri, 28 Nov 2003, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: On Fri, 28 Nov 2003, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: On an Intel Linux 2.4.18 I get them quite often, 25 in 1'45, but they are all just a microsecond. What do you mean by just

Re: [HACKERS] gettimeofday() goes backwards on FreeBSD 4.9

2003-11-28 Thread Nigel J. Andrews
On Fri, 28 Nov 2003, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: $ time ./a.out 21 | tee a.txt out of order tv_sec: 1070066197 273140, prev 1070066195 721010 out of order tv_usec: 1070066197 273140, prev 1070066195 721010 out of order tv_sec: 1070067322 116061, prev

Re: [HACKERS] Commercial binary support?

2003-11-23 Thread Nigel J. Andrews
On Sun, 23 Nov 2003, Oleg Bartunov wrote: does tsearch2 in 7.4 still has the problem ? I apologies if we miss your patches but certainly we're interested in clear explanation of the problem. The problem was memory allocations made through malloc and family were not being checked for failure

Re: [HACKERS] Commercial binary support?

2003-11-22 Thread Nigel J. Andrews
On 19 Nov 2003, Robert Treat wrote: I don't think *we* thought it was a hot button issue.. at least I certainly didn't when I initially responded. There is no need for you to apologize, in fact, I'll apologize for the list, we sometimes get a little heated on -hackers. Hopefully you've not

Re: [HACKERS] Commercial binary support?

2003-11-22 Thread Nigel J. Andrews
However, I would love to see those patches. Sure. Should be in the archive. The version for 7.4 was submitted and applied pre-release but if you really do want the 7.3 runnable stuff I can send it. It was only the unchecked returns from malloc and family patch in the snowball directory. I

Re: [HACKERS] Commercial binary support?

2003-11-22 Thread Nigel J. Andrews
Oops, sorry folks. That was only meant to go to Joshua. On Sat, 22 Nov 2003, Nigel J. Andrews wrote: However, I would love to see those patches. Sure. Should be in the archive. The version for 7.4 was submitted and applied ... ---(end of broadcast

Re: [HACKERS] Commercial binary support?

2003-11-19 Thread Nigel J. Andrews
On Wed, 19 Nov 2003, Bruce Momjian wrote: Marc G. Fournier wrote: On Wed, 19 Nov 2003, Michael Meskes wrote: On Tue, Nov 18, 2003 at 04:19:35PM -0600, Austin Gonyou wrote: I've been looking all over but I can't seem to see a company that is providing *up-to-date* postgresql

Re: [HACKERS] About the partial tarballs

2003-11-11 Thread Nigel J. Andrews
those messages? Similar sort of question to the 'Does anyone read any of those popup boxes produced by everything in Windows before hitting OK?' one. -- Nigel J. Andrews ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] Learning PostgreSQL

2003-10-05 Thread Nigel J. Andrews
On Sun, 5 Oct 2003, Gevik Babakhani wrote: Dear PostgreSQL masters, I know this might look like a childish question and you probably might have a good laugh over this but I would like to learn how PostgreSQL works inside-out. Could anyone please give me some pointers of where to start

Re: [HACKERS] Thoughts on maintaining 7.3

2003-10-03 Thread Nigel J. Andrews
was running a 7.3 series server but wanted the nifty features of tsearch2 instead of tsearch, would you expect all people upgrading within the stable 7.3 branch for bug fixes to be forced to use tsearch2 and not tsearch? -- Nigel J. Andrews ---(end of broadcast

Re: ADD FOREIGN KEY (was Re: [HACKERS] [GENERAL] 7.4Beta)

2003-09-29 Thread Nigel J. Andrews
On Mon, 29 Sep 2003, Christopher Kings-Lynne wrote: So a db designer made a bloody mistake. The problem is there's no easy way to find out what's missing. I'd really like EXPLAIN to display all subsequent triggered queries also, to see the full scans caused by missing indexes. I'd

Re: [HACKERS] getaddrinfo() for threading instead of gethostbyname()

2003-09-27 Thread Nigel J. Andrews
On Sat, 27 Sep 2003, Bruce Momjian wrote: OK, the thread test program is read for platform testing, src/tools/thread_test. You will find the README, Makefile tests, and program output to be very clear and almost error-proof. Please run it on platforms we support and report back. Thanks.

Re: [HACKERS] feature request: show pgsql version when running initdb

2003-09-26 Thread Nigel J. Andrews
. -- Nigel J. Andrews ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] pgsql procedures??

2003-09-25 Thread Nigel J. Andrews
that. But it can if you switch to one of the other languages like plpgsql, which isn't terribly complicated but does require the language to be installed in the database. -- Nigel J. Andrews ---(end of broadcast)--- TIP 7: don't forget to increase

Re: [HACKERS] [GENERAL] pgindented tsearch2 for 7.3.4

2003-09-24 Thread Nigel J. Andrews
On Wed, 24 Sep 2003, Bruce Momjian wrote: Nigel J. Andrews wrote: I never knew running indent was so damn complicated. All three of my development systems can not manage it without throughing a fault ... There are about 6 files that can't be run through pgindent, and tsearch2 has

[HACKERS] old pgindent change

2003-09-22 Thread Nigel J. Andrews
been there, and specifically placed there, for nearly 2 years. -- Nigel J. Andrews #!/bin/sh echo echo -n Path= echo $PATH echo # Known bugs: # # Blank line is added after, seen as a function definition, no space # after *: # y = (int) x *y; trap rm -f /tmp/$$ /tmp/$$a 0 1 2 3 15 entab

Re: [HACKERS] old pgindent change

2003-09-22 Thread Nigel J. Andrews
On Mon, 22 Sep 2003, Nigel J. Andrews wrote: There was a simple change commited in revision 1.47 of pgindent, listed as being More updates for GNU indent. The questions are: why? and surely I can't be the only one whose hit this problem since November 2001? ... I also had to apply

Re: [HACKERS] change of table name - any help

2003-09-19 Thread Nigel J. Andrews
[I'm not convinced this is a -hackers issue so have cross posted to -general in the expectation followups will go there] I also didn't feel there was much I could cut from the earlier posts without losing relevent info, so I didn't. Sorry. On Fri, 19 Sep 2003, chakkara rangarajan wrote:

Re: [HACKERS] Why select * from function doesn't work when function

2003-07-24 Thread Nigel J. Andrews
On Thu, 24 Jul 2003, Francisco Figueiredo Jr. wrote: Nigel J. Andrews wrote: On Tue, 22 Jul 2003, Francisco Figueiredo Jr. wrote: How's this for an alternative if you really don't want any rows returned: create function fincF ( ) returns setof integer as ' begin delete from

Re: [HACKERS] tsearch2 for 7.3.X

2003-07-22 Thread Nigel J. Andrews
On Tue, 22 Jul 2003, Tom Lane wrote: Oleg Bartunov [EMAIL PROTECTED] writes: OK. I'll suggest people to try new tsearch2 in README file of old tsearch. Okay, that works for me. Please patch the old tsearch README file in both HEAD and REL7_3_STABLE branch as soon as possible --- we are

Re: [HACKERS] suggestions to improve postgresql suitability for

2003-07-22 Thread Nigel J. Andrews
/tmp or other partitions? Maybe a set of other directories could be designated for this purpose? Hope this help... at least to add new items to the postgresql todo list;-) Have a nice day, -- Nigel J. Andrews ---(end of broadcast

Re: [HACKERS] Why select * from function doesn't work when function

2003-07-22 Thread Nigel J. Andrews
delete from blah; return null; end; ' as language 'plpgsql'; select * from funcF(); I believe that would work but don't quote me :) -- Nigel J. Andrews ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Why select * from function doesn't work when function

2003-07-22 Thread Nigel J. Andrews
; ' language 'plpgsql'; -- Nigel J. Andrews ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Why select * from function doesn't work when function

2003-07-22 Thread Nigel J. Andrews
exactly that. Doesn't even return a null. Give it a quick go, skip the delete statement obviously, and see. You'll get something like: ? --- (0 rows) -- Nigel J. Andrews ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go

Re: [HACKERS] Error messages --- now that we've got it, do you like

2003-07-20 Thread Nigel J. Andrews
On Sun, 20 Jul 2003, Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: VERBOSE doesn't seem like the right name for the \set parameter. VERBOSITY would be okay with me. Sounds meaningful. I often want to say 'verbosity level' when talking such things. -- Nigel J. Andrews

Re: [HACKERS] Error messages --- now that we've got it, do you like

2003-07-04 Thread Nigel J. Andrews
. Error codes are always handy to have and the extra details are just the ticket, I especially like the hint. -- Nigel J. Andrews ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs

Re: [HACKERS] Two weeks to feature freeze

2003-06-23 Thread Nigel J. Andrews
, if the testing is not upto your level of testing submit something that makes it so. Having said that I do believe you mentioned that you didn't have the time to create something but you would be happy to test it, i.e. test the test. -- Nigel J. Andrews ---(end

Re: [HACKERS] Two weeks to feature freeze

2003-06-20 Thread Nigel J. Andrews
On Thu, 19 Jun 2003, The Hermit Hacker wrote: On Thu, 19 Jun 2003, Andrew Dunstan wrote: Maybe a better strategy would be to get a release out soon but not wait 6 months for another release which would contain the Win32 port and the PITR stuff (assuming those aren't done in time for

Re: [HACKERS] Pre-allocation of shared memory ...

2003-06-13 Thread Nigel J. Andrews
the start of this thread so I've probably missed the reason for the complaint about lack of swap space, like a problem on a small memory system. -- Nigel J. Andrews ---(end of broadcast)--- TIP 9: most folks find a random_page_cost between 1 or 2

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-10 Thread Nigel J. Andrews
On Mon, 9 Jun 2003, Tom Lane wrote: Josh Berkus [EMAIL PROTECTED] writes: Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the option that's supposed to let you turn off Inserting missing FROM clause for table ... Bruce hasn't applied that patch yet. I believe

Re: [HACKERS] host and hostssl equivalence in pg_hba.conf

2003-06-10 Thread Nigel J. Andrews
On Tue, 10 Jun 2003, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: How do people feel about changing matching for host and hostssl to be such that a plain host line in pg_hba.conf does not allow a SSL connection but requires the hostssl specifier? Then there would be no way

Re: [HACKERS] large objects

2003-06-08 Thread Nigel J. Andrews
On Fri, 6 Jun 2003, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: Now, I did a little bit of testing and when doing a \lo_export oid filename in psql connected via localhost a SIGPIPE is generated in write() in libc and psql quit, without printing any message to the terminal

Re: [HACKERS] large objects

2003-06-08 Thread Nigel J. Andrews
been lost in a hole somewhere much like another of my posts. On Sun, 8 Jun 2003, Nigel J. Andrews wrote: Note, primary list address changed to -general, I'd suggest any followups remove the -hackers, which I've left in just for 'closure'. On Fri, 6 Jun 2003, Nigel J. Andrews wrote

Re: [HACKERS] large objects

2003-06-08 Thread Nigel J. Andrews
Note, primary list address changed to -general, I'd suggest any followups remove the -hackers, which I've left in just for 'closure'. On Fri, 6 Jun 2003, Nigel J. Andrews wrote: On Fri, 6 Jun 2003, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: Now, I did a little bit

[HACKERS] large objects

2003-06-06 Thread Nigel J. Andrews
, a) is this known? b) what is it? c) is it not going to happen in the new protocol? and d) does anyone care? -- Nigel J. Andrews ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-05 Thread Nigel J. Andrews
are dangerous, they turn you mind off. I voted for setting 'C' by default. -- Nigel J. Andrews ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Postgres config file: autocommit = off

2003-06-03 Thread Nigel J. Andrews
that the autocommit is turned off. -- Nigel J. Andrews ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Primary key and references

2003-03-18 Thread Nigel J. Andrews
. The workaround shown here is acceptable as I don't really need a compound primary key. But If I need, I know it won't work.. I hope that helps. TIA.. Shridhar -- Nigel J. Andrews ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [HACKERS] location of the configuration files

2003-02-13 Thread Nigel J. Andrews
simplifies switching between versions of software, try doing that if your config is /etc/postgresql/postgres.conf. -- Nigel J. Andrews ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Maximum Size for Large Object / TOASTed Object

2003-02-11 Thread Nigel J. Andrews
a field? :) Thanks, Paul I don't know but large objects are stored in the filesystem so I presume any limit is going to apply there. A large object isn't a field, the large object id can, and very probably should, be stored in one though. -- Nigel J. Andrews ---(end

Re: [HACKERS] [ADMIN] Cannot connect to the database (PG 7.3)

2003-01-28 Thread Nigel J. Andrews
throwing an error if an all digit user name is given to create user as already alluded to? Seems that would be simple, not that I know anything about the parser, but does that break any standards? -- Nigel J. Andrews ---(end of broadcast)--- TIP 6: Have

Re: [HACKERS] Yaarrgh! CVS remote buffer overflow

2003-01-21 Thread Nigel J. Andrews
applies to the pserver method. -- Nigel J. Andrews ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Indexes

2003-01-16 Thread Nigel J. Andrews
certainly remember some discussion on this subject a few months ago. -- Nigel J. Andrews ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] I feel the need for speed. What am I doing wrong?

2003-01-06 Thread Nigel J. Andrews
that let's hope I haven't embarrassed myself. -- Nigel J. Andrews ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Postgres Security Expert???

2002-11-26 Thread Nigel J. Andrews
FWIW, a search on Google gives some hits for the name on the lists this year. First impressions are that it's not Sir Mondred (or whatever the spelling was). On Tue, 26 Nov 2002, Justin Clift wrote: Hi Chris, Just received this from them. Look like he was trying to claim stuff that

Re: [HACKERS] Need Quote for 7.3

2002-11-19 Thread Nigel J. Andrews
will be drafted in 2 days. If you have something to say, please e-mail me, Marc ([EMAIL PROTECTED]) and Justin ([EMAIL PROTECTED]) off-list so we can quote you! I think it's great - but don't quote me on that. :) -- Nigel J. Andrews ---(end of broadcast

Re: [HACKERS] Debian build prob

2002-11-15 Thread Nigel J. Andrews
upgrades or anything. Now of course one would need a new bison. -- Nigel J. Andrews ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can

Re: [HACKERS] RC1?

2002-11-13 Thread Nigel J. Andrews
operation either exceeded legal ranges or was a divide by zero SELECT '' AS bad, f.f1 ^ '1e200' from FLOAT8_TBL f; ERROR: pow() result is out of range SELECT '' AS bad, ln(f.f1) from FLOAT8_TBL f where f.f1 = '0.0' ; in the float8 test. -- Nigel J. Andrews Logictree Systems Limited

Re: [HACKERS] RC1?

2002-11-13 Thread Nigel J. Andrews
On Wed, 13 Nov 2002, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: FWIW, gmake check and gmake bigcheck pass on: FreeBSD 3.3-RELEASE #3: Thu Feb 3 23:48:56 GMT 2000 with the expection of: [snipped] in the float8 test. Okay, looks like we need to use float8-fp

Re: [HACKERS] Memory leaks

2002-10-23 Thread Nigel J. Andrews
very closely but nothing jumped out at me as being obviously wrong from the grep output. -- Nigel J. Andrews ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Memory leaks

2002-10-22 Thread Nigel J. Andrews
paragraph. Can't we get Sir Mongle (or whatever the name was) to test these things under the auspices of them being DoS attacks? -- Nigel J. Andrews ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] Freeing plan memory

2002-10-19 Thread Nigel J. Andrews
still had an obvious memory leak so looked a little closer at SPI. -- Nigel J. Andrews ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Freeing plan memory

2002-10-19 Thread Nigel J. Andrews
On Sat, 19 Oct 2002, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: The leak is that memory is grabbed in SPI_prepare() for a plan within whatever context is current when it does the palloc(). It may be the caller's or it may be the relevent SPI one. The plan is then copied

Re: [HACKERS] Little note to php coders

2002-10-08 Thread Nigel J. Andrews
about internationalisation and that test. -- Nigel J. Andrews ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

[HACKERS] anoncvs and diff

2002-10-03 Thread Nigel J. Andrews
with the anoncvs archive? -- Nigel J. Andrews ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] anoncvs and diff

2002-10-03 Thread Nigel J. Andrews
On Thu, 3 Oct 2002, Bruce Momjian wrote: Nigel J. Andrews wrote: cvs diff -r HEAD pltcl.c gave me differences against revision 1.64 and cvs update pltcl.c said it was merging changes between 1.64 and 1.61 and a plain cvs diff now shows me differences against 1.64 I

Re: Fwd: [HACKERS] int type problem in 7.3

2002-10-02 Thread Nigel J. Andrews
type? If you want to select on NULL, whether or not you think the database is more intelligent than you in determining what you really want, then write your query to select on NULL. The chances are your database is not actually a mind reader. -- Nigel J. Andrews

Re: [HACKERS] pltcl.so patch

2002-09-25 Thread Nigel J. Andrews
On 25 Sep 2002, Neil Conway wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: Yes, I do get the similar results. A quick investigation shows that the SPI_freetuptable at the end of pltcl_SPI_exec is trying to free a tuptable of value 0x82ebe64 (which looks sensible to me) but which

Re: [HACKERS] pltcl.so patch

2002-09-25 Thread Nigel J. Andrews
that I've straightened this out in my brain a bit more. On Wed, 25 Sep 2002, Nigel J. Andrews wrote: On 25 Sep 2002, Neil Conway wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: Yes, I do get the similar results. A quick investigation shows that the SPI_freetuptable at the end

Re: [HACKERS] pltcl.so patch

2002-09-24 Thread Nigel J. Andrews
that test function wrong, it's got a level of nesting. Unfortunately, I am currently trying to throw together a quick demo of something at the moment so can't investigate too fully for the next day or so. If someone wants to pick this up feel free otherwise I'll look into it later. -- Nigel J. Andrews

Re: [HACKERS] PGXLOG variable worthwhile?

2002-09-23 Thread Nigel J. Andrews
configurable --- it was just the notion of making it depend on environment variables that scared people. And it's obvious it was centred on the use of an environment variable from the subject line, it's still got PGXLOG in capitals in it. -- Nigel J. Andrews ---(end

Re: [HACKERS] SCSI Error

2002-09-20 Thread Nigel J. Andrews
on the hardware. On the other hand I do believe I saw a message recently saying that some of the 2.4 series kernels had file system bugs. I don't know which, someone else might be able to expand. -- Nigel J. Andrews ---(end of broadcast)--- TIP 4: Don't

Re: [HACKERS] Improving speed of copy

2002-09-20 Thread Nigel J. Andrews
. That's 1 second (approx.) per row retrieved. That is pretty dire for an index scan. The data/index must be very non unique. -- Nigel J. Andrews ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] [GENERAL] Memory Errors...

2002-09-20 Thread Nigel J. Andrews
there might be another leak with prepared plans. I'm looking into that so I won't be sending this patch just yet. -- Nigel J. Andrews ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Memory Errors...

2002-09-20 Thread Nigel J. Andrews
warnings. Can anyone comment on the correctness of this? Reversing my changes doesn't really help matters so I presume it is something else that is causing the different behaviour. -- Nigel J. Andrews On Fri, 20 Sep 2002, Nigel J. Andrews wrote: On Thu, 19 Sep 2002, Tom Lane wrote: Ian

Re: [HACKERS] [GENERAL] Memory Errors...

2002-09-19 Thread Nigel J. Andrews
the day before beta freeze. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] [GENERAL] Memory Errors...

2002-09-19 Thread Nigel J. Andrews
shows a lack of tuptable freeing. -- Nigel J. Andrews ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] PGXLOG variable worthwhile?

2002-09-17 Thread Nigel J. Andrews
is that going to work if tablespaces are introduced in 7.4. Surely the same mechanism for tablespaces would be used for pg_xlog. As the tablespace mechanism hasn't been determined yet, as far as I know, wouldn't it be best to see what happens there before creating the TODO item for the log? -- Nigel J

[HACKERS] SRF and pg_group

2002-09-10 Thread Nigel J. Andrews
email and work load. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants /* * Derived from tablefunc.c, a sample to demonstrate C functions which * return setof scalar and setof composite by Joe Conway [EMAIL PROTECTED] * * Copyright 2002 by PostgreSQL

[HACKERS] Memory management question

2002-09-03 Thread Nigel J. Andrews
It's probably a pretty basic question explained in some document I haven't seen but...if I do something like a CreateTupleDescCopy() how do I know my memory context owns everything allocated without following the code all the way through until it returns to me? -- Nigel J. Andrews

Re: [HACKERS] Memory management question

2002-09-03 Thread Nigel J. Andrews
On Tue, 3 Sep 2002, Karel Zak wrote: On Tue, Sep 03, 2002 at 12:28:37PM +0100, Nigel J. Andrews wrote: It's probably a pretty basic question explained in some document I haven't seen but...if I do something like a CreateTupleDescCopy() how do I know my memory context owns everything

[HACKERS] Impending freeze

2002-09-01 Thread Nigel J. Andrews
at the moment. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Impending freeze

2002-09-01 Thread Nigel J. Andrews
On Mon, 2 Sep 2002, Gavin Sherry wrote: On Sun, 1 Sep 2002, Nigel J. Andrews wrote: When is the beta freeze? Today. Oops, my fault for being imprecise. I was wondering what time of day with timezone. Someone suggested end of today but that means different times to different people

Re: [HACKERS] Impending freeze

2002-09-01 Thread Nigel J. Andrews
On Sun, 1 Sep 2002, Marc G. Fournier wrote: On Sun, 1 Sep 2002, Nigel J. Andrews wrote: On Mon, 2 Sep 2002, Gavin Sherry wrote: On Sun, 1 Sep 2002, Nigel J. Andrews wrote: When is the beta freeze? Today. Oops, my fault for being imprecise. I was wondering what

Re: [HACKERS] Fulltextindex

2002-08-30 Thread Nigel J. Andrews
it. Disclaimer: I have no idea what I'm doing here. -- Nigel J. Andrews ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] source code indexer

2002-08-30 Thread Nigel J. Andrews
somedir some spec. | xargs grep often followed by tags in Emacs. It isn't perfect but then I'm not either. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 5: Have you checked our

Re: [HACKERS] TODO Done. Superuser backend slot reservations

2002-08-26 Thread Nigel J. Andrews
On Mon, 26 Aug 2002, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: + if (!superuser() MyBackendId MaxBackends - ReservedBackends) + elog(ERROR, Normal user limit exceeded); This coding is wrong on its face: the slot number you happen to find has

Re: [HACKERS] TODO Done. Superuser backend slot reservations

2002-08-26 Thread Nigel J. Andrews
On Mon, 26 Aug 2002, Bruce Momjian wrote: Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: I was taking the line that the last slots in the array are reserved. Those are not going to be taken by non su connections. But that doesn't do the job, does it? My view

[HACKERS] A configure.in patch check

2002-08-25 Thread Nigel J. Andrews
. For the record, this is related to reserving the last few backend slots for the superuser and I just need to test what I've done. TIA -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 2: you can

[HACKERS] A configure.in patch check (fwd)

2002-08-25 Thread Nigel J. Andrews
Helps if I attach the patch... -- Forwarded message -- Date: Sun, 25 Aug 2002 14:36:19 +0100 (BST) From: Nigel J. Andrews [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: A configure.in patch check Would someone apply the attached patch to the development source and let me

Re: [HACKERS] A configure.in patch check (fwd)

2002-08-25 Thread Nigel J. Andrews
On Sun, 25 Aug 2002, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: + AC_MSG_CHECKING([for default superuser reserved number of connections]) + PGAC_ARG_REQ(with, reservedbackends, [ --with-reservedbackends=Nset default superuser reserved number of connections [2

Re: [HACKERS] Proposal: make opaque obsolete

2002-08-21 Thread Nigel J. Andrews
record on pg_type? That presumably means we'd need in and out functions defined for these, which in the case of cstring would just be copying the input to output? (As you can see I may not be the best person to work on this if it is to be available for the beta) -- Nigel J. Andrews Director

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

2002-08-20 Thread Nigel J. Andrews
input types, i.e. not cash_out(opaque)? cash_words is already listed as only taking the money type is cash_out really that different? On a related topic cash_out() is listed in pg_proc as returning an int4 but doesn't the code clearly show that is incorrect? -- Nigel J. Andrews Director

Re: [HACKERS] @(#) Mordred Labs advisory 0x0001: Buffer overflow in

2002-08-20 Thread Nigel J. Andrews
On Tue, 20 Aug 2002, Tom Lane wrote: Nigel J. Andrews [EMAIL PROTECTED] writes: I'd like to see something done about this fairly soon, but it's not happening for 7.3 ... Does anyone have an idea about what other functions are affected by this? As a first approximation, every output

Re: [HACKERS] Open 7.3 issues

2002-08-18 Thread Nigel J. Andrews
systems like Win32. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Open 7.3 items

2002-08-14 Thread Nigel J. Andrews
.] -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] [HACKERS] Linux Largefile Support In Postgresql RPMS

2002-08-09 Thread Nigel J. Andrews
. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Linux Largefile Support In Postgresql RPMS

2002-08-08 Thread Nigel J. Andrews
, I'm going to shut up now before I really do show my ignorance and let you answer. -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [HACKERS] postgresql performance tuning document ?

2002-08-08 Thread Nigel J. Andrews
? -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [HACKERS] Trimming the Fat, Part Deux ...

2002-08-01 Thread Nigel J. Andrews
software13288 Jul 27 21:10 Makefile.global.in -rw-r--r--1 software software10853 Jul 27 21:10 Makefile.shlib drwxr-xr-x 23 software software 4096 Aug 1 23:27 backend -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end

[HACKERS] PERFORM effects FOUND patch (Was: [GENERAL] I must be blind...)

2002-06-15 Thread Nigel J. Andrews
On Fri, 14 Jun 2002, Alvaro Herrera wrote: Tom Lane dijo: Nigel J. Andrews [EMAIL PROTECTED] writes: However, because PERFORM discards the results of a query it is only useful for side effects of the query. Okay. I guess the next question is whether PERFORM *should* be setting

Re: [HACKERS] Redhat 7.3 time manipulation bug

2002-05-24 Thread Nigel J. Andrews
with the baddies from the first paragraph :) -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [HACKERS] 2nd cut at SSL documentation

2002-05-22 Thread Nigel J. Andrews
the documentation. I'm also a bit of a newbie when it comes to SSH and I've not investigated ssh3 at all yet. However, isn't this assuming ssh1 only? I know ssh2 will fallback to ssh1 compatibility but should there be something about configuring for the later versions? -- Nigel J. Andrews Director

Re: [HACKERS] [INTERFACES] libpgtcl - backend version information patch

2002-05-18 Thread Nigel J. Andrews
[My apolgies if this turns up in the lists twice (now three times) but my mailer claims it's been in the queue for them too long. Not sure why it thinks that since it's only a few minutes since I sent it.] On Fri, 17 May 2002, Peter Eisentraut wrote: Nigel J. Andrews writes

[HACKERS] *new* libpgtcl - backend version information patch

2002-05-18 Thread Nigel J. Andrews
a bug fix and is therefore for 7.3 not 7.2.2 -- Nigel J. Andrews Director --- Logictree Systems Limited Computer Consultants ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

  1   2   >