Search Discussions
-
People have complained that we store passwords unencrypted in pg_shadow. Long ago we agreed to a solution and I am going to try to implement that next. What we do now with crypt authentication is ...
Bruce Momjian
Jun 15, 2001 at 12:16 am
Jul 12, 2001 at 6:20 am -
38
Primary Key
Given the following CREATE TABLE instructions... 1) CREATE TABLE message ( int4 msgid PRIMARY KEY NOT NULL, text msgtext ); 2) CREATE TABLE message ( int4 msgid not null, text msgtext, PRIMARY KEY ...P. Dwayne Miller
Jun 19, 2001 at 7:01 pm
Jul 9, 2001 at 8:54 pm -
Actually I am not sure whether the column = NULL syntax is even defined or allowed in SQL92 (e.g. Informix interprets the NULL as column name in this context and errs out). If not it would simply be ...
Andreas Zeugswetter
Jun 7, 2001 at 8:09 am
Jun 29, 2001 at 12:16 pm -
I have seen problems with extremely many concurrent users. I run pgbench: pgbench -c 1000 -t 1 test And I get stuck spin lock errors. This is 100% reproducable (i.e. I have nerver succeeded in ...
Tatsuo Ishii
Jun 20, 2001 at 9:28 am
Jul 5, 2001 at 1:47 pm -
Hi all! I'm thinking about starting a (serius) project to bring a good graphical interface to the administration and operation of postgresql, similar to what other databases have. The goal is to be ...
Pedro Abelleira Seco
Jun 19, 2001 at 3:48 pm
Jun 22, 2001 at 11:01 pm -
[ - hackers ] Tom Lane writes: IMHO, nextval() isn't the greatest interface in the world. I do like the alternative (deprecated?) syntax sequence.nextval() because of the notational resemblence to ...
Peter Eisentraut
Jun 3, 2001 at 3:17 pm
Jun 14, 2001 at 1:41 am -
Let's switch 'timestamp with time zone' back to 'timestamp'. This just makes no sense. -- Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
Peter Eisentraut
Jun 17, 2001 at 10:57 pm
Sep 6, 2001 at 5:56 am -
I started thinking about Tom's idea to implement functions as table source. To me, it seems that a very few changes are necessary: a) parser must be changed to allow functioncall to be a table_ref ...
Alex Pilosov
Jun 26, 2001 at 9:01 pm
Jun 28, 2001 at 5:14 pm -
Hi, All! I've developed new data type for PostgreSQL - uniqueidentifier - 128-bit value claims to be unique across Universe. It depends on libuuid from e2fsprogs by Theodore Ts'o. Now I use it in my ...
Dmitry G. Mastrukov
Jun 26, 2001 at 7:59 pm
Jul 3, 2001 at 8:27 pm -
I know this topic was discussed a few months ago, but I'm wondering if any decisions have been reached on if, how, and when setuid functions and triggers might be implemented. If not, I have an idea ...
Mark Volpe
Jun 13, 2001 at 6:32 pm
Jun 25, 2001 at 1:09 pm -
17
7.2 stuff
How far off is 7.2? Ages? I want to add the rest of the ALTER TABLE functionality for 7.2, but I've just been busy - don't worry I haven't forgotten! This is my personal TODO list: * ALTER TABLE ADD ...Christopher Kings-Lynne
Jun 21, 2001 at 3:24 am
Feb 25, 2002 at 7:41 am -
In process of converting a bunch of scripts from sybase to postgresql I see something that doesn't make much sense.. I can grant a series of privileges (comma separated) on a series of objects (comma ...
Vince Vielhaber
Jun 7, 2001 at 2:23 pm
Jul 13, 2001 at 6:22 pm -
Alex Pilosov
Jun 22, 2001 at 9:16 pm
Jun 25, 2001 at 10:00 pm -
I know we're not in the business of copying mySQL, but the REPLACE INTO table (...) values (...) could be a useful semantic. This is a combination INSERT or UPDATE statement. For one thing, it is ...
Dale Johnson
Jun 5, 2001 at 7:09 pm
Jun 20, 2001 at 4:09 pm -
Hi, OK, all the high-frequently called functions of the pgstat stuff are macros (will commit that later today). Now about the per database configuration. The thing is that I don't know if it is worth ...
Jan Wieck
Jun 29, 2001 at 1:14 pm
Jun 29, 2001 at 9:34 pm -
Yeah, if anything the knee in the curve seems to be worse at 1024 buffers. Curious. Deserves more investigation, perhaps. This does remind me that I'd been thinking of suggesting that we raise the ...
Tom Lane
Jun 22, 2001 at 9:52 pm
Jun 23, 2001 at 6:47 pm -
We have the following item on TODO: * Overhaul pg_hba.conf host-based authentication Can people tell me what they want changed. I know we need the pg_shadow password field encrypted in the table and ...
Bruce Momjian
Jun 12, 2001 at 4:28 pm
Jul 23, 2001 at 9:56 am -
Hi, some PostgreSQL users in Japan have been translating 7.1 docs into Japanese. I hope the work would finish within 1-2 months. My question is how the translated docs could be merged into the doc ...
Tatsuo Ishii
Jun 18, 2001 at 1:03 am
Jun 18, 2001 at 10:15 pm -
I'm running postgres 6.5.3 and 7.0.3 and pg_dump gives me the following output: DROP TABLE "genrenametable"; CREATE TABLE "genrenametable" ( "genreid" int4, "name" character varying(128), ...
Robert Forsman
Jun 1, 2001 at 5:06 pm
Jun 4, 2001 at 9:58 pm -
(moved to -hackers list, since this is a *feature change* which should not just be discussed in -patches) Um, er... I'm not particularly happy about the solution, and would like to not see it in the ...
Thomas Lockhart
Jun 12, 2001 at 3:04 pm
Jun 20, 2001 at 8:48 pm -
Guys, Just installed a new data base in my server and while running vacuum analyze postgres dies with the following message: [...] NOTICE: Index pg_rewrite_oid_index: Pages 2; Tuples 16. CPU ...
Manuel Sugawara
Jun 15, 2001 at 7:10 pm
Jun 20, 2001 at 4:10 pm -
I noticed current wierd behaviour of a less/greater than comparisons of things involving inet/cidr: 10.1.2.3/8 is considered to be less than 10.0.0.0/32 The current logic does the following: a) ...
Alex Pilosov
Jun 11, 2001 at 1:37 pm
Jun 11, 2001 at 8:51 pm -
Hi, Is there any plans for making RPM's for 7.1.2 ? I'm particularily interested in RPM's for RH 6.2 as I have only a few sites running RH 7.x and can do the usual configure-make-make install on ...
Hannu Krosing
Jun 7, 2001 at 6:44 am
Jun 7, 2001 at 7:29 pm -
Had trouble getting ERWin to work with postgres (even with the Oracle look alike views). So, I wrote a small perl script which outputs XML for Dia to import. Works pretty good. More details can be ...
Rod Taylor
Jun 29, 2001 at 12:25 pm
Jul 3, 2001 at 9:18 pm -
Yes, optimal would imho also be if the foo() somehow had access to the where restriction, so it could only produce output, that the higher level is interested in, very cool. This would be extremely ...
Andreas Zeugswetter
Jun 27, 2001 at 8:35 am
Jun 27, 2001 at 1:19 pm -
Oracle. Except for Access Exclusive/Share Locks. Vadim
Mikheev, Vadim
Jun 21, 2001 at 9:29 pm
Jun 25, 2001 at 1:41 am -
Alex Pilosov
Jun 16, 2001 at 3:03 am
Jun 18, 2001 at 7:38 pm -
I notice that the signal handlers in postmaster.c do quite a lot of work, much more than what they teach you in school they should do. While fprintf, elog, and ctime may simply lead to annoyances, ...
Peter Eisentraut
Jun 14, 2001 at 5:37 pm
Jun 14, 2001 at 11:20 pm -
I had a baby girl on Tuesday. I am working through my backlogged emails today. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 ...
Bruce Momjian
Jun 9, 2001 at 10:30 pm
Jun 11, 2001 at 5:30 pm -
Baby girl on Jun 27. Vadim
Vadim Mikheev
Jun 30, 2001 at 6:57 am
Jul 2, 2001 at 3:50 pm -
Can one of you knowledgeable people tell me why current CVS as of a week ago would have the backend running this query grow to 600 meg+? INSERT into traffic_summary SELECT asn,protocol, ...
Larry Rosenman
Jun 22, 2001 at 4:03 pm
Jun 24, 2001 at 9:08 pm -
If USE_READLINE exists, but HAVE_RL_FILENAME_COMPLETION_FUNCTION does not, -current build breaks: gcc -O2 -pipe -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/interfaces/libpq ...
Alex Pilosov
Jun 15, 2001 at 10:45 pm
Jun 22, 2001 at 12:39 pm -
I saw someone else also saw this error. I am seeing it in 7.1.2 and I think I may have tracked it down. It's after a different operation but perhaps it is related. I have written a trigger. It dies ...
D'Arcy J.M. Cain
Jun 8, 2001 at 1:07 pm
Jun 10, 2001 at 7:27 am -
On hub, in /home/projects/pgsql/ftp/pub/dev I see *.tar.gz.md5 postgresql-opt-snapshot.tar.gz doc postgresql-opt-snapshot.tar.gz.md5 postgresql-base-snapshot.tar.gz postgresql-snapshot.tar.gz ...
Tom Lane
Jun 5, 2001 at 1:56 am
Jun 5, 2001 at 1:55 pm -
Hi all, One more question/comment. In order to track down the problem with the interaction between WebObjects and the PostgreSQL JDBC driver, I had to insert a fair amount of logging. This logging ...
Btoback
Jun 23, 2001 at 11:37 pm
Jun 28, 2001 at 12:27 pm -
We use uniq index for UK/PK but shouldn't. Jan? Vadim
Mikheev, Vadim
Jun 20, 2001 at 4:45 pm
Jun 25, 2001 at 12:41 pm -
I believe you are right: the spinlock doesn't need to be grabbed, because if a valid buffer is passed in, it must already be pinned (since the returned buffer is expected to be pinned). Hence the ...
Tom Lane
Jun 8, 2001 at 9:58 pm
Jun 19, 2001 at 1:11 am -
Hiroshi asked me to reproduce the problem WRT Access 97 and NULLs. I could not. A couple of years ago the problem was appearing on the interfaces list as some users using ODBC were experiencing the ...
Mike Mascari
Jun 14, 2001 at 8:07 pm
Jun 18, 2001 at 11:47 pm -
In PQexec() and also in parseInput() (both fe-exec.c) there is a provision for, if more than one result set is returned, to concatenate the error messages (while only returning the last result set). ...
Peter Eisentraut
Jun 5, 2001 at 7:50 pm
Jun 8, 2001 at 3:01 pm -
If someone was interested in joining the development team, where would they... - Find a description of the open source development process used by the PostgreSQL team. - Find the development ...
P. Dwayne Miller
Jun 22, 2001 at 4:01 pm
Nov 27, 2001 at 11:41 pm -
Well, I'm on my way to implement what was discussed on list before. I am doing it the way Karel and Jan suggested: creating a pg_class/pg_attribute tuple[s] for a function that returns a setof. I ...
Alex Pilosov
Jun 29, 2001 at 6:36 pm
Jul 1, 2001 at 1:28 pm -
Here is my proposal to fix the security problem of storing cleartext passwords in pg_shadow. The solution is somewhat complex because we have to allow 7.2 servers to communicate with 7.1 clients, at ...
Bruce Momjian
Jun 26, 2001 at 3:04 am
Jun 26, 2001 at 4:34 am -
I make queries on catalog tables in order get metadata about table attributes. I need this metadata in order to help me controlling the data that users enter using html forms dynamically generated ...
Bernardo Pons
Jun 22, 2001 at 9:17 pm
Jun 24, 2001 at 2:59 pm -
Hi all, While testing postgresql with openssl on Unixware, I had this problem that psql alaways replied "PRGN not seeded". That because psql does'nt not seed it in anyway. That's all right on systems ...
Olivier PRENANT
Jun 21, 2001 at 8:32 pm
Jun 23, 2001 at 6:07 pm -
If we did this the straightforward way (exchange authentication packets after fork()) then rogue clients could connect, start a backend, twiddle thumbs, never finish the authentication exchange, ...
Peter Eisentraut
Jun 14, 2001 at 4:30 pm
Jun 17, 2001 at 9:58 am -
Could I ask a huge favour of the experienced PostgreSQL hackers to make a simple page on the postgreSQL.org website listing TODO items that newbie hackers can get stuck into? I was thinking of doing ...
James Buchanan
Jun 5, 2001 at 7:03 pm
Jun 11, 2001 at 1:22 pm -
Microsoft Access is the guilty party, IIRC. I recently tried to stir up some interest in changing this behavior back to the standard, but apparently there are still too many people using broken ...
Tom Lane
Jun 7, 2001 at 2:21 am
Jun 11, 2001 at 1:11 pm -
Hi All, I'm developing (currently in pre-alfa stage) a Acucobol interface for the Postgresql. The Acucobol runtime have a generic FS API interface that handle the work with the record oriented files, ...
Roberto Fichera
Jun 5, 2001 at 7:05 pm
Jun 8, 2001 at 8:48 am -
Tom, I have a problem with slow query execution (postgresql 7.1.2): There are 2 tables - idx, msg_prt: bug=# \dt List of relations Name | Type | Owner ---------+-------+-------- idx | table | megera ...
Oleg Bartunov
Jun 5, 2001 at 2:12 pm
Jun 5, 2001 at 7:03 pm -
Probably not :-( PS. ...may be someone in hackers list port it to 7.1 (see CC) -- Karel Zak <zakkr@zf.jcu.cz http://home.zf.jcu.cz/~zakkr/ C, PostgreSQL, PHP, WWW, http://docs.linux.cz, ...
Karel Zak
Jun 21, 2001 at 12:00 pm
Feb 22, 2002 at 1:08 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 228 |
posts | 1,131 |
users | 159 |
website | postgresql.org... |
irc | #postgresql |
159 users for June 2001
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)