Search Discussions
-
Hello, I've looked at the resources available through the web page to CVS and other stuff, however I cant find a statement of whats likely to be in 7.1 and what is planned for later. Reason: I want ...
John Huttley
Nov 23, 2000 at 5:00 am
Dec 7, 2000 at 8:28 pm -
You shouldn't normally use it - postmaster will start backend each 3-5 minutes to do this automatically. Yes, though we can change this. We also can implement now feature that Bruce wanted so long ...
Mikheev, Vadim
Nov 8, 2000 at 6:01 pm
Jan 24, 2001 at 1:27 pm -
Here is a patch for allowing the syslog facility to be set. Index: doc/src/sgml/runtime.sgml =================================================================== RCS file: ...
Larry Rosenman
Nov 12, 2000 at 5:16 pm
Nov 16, 2000 at 5:51 am -
We can do the same thing with a 5-line change in pg_dumpall. We don't need an extra copy&pasted program for that. -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
Peter Eisentraut
Nov 2, 2000 at 7:09 pm
Nov 6, 2000 at 8:47 am -
We've hacked up pg_dump so that it won't dump objects inherited from template1. Unfortunately I have realized there are a couple of serious problems: 1. What if the inherited object is a table or a ...
Tom Lane
Nov 3, 2000 at 12:35 am
Nov 17, 2000 at 1:55 pm -
... and I am not going to allow 7.1 to go out without a fix for this class of problems. I'm fed up ;-) As near as I can tell from the setlocale() man page, the only locale categories that are really ...
Tom Lane
Nov 24, 2000 at 9:20 pm
Nov 27, 2000 at 6:40 pm -
Philip pointed out awhile back that it does not work to load a 7.0.* dump into current sources if the dumped database contains any procedural language definitions. The dumped handler-function ...
Tom Lane
Nov 10, 2000 at 5:07 pm
Nov 20, 2000 at 9:05 pm -
Hi, I was looking at the ALTER TABLE DROP CONSTRAINT bit of PostgreSQL, and I started thinking about trying to implement it (as a bit of mental exercise). (And because it's highly annoying not being ...
Christopher Kings-Lynne
Nov 20, 2000 at 7:15 am
Nov 23, 2000 at 3:44 pm -
I'm tryin to figure out how to speed up udmsearch when run under postgresql, and am being hit by atrocious performance when using a LIKE query ... the query looks like: SELECT ...
The Hermit Hacker
Nov 6, 2000 at 1:05 am
Nov 7, 2000 at 1:09 am -
I'm trying to compile the CVS (fresh download) of postgres and I get this running the configure script: checking for tzname... yes checking for union semun... no checking for struct sockaddr_un... ...
Martin A. Marques
Nov 3, 2000 at 11:08 pm
Nov 9, 2000 at 5:17 pm -
We've expended a lot of worry and discussion in the past about what happens if the OID generator wraps around. However, there is another 4-byte counter in the system: the transaction ID (XID) ...
Tom Lane
Nov 3, 2000 at 10:47 pm
Jan 20, 2001 at 4:03 pm -
The last batch of commits break on FreeBSD 4.2-STABLE. $ uname -a FreeBSD lerbsd.lerctr.org 4.2-STABLE FreeBSD 4.2-STABLE #90: Tue Nov 28 04:07:50 CST 2000 ...
Larry Rosenman
Nov 29, 2000 at 1:35 am
Dec 5, 2000 at 3:23 pm -
This snippet in xlog.c makes we wonder... else if (ControlFile- state == DB_IN_RECOVERY) { elog(LOG, "Data Base System was interrupted being in recovery at %s\n" "\tThis propably means that some data ...
Peter Eisentraut
Nov 21, 2000 at 10:00 pm
Dec 4, 2000 at 9:16 pm -
This is just a curiosity. Why is the default postgres block size 8192? These days, with caching file systems, high speed DMA disks, hundreds of megabytes of RAM, maybe even gigabytes. Surely, 8K is ...
Mark L. Woodward
Nov 27, 2000 at 11:27 pm
Nov 29, 2000 at 1:25 pm -
I have to agree with Peter E. on this patch: it's poorly thought out. I don't mind the idea of being able to relocate the socket file, but the client-side interface they've chosen is silly. Having to ...
Tom Lane
Nov 13, 2000 at 5:35 pm
Nov 22, 2000 at 1:40 am -
At present the Unix socket's location is hard-coded as /tmp. As a result of a bug report, I have moved it in the Debian package to /var/run/postgresql/. (The bug was that tmpreaper was deleting it ...
Oliver Elphick
Nov 18, 2000 at 12:38 am
Nov 30, 2000 at 6:08 pm -
Situation: 7.1 has a new backend interface for loadable modules. (but it supports old 7.0 interface too) Now the problem: How do you tell the backend with what interface to use for particular ...
Marko Kreen
Nov 16, 2000 at 3:47 pm
Nov 23, 2000 at 3:15 pm -
How will they wait? Without a semaphore involved, your answer must be either "timed sleep" or "busy-wait loop", neither of which is attractive ... regards, tom lane
Tom Lane
Nov 18, 2000 at 5:17 am
Jan 24, 2001 at 2:25 pm -
Note: CC'd to Hackers, as this has wandered into deeper feature issues. Tom Lane wrote: This does have an unfortunate denial-of-service implication, where an attack can effectively suck up all ...
Ron Chmara
Nov 26, 2000 at 12:26 am
Nov 27, 2000 at 6:44 pm -
Thought this may be of interest to some... http://www.phpbuilder.com/columns/tim20001112.php3 Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio
Michael Fork
Nov 13, 2000 at 4:39 am
Nov 26, 2000 at 4:36 am -
I've been examining the pg_dump source and output, and I've come to the conclusion that I can modify it so that UNIQUE constraints appear as part of the CREATE TABLE statement, rather than as a ...
Christopher Kings-Lynne
Nov 22, 2000 at 8:00 am
Nov 23, 2000 at 3:44 am -
Anyone care if I build a patch to kill the -m486 type options in the following files: $ grep -i -- 486 * bsdi: i?86) CFLAGS="$CFLAGS -m486";; freebsd:CFLAGS='-O2 -m486 -pipe' univel:CFLAGS='-v -O -K ...
Larry Rosenman
Nov 14, 2000 at 9:42 pm
Nov 16, 2000 at 5:30 am -
Here's what I'm planning to do to make the world safe for backup/restore of user-added template1 data: 1. pg_database will have two new boolean columns, dbistemplate and dballowconn --- if ...
Tom Lane
Nov 13, 2000 at 4:50 pm
Nov 15, 2000 at 5:04 am -
Well, yes. Why isn't it? Full text indexing should be just as much a feature as any other key feature in PG. With the advent of unlimited file and record lengths in 7.1, this would be a good time to ...
John Huttley
Nov 28, 2000 at 1:51 am
Nov 28, 2000 at 3:05 pm -
I have a program that does a: DECLARE getsitescursor CURSOR FOR select... I ^C'd it and it didn't properly shut down the channel to postgresql and I got this crash: #0 0x4828ffc8 in kill () from ...
Alfred Perlstein
Nov 10, 2000 at 1:05 am
Nov 11, 2000 at 10:25 am -
Hi, Remember also that the GiST library has been integrated into PG, (my brother is doing some thesis workon that at the moment), and you can create new index types relatively quickly (assuming that ...
Michael Ansley
Nov 26, 2000 at 11:32 am
Nov 28, 2000 at 5:07 am -
Just playing with the syslog functionality on 7.1devel, and the explain output looks weird to me: Nov 22 14:58:44 lerami pg-test[4005]: [2] DEBUG: MoveOfflineLogs: skip 0000000000000006 Nov 22 ...
Larry Rosenman
Nov 22, 2000 at 9:01 pm
Nov 26, 2000 at 8:19 pm -
I like this "not really a database" idea. Might even be something for $libdir, no ? Then all that would be needed is a command that creates a database from this location instead of template1. Andreas
Andreas Zeugswetter
Nov 9, 2000 at 7:57 am
Nov 10, 2000 at 8:38 am -
I think alot of it has to do with the web server/db setup not pg. They are using Apache/PHP and looking at their code every page has the additional overhead of making the db connection. Now if they ...
Carl garland
Nov 15, 2000 at 1:42 pm
Dec 1, 2000 at 3:12 am -
Trying to compile current sources using: ./configure --prefix=/home/ler/pg-test --enable-syslog \ --with-CXX --with-perl --enable-multibyte --enable-cassert \ --with-openssl --with-tcl \ ...
Larry Rosenman
Nov 25, 2000 at 10:24 pm
Nov 27, 2000 at 2:06 am -
Configured as: CC=cc CXX=CC ./configure --prefix=/home/ler/pg-test --enable-syslog --with-CXX --with-perl --enable-multibyte --with-includes=/usr/local/include --with-libs=/usr/local/lib I get: gmake ...
Larry Rosenman
Nov 20, 2000 at 3:06 pm
Nov 20, 2000 at 7:38 pm -
Hi I fixed a few bugs caused by SearchSysCacheTuple() recently. There seems to remain more similar bugs. They are ill-natured and so we seem to have to avoid such bugs by some means. The simplest way ...
Hiroshi Inoue
Nov 14, 2000 at 5:50 am
Nov 16, 2000 at 4:51 am -
[Cced to hackers list] As long as frontend side knows the current client side encoding is Big5, this should be no problem. At least for libpq. It examins the first byte of Big5. If it is greater than ...
Tatsuo Ishii
Nov 14, 2000 at 5:52 am
Dec 30, 2000 at 3:08 am -
Why is a "select * from table1 where field in (select field from table2 where condition )" is so dramatically bad compared to: "select * from table1, table2 where table1.field = table2.field and ...
Mark L. Woodward
Nov 29, 2000 at 10:50 pm
Dec 10, 2000 at 7:06 pm -
Nope. Still fails... *** ./expected/opr_sanity.out Tue Nov 14 13:32:58 2000 --- ./results/opr_sanity.out Mon Nov 20 20:27:46 2000 *************** *** 482,489 **** (p2.pronargs = 1 AND p1.aggbasetype ...
Larry Rosenman
Nov 21, 2000 at 2:34 am
Nov 21, 2000 at 10:00 am -
C code compatible with Informix: int32 intadd (int32 a, int32 b) { return a + b; } This is the same code that was standard in PostgreSQL 7.0 Andreas
Andreas Zeugswetter
Nov 15, 2000 at 1:44 pm
Nov 16, 2000 at 4:00 pm -
One thing that worries me though is, that it extends the sql language, and there has been no discussion about the chosen syntax. Imho the standard embedded SQL syntax (prepare ...) could be a ...
Andreas Zeugswetter
Nov 2, 2000 at 8:35 am
Nov 12, 2000 at 11:36 am -
With the new oid file naming, the alternative database location feature has disappeared. Not good. Also, is there any merit in keeping the #ifdef OLD_FILE_NAMING code path? I could probably go ...
Peter Eisentraut
Nov 3, 2000 at 9:04 pm
Nov 6, 2000 at 8:08 pm -
is anyone working on the port of PostgreSQL for Alpha FreeBSD ?? I have been waiting for over a year very very patiently !!! I really love my Alpha FreeBSD box and I want to use PostgreSQL on it... ...
Nathan Boeger
Nov 3, 2000 at 11:34 pm
Nov 4, 2000 at 3:39 am -
Am I misunderstanding how to use rule w/conditionals, or is there a bug in this? -- I love to use Pgsql comments, but find the 'comment on field...' language a bit of a pain for documenting a large ...
Joel Burton
Nov 29, 2000 at 11:04 pm
Dec 3, 2000 at 11:48 pm -
how about a .pid/.port/.??? file in the /data directory, and a lock on that? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs ...
Larry Rosenman
Nov 25, 2000 at 10:40 pm
Nov 29, 2000 at 10:09 pm -
TINTERVAL is a poorly supported, old and creaky data type. It is based on ABSTIME, which is not as capable as TIMESTAMP. Maybe. The SQL9x function/operator OVERLAPS is recognized by PostgreSQL 7.x, ...
Thomas Lockhart
Nov 27, 2000 at 6:21 pm
Nov 28, 2000 at 6:00 pm -
Sorry if I'm posting to the wrong list, but I don't know which list is appropriate for this question. I've a question concerning compatibilty Postgres <- Oracle. In Oracle, empty strings and null are ...
Mario Weilguni
Nov 27, 2000 at 5:09 pm
Nov 28, 2000 at 3:04 pm -
$ psql -U psql: option requires an argument -- U Try -? for help. $ psql -? psql: No match. $ Vince. -- ========================================================================== Vince Vielhaber -- ...
Vince Vielhaber
Nov 19, 2000 at 7:33 pm
Nov 25, 2000 at 7:28 pm -
Trying to get my FreeBSD box (lerbsd.lerctr.org, 4.2-BETA) up on current sources. Got this error: make[3]: Entering directory `/home/ler/pg-dev/src/backend/parser' cc -O2 -m486 -pipe -Wall ...
Larry Rosenman
Nov 14, 2000 at 9:01 pm
Nov 15, 2000 at 5:58 pm -
This should not be so. Your setup should definitely work without regression failures. There is something wrong with your dynamic loading of shared libs. Can you give more details, e.g. did you add ...
Andreas Zeugswetter
Nov 7, 2000 at 9:58 am
Nov 7, 2000 at 9:58 pm -
8
me too
I too got somehow on the list without subscribing. Something is wrong. But I like it and will stay on. :) Bob Kernell Research Scientist Surface Validation Group Atmospheric Sciences Competency ...Robert Kernell
Nov 2, 2000 at 6:23 pm
Nov 4, 2000 at 12:12 am -
Which one of these should we use? int4 is a data type, int32 isn't. c.h has DatumGetInt8, but no DatumGetInt64; it also has DatumGetInt32 but no DatumGetInt4. fmgr has PG_GETARG_INT32 et al. ...
Peter Eisentraut
Nov 15, 2000 at 7:37 pm
Jan 23, 2001 at 2:24 am -
There is a special case in nabstime.h for AIX, which imho got swapped. The normal case for me would be INT_MIN and not the 0x80000001. There is a comment that I don't understand at all given the ...
Andreas Zeugswetter
Nov 10, 2000 at 6:19 pm
Jan 23, 2001 at 1:19 am -
I've a problem with initdb on beos with the current tree. (The last one running clean is one month old). when I run initdb, I get the following : $ initdb -d -n Running with debug mode on. Running ...
Cyril VELTER
Nov 26, 2000 at 10:25 am
Nov 29, 2000 at 4:26 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 240 |
posts | 1,390 |
users | 131 |
website | postgresql.org... |
irc | #postgresql |
131 users for November 2000
Archives
- August 2013 (1,430)
- July 2013 (1,772)
- June 2013 (2,428)
- May 2013 (1,555)
- April 2013 (1,283)
- March 2013 (1,441)
- February 2013 (1,366)
- January 2013 (2,520)
- December 2012 (1,701)
- November 2012 (1,618)
- October 2012 (1,580)
- September 2012 (1,195)
- August 2012 (1,180)
- July 2012 (1,125)
- June 2012 (1,850)
- May 2012 (1,584)
- April 2012 (1,459)
- March 2012 (1,921)
- February 2012 (1,517)
- January 2012 (1,777)
- December 2011 (1,347)
- November 2011 (1,764)
- October 2011 (1,687)
- September 2011 (1,623)
- August 2011 (1,433)
- July 2011 (1,658)
- June 2011 (2,404)
- May 2011 (1,664)
- April 2011 (1,834)
- March 2011 (1,956)
- February 2011 (2,476)
- January 2011 (2,965)
- December 2010 (2,587)
- November 2010 (2,109)
- October 2010 (2,113)
- September 2010 (2,173)
- August 2010 (2,061)
- July 2010 (1,612)
- June 2010 (1,560)
- May 2010 (1,961)
- April 2010 (1,575)
- March 2010 (1,314)
- February 2010 (2,439)
- January 2010 (3,118)
- December 2009 (2,514)
- November 2009 (493)
- October 2009 (1,903)
- September 2009 (1,990)
- August 2009 (2,170)
- July 2009 (2,025)
- June 2009 (1,565)
- May 2009 (1,518)
- April 2009 (1,431)
- March 2009 (1,424)
- February 2009 (1,399)
- January 2009 (2,641)
- December 2008 (2,011)
- November 2008 (1,918)
- October 2008 (1,695)
- September 2008 (1,887)
- August 2008 (1,374)
- July 2008 (1,495)
- June 2008 (1,149)
- May 2008 (1,112)
- April 2008 (1,908)
- March 2008 (1,288)
- February 2008 (1,309)
- January 2008 (1,220)
- December 2007 (989)
- November 2007 (1,369)
- October 2007 (1,553)
- September 2007 (1,225)
- August 2007 (1,221)
- July 2007 (1,007)
- June 2007 (1,127)
- May 2007 (1,189)
- April 2007 (1,266)
- March 2007 (1,866)
- February 2007 (1,916)
- January 2007 (1,645)
- December 2006 (1,423)
- November 2006 (1,021)
- October 2006 (1,565)
- September 2006 (2,375)
- August 2006 (2,039)
- July 2006 (1,626)
- June 2006 (1,624)
- May 2006 (1,366)
- April 2006 (1,150)
- March 2006 (1,327)
- February 2006 (1,259)
- January 2006 (1,030)
- December 2005 (1,252)
- November 2005 (1,568)
- October 2005 (1,417)
- September 2005 (1,464)
- August 2005 (1,191)
- July 2005 (1,150)
- June 2005 (1,576)
- May 2005 (1,592)
- April 2005 (1,004)
- March 2005 (1,069)
- February 2005 (969)
- January 2005 (1,100)
- December 2004 (949)
- November 2004 (1,210)
- October 2004 (1,059)
- September 2004 (951)
- August 2004 (1,601)
- July 2004 (1,397)
- June 2004 (1,037)
- May 2004 (1,446)
- April 2004 (1,167)
- March 2004 (1,330)
- February 2004 (1,003)
- January 2004 (861)
- December 2003 (827)
- November 2003 (1,618)
- October 2003 (1,602)
- September 2003 (1,683)
- August 2003 (1,343)
- July 2003 (1,045)
- June 2003 (1,302)
- May 2003 (802)
- April 2003 (1,012)
- March 2003 (1,242)
- February 2003 (1,323)
- January 2003 (1,315)
- December 2002 (1,176)
- November 2002 (1,220)
- October 2002 (1,449)
- September 2002 (1,816)
- August 2002 (2,295)
- July 2002 (1,290)
- June 2002 (1,024)
- May 2002 (1,157)
- April 2002 (1,532)
- March 2002 (1,207)
- February 2002 (1,225)
- January 2002 (1,397)
- December 2001 (963)
- November 2001 (1,301)
- October 2001 (1,155)
- September 2001 (895)
- August 2001 (1,204)
- July 2001 (938)
- June 2001 (1,131)
- May 2001 (1,458)
- April 2001 (1,168)
- March 2001 (1,672)
- February 2001 (1,154)
- January 2001 (1,450)
- December 2000 (1,222)
- November 2000 (1,390)
- October 2000 (1,296)
- September 2000 (633)
- August 2000 (888)
- July 2000 (1,428)
- June 2000 (1,283)
- May 2000 (1,648)
- April 2000 (184)
- March 2000 (291)
- February 2000 (1,464)
- January 2000 (1,639)
- December 1999 (1,056)
- November 1999 (916)
- October 1999 (949)
- September 1999 (946)
- August 1999 (695)
- July 1999 (1,070)
- June 1999 (1,242)
- May 1999 (1,136)
- April 1999 (218)
- March 1999 (1,002)
- February 1999 (692)
- January 1999 (758)
- December 1998 (591)
- November 1998 (600)
- October 1998 (1,208)
- September 1998 (678)
- August 1998 (856)
- July 1998 (482)
- June 1998 (496)
- May 1998 (618)
- April 1998 (702)
- March 1998 (1,118)
- February 1998 (1,307)
- January 1998 (855)
- December 1997 (346)
- November 1997 (374)
- October 1997 (575)
- September 1997 (549)
- August 1997 (404)
- July 1997 (391)
- June 1997 (595)
- May 1997 (478)
- April 1997 (854)
- March 1997 (526)
- February 1997 (297)
- January 1997 (927)
- December 1996 (2)
- November 1996 (1)
- October 1996 (1)
- October 1995 (2)
- July 1995 (1)