FAQ

Search Discussions

167 discussions - 1,315 posts

  • Tom brings up a good point, that changes to support Windows should not add to the tasks of those who are doing the bulk of the work on Unixen. I don't think, however, that this necessarily means that ...
    Curtis FaithCurtis Faith
    Jan 22, 2003 at 3:35 pm
    Feb 3, 2003 at 10:02 pm
  • I'm just announcing here, since I'd like to see some ppl testing this out and let us know if there are any problems ... DNS is going to take a little while to propogate, so the old site may still ...
    Marc G. FournierMarc G. Fournier
    Jan 5, 2003 at 12:40 am
    Jan 7, 2003 at 9:37 pm
  • Hi, Is there any way of making the 'up' arrow retrieve all of the last multiline query, instead of just the last line? It's really annoying working with large multiline queries at the moment... Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Jan 8, 2003 at 6:55 am
    Feb 19, 2003 at 3:30 pm
  • I have posted before about this but I am now posting to both NetBSD and PostgreSQL since it seems to be some sort of interaction between the two. I have a NetAPP filer on which I am putting a ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Jan 30, 2003 at 3:43 pm
    Feb 6, 2003 at 6:31 pm
  • Well, certainly the driver could parse the sql and extract what it thinks is the table name. It just seems quite foreign to me to have a database engine go through the motions of determining column ...
    Reggie BurnettReggie Burnett
    Jan 27, 2003 at 3:45 pm
    Jan 31, 2003 at 6:36 am
  • It's that time of year again, when I remind everyone just how difficult life in the trenches with PostgreSQL can be, when the life in the trenches involves upgrades. If you don't want to read about ...
    Lamar OwenLamar Owen
    Jan 2, 2003 at 11:19 pm
    Jan 7, 2003 at 10:39 am
  • Linux.conf.au Report -------------------- The Linux.conf.au is an international Linux/Open Source event that attracts lots of international speakers. Total conf attendance was around 360, maybe even ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jan 30, 2003 at 2:48 am
    Feb 16, 2003 at 8:50 am
  • I just wanted to post this note. I have been in Oracle hell for four days now, and in between the 5 minutes of work and the hours of watings, dealing with table spaces, extents, and all that, I just ...
    Mark L. WoodwardMark L. Woodward
    Jan 16, 2003 at 3:09 am
    Feb 12, 2003 at 5:13 pm
  • Hi all, I am sure, many of you would like to delete this message before reading, hold on. :-) There is much talk about threading on this list and the idea is always deferred for want of robust thread ...
    Shridhar DaithankarShridhar Daithankar
    Jan 3, 2003 at 3:25 pm
    Jan 23, 2003 at 9:24 pm
  • Hi, I just submitted the patches for the native Win32 port of v7.2.1 on the patches mailing list. If you are not subscribed to the patches list you can download them from ...
    Jan WieckJan Wieck
    Jan 20, 2003 at 10:08 pm
    Jan 29, 2003 at 8:00 pm
  • Refresh my memory: what is the point of inventing an additional LAST keyword, when the behavior is exactly the same as MOVE ALL ? regards, tom lane
    Tom LaneTom Lane
    Jan 7, 2003 at 11:07 pm
    Feb 4, 2003 at 11:23 am
  • Is there any way of fixing the following? 164_459_openacs= \d ERROR: parser: parse error at or near "." 164_459_openacs= We've started to upgrade the client machines, before upgrading the server ...
    Marc G. FournierMarc G. Fournier
    Jan 10, 2003 at 5:30 pm
    Jan 23, 2003 at 1:19 pm
  • I've been looking at the PID file creation mechanism we currently use. It goes through a loop in an attempt to create the PID file, and if one is there it attempts to remove it if the PID it contains ...
    Kevin BrownKevin Brown
    Jan 31, 2003 at 3:31 am
    Feb 3, 2003 at 12:10 pm
  • Steve Crawford sent me some profiling results for queries involving wide tuples (hundreds of columns). Yipes, you can say that again. % cumulative self self total time seconds seconds calls ms/call ...
    Tom LaneTom Lane
    Jan 22, 2003 at 11:51 pm
    Feb 14, 2003 at 1:11 pm
  • This is a serious inquiry, very serious. People are complaining about ads. What do we need in the form of equipment, bandwidth, etc.
    Mark L. WoodwardMark L. Woodward
    Jan 7, 2003 at 10:06 pm
    Jan 13, 2003 at 10:49 pm
  • I noticed sync() is used in PostgreSQL. CHECKPOINT - FlushBufferPool() - smgrsync() - mdsync() - sync() Can someone tell me why we need sync() here? -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Jan 8, 2003 at 6:09 am
    Feb 1, 2003 at 5:20 pm
  • Hi everyone, Dave Page put up a new survey on the PostgreSQL portal page very recently, " What would attract the most new PostgreSQL users?" and the results in already are interesting (1,529 results ...
    Justin CliftJustin Clift
    Jan 19, 2003 at 2:15 pm
    Jan 26, 2003 at 1:53 am
  • Often I need to remove a user and cede their permissions to someone else. How about something like this: DROP USER blah PERMISSIONS TO chriskl; or maybe GRANT ALL USER blah TO chriskl; ??? Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Jan 14, 2003 at 2:40 am
    Jan 26, 2003 at 1:00 am
  • Hi! I just came across a posting in this list, and a question arose from that which I'm carrying for some time. PG has *some* views in the system catalog, which make life easier, but some ...
    Joerg HessdoerferJoerg Hessdoerfer
    Jan 13, 2003 at 3:56 pm
    Jan 14, 2003 at 4:39 pm
  • Morning all ... I jsut bundled up v7.2.4 with all the recent security fixes ... can a few ppl do some regression tests and report back before I announce in the morning? I did a configure and build ...
    Marc G. FournierMarc G. Fournier
    Jan 30, 2003 at 2:00 am
    Jan 31, 2003 at 2:59 pm
  • We've gotten a couple of complaints now about the fact that 7.3 doesn't include an OID column in a table created via CREATE TABLE AS or SELECT INTO. Unless I hear objections, I'm going to revert it ...
    Tom LaneTom Lane
    Jan 21, 2003 at 8:11 pm
    Jan 27, 2003 at 10:49 pm
  • Currently, the default sysid assigned to a user or group is computed as "max(sysid)+1". We've seen a couple of complaints now from people who deleted their newest user, made another user, and found ...
    Tom LaneTom Lane
    Jan 17, 2003 at 6:16 am
    Jan 17, 2003 at 8:20 pm
  • Hello, Happy New Year everyone, Attached is an attempt to eliminate duplicate pg_dump option descriptions, and have a single description for both short and long options. For me, as for a translator, ...
    Serguei MokhovSerguei Mokhov
    Jan 2, 2003 at 6:16 am
    Jan 4, 2003 at 11:18 pm
  • Folks, Is it a good idea for CREATE TABLE to default to WITHOUT OIDS, rather than WITH OIDS? Naturally, this would (a) be some time in the future (7.5, perhaps) and (b) only apply to user tables. The ...
    Neil ConwayNeil Conway
    Jan 10, 2003 at 9:50 pm
    Jan 26, 2003 at 2:26 am
  • Hi all, A pgAdmin user has noticed that Foreign Keys take significantly longer to create when migrating a database in pgAdmin in v1.4.12 than in v1.4.2. The only difference in the migration code ...
    Dave PageDave Page
    Jan 20, 2003 at 10:18 am
    Jan 23, 2003 at 6:00 pm
  • I have a query using two postgres tables. One is called "CNX_DS_53_SIS_STU_OPT_FEE_TB" and the other is called "CNX_DS2_53_SIS_STU_OPT_FEE_TB". I am getting 3 times slower performance than Microsoft ...
    Dann CorbitDann Corbit
    Jan 7, 2003 at 12:21 am
    Jan 8, 2003 at 7:02 pm
  • Hi all, I would like to use ECPG as it is relatively easy to code. However my application is multithreaded and also uses connecion pools. I would like to know if ECPG is thread safe and I can use an ...
    "Shridhar Daithankar"Shridhar Daithankar
    Jan 23, 2003 at 9:10 am
    Jan 27, 2003 at 7:29 pm
  • Looks like some ORDER BY statements would be useful. *** ./expected/inet.out Sat Jun 16 22:05:20 2001 --- ./results/inet.out Wed Jan 15 10:18:40 2003 *************** *** 193,212 **** select * from ...
    Rod TaylorRod Taylor
    Jan 15, 2003 at 4:20 pm
    Jan 16, 2003 at 5:42 am
  • There is a long tradition of systematically failing to tag releases in this project. Don't expect it to improve. -- Peter Eisentraut peter_e@gmx.net
    Peter EisentrautPeter Eisentraut
    Jan 4, 2003 at 10:20 am
    Jan 5, 2003 at 4:52 pm
  • There is a nasty bug with the client_encoding directive in postgresql.conf. It is simply ignored. This bug exists in both 7.3 or later and in current. Interesting thing is "show client_encoding" ...
    Tatsuo IshiiTatsuo Ishii
    Jan 29, 2003 at 1:23 pm
    Feb 17, 2003 at 4:24 pm
  • Hi everyone, We don't support OS/400 yet do we? :-) Regards and best wishes, Justin Clift -- "My grandfather once told me that there are two kinds of people: those who work and those who take the ...
    Justin CliftJustin Clift
    Jan 7, 2003 at 1:03 am
    Jan 7, 2003 at 8:45 am
  • On a slightly related note to the other threads thread [sic] going on... Over the Christmas/New Year break i've been looking into making the PostgreSQL client libraries (in particular libpq and ecpg) ...
    Lee KindnessLee Kindness
    Jan 6, 2003 at 4:33 pm
    Jan 9, 2003 at 3:27 pm
  • Interesting thought, indeed. Since we truncate the WAL after each checkpoint, seems like this approach would no more than double the time for restart. The win is it'd eliminate pg_control as a single ...
    Tom LaneTom Lane
    Jan 25, 2003 at 6:46 am
    Feb 18, 2003 at 7:09 pm
  • Folks, Someone contacted me in IRC about a bug in PL/PgSQL. I've confirmed that the example SQL they sent me causes a segfault on my machine (CVS HEAD), but I've so far not had a lot of success ...
    Neil ConwayNeil Conway
    Jan 11, 2003 at 1:08 am
    Jan 12, 2003 at 1:36 pm
  • Hi everyone, Mark (mlw) put together a PostgreSQL installer for Windows (cygwin version) a little while ago, but he hasn't been responding to requests for feedback regarding it (probably busy). As ...
    Justin CliftJustin Clift
    Jan 26, 2003 at 3:14 am
    Jan 27, 2003 at 12:08 pm
  • I have an idea for an aggregate function (actually a pair) that would be very useful. It's something I've wanted very frequently with Oracle and other databases and while it's possible to implement ...
    Greg StarkGreg Stark
    Jan 17, 2003 at 6:41 pm
    Jan 24, 2003 at 9:24 pm
  • Q: Why do I get strange results with a CHAR(n) field? A. Don't use CHAR(n). VARCHAR(n) has the behavior you are probably expecting; on top of which it's more compact and usually faster. I suppose the ...
    Tom LaneTom Lane
    Jan 12, 2003 at 4:59 am
    Jan 15, 2003 at 6:56 pm
  • Postgresql 7.3.1 on Linux i386 - but from what I can see it is on all platforms It seems pg_get_constraintdef does not remember the setting "DEFERRABLE" on a constraint. This has the effect that it ...
    Magnus HaganderMagnus Hagander
    Jan 1, 2003 at 6:41 pm
    Jan 8, 2003 at 10:52 pm
  • Just got this in my mailbox: 2002 LinuxQuestions.org Members Choice Awards: http://www.linuxquestions.org/questions/showthread.php?s=78a8c06fbc1dcecd52597decd6c56ad8&threadid=39870 And we are way ...
    Marc G. FournierMarc G. Fournier
    Jan 2, 2003 at 6:25 am
    Jan 2, 2003 at 8:39 pm
  • Hi there, we've discussed with Teodor about adding ranking feature to tsearch and seems we've found a way to do that. New version of tsearch will have ranking supports, friendly configurability, ...
    Oleg BartunovOleg Bartunov
    Jan 31, 2003 at 12:00 pm
    Feb 7, 2003 at 2:28 am
  • Despite some people's thoughts that a powerfail test is of little use, I going to spend some time doing one anyway because I think Tom's arguments for it are valid. I have lashed together the ...
    Dave PageDave Page
    Jan 31, 2003 at 10:12 pm
    Feb 1, 2003 at 8:22 pm
  • Does anybody know: select 1.0 union select 1; or select 1 union select 1.0; should return 1 or 1.0? I see below on my Linux box: test=# select 1 union select 1.0; ?column? ---------- 1 (1 row) test=# ...
    Tatsuo IshiiTatsuo Ishii
    Jan 15, 2003 at 4:04 am
    Jan 15, 2003 at 5:00 pm
  • This works: pg_dump -h myhost -p 5432 -f mydb.cpgdmp mydb This does not: pg_dump -h myhost -p 5432 -Fc -f mydb.cpgdmp mydb Segmentation fault (core dumped) Nor does this: pg_dump -h myhost -p 5432 ...
    Laurette CisnerosLaurette Cisneros
    Jan 11, 2003 at 1:02 am
    Jan 11, 2003 at 5:01 am
  • So currently the only way to specify a row type is by using a table, right? E.g.: CREATE TABLE t2_retval ( value1 int NOT NULL DEFAULT -1, value2 int NOT NULL, value3 int ); Are there plans to add ...
    Curt SampsonCurt Sampson
    Jan 29, 2003 at 6:07 am
    Jan 29, 2003 at 4:47 pm
  • As part of the training class I did, some people tested what happens when the client allocates tons of memory to store a result and aborts. What we found was that though elog was properly called: ...
    Bruce MomjianBruce Momjian
    Jan 27, 2003 at 11:01 pm
    Jan 28, 2003 at 4:28 am
  • I'm running a little late on this, but we'd like to put out a release of each of the above over the course of the next 2 weeks ... What I'd like to aim for is v7.2.4 for Tuesday next week, and v7.3.2 ...
    Marc G. FournierMarc G. Fournier
    Jan 22, 2003 at 8:09 pm
    Jan 28, 2003 at 3:55 am
  • Hi guys, Have created a Solaris 8 Intel package for PostgreSQL 7.3.1, but don't have any SPARC boxes here any more. Does anyone have a SPARC box handy that would be available for compiling PostgreSQL ...
    Justin CliftJustin Clift
    Jan 15, 2003 at 12:35 am
    Jan 16, 2003 at 1:20 am
  • Hi guys, Also received a through the Advocacy website asking if anyone has ported PostgreSQL to the AlphaServers under VMS. Anyone know if we run on VMS? Last time I touched VMS (about 10 years ago) ...
    Justin CliftJustin Clift
    Jan 7, 2003 at 8:45 am
    Jan 7, 2003 at 10:14 pm
  • In CVS tip, if you run "make installcheck" in src/pl/plpython, the test fails with a number of diffs between the expected and actual output. I'm not sure if plpython is broken, or if it's just that ...
    Tom LaneTom Lane
    Jan 30, 2003 at 10:39 pm
    Jan 31, 2003 at 2:57 pm
  • Due to my error, log_min_error messages went into 7.3.X with the wrong default, and the wrong listed options. This fixes the bug in CVS current and 7.3.X. Patch attached. -- Bruce Momjian | ...
    Bruce MomjianBruce Momjian
    Jan 27, 2003 at 11:58 pm
    Jan 29, 2003 at 7:17 pm
Group Navigation
period‹ prev | Jan 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions167
posts1,315
users149
websitepostgresql.org...
irc#postgresql

149 users for January 2003

Tom Lane: 223 posts Bruce Momjian: 131 posts Christopher Kings-Lynne: 58 posts Peter Eisentraut: 57 posts Justin Clift: 52 posts Dave Page: 49 posts Greg Copeland: 37 posts Marc G. Fournier: 35 posts Rod Taylor: 35 posts Mark L. Woodward: 30 posts Lamar Owen: 27 posts Vince Vielhaber: 24 posts Dann Corbit: 22 posts Curt Sampson: 21 posts Dan Langille: 21 posts Hannu Krosing: 21 posts Neil Conway: 20 posts Kevin Brown: 18 posts D'Arcy J.M. Cain: 16 posts Jan Wieck: 16 posts
show more
Archives