FAQ

Search Discussions

204 discussions - 1,045 posts

  • what do you think about plphp ?
    IvanIvan
    Jul 12, 2003 at 9:32 pm
    Aug 2, 2003 at 1:25 pm
  • 28

    Re:

    FreeBSD has a separate libc_r. I don't think they would bother with that if there was no significant difference. The performance hit isn't in the mutexes or specifically here or there. But when you ...
    Peter EisentrautPeter Eisentraut
    Jul 23, 2003 at 2:14 pm
    Jul 25, 2003 at 10:27 pm
  • I am seeing the following parallel regression test failures. Any idea on the cause? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, ...
    Bruce MomjianBruce Momjian
    Jul 25, 2003 at 9:47 pm
    Aug 9, 2003 at 2:12 pm
  • Iam trying to acquire rowlevel locks in postgresql. I try doing this: 'select * from students where name='Larry' for update; But by looking at the holding array of proclock , I've noticed that by ...
    Jenny -Jenny -
    Jul 23, 2003 at 7:48 pm
    Jul 31, 2003 at 5:57 am
  • I did a fresh CVS get (2003-07-07 12:30 UTC +10:00), attempted to build on "OSF1 V4.0 1229 alpha" (Tru64 running on alpha) but build failed with: In file included from ...
    Philip YarraPhilip Yarra
    Jul 7, 2003 at 3:06 am
    Jul 28, 2003 at 8:02 am
  • Hi, I'm trying to build cvs, but it fails: bison -y -d preproc.y preproc.y:6214: fatal error: maximum table size (32767) exceeded make[4]: *** [preproc.h] Error 1 make[4]: Leaving directory ...
    Markus BertheauMarkus Bertheau
    Jul 1, 2003 at 7:40 pm
    Jul 2, 2003 at 4:56 am
  • [ cc to hackers] It certainly looks closer, particularly because the failure is s simple domain constraint failure and not a more internal error. Have you tried moving ahead a few days to see if the ...
    Bruce MomjianBruce Momjian
    Jul 26, 2003 at 8:49 pm
    Jul 29, 2003 at 12:57 am
  • Hi there, we still have no r/w access to CVS, so I'm asking authoritative developers to grab archive http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch-v2-stable.tar.gz and submit it to ...
    Oleg BartunovOleg Bartunov
    Jul 3, 2003 at 3:40 pm
    Jul 20, 2003 at 7:32 pm
  • Hi hackers, I know you're all very busy with 7.4 coming out next week.But I thought I could ask for a little feature with postgres logs. Today, logs are all going to a file or syslog or both. But ...
    OhpOhp
    Jul 23, 2003 at 3:49 pm
    Jul 30, 2003 at 7:35 pm
  • Hi there, seems we'll have 7.3.4 release. Is't worth to submit new tsearch2 module for this release ? People could play with new module without waiting 7.4 release. Regards, Oleg Oleg Bartunov, ...
    Oleg BartunovOleg Bartunov
    Jul 21, 2003 at 8:43 pm
    Jul 23, 2003 at 4:17 am
  • First fruits of all that work on error message rejiggering ... regression=# \set VERBOSE terse regression=# select 1!! ; ERROR: operator does not exist: integer !! regression=# \set VERBOSE default ...
    Tom LaneTom Lane
    Jul 4, 2003 at 3:02 am
    Jul 31, 2003 at 6:31 pm
  • It seems that a value of addr- ai_socktype returned by getaddrinfo in pg_stat.c is not SOCK_DGRAM. Kenji Sugita
    Kenji SugitaKenji Sugita
    Jul 2, 2003 at 6:49 am
    Jul 25, 2003 at 4:34 am
  • This week I have done some performance tuning at a customer's office. We have beaten (demoralized) MS SQL and DB2 in serializable mode and DB2 in any transaction isolation level :). By the way: In ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Jul 5, 2003 at 5:45 am
    Jul 23, 2003 at 4:37 am
  • I just tried compiling all contribs on freebsd/alpha, and I saw these issues: gmake[1]: Entering directory `/home/chriskl/pgsql-temp/contrib/pgstattuple' sed 's,MODULE_PATHNAME,$libdir/pgstattuple,g' ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 24, 2003 at 2:12 am
    Aug 5, 2003 at 5:27 am
  • Hi all, As many of you know, PostgreSQL, Inc. has determined that Real Soon Now is the time to release their older version of eRServer as a contribution back to the rserv project. That Has Not ...
    Andrew SullivanAndrew Sullivan
    Jul 15, 2003 at 8:18 pm
    Jul 23, 2003 at 2:32 pm
  • Has anyone thought of what will happen to the server_encoding parameter when the character set/encoding will be settable for individual columns and the concept of a global server encoding will go ...
    Peter EisentrautPeter Eisentraut
    Jul 28, 2003 at 7:40 am
    Aug 31, 2003 at 7:10 pm
  • I've been thinking some about how exactly to provide the new option of thread-safe clients (libpq, ecpg). Let me state the following goals: a. Thread-safeness, where it makes a difference, is ...
    Peter EisentrautPeter Eisentraut
    Jul 22, 2003 at 2:46 pm
    Jul 24, 2003 at 6:44 am
  • Hi all, I would like to know why does calling a function with select * from function doesn't work when its return type is set to void. I'm asking this because I have a code which uses this syntax to ...
    Francisco Figueiredo Jr.Francisco Figueiredo Jr.
    Jul 22, 2003 at 7:15 pm
    Jul 26, 2003 at 12:27 am
  • Make clean fails on an up-to-date CVS (as of 2:40 PM CDT on Sunday). Here's the final part of the output: make[2]: Leaving directory `/home/nolan/beta/pgsql/contrib/tablefunc' make[2]: Entering ...
    NolanNolan
    Jul 27, 2003 at 7:45 pm
    Jul 29, 2003 at 4:16 pm
  • Is the patches list working? I submitted on yesterday that never made it. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat ...
    Larry RosenmanLarry Rosenman
    Jul 16, 2003 at 4:28 pm
    Jul 19, 2003 at 1:26 am
  • Presumably, the "is_superuser" parameter was intended to make the updating of psql's prompt more accurate when SET SESSION AUTHORIZATION is used. However, if the prompt is customized to include the ...
    Peter EisentrautPeter Eisentraut
    Jul 28, 2003 at 7:41 am
    Oct 4, 2003 at 2:36 am
  • Iam trying to acquire rowlevel locks in postgresql. I try doing this: 'select * from students where name='Larry' for update; But by looking at the holding array of proclock , I've noticed that by ...
    Jenny -Jenny -
    Jul 11, 2003 at 1:35 am
    Aug 26, 2003 at 5:48 pm
  • The attached patch shows how initdb can dynamically determine reasonable shared_buffers and max_connections settings that will work on the current machine. It consists of two trivial adjustments: one ...
    Tom LaneTom Lane
    Jul 4, 2003 at 7:29 pm
    Jul 31, 2003 at 4:44 pm
  • Hi, I was just wondering over it. This is for difference between vacuum full and vacuum analyze. Can somebody enlighten, 1. IIRC vacuum recovers/reuses dead tuples generated from update but can not ...
    Shridhar DaithankarShridhar Daithankar
    Jul 28, 2003 at 8:57 am
    Jul 29, 2003 at 8:55 am
  • Guys, attached is a patch to fix two memory leaks on start-up. The first is when freeaddrinfo has been used to free memory allocated by getaddrinfo2 (so freeaddrinfo2 should be used). The second is 2 ...
    Lee KindnessLee Kindness
    Jul 22, 2003 at 8:14 am
    Jul 27, 2003 at 7:39 pm
  • someone looked at my files function ??
    IvanIvan
    Jul 13, 2003 at 8:13 pm
    Jul 23, 2003 at 10:03 pm
  • I'm getting far too many errors while trying to compile gram.c in the backend/parser, that I must be missing something.. Story so far gmake distclean cvs update configure --enable-debug ...
    Patrick WelchePatrick Welche
    Jul 15, 2003 at 12:47 pm
    Jul 16, 2003 at 7:02 pm
  • After upgrade on 7.3.3 we have following: signal 11 #0 0x254f38 in pfree () #1 0x1fde44 in convert_to_scalar () #2 0x1faafc in scalarineqsel () #3 0x1fd574 in mergejoinscansel () #4 0x14fec8 in ...
    Maksim LikharevMaksim Likharev
    Jul 8, 2003 at 4:34 pm
    Jul 12, 2003 at 11:59 pm
  • Does anyone have recent archives of the pgsql-hackers list in mbx or flat file format? I know that I can search through the website or through other interfaces, but I would like to be able to ...
    Thomas SwanThomas Swan
    Jul 16, 2003 at 6:57 pm
    Dec 14, 2003 at 11:10 pm
  • Hackers, Two buglets: The first one is in createlang, trying to create a language without enough permission: $ createlang -d alvherre plpgsql createlang: language installation failed: ERROR: c: ...
    Alvaro Herrera MunozAlvaro Herrera Munoz
    Jul 31, 2003 at 8:32 pm
    Aug 5, 2003 at 3:57 am
  • [ CC to Kurt and Steven on bsdi list.] Guys, I just replied to this email on the BSDi email list. The issue is that someone found that some(most?) IDE drives have write cache enabled, though the ...
    Bruce MomjianBruce Momjian
    Jul 30, 2003 at 4:38 am
    Jul 31, 2003 at 2:50 pm
  • Dear hackers, Do you think there would be any use for an aggregate which returns an array of the aggregated (usually simple) type? Has this already been done by anyone? I looked at the source and ...
    Merlin MoncureMerlin Moncure
    Jul 28, 2003 at 9:22 pm
    Jul 29, 2003 at 8:48 pm
  • NOWAIT". implementing I think I'm a quite attentive to the SQL and HACKERS list, and I see requests for a NOWAIT option at least once a month, and it's growing. Regards, Christoph
    Christoph HallerChristoph Haller
    Jul 23, 2003 at 7:35 am
    Jul 23, 2003 at 11:09 pm
  • Hi, Does anybody know why vacuum full does not relcaim deleted rows if a open transaction which started before the deletion happens is running even on a different database? Here is an example: T1: ...
    Tatsuo IshiiTatsuo Ishii
    Jul 5, 2003 at 6:33 pm
    Jul 21, 2003 at 5:03 am
  • Hm. Evidently not :-(. The COMMENT ON DATABASE facility is a bit bogus anyway (since there's no way to make the comments visible across databases). You might be best advised not to use it. Hackers: ...
    Tom LaneTom Lane
    Jul 15, 2003 at 4:26 pm
    Jul 16, 2003 at 10:38 pm
  • Behdad EsfahbodBehdad Esfahbod
    Jul 2, 2003 at 2:50 am
    Jul 2, 2003 at 10:01 am
  • Hi, make check fails, and I have absolutely no idea where to look: running on port 65432 with pid 631 ============== creating database "regression" ============== createdb: could not connect to ...
    Markus BertheauMarkus Bertheau
    Jul 1, 2003 at 8:28 pm
    Jul 1, 2003 at 10:03 pm
  • I see autocommit as implemented only in psql, not in libpq. Is that what we want to do for 7.4? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a ...
    Bruce MomjianBruce Momjian
    Jul 22, 2003 at 9:26 pm
    Jul 31, 2003 at 2:26 pm
  • I know that I can use fcinfo- flinfo- fn_extra to determine if a particular function has been previously called within a given SQL statement execution, but what is the best way to determine that the ...
    Joe ConwayJoe Conway
    Jul 24, 2003 at 11:44 pm
    Jul 28, 2003 at 5:28 pm
  • Hi all, since long time ( in the mean time I did Postgres upgrade four time and now I'm using 7.3.3 ) I'm having, at least once in a week, a signal 11 on a backend, and how you can immagine with the ...
    Mendola GaetanoMendola Gaetano
    Jul 26, 2003 at 9:36 pm
    Jul 27, 2003 at 8:40 pm
  • When a SELECT FOR UPDATE query is executed, are the row level locks on a table acquired in any specific order such as to enhance deadlock prevention? ( primary key, oid, etc. )
    Thomas SwanThomas Swan
    Jul 25, 2003 at 1:17 am
    Jul 25, 2003 at 10:24 pm
  • The s_lock.h change will be in 7.4. --------------------------------------------------------------------------- Tom Lane wrote: -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | ...
    Bruce MomjianBruce Momjian
    Jul 8, 2003 at 10:48 pm
    Jul 22, 2003 at 2:00 am
  • Just saw this on our demo server: root@phppgadmin:~/htdocs/webdb/conf# /usr/local/pgsql-7.3.3/bin/psql -p5473 phppgadmin psql: FATAL: cannot open segment 1 of relation pg_trigger_tgrelid_tgname_index ...
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 10, 2003 at 1:16 am
    Jul 13, 2003 at 12:01 am
  • You might have noticed I am behind on email. I had a big family reunion at my house during the July 4th holiday, with 16 people staying for 2-4 days. This cut into my email time, and I left for OSCON ...
    Bruce MomjianBruce Momjian
    Jul 9, 2003 at 6:08 pm
    Jul 11, 2003 at 7:03 am
  • Currently, the extract(timezone_hour ...) and extract(timezone_minute ...) constructs (also the equivalent date_part() calls) return positive values for timezones west of Greenwich, and negative ...
    Tom LaneTom Lane
    Jul 3, 2003 at 5:18 pm
    Jul 5, 2003 at 6:17 pm
  • Hi, I'm trying to compile pgsql-7.4devl on Solaris8, but got the error below: ----------------------------------------8<--------------------------------------------------------------------- ...
    Weiping HeWeiping He
    Jul 4, 2003 at 7:00 am
    Jul 4, 2003 at 7:03 pm
  • Just a slight nitpick, shouldn't this line: # - Previous Postgres Versions - Be this: # - Previous PostgreSQL Versions - Chris
    Christopher Kings-LynneChristopher Kings-Lynne
    Jul 28, 2003 at 2:41 am
    Jul 31, 2003 at 6:39 pm
  • So you want to update same table more than once in a single transaction? That should work.. Whoa!! That's something. How did you conclude it is locked. If you can produce some reproducible test case, ...
    Shridhar DaithankarShridhar Daithankar
    Jul 29, 2003 at 11:01 am
    Jul 30, 2003 at 3:08 pm
  • I created a function thus: CREATE OR REPLACE FUNCTION dwarray(anyelement, anyelement) RETURNS anyarray AS ' SELECT ARRAY[$1,$2] ' LANGUAGE 'sql' IMMUTABLE STRICT; My hope was to use STRICT to get the ...
    Joe ConwayJoe Conway
    Jul 24, 2003 at 6:25 pm
    Jul 24, 2003 at 9:44 pm
  • I have just seen a nice feature provided by DB2 which seems very useful to me. When importing huge amounts of data (dozens of gigs) with the help of COPY errors might occur from time to time ...
    Hans-Jürgen SchönigHans-Jürgen Schönig
    Jul 18, 2003 at 6:52 pm
    Jul 24, 2003 at 6:58 am
Group Navigation
period‹ prev | Jul 2003 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions204
posts1,045
users132
websitepostgresql.org...
irc#postgresql

132 users for July 2003

Tom Lane: 168 posts Bruce Momjian: 164 posts Christopher Kings-Lynne: 48 posts Peter Eisentraut: 34 posts Joe Conway: 26 posts Ivan: 23 posts Larry Rosenman: 23 posts Oleg Bartunov: 22 posts Jenny -: 20 posts Rod Taylor: 20 posts Kurt Roeckx: 17 posts Robert Creager: 16 posts Alvaro Herrera Munoz: 15 posts The Hermit Hacker: 14 posts Josh Berkus: 13 posts Sailesh Krishnamurthy: 13 posts Francisco Figueiredo Jr.: 12 posts Lee Kindness: 12 posts Marcus Börger: 12 posts Shridhar Daithankar: 12 posts
show more
Archives