Search Discussions
-
From what I know it is possible to simply restore one table file since pg_log keeps all tid's. Of course it cannot guarantee integrity and does not work if the table was altered. In the last proposal ...
Andreas Zeugswetter
Jun 15, 2000 at 7:31 am
Jul 2, 2000 at 3:16 pm -
I am considering making some changes to pg_dump, and would appreciate any suggestions/ideas from the list. The outline is as follows: - Add a flag to modify the output of pg_dump so that it is more ...
Philip Warner
Jun 22, 2000 at 4:51 pm
Oct 11, 2000 at 1:07 am -
I have finished updating about half of Postgres' builtin functions to the new style of fmgr interface. At this point, everything that accepts any pass-by-value datatypes is converted; the remaining ...
Tom Lane
Jun 14, 2000 at 4:55 pm
Aug 17, 2000 at 12:02 pm -
Well, in attempting to build RPMs for 7.0.1, I have unearthed a 26 megabyte problem. 26 megabytes is the difference in the size of an unpacked 7.0.1 source tree versus 7.0. 7.0.1 is 26 MB _smaller_. ...
Lamar Owen
Jun 4, 2000 at 4:52 am
Jun 13, 2000 at 12:52 pm -
It seems the truncate command deletes all rows from a table even it is referenced by another tables. TRUNCATE is not in the standard any way, so I would not claim this is a bug. However, sometimes it ...
Tatsuo Ishii
Jun 8, 2000 at 12:22 pm
Oct 9, 2000 at 7:42 pm -
I'd like to change some things about how the code handles the information about its own version number. The version number would be set in configure.in as in VERSION='1.2.3' (Keep it in configure.in ...
Peter Eisentraut
Jun 29, 2000 at 11:27 pm
Jul 8, 2000 at 4:04 pm -
While people are working on that, they might want to add some sanity checking to the multibyte character decoders. Currently they fail to check for "illegal" character sequences (i.e. sequences with ...
Michael Robinson
Jun 14, 2000 at 9:24 am
Jun 25, 2000 at 4:38 pm -
Hello all, This is the result of my 6 days "war" with Linux kernel people... Any usefull comments on this???? ---------- Forwarded Message ---------- Subject: Re: Fwd: Problem with recv syscall on ...
Denis Perchine
Jun 27, 2000 at 4:45 pm
Jul 5, 2000 at 6:01 pm -
I'm about halfway done with revising backend memory management per the discussions on pghackers around the end of April (see the just-committed src/backend/utils/mmgr/README for latest version of the ...
Tom Lane
Jun 28, 2000 at 5:04 pm
Jul 1, 2000 at 2:57 pm -
After further thought I think there's a lot of merit in Hiroshi's opinion that physical file names should not be tied to relation OID. If we use a separately generated value for the file name, we can ...
Tom Lane
Jun 16, 2000 at 5:51 pm
Jun 20, 2000 at 10:51 pm -
I have prepared the REL7_0_PATCHES tree for 7.0.1. Here are the changes. --------------------------------------------------------------------------- Release 7.0.1 This is basically a cleanup release ...
Bruce Momjian
Jun 1, 2000 at 5:15 am
Jun 6, 2000 at 7:34 am -
I'm in the process of fixing build problems in 7.0.2 for Solaris CC (not GCC). 1. I'm curious why src/template/solaris_sparc_cc contains: -DDISABLE_COMPLEX_MACRO src/templates/solaris_i386_cc does ...
Pgsql-hackers
Jun 28, 2000 at 3:17 am
Oct 12, 2000 at 2:42 pm -
I'm making consistent accessor functions to all of the special file names used in the backend (e.g., "pg_hba.conf", "pg_control", etc.) and I got to the pid file stuff. I'm wondering why you call the ...
Peter Eisentraut
Jun 23, 2000 at 4:14 pm
Jun 26, 2000 at 12:44 pm -
Something changed in 7.02 from 6.3. I used to do this: CREATE FUNCTION make_date() RETURNS opaque AS '/usr/pgsql/modules/make_date.so' LANGUAGE 'c'; CREATE TRIGGER make_edate BEFORE INSERT OR UPDATE ...
D'Arcy J.M. Cain
Jun 16, 2000 at 12:43 pm
Jun 22, 2000 at 1:59 pm -
I have committed new warning code to alert users who auto-create relations without knowing it. The new code does not throw a warning for: SELECT pg_language.*; but does throw one for: SELECT ...
Bruce Momjian
Jun 3, 2000 at 4:40 am
Jun 5, 2000 at 12:15 am -
Attached is a first attempt at implementing the classoid feature. It works! Can the postgres gurus comment if I've done it right and point out any problems. A lot of it was guess work so I'm sure it ...
Chris Bitmead
Jun 24, 2000 at 3:26 pm
Oct 10, 2000 at 10:24 pm -
I've started doing a bit of work on gram.y, and am noticing some new cruftiness in the Makefile: if I add tokens to gram.y/keywords.c then I can't just remake in that directory since parse.h is not ...
Thomas Lockhart
Jun 26, 2000 at 1:36 pm
Jul 2, 2000 at 3:15 pm -
The problem here is that given the search pattern '\341%', the planner generates index limit conditions name = '\341' AND name < '\342'; Apparently, in CZ locale it is true that '\341' is less than ...
Tom Lane
Jun 8, 2000 at 2:22 am
Jun 9, 2000 at 8:10 pm -
A minor nasty error I got when trying to improve the query used to disable triggers: create table t1(f1 int4, f2 int4); create table t2(f1 int4, f2 int4); insert into t1 values(1, 0); insert into t1 ...
Philip Warner
Jun 30, 2000 at 11:55 am
Dec 5, 2001 at 9:05 pm -
Can someone give me a TODO summary for this issue? [ Charset ISO-8859-1 unsupported, converting... ] -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your ...
Bruce Momjian
Jun 9, 2000 at 8:31 pm
Oct 3, 2000 at 4:16 am -
afaik, no. I've got a Mandrake 7.0.x machine at home, and a 7.0 laptop which is apparently not quite the same thing since one was upgraded from 6.1 and the other was a clean install. But my laptop ...
Thomas Lockhart
Jun 14, 2000 at 12:35 pm
Jun 23, 2000 at 8:12 pm -
10
day of week
We have for same questions different answers now: (DAY OF WEEK) test=# select date_part('dow', now()); date_part ----------- 1 (1 row) test=# select to_char(now(), 'D'); to_char --------- 2 (1 row) ...Karel Zak
Jun 5, 2000 at 8:53 pm
Jun 13, 2000 at 1:15 pm -
Hi, I know it doesn't show in a patch, but.. there are some rogue spaces at the end of the line containing "usecreatetable". Keith. *** pgsql/src/bin/initdb/initdb.sh Fri Jun 9 18:09:51 2000 --- ...
Keith Parks
Jun 9, 2000 at 11:13 pm
Jun 12, 2000 at 4:08 pm -
Can someone comment on where we are with DROP COLUMN? -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ ...
Bruce Momjian
Jun 8, 2000 at 3:09 am
Jun 9, 2000 at 12:09 am -
Hello, newbie here. I need 64-bit sequences. I started looking at sequence.h, sequence.c, and some other files, and I have some questions before I start mucking up your code. :-) (I'd rather do it ...
Paul Caskey
Jun 23, 2000 at 3:32 am
Jul 5, 2000 at 9:35 pm -
I have a query crashing the backend and leaving this message in the server log... What does exit status 139 mean? Better still would be a pointer to some documentation for error codes if such beast ...
Ed Loehr
Jun 23, 2000 at 6:11 pm
Jun 26, 2000 at 11:51 am -
I've seen a number of RDBMSs that require that an entire database (whatever they call a database) has to be in the same code page. There are disadvantages in this. With those disadvantages in mind ...
Randall Parker
Jun 21, 2000 at 9:23 pm
Jun 22, 2000 at 10:30 pm -
I just upgraded to 7.0.2. Everything looks fine, except for one (annoying) change. I have an attribute in a table named "significance_of_anova_for_spike_rates". (I know, I know. I get laughed at all ...
G. Anthony Reina
Jun 14, 2000 at 1:23 am
Jun 16, 2000 at 2:05 am -
Hi all, I regularly do a "cvs update" and compile and test PostgreSQL. Recently, since about 1 week, I've had a nasty problem. Doing an "initdb" seems to suck up all available memory and almost kills ...
Keith Parks
Jun 1, 2000 at 8:32 pm
Jun 3, 2000 at 2:50 am -
Hi all, I've had a table for years to keep radius connections to our NAS. Not havin inet type, I typed ip_adress as text. Now, I'em trying to change this column type to no avail. select ...
Olivier PRENANT
Jun 2, 2000 at 4:27 pm
Jun 2, 2000 at 10:32 pm -
Hi folks, This is my first post to your list. I've been reading it for about a week. I like the quality of the developers here and think this portends well for the future of Postgres. Anyway, an ...
Randall Parker
Jun 21, 2000 at 8:12 pm
Jun 22, 2000 at 11:39 am -
In the following archived email: http://www.postgresql.org/mhonarc/pgsql-admin/2000-05/msg00025.html this was posed as a solutions to modifying the NOT NULL constraint: I didn't find any further ...
Dan Wilson
Jun 14, 2000 at 3:27 am
Jun 14, 2000 at 11:07 pm -
Hello all, While digging the code I found out quite interesting comment in src/backend/access/heap/hio.c before function RelationPutHeapTupleAtEnd * Eventually, we should cache the number of blocks ...
Denis Perchine
Jun 12, 2000 at 5:38 pm
Jun 13, 2000 at 3:03 am -
Is PostgreSQL going to start using odd release numbers for development versions? This is how the Linux kernel is, and some other projects. Version.release.revision/build Like 7.0.x would be the ...
Robert B. Easter
Jun 6, 2000 at 3:44 pm
Jun 7, 2000 at 3:13 am -
Yes, only Bruce and I are of the opinion that it *is* an Error, and I guess we want some consensus. The notice is imho of the sort: notice this syntax is going to be disallowed soon. Andreas
Andreas Zeugswetter
Jun 5, 2000 at 8:03 am
Jun 6, 2000 at 4:31 pm -
Hello, This is a report on my attempts to install unixODBC (1.8.9) and postgres odbc driver on IRIX 6.5.7 64bit using the native compiler. There are a number of changes that were necessary to be made ...
Murad Nayal
Jun 14, 2000 at 8:27 pm
Jun 15, 2000 at 7:13 pm -
Who's maintaining the ODBC configure and build stuff? There's a grave issue with ODBC linking in all kinds of makefiles, templates, header files, etc. from the main Postgres configure process. That ...
Peter Eisentraut
Jun 5, 2000 at 12:15 am
Jun 13, 2000 at 3:02 pm -
Can anyone comment on this work? Karel? -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your ...
Bruce Momjian
Jun 13, 2000 at 12:32 am
Jun 13, 2000 at 9:02 am -
http://linuxworld.com/linuxworld/lw-2000-06/lw-06-S390-3.html This article, while on the subject of Linux for IBM System/390 mainframes, also notes that PostgreSQL was easily brought up on that ...
Lamar Owen
Jun 22, 2000 at 8:17 pm
Jun 25, 2000 at 2:08 am -
In looking at the INSTALL/install.sgml files, I see that there are no instructions for removing the /data directory after the backup, so initdb will succeed. Should that be suggested after the backup ...
Bruce Momjian
Jun 5, 2000 at 10:59 am
Jun 8, 2000 at 5:12 pm -
Hello all, I did small patch for subj. I am sure that it is not perfect, but it works for me. I will continue its testing. This is my first patch to pgsql. If you will find some obvious mistakes, do ...
Denis Perchine
Jun 10, 2000 at 11:05 pm
Oct 3, 2000 at 3:45 am -
Please note that as I've just moved home, my home internet connection is not up at the moment, so it's better to send emails about the JDBC driver to my work's address: petermount@it.maidstone.gov.uk ...
Peter Mount
Jun 26, 2000 at 8:06 am
Jul 12, 2000 at 11:36 am -
I see mention in SQL99 of function definitions which can have IN, OUT, and INOUT arguments. Any thoughts on how this could be supported in Postgres? I assume that we would need to figure out how to ...
Thomas Lockhart
Jun 27, 2000 at 2:39 am
Jun 27, 2000 at 3:43 pm -
Please help! Unfortunetely I gave numbers for user names (column "usename" in pg_shadow). Now in 7.0 we have ALTER GROUP, but the statement test=# ALTER GROUP anygroup ADD USER 1234; where 1234 can ...
Kovacs Zoltan Sandor
Jun 22, 2000 at 8:45 pm
Jun 24, 2000 at 10:15 am -
inside the backend, if I have a TupleTableSlot, can I find out from what basetable it is referring to or not?
Chris Bitmead
Jun 23, 2000 at 12:42 am
Jun 23, 2000 at 8:33 am -
Current cvs compiled on Solaris gives the following error... In file included from ../../include/tcop/tcopprot.h:22, from pg_proc.c:26: /usr/include/setjmp.h:70: conflicting types for `jmp_buf' ...
Chris Bitmead
Jun 19, 2000 at 1:43 am
Jun 19, 2000 at 6:55 am -
I have 2 tables with indices as follows: Table "activity" (~4000 rows) id serial start_time timestamp not null stop_time timestamp not null ... CREATE INDEX activity_start_time ON activity ...
Ed Loehr
Jun 16, 2000 at 5:32 pm
Jun 16, 2000 at 10:48 pm -
Maybe Tom Lane can comment on wither it also has setproctitle(). -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe ...
Bruce Momjian
Jun 13, 2000 at 9:00 am
Jun 14, 2000 at 3:38 am -
Hi, Can you tell me trim() spec, please ? (This problem has been discussed in pgsql-jp ML. ) In trim(trailing 'abc' from '123cbabc') function, 'abc' means ~'[abc]'. pgbash select trim(trailing 'abc' ...
SAKAIDA Masaaki
Jun 3, 2000 at 3:22 am
Jun 13, 2000 at 3:26 pm -
Not sure this belongs in the FAQ. Seems more of a web page thing. -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe ...
Bruce Momjian
Jun 1, 2000 at 1:23 am
Jun 2, 2000 at 11:42 pm
Group Overview
group | pgsql-hackers |
categories | postgresql |
discussions | 223 |
posts | 1,283 |
users | 124 |
website | postgresql.org... |
irc | #postgresql |
124 users for June 2000
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)