Search Discussions

228 discussions - 1,131 posts

  • 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 MomjianBruce Momjian
    Jun 15, 2001 at 12:16 am
    Jul 12, 2001 at 6:20 am
  • 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 MillerP. 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 ZeugswetterAndreas 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 IshiiTatsuo 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 SecoPedro 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 EisentrautPeter 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 EisentrautPeter 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 PilosovAlex 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. MastrukovDmitry 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 VolpeMark Volpe
    Jun 13, 2001 at 6:32 pm
    Jun 25, 2001 at 1:09 pm
  • 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-LynneChristopher 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 VielhaberVince Vielhaber
    Jun 7, 2001 at 2:23 pm
    Jul 13, 2001 at 6:22 pm
  • Alex PilosovAlex 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 JohnsonDale 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 WieckJan 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 LaneTom 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 MomjianBruce 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 IshiiTatsuo 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 ForsmanRobert 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 LockhartThomas 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 SugawaraManuel 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: is considered to be less than The current logic does the following: a) ...
    Alex PilosovAlex 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 KrosingHannu 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 TaylorRod 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 ZeugswetterAndreas Zeugswetter
    Jun 27, 2001 at 8:35 am
    Jun 27, 2001 at 1:19 pm
  • Oracle. Except for Access Exclusive/Share Locks. Vadim
    Mikheev, VadimMikheev, Vadim
    Jun 21, 2001 at 9:29 pm
    Jun 25, 2001 at 1:41 am
  • Alex PilosovAlex 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 EisentrautPeter 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 MomjianBruce Momjian
    Jun 9, 2001 at 10:30 pm
    Jun 11, 2001 at 5:30 pm
  • Baby girl on Jun 27. Vadim
    Vadim MikheevVadim 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 RosenmanLarry 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 PilosovAlex 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. CainD'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 LaneTom 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 ...
    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, VadimMikheev, 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 LaneTom 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 MascariMike 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 EisentrautPeter 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 MillerP. 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 PilosovAlex 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 MomjianBruce 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 PonsBernardo 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 PRENANTOlivier 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 EisentrautPeter 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 BuchananJames 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 LaneTom 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 FicheraRoberto 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 BartunovOleg 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 ZakKarel Zak
    Jun 21, 2001 at 12:00 pm
    Feb 22, 2002 at 1:08 pm
Group Navigation
period‹ prev | Jun 2001 | next ›
Group Overview
grouppgsql-hackers @

159 users for June 2001

Tom Lane: 205 posts Bruce Momjian: 126 posts Peter Eisentraut: 72 posts Alex Pilosov: 71 posts Andreas Zeugswetter: 38 posts Jan Wieck: 30 posts Hannu Krosing: 26 posts Mark L. Woodward: 23 posts Jim Mercer: 22 posts The Hermit Hacker: 19 posts Oleg Bartunov: 18 posts Tatsuo Ishii: 17 posts Christopher Kings-Lynne: 15 posts Vince Vielhaber: 15 posts Hiroshi Inoue: 13 posts Nathan Myers: 13 posts Joe Conway: 12 posts Stephan Szabo: 11 posts Thomas Lockhart: 10 posts D'Arcy J.M. Cain: 9 posts
show more