FAQ

PostgreSQL > pgsql-hackers > October 2001

Search Discussions

198 discussions - 1,155 posts

  • Hello, I'm in the process of porting a large application from Ingres to PostgreSQL. We make heavy use of bulkloading using the 'COPY' statement in ESQL/C. Consider the SQL statements below (in a psql ...
    Lee KindnessLee Kindness
    Oct 1, 2001 at 11:04 am
    Jan 4, 2002 at 8:14 pm
  • Hello, I discussed a problem concerning the speed of PostgreSQL compared to MS SQL server heavily on postgres-general list. The thread starts with message ...
    Tille, AndreasTille, Andreas
    Oct 29, 2001 at 12:44 pm
    Nov 5, 2001 at 5:53 pm
  • I've cc'd this to the hackers list. I know the discussion started on general, but if I hadn't been subscribed to *that* list I'd have never known about any of this. And noone else on hackers would ...
    Thomas LockhartThomas Lockhart
    Oct 22, 2001 at 4:56 pm
    Feb 20, 2002 at 6:43 pm
  • I have been pondering a little about something I called "package", completely independent of anything previously implemented. What I would like to get out of a package is the same thing I get out of ...
    Peter EisentrautPeter Eisentraut
    Oct 14, 2001 at 8:45 pm
    Oct 26, 2001 at 10:40 pm
  • Marc, what's happens with cvs ? I still can't update: cvs server: failed to create lock directory for /projects/cvsroot/pgsql/contrib/pgstattuple' ...
    Oleg BartunovOleg Bartunov
    Oct 1, 2001 at 2:37 pm
    Oct 10, 2001 at 9:32 pm
  • I'm fresh in the code, but this has solved my issues with PQconnect* failing when interrupted by signals. Some of it is sloppy and not to my liking yet, but I'm still digging through to see if ...
    David FordDavid Ford
    Oct 25, 2001 at 9:10 pm
    Nov 12, 2001 at 4:42 am
  • Dear all, I am running PostgreSQL 7.1.2 with UNICODE support in production. Maybe I miss something about UNICODE: CREATE TABLE "test" ( "source_oid" serial, "source_timestamp" timestamp, ...
    Jean-Michel PoureJean-Michel Poure
    Oct 28, 2001 at 8:22 am
    Oct 29, 2001 at 4:30 pm
  • My patch doesn't loose the option, it's never been passed on anyway: opt_with_grant: WITH GRANT OPTION { mmerror(ET_ERROR, "WITH GRANT OPTION is not supported. Only relation owners can set ...
    Lee KindnessLee Kindness
    Oct 15, 2001 at 9:09 am
    Oct 19, 2001 at 2:34 pm
  • Per Tom's request(1000 concurrent backends), I tried current on IBM AIX 5L and found that make check hungs: parallel group (13 tests): float4 oid varchar pgbench hungs too if more than 4 or so ...
    Tatsuo IshiiTatsuo Ishii
    Oct 1, 2001 at 4:15 am
    Oct 5, 2001 at 5:42 pm
  • Bill StudenmundBill Studenmund
    Oct 13, 2001 at 12:59 am
    Feb 22, 2002 at 7:12 pm
  • I get no mail from pgsql-committers since Oct 19. Does anybody know what's going on? -- Tatsuo Ishii
    Tatsuo IshiiTatsuo Ishii
    Oct 30, 2001 at 1:02 am
    Oct 31, 2001 at 9:59 am
  • ... is now packaged ... mirrors will pick it up soon, but if anyone wants to do a quick check, its in /pub/beta ...
    Marc G. FournierMarc G. Fournier
    Oct 25, 2001 at 4:48 pm
    Oct 30, 2001 at 2:40 am
  • Well I never submitted my patch for building using the Sun compilers since I thought that the newer versions did support the -Wl option - I'm using an old (version 4) Sun compiler. However it seems ...
    Lee KindnessLee Kindness
    Oct 23, 2001 at 9:29 am
    Nov 11, 2001 at 7:21 pm
  • Did we come to any conclusion about whether to accept Gavin Sherry's CREATE OR REPLACE FUNCTION patch? http://fts.postgresql.org/db/mw/msg.html?mid=1035792 AFAIR, the score was that I liked it, Bruce ...
    Tom LaneTom Lane
    Oct 2, 2001 at 2:30 pm
    Oct 29, 2001 at 7:33 am
  • Reply-To: sender Hi. I was surprised to discover today that postgres's character types don't support zero bytes. That is, Postgres isn't 8-bit clean. Why is that? More to the point, I need to store ...
    Jason OrendorffJason Orendorff
    Oct 22, 2001 at 5:26 pm
    Oct 28, 2001 at 1:02 am
  • I'd like to propose a new command, CREATE OPERATOR CLASS. Its purpose is to create a named operator class, so that you can create new types of index ops. Also, its inclusion would remove the section ...
    Bill StudenmundBill Studenmund
    Oct 24, 2001 at 6:43 pm
    Mar 6, 2002 at 9:59 pm
  • Dear all, Would it be possible to implement CREATE OR REPLACE VIEW / TRIGGER in PostgreSQL 7.2? Alternatively, could someone implement CREATE OR DROP VIEW / TRIGGER? These features are needed for ...
    Jean-Michel PoureJean-Michel Poure
    Oct 23, 2001 at 3:17 pm
    Oct 27, 2001 at 1:50 pm
  • Hello PostgreSQl Users! PostSQL V 7.1.1: I have defined a table and the necessary indices. But the index is not used in every SELECT. (Therefore, the selects are *very* slow, due to seq scan on 20 ...
    Reiner DassingReiner Dassing
    Oct 22, 2001 at 4:30 pm
    Oct 25, 2001 at 2:25 pm
  • Hi, In trying to solve a bug in 'ALTER TABLE tbl RENAME col1 TO col2',I noticed (what must be) a typo in src/interfaces/ecpg/preproc/preproc.y patch attached, tho it might be easier if you just look ...
    Brent VernerBrent Verner
    Oct 5, 2001 at 3:38 am
    Oct 9, 2001 at 4:20 am
  • Problem: the external representation of time and timestamp are less precise than the internal representation. We are using postgresql 7.1.3 The timestamp and time types support resolving microseconds ...
    Laurette CisnerosLaurette Cisneros
    Oct 4, 2001 at 12:04 am
    Oct 5, 2001 at 8:00 am
  • Hello all!! I'm developer of a interface for PostgreSQL for the Borland Kylix and Delphi tools (http://www.vitavoom.com). I've run into the following problems with catalogs: - pg_group: the grolist ...
    Steve HoweSteve Howe
    Oct 20, 2001 at 3:05 am
    Oct 28, 2001 at 5:21 pm
  • Any idea to get a human readable list with column descriptions like type,size,key,default,null. It would be nice if it would look simular to the mysql variant: mysql describe employee; ...
    Ron de JongRon de Jong
    Oct 19, 2001 at 11:35 am
    Oct 26, 2001 at 10:05 am
  • I have been asked to run pgindent in preparation for beta starting tomorrow. In this run, I will also reformat the jdbc files as agreed to by the jdbc list. I don't have much time to wait before ...
    Bruce MomjianBruce Momjian
    Oct 24, 2001 at 5:55 pm
    Oct 28, 2001 at 6:24 am
  • Our FAQ, item 4.16.2 has: $newSerialID = nextval('person_id_seq'); INSERT INTO person (id, name) VALUES ($newSerialID, 'Blaise Pascal'); Is this correct Perl? I don't see a nextval() function in ...
    Bruce MomjianBruce Momjian
    Oct 10, 2001 at 11:36 pm
    Oct 14, 2001 at 11:27 pm
  • Hi, Now that postgresql doesn't have field size limits, it seems to me they should be good for storing large blobs, even if it means having to uuencode them to be non-binary or whatever. I don't like ...
    Chris BitmeadChris Bitmead
    Oct 10, 2001 at 1:34 am
    Oct 13, 2001 at 4:13 am
  • This is using an almost up-to-date CVS version. Sorry for the convoluted example: Create table t1(n text, f1 int, f2 int); create table g1(n text, t1n text); create table s1(k1 text, f1a int, f1b ...
    Philip WarnerPhilip Warner
    Oct 29, 2001 at 3:13 am
    Oct 30, 2001 at 8:06 pm
  • A customer's machine hangs from time to time. All we could find so far is that postgres seems to be in state "idle in transaction": postgres 19317 0.0 0.3 8168 392 ? S Oct05 0:00 ...
    Michael MeskesMichael Meskes
    Oct 11, 2001 at 10:00 am
    Oct 29, 2001 at 7:05 am
  • ... work for you with code built from the cvs tip? I did an update and build tonight and see myst$ postmaster -i postgres: invalid option -- r Usage: postgres -boot [-d] [-D datadir] [-F] [-o file] ...
    Thomas LockhartThomas Lockhart
    Oct 19, 2001 at 6:17 am
    Oct 23, 2001 at 1:34 am
  • #create table t (v varchar); #insert into t values ('0123456789a0123456789b0123456789c0123456789d'); #select v from t; v ---------------------------------------------- ...
    Dave BlasbyDave Blasby
    Oct 3, 2001 at 6:40 pm
    Oct 12, 2001 at 6:06 pm
  • I just grabbed cvs tip this afternoon and ran into two issues: - First one is that the regression fails on "geometry" on what appears to be a difference in the 13th decimal place of the output value. ...
    Joe ConwayJoe Conway
    Oct 1, 2001 at 2:36 am
    Oct 2, 2001 at 12:22 pm
  • Right now, from what I can tell, the snapshot looks great to me: postgresql# ls -lt total 486 drwxrwxrwx 15 pgsql pgsql 512 Oct 15 04:04 src drwxrwxrwx 43 pgsql pgsql 1024 Oct 15 04:04 contrib ...
    Marc G. FournierMarc G. Fournier
    Oct 15, 2001 at 12:41 pm
    Oct 29, 2001 at 3:54 am
  • Hi, Version 7.1.3, Linux 2.2.18 Following procedure: 1. pg_dump dbname outfile Everything is fine. 2. Recreating the database on another system (same Versions) psql dbname < infile I get once: ERROR: ...
    Johann ZuschlagJohann Zuschlag
    Oct 19, 2001 at 10:38 pm
    Oct 22, 2001 at 9:28 pm
  • May be it's cosmetic, but: - "Migration to 7.1" right is "Migration to 7.2" Be missing: - information that some parts of interface are translated to Swedish, Russian, French, Germany nad Czech. (IMHO ...
    Karel ZakKarel Zak
    Oct 1, 2001 at 10:26 am
    Oct 29, 2001 at 7:15 pm
  • Greetings, PostgreSQL 7.1.3, FreeBSD-4.3-RELEASE, gcc 2.95.3 I'm trying to attempt to detect a failed backend connection, but a call to PQstatus() always returns the state of the backend when the ...
    Matthew HagertyMatthew Hagerty
    Oct 18, 2001 at 12:46 am
    Oct 19, 2001 at 10:04 am
  • Just updated... peter=# SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 20:38:40'); ERROR: Timestamp with time zone units 'dow' not recognized This is documented to work. peter=# SELECT EXTRACT(DOW ...
    Peter EisentrautPeter Eisentraut
    Oct 9, 2001 at 10:29 pm
    Oct 15, 2001 at 5:34 am
  • Is the developer's faq still a valid document? After last nite's website changes I've been tracking down missing items and this one pops up. The only place I see it tho is in the cvs Attic. Isn't the ...
    Vince VielhaberVince Vielhaber
    Oct 1, 2001 at 12:45 pm
    Oct 1, 2001 at 5:31 pm
  • I have traced down the postmaster-option-processing failure that Thomas reported this morning. It appears to be specific to systems running glibc: the problem is that resetting optind to 1 is not ...
    Tom LaneTom Lane
    Oct 19, 2001 at 9:50 pm
    Nov 7, 2001 at 3:40 am
  • Hmm, on trying it you are right. The second index creation blocks here: #6 0x1718e0 in XactLockTableWait (xid=17334) at lmgr.c:344 #7 0x9e530 in heap_mark4update (relation=0xc1be62f8, ...
    Tom LaneTom Lane
    Oct 23, 2001 at 6:17 pm
    Oct 26, 2001 at 1:42 am
  • I have tons of old files with names like base/db/pg_sorttemp####.##. I assume that they are temporary sorting files but somehow they never got cleared out. Is it safe to delete these from a running ...
    D'Arcy J.M. CainD'Arcy J.M. Cain
    Oct 17, 2001 at 7:46 pm
    Oct 20, 2001 at 4:38 pm
  • Hi, we'd like to submit new module contrib/tsearch which contains implementation of new data type txtidx - a searchable data type (textual) with indexed access. It's based on current CVS and will not ...
    Oleg BartunovOleg Bartunov
    Oct 12, 2001 at 3:04 pm
    Oct 15, 2001 at 11:36 pm
  • I'm curious as to whether anybody has gotten PostgreSQL to work with a database that lives on some sort of read-only medium...like a CD. I've looked around in the newsgroups and I've seen a comment ...
    Kelly HarmonKelly Harmon
    Oct 8, 2001 at 3:34 am
    Oct 12, 2001 at 6:35 pm
  • Patch fix memory leaks in src/backend/utils/fmgr/dfmgr.c . This leaks is very significant with massive update/insert tables with gist indexes in one transaction or with following sequence of ...
    Teodor SigaevTeodor Sigaev
    Oct 4, 2001 at 3:56 pm
    Oct 6, 2001 at 11:25 pm
  • Is this an expected behavior? I could not see why t1 and t2 are showing different time resolutions... test=# create table t3(t1 timestamp(2), t2 timestamp(2) default current_timestamp); CREATE test=# ...
    Tatsuo IshiiTatsuo Ishii
    Oct 4, 2001 at 4:51 am
    Oct 4, 2001 at 8:20 pm
  • Christof just told me that I overwrote Tom's patch fixing the setlocale problem in ecpg. I did not notice that and for some strange reason did not get Tom's mail either. Anyway, the CVS problem was ...
    Michael MeskesMichael Meskes
    Oct 2, 2001 at 2:17 pm
    Oct 4, 2001 at 6:31 am
  • HI, I've seen lots of talk about anoncvs not working, but I can't even find out where it is ;( The old address gives [hannu@taru pgsql]$ ../update.cvs cvs update: authorization failed: server ...
    Hannu KrosingHannu Krosing
    Oct 2, 2001 at 7:50 am
    Oct 2, 2001 at 1:21 pm
  • Looking over your question, I wanted to clarify the problem a bit, so: (cleaned up example a bit from Aasmund) -- set up tables drop view normal; drop view dbl; drop table raw; CREATE TABLE raw (id ...
    Joel BurtonJoel Burton
    Oct 21, 2001 at 3:29 am
    Nov 29, 2001 at 10:17 pm
  • Hi all, While testing 7.2b1 on unixware 711 and open unix 8 I have those errors on abstime, tinterval and horology. It doesn't seem to bad though. FWIW, here regression.out... Regards to all of you ...
    Olivier PRENANTOlivier PRENANT
    Oct 28, 2001 at 6:32 pm
    Oct 30, 2001 at 10:52 pm
  • Hi all! I wanted to propose a possible "rationalization" of the PostgreSQL naming scheme, as briefly outlined below. The following suggestion may seem like a trivial improvement to some, but to me it ...
    Robert DyasRobert Dyas
    Oct 27, 2001 at 2:52 am
    Oct 29, 2001 at 8:30 pm
  • The minor featurette seems to have crept into current sources; it is probably the cause of pg_dump being unable to reinstate disabled triggers. ...
    Philip WarnerPhilip Warner
    Oct 24, 2001 at 3:14 pm
    Oct 25, 2001 at 2:13 pm
  • I'm working on making some changes to the top level configure.in and m4 has now been running for 17 minutes on a 1.4G tbird. Am I missing something or is this know to take forever? Thanks guys, - ...
    BpalmerBpalmer
    Oct 18, 2001 at 2:13 am
    Oct 24, 2001 at 5:57 pm
Oct 2001
1234
Group Navigation
period‹ prev | Oct 2001 | next ›
Group Overview
grouppgsql-hackers @
categoriespostgresql
discussions198
posts1,155
users153
websitepostgresql.org...
irc#postgresql

153 users for October 2001

Tom Lane: 204 posts Bruce Momjian: 151 posts Thomas Lockhart: 64 posts Peter Eisentraut: 63 posts Tatsuo Ishii: 46 posts Bill Studenmund: 44 posts Marc G. Fournier: 37 posts Vince Vielhaber: 24 posts Lee Kindness: 23 posts Andreas Zeugswetter: 22 posts Jean-Michel Poure: 18 posts Mark L. Woodward: 18 posts Hannu Krosing: 17 posts Oleg Bartunov: 17 posts Hiroshi Inoue: 15 posts Christopher Kings-Lynne: 14 posts Lamar Owen: 13 posts Michael Meskes: 13 posts Brent Verner: 12 posts David Ford: 12 posts
show more
Archives