Search Discussions
-
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 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, 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 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 Eisentraut
Oct 14, 2001 at 8:45 pm
Oct 26, 2001 at 10:40 pm -
32
cvs problem
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 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 Ford
Oct 25, 2001 at 9:10 pm
Nov 12, 2001 at 4:42 am -
26
UNICODE
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 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 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 Ishii
Oct 1, 2001 at 4:15 am
Oct 5, 2001 at 5:42 pm -
Bill 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 Ishii
Oct 30, 2001 at 1:02 am
Oct 31, 2001 at 9:59 am -
15
7.2b1 ...
... is now packaged ... mirrors will pick it up soon, but if anyone wants to do a quick check, its in /pub/beta ...Marc 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 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 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 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 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 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 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 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 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 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 Jong
Oct 19, 2001 at 11:35 am
Oct 26, 2001 at 10:05 am -
10
pgindent run
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 Momjian
Oct 24, 2001 at 5:55 pm
Oct 28, 2001 at 6:24 am -
10
FAQ error
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 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 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 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 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 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 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 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. 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 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 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 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 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 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 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 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. 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 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 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 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 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 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 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 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 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 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 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, - ...
Bpalmer
Oct 18, 2001 at 2:13 am
Oct 24, 2001 at 5:57 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 198 |
posts | 1,155 |
users | 153 |
website | postgresql.org... |
irc | #postgresql |
153 users for October 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)