Search Discussions
-
Hello, While trying to optimise a query I found that running VACUUM ANALYSE changed all the Index Scans to Seq Scans and that the only way to revert to Index Scans was the add "enable_seqscan = 0" in ...
Louis-David Mitterrand
Apr 16, 2002 at 2:03 pm
Jun 27, 2002 at 3:38 am -
OK, would people please vote on how to handle SET in an aborted transaction? This vote will allow us to resolve the issue and move forward if needed. In the case of: SET x=1; BEGIN; SET x=2; ...
Bruce Momjian
Apr 23, 2002 at 4:27 pm
Apr 30, 2002 at 3:06 am -
Current CVS tip has most of the needed infrastructure for SQL-spec schema support: you can create schemas, and you can create objects within schemas, and search-path-based lookup for named objects ...
Tom Lane
Apr 30, 2002 at 5:31 pm
Jun 12, 2002 at 3:44 am -
44
7.3 schedule
Is anyone feeling we have the 7.3 release nearing? I certainly am not. I can imagine us going for several more months like this, perhaps through August. -- Bruce Momjian | http://candle.pha.pa.us ...Bruce Momjian
Apr 11, 2002 at 4:51 am
Apr 18, 2002 at 4:13 am -
I was originally planning to revise pg_aggregate along the same lines as pg_proc and so forth: add an aggnamespace column and fix the search code to be namespace-aware. But it seemed a tad annoying ...
Tom Lane
Apr 6, 2002 at 7:27 am
Apr 18, 2002 at 4:00 am -
Hi, I'm playing with the new schema functionality. I login to a database as a user yamada. There I created 2 schemas yamada and inoue. By accident I made 2 tables with the same name vs1 in both ...
Hiroshi Inoue
Apr 4, 2002 at 3:40 am
Apr 19, 2002 at 9:03 am -
From here: http://osdb.sourceforge.net/ We find this quote: "For you long-suffering OSDB PostgreSQL users, we offer --postgresql=no_hash_index to work around the hash index problems of OSDB with ...
Dann Corbit
Apr 22, 2002 at 9:16 pm
Jun 22, 2002 at 4:02 am -
I've been thinking about exactly what to do with access privileges for namespaces (a/k/a schemas). The SQL99 spec isn't much guidance, since as far as I can tell it doesn't have explicit privileges ...
Tom Lane
Apr 18, 2002 at 11:14 pm
Apr 22, 2002 at 3:25 am -
Since I'm about to have to edit pg_proc.h to add a namespace column, I thought this would be a good time to revise the current proiscachable column into the three-way cachability distinction we've ...
Tom Lane
Apr 2, 2002 at 9:40 pm
Apr 13, 2002 at 3:34 pm -
It would be nice if total table cardinality could be maintained live. So (after the initial vacuum) we update the cardinality for each table in the system table (or perhaps add an entry to the table ...
Dann Corbit
Apr 5, 2002 at 6:58 pm
Apr 8, 2002 at 3:23 am -
Hi Tom, How about we include this and have configure somehow ensure the Solaris users get it automatically? There are a *bunch* of Solaris users out there. :-) Regards and best wishes, Justin Clift ...
Justin Clift
Apr 3, 2002 at 8:02 am
Jun 6, 2002 at 5:49 pm -
I've applied patches to implement an int64-based data/time storage scheme. I've also accumulated some other minor fixes, which result in an initdb being required (sorry!). Note that the *default* ...
Thomas Lockhart
Apr 21, 2002 at 8:02 pm
Apr 22, 2002 at 2:57 am -
The emitted code might or might not be the same --- but duplicate or near-duplicate chunks of source code are always best avoided, if only from a maintenance perspective. Try chasing the references ...
Tom Lane
Apr 11, 2002 at 3:09 am
Apr 18, 2002 at 3:26 am -
Can someone comment on this? I can't decide. --------------------------------------------------------------------------- Andreas Scherbaum wrote: -- Bruce Momjian | http://candle.pha.pa.us ...
Bruce Momjian
Apr 18, 2002 at 3:46 am
Apr 25, 2002 at 2:34 pm -
Hi all, I'm working on a fairly large patch (cleaning up Karel Zak's PREPARE/EXECUTE work), and I'm having some problems with bison (I'm a yacc newbie). In fact, my grammar currently has an obscene ...
Neil Conway
Apr 11, 2002 at 1:29 am
Apr 12, 2002 at 4:20 pm -
I've detected that the restoring of large objects may consume huge amounts of diskspace when using unusual blocksizes (e.g. 32KB). My setup is Postgresql-7.2.1 + 32KB blocks + LOBLKSIZE 16KB, a ...
Mario Weilguni
Apr 11, 2002 at 8:55 am
May 3, 2002 at 12:29 pm -
I posted this some time ago to pgsql-bugs[1], to no response. So I'll venture to try here. Postgres breaks the standard for string literals by supporting C-like escape sequences. This causes pain for ...
Andrew Pimlott
Apr 24, 2002 at 6:05 pm
Jun 6, 2002 at 7:27 pm -
Appended is a message that I sent to the pgsql-general list, and for which I received no useful reply. (Well, anyway, no reply that has helped me to speed up my imports.) If you've read it already, ...
Curt Sampson
Apr 15, 2002 at 6:48 am
Apr 16, 2002 at 5:15 am -
After some fooling around with gram.y, I have come to the conclusion that there's just no way to use a schema-qualified name for an operator in an expression. I was hoping we might be able to write ...
Tom Lane
Apr 15, 2002 at 4:43 pm
Apr 16, 2002 at 11:03 pm -
I submitted a patch which would make Postgresql ANSI compliant in regards to INSERT with a provided column list. As Tom states below, this is not full compliance. CREATE TABLE tab(col1 text, col2 ...
Rod Taylor
Apr 15, 2002 at 4:01 am
Apr 16, 2002 at 2:45 am -
PQescapebytea() is not multibyte aware and will produce bad multibyte character sequences. Example: INSERT INTO t1(bytea_col) VALUES('characters produced by PQescapebytea'); ERROR: Invalid EUC_JP ...
Tatsuo Ishii
Apr 5, 2002 at 6:26 am
Apr 8, 2002 at 3:52 am -
Can we enable syslog support by default for 7.3? -- Tatsuo Ishii
Tatsuo Ishii
Apr 19, 2002 at 2:35 am
Apr 26, 2002 at 1:57 pm -
The determination of locale is now done as follows: collate/ctype: initdb --lc-collate, initdb --locale, LC_ALL, LC_COLLATE, LANG messages/monetary/numeric/time: Have GUC variables lc_messages, etc. ...
Peter Eisentraut
Apr 3, 2002 at 5:47 am
Apr 4, 2002 at 4:46 am -
Hi, Would it be an idea to have pg_dump append an ANALYZE; command to the end of its dumps to assist newbies / inexperienced admins? Reason being is that I noticed that when I just restored a 50MB ...
Christopher Kings-Lynne
Apr 3, 2002 at 1:40 am
Apr 4, 2002 at 6:14 pm -
[Please CC any replies, I'm subscribed nomail] Hi, Chapter 7 of the Developers guide in about the Page Format on disk and it's a little out of date not to mention somewhat incomplete. 1. Is there ...
Martijn van Oosterhout
Apr 20, 2002 at 2:22 pm
Jun 20, 2002 at 10:27 pm -
Hi All, With regards to the proposed command.c refactoring... I've done it by removing command.c and replacing it with portal.c alter.c lock.c namespace.c Is that a good idea? Will it break too many ...
Christopher Kings-Lynne
Apr 3, 2002 at 8:39 am
Apr 14, 2002 at 11:12 pm -
I was just fooling around with replacing the existing plain index on pg_trigger.tgrelid with a unique index on (tgrelid, tgname). In theory this should not affect anything --- the code already ...
Tom Lane
Apr 19, 2002 at 2:02 am
Apr 23, 2002 at 4:56 pm -
[I've moved this discussion about changing the line pointer from four bytes to two from -general to -hackers, since it's fairly technical. The entire message Tom is responding to is appended to this ...
Curt Sampson
Apr 20, 2002 at 8:07 am
Apr 21, 2002 at 7:51 pm -
Hi all, I've attached an updated version of Karel Zak's pg_qcache patch, which adds PREPARE/EXECUTE support to PostgreSQL (allowing prepared SQL statements). It should apply cleanly against CVS HEAD, ...
Neil Conway
Apr 13, 2002 at 10:47 pm
Apr 16, 2002 at 3:51 pm -
Here is the resignation letter from Jordan Hubbard, long time FreeBSD core member. The interesting part is where he explains that being in the core/hackers group isn't fun anymore: ...
Bruce Momjian
Apr 30, 2002 at 1:50 am
Apr 30, 2002 at 5:10 am -
I agree that we don't want to reinstate that hack on the gram.y side. However, it seems to me way past time that we did what needs to be done with variable.c --- ie, get rid of it. All these ...
Tom Lane
Apr 21, 2002 at 9:52 pm
Apr 22, 2002 at 12:06 am -
pg_dumping a table having a primary key yields commands like -- -- TOC Entry ID 2 (OID 139812) -- -- Name: table1 Type: TABLE Owner: postgres -- CREATE TABLE "table1" ( "column10" character ...
Tom Lane
Apr 12, 2002 at 5:28 pm
Apr 13, 2002 at 7:57 pm -
Take this update statement: update mytable set foo=foo+1 where bar='xxx'; If that gets executed more than once at the same time by multiple instances of postgresql. Will foo ever lose a count? I am ...
Mlw
Apr 3, 2002 at 2:28 pm
Apr 4, 2002 at 1:38 am -
Hi all, Why does the password_encryption GUC variable default to false? AFAICT there shouldn't be any issues with client compatibility -- in fact, I'd be inclined to rip out all support for storing ...
Neil Conway
Apr 25, 2002 at 5:21 am
Apr 25, 2002 at 8:26 pm -
I'd like to implement *something* to help us collect information on what platforms actually have what features. This would be useful, for example, for figuring out whether any platforms are lacking 8 ...
Thomas Lockhart
Apr 23, 2002 at 5:20 am
Apr 24, 2002 at 6:28 pm -
Hi all, Here's an updated version of the experimental qCache patch I posted a couple days ago (which is a port of Karel Zak's 7.0 work to CVS HEAD). Changes: - fix segfault in EXECUTE under some ...
Neil Conway
Apr 17, 2002 at 9:17 pm
Apr 18, 2002 at 9:04 am -
On the note of NAMEDATALEN, a view in the INFORMATION_SCHEMA definition is exactly 2 characters over the current limit. ADMINISTRABLE_ROLE_AUTHORIZATIONS Not that it's a great reason, but it isn't a ...
Rod Taylor
Apr 16, 2002 at 3:19 am
Apr 16, 2002 at 6:12 pm -
I'm running into a minor issue with security in regards to users being able to see constructs that they have no access too. The solution? Information_Schema coupled with no direct access to ...
Rod Taylor
Apr 15, 2002 at 1:26 am
Apr 15, 2002 at 5:01 am -
Hi everyone, This is Prof. Bayer's response to the question "is it alright to use UB-Tree's in Open Source projects?". It's a "No, but we can discuss a licensing model" type answer. Regards and best ...
Justin Clift
Apr 10, 2002 at 2:35 pm
Apr 12, 2002 at 4:41 pm -
Hi all, Some questions: 1. What is the difference between abstime and timestamp - they seem to display equally... 2. Since int4 and abstime are binary compatible (ie int4::abstime works), is there ...
Christopher Kings-Lynne
Apr 4, 2002 at 4:48 am
Apr 5, 2002 at 3:13 pm -
Over this past weekend, the PostgreSQL Global Development Group packaged up and put onto our ftp server PostgreSQL v7.2.1 ... a bug fix release, it fixes a critical bug in v7.2: sequence counters ...
Marc G. Fournier
Apr 2, 2002 at 2:08 pm
Apr 2, 2002 at 5:30 pm -
For tracking of Foreign Keys, Check constraints, and maybe NULL / NOT NULL (specific type of check constraint) I intend to create (as per suggestion) pg_constraint. conrelid conname contype ('c'heck, ...
Rod Taylor
Apr 26, 2002 at 2:31 am
Apr 26, 2002 at 5:29 pm -
The Firebird guys have gotten around to releasing 1.0. If you read this front page spiel, you'll notice that they use MVCC, but with an overwriting storage manager. ...
Christopher Kings-Lynne
Apr 16, 2002 at 4:35 am
Apr 16, 2002 at 11:14 pm -
Has anyone seen this: ERROR: dtoi4: integer out of range on 7.1.3 What worries me, is that at startup time, the log shows: DEBUG: database system was shut down at 2002-04-02 23:16:52 EEST DEBUG: ...
Daniel Kalchev
Apr 2, 2002 at 8:25 pm
Apr 3, 2002 at 3:28 pm -
Appears psql needs to know how to differentiate between it's own temp tables and those of another connection. On the plus side, this takes care of a TODO item to add temp table listings to psql. ...
Rod Taylor
Apr 30, 2002 at 1:23 am
May 25, 2002 at 10:45 pm -
Assuming the following fetch statement in embedded SQL/C: EXEC SQL FETCH ALL IN selectFromTable_cur INTO :array1, :array2; is memory automatically allocated (by experimentation I guess so)? Should ...
Lee Kindness
Apr 25, 2002 at 11:42 am
May 6, 2002 at 1:59 pm -
Caveat: I'm not a pg hacker, I apologize in advance if this is a dumb question, but it has been nagging at me, and I don't know who else to ask. If the WAL is a record of all transactions, and if the ...
Mike Biamonte
Apr 24, 2002 at 2:07 pm
Apr 27, 2002 at 1:18 pm -
I've been poking at the scanner a bit using the large literal test case from the other day http://archives.postgresql.org/pgsql-hackers/2002-04/msg00811.php I've been able to reduce the wall-clock ...
Peter Eisentraut
Apr 19, 2002 at 4:57 pm
Apr 21, 2002 at 2:05 am -
In my understanding, our consensus was enabling multibyte support by default for 7.3. Any objection? -- Tatsuo Ishii
Tatsuo Ishii
Apr 16, 2002 at 1:21 am
Apr 17, 2002 at 2:10 am -
RPMs for 7.2.1 are immediately available for download from ftp://ftp.postgresql.org/pub/binary/v7.2.1/RPMS Binary RPMs available are for RedHat-skipjack 7.2.93 and RedHat 6.2/SPARC, and the source ...
Lamar Owen
Apr 14, 2002 at 3:59 am
Apr 14, 2002 at 7:59 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 164 |
posts | 1,531 |
users | 136 |
website | postgresql.org... |
irc | #postgresql |
136 users for April 2002
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)