Search Discussions
-
46
subselects
Vadim, I know you are still thinking about subselects, but I have some more clarification that may help. We have to add phantom range table entries to correlated subselects so they will pass the ...Bruce Momjian
Jan 9, 1998 at 4:00 am
Jan 21, 1998 at 4:03 pm -
When the postmaster crashes, it leaves the /tmp/.s.pgsql file in /tmp. Is there a way to auto-remove it after a postmaster crash? -- Bruce Momjian maillist@candle.pha.pa.us
Bruce Momjian
Jan 26, 1998 at 9:30 pm
Jan 30, 1998 at 3:41 am -
OK, general question. Does pg_user need to be readable? Do non-postgres users want to see who owns each table? I don't know. -- Bruce Momjian maillist@candle.pha.pa.us
Bruce Momjian
Jan 11, 1998 at 9:54 pm
Jan 20, 1998 at 8:01 pm -
I just wrote about issues regarding upping the max blocksize. There is stuff in storage/itemid.h that would need to be modified (also in bufmgr.h, but that is trivial). Th idea is that: typedef ...
Integration
Jan 4, 1998 at 4:05 am
Jan 5, 1998 at 1:31 pm -
24
subselect
I was thinking about subselects, and how to attach the two queries. What if the subquery makes a range table entry in the outer query, and the query is set up like the UNION queries where we put the ...Bruce Momjian
Jan 5, 1998 at 5:16 am
Jan 6, 1998 at 5:31 am -
Yes, that's one of the things I don't understand with PostgreSQL. ERROR would be much better. It would be even better if the backend would have an option to log all messages via syslog. That would be ...
Mattias Kregert
Jan 2, 1998 at 4:30 pm
Jan 6, 1998 at 12:08 am -
Without order by the result set is never guaranteed to be ordered in a specific way (standard speak). The order is dependent on the chosen query path, which changes from query to query. Andreas
Zeugswetter Andreas DBT
Jan 27, 1998 at 10:13 am
Jan 29, 1998 at 3:01 pm -
Hi again, It seems unfortunate, but if I can't efficiently (i.e. no copying of whole table, no blocking and using index) browse the table, I might not be able to "sell" postgres into the commercial ...
Jan Vicherek
Jan 23, 1998 at 9:51 pm
Jan 24, 1998 at 10:43 pm -
Not sure, but this one is about the only major thing that is continuing to bother me :( Is there any method of improving this? This oen is improved upon in v6.3, where at compile time you can ...
The Hermit Hacker
Jan 17, 1998 at 11:08 pm
Jan 21, 1998 at 8:17 pm -
Hi, I created a table with two columns of type int, and loaded about 300 K records in it. So, the total size of the table is approx. that of 600 K integers, roughly 2.4 MB. But, the file ...
Shiby Thomas
Jan 6, 1998 at 11:10 pm
Jan 7, 1998 at 7:30 pm -
Mark me down for it... ------------------------------
The Hermit Hacker
Jan 2, 1998 at 6:38 pm
Jan 5, 1998 at 4:10 pm -
12
tables >2GB
Now that we know the storage manager code that splits tables over 2GB into separate files doesn't work(Irix), can we rip out that code and just use the OS code to access 2GB files as normal files. ...Bruce Momjian
Jan 29, 1998 at 5:32 am
Mar 21, 1998 at 2:58 pm -
The last we discussed in pgsql-hackers was that OIDs would not be dropped... Nobody is actively *removing* OO features...or at least not that I'm aware of...we (the developers) are addressing ...
The Hermit Hacker
Jan 14, 1998 at 1:17 pm
Jan 17, 1998 at 6:45 am -
Hello all, WARNING : It's a long mail, but please have patience and read it *all* I have reached a point in developing PgAccess when I discovered that some functions in libpgtcl are bad implemented ...
Constantin Teodorescu
Jan 5, 1998 at 6:43 pm
Jan 7, 1998 at 3:49 pm -
I am still wondering why postmaster fork/exec instead of just forking when receiving a new connection. Fork on modern unices (linux and (a think) *BSD) cost almost nothing (in time and memory) thanks ...
Goran Thyni
Jan 24, 1998 at 7:25 pm
Jan 25, 1998 at 6:39 pm -
A few things that I have noticed will be affected by allowing the disk block size to be other than 8k. (4k, 8k, 16k or 32k) 1. Rules The rule system currently stores plans as tuples in pg_rewrite. ...
Darren King
Jan 8, 1998 at 5:32 pm
Jan 10, 1998 at 12:39 pm -
The Hermit Hacker
Jan 25, 1998 at 7:12 am
Jan 28, 1998 at 12:52 am -
Here they are: --------------------------------------------------------------------------- GROUP BY bug of duplicates GROUP BY nulls bug ORDER BY nulls(Vadim?) many OR's exhaust optimizer ...
Bruce Momjian
Jan 22, 1998 at 3:08 am
Jan 23, 1998 at 11:45 am -
OK, we never installed this for 6.2 because we were already in Beta. Can we do this for 6.3? Vadim suggested we make this part of libpq, so all applications could make use of it. I have one of the ...
Bruce Momjian
Jan 11, 1998 at 8:18 pm
Jan 18, 1998 at 7:34 pm -
I am now thinking about this patch, and I don't think I like it. The original code allowed APPEND-only for users who can create databases, but no DELETE. The patch gives them DELETE permission, so ...
Bruce Momjian
Jan 6, 1998 at 5:00 pm
Jan 7, 1998 at 2:31 am -
9
inlining
Let me add, I am not inlining all the functions, but only the top part of them that deals with cachoffsets and nulls. These are the easy ones, and the ones that get used most often. -- Bruce Momjian ...Bruce Momjian
Jan 30, 1998 at 6:01 am
Feb 1, 1998 at 7:28 pm -
While looking thru the nodeGroup code, I noticed the following that I'm not sure is correct. -- Using 01-09 snapshot create table t1 (a int4, b char(2), c char(2)); CREATE insert into t1 (a,c) values ...
Darren King
Jan 17, 1998 at 10:11 pm
Jan 27, 1998 at 3:39 pm -
I've been seeing trouble with varchar() columns for a little while, and since it is still there with a fresh install of the development tree it's time to report it: postgres= create table t (v ...
Thomas G. Lockhart
Jan 12, 1998 at 2:54 pm
Jan 19, 1998 at 7:12 pm -
Vadim, can you look at this for me. If you set a break at ExecEvalVar before executing the SELECT, you will see its tupledescriptor- attrs[0].attlen is the max length, and not -1 as it should be. I ...
Bruce Momjian
Jan 13, 1998 at 6:01 am
Jan 18, 1998 at 8:29 am -
While implementing a method to retrieve the permissions on a table, the statement: "grant all on test to public;" kills the backend. -- Peter T Mount petermount@earthling.net or ...
Peter T Mount
Jan 8, 1998 at 10:07 pm
Jan 11, 1998 at 12:44 pm -
unsubscribe
Andy Doerr
Jan 12, 1998 at 3:08 pm
Jan 29, 1998 at 2:57 pm -
I have a potential patch for the glibc2 date problem; however I can't test it because the snapshot won't build. Has this build error been cured recently, or do I have my own unique problem? O/S: ...
Oliver Elphick
Jan 15, 1998 at 12:48 pm
Jan 16, 1998 at 3:55 pm -
Well, I've rebuilt postgres again, using a fresh cvs snapshot, and grant is still broken. Infact, it gets worse. Once you try to use the grant statement, then any other connection that was active at ...
Peter T Mount
Jan 13, 1998 at 8:06 pm
Jan 14, 1998 at 3:40 pm -
Does someone want to remind me why we allocate the full size for char() and varchar(), when we really can just allocate the size of the given string? I relize char() has to be padded, but why ...
Bruce Momjian
Jan 7, 1998 at 6:00 pm
Jan 13, 1998 at 8:57 am -
Do people want the overhead of char(), varchar(), and text to be reduced from 4-bytes to 2-bytes. We store the length in this overhead, but since we have a size limit on tuple size, we can't have a ...
Bruce Momjian
Jan 21, 1998 at 10:00 pm
Jan 22, 1998 at 4:01 pm -
Got my Linux Journal today and the first featured article is entitled "PostgreSQL - The Linux of Databases" Now scrappy, before you get bent out of joint, they mean this in a nice way ;-) The author ...
Thomas G. Lockhart
Jan 15, 1998 at 4:24 am
Jan 16, 1998 at 4:25 pm -
Hi all, in the current snapshot there is no default for PGHOST in src/interfaces/libpq/fe-connect.c. In 6.2 this was 'localhost', which is a reasonable default. If there is no real reason for not ...
Edmund Mergl
Jan 10, 1998 at 8:50 am
Jan 10, 1998 at 8:02 pm -
Hi, I read this message on the debian development list. Thought it might be of interest to scrappy on the PostODBC thingie... Maarten ...
Maarten Boekhold
Jan 24, 1998 at 10:32 am
Jan 26, 1998 at 10:31 am -
Developers Frequently Asked Questions (FAQ) for PostgreSQL Last updated: Thu Jan 22 15:04:10 EST 1998 Current maintainer: Bruce Momjian (maillist@candle.pha.pa.us) The most recent version of this ...
Bruce Momjian
Jan 22, 1998 at 8:05 pm
Jan 22, 1998 at 10:35 pm -
Here's a blast from the past. Shows how I keep those open issues in my mailbox. Forwarded message: -- Bruce Momjian maillist@candle.pha.pa.us
Bruce Momjian
Jan 10, 1998 at 3:30 am
Jan 22, 1998 at 3:02 am -
I installed some patches today for the univel port, and one of the changes did the following to include/storage/s_lock.h: 302c318 < __asm__("xchgb %0,%1": "=q"(_res), "=m"(*lock):"0"(0x1)); \ --- ...
The Hermit Hacker
Jan 18, 1998 at 1:39 am
Jan 20, 1998 at 7:39 pm -
With Ingres and Informix char() is fixed size, while varchar() is VARiable size. -- Bruce Momjian maillist@candle.pha.pa.us
Bruce Momjian
Jan 8, 1998 at 3:17 am
Jan 9, 1998 at 6:30 pm -
On linux-elf: pqcomm.c: In function `StreamServerPort': pqcomm.c:605: structure has no member named `sun_len' pqcomm.c: In function `StreamOpen': pqcomm.c:760: structure has no member named `sun_len' ...
Serj
Jan 27, 1998 at 8:45 am
Jan 28, 1998 at 1:05 am -
They optimise sorting (use indexes) as well and so make it doable using cursors I even think that Oracle can use indexes for some cases of count(*) and min() and max(). It actually works for forward ...
Hannu Krosing
Jan 24, 1998 at 9:21 am
Jan 25, 1998 at 5:37 am -
Unfortunately, with the way that the currencies fluctuate, it will vary greatly...but yes, it is in Canadian dollars. Yes, this is not a problem Marc G. Fournier Systems Administrator @ hub.org ...
The Hermit Hacker
Jan 23, 1998 at 4:01 am
Jan 23, 1998 at 5:26 pm -
Hi... Well, since this has all sort of died off, and since I'd like to get some resolution on it. Does anyone here *understand* the LGPL? If we put the ODBC drivers *under* src/interfaces, does that ...
The Hermit Hacker
Jan 12, 1998 at 6:13 pm
Jan 16, 1998 at 4:31 pm -
Seems like the discussion on views and access control is drifting in a direction that interests me. At the risk of once again bringing up an issue that's already been solved and tabled, I offer the ...
De Clarke
Jan 14, 1998 at 8:24 pm
Jan 16, 1998 at 4:21 am -
Hi, I have installed PostgreSQL6.2.1 from my own user account (I was just trying to test out something first). It seems to be running too slow. For example, the self join of a table with roughly 300K ...
Shiby Thomas
Jan 15, 1998 at 6:02 pm
Jan 16, 1998 at 3:31 am -
Hi all, Have just tried 9. Jan snapshot on AIX 4.1.5, compiles with gcc not with cc (fails in heaptuple.c), aix won't get defined though, did a -Daix The as keyword is now obligatory as in: ...
Zeugswetter Andreas DBT
Jan 9, 1998 at 3:18 pm
Jan 9, 1998 at 8:11 pm -
I have just fixed many of these WARN problems. I am looking at the new results. The first problem: ====== boolean ====== 166,168d165 < |f |f < |f |f < |f |f 170a168 173a172 176a176 is because the ...
Bruce Momjian
Jan 6, 1998 at 7:58 pm
Jan 7, 1998 at 9:45 am -
PostgreSQL seem to have a lot of names; Postgres 95, Postgres, Pg, Pgsql ... All these names are used in FAQ, filenames, docs, installation info, messages etc. Examples: The backend executable is ...
Mattias Kregert
Jan 20, 1998 at 2:00 pm
Mar 18, 1998 at 3:25 pm -
Try changing your OS default memory size. Unsure how to do this under AIX. -- Bruce Momjian maillist@candle.pha.pa.us
Bruce Momjian
Jan 12, 1998 at 5:00 pm
Mar 16, 1998 at 5:09 am -
As far as I know, none of these are ready for 6.3, which is due on Sunday. What is the game plan, folks? And the tools/RELEASE_CHANGES files have not been updated. I will do the FAQ, TODO, HISTORY ...
Bruce Momjian
Jan 30, 1998 at 6:30 am
Feb 1, 1998 at 5:30 am -
Any reason why the whole domain appears to be dead? Anything I can do to help? ---------- Sincerely Yours, Simon Shapiro Shimon@Simon-Shapiro.ORG Voice: 503.799.2313
Simon Shapiro
Jan 28, 1998 at 1:27 am
Jan 28, 1998 at 4:52 pm -
I believe I found a bug. If a user other than the postgres superuser is given permission to create databases, then he should be able to destroy the databases he creates. Currently he can't, at least ...
Kevin Witten
Jan 6, 1998 at 3:57 am
Jan 6, 1998 at 5:30 am
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 207 |
posts | 852 |
users | 76 |
website | postgresql.org... |
irc | #postgresql |
76 users for January 1998
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)