Re: [HACKERS] Full socket send buffer prevents cancel, timeout

2008-10-25 Thread Michael Fuhr
On Sat, Oct 25, 2008 at 12:36:24PM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > If the write is interrupted by a timeout or cancel, can anything > > be done here or elsewhere to abort the statement and release its > > locks? > > The best

[HACKERS] Full socket send buffer prevents cancel, timeout

2008-10-25 Thread Michael Fuhr
to execute a query that returns enough data to fill both the client's and the server's socket buffers, then go to sleep without reading the response). -- Michael Fuhr -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] DROP DATABASE always seeing database in use

2008-08-04 Thread Michael Fuhr
ther users. Are any prepared transactions still open? select * from pg_prepared_xacts; -- Michael Fuhr -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-16 Thread Michael Fuhr
http://www.securityfocus.com/archive/1/471541/30/0/threaded -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] [COMMITTERS] pgsql: Avoid losing track of data for shared tables in pgstats.

2007-06-07 Thread Michael Fuhr
um, so I assume it doesn't. Doesn't appear to, at least not using the test case I found for 8.1 and later. -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an

Re: [HACKERS] [COMMITTERS] pgsql: Avoid losing track of data for shared tables in pgstats.

2007-06-07 Thread Michael Fuhr
improved immediately. INFO: "pg_shdepend": found 8475403 removable, 3907 nonremovable row versions in 76783 pages -- Michael Fuhr ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] Vacuuming anything zeroes shared table stats

2007-06-07 Thread Michael Fuhr
ecome zero, which should be within 15 seconds. Repeating the experiment should reveal a 15-second cycle of statistics resets. In case this behavior is platform-dependent I'm testing on Solaris 9 sparc. -- Michael Fuhr ---(end of broadcast)--- T

[HACKERS] Vacuuming anything zeroes shared table stats

2007-06-06 Thread Michael Fuhr
0 | 0 pg_toast_1260|0 |0 | 0 | 0 | 0 pg_toast_1262|0 |0 | 0 | 0 | 0 pg_toast_2396|0 |0 | 0 | 0 | 0 (10 rows) -- Michael Fuhr ---

Re: [HACKERS] What is the maximum encoding-conversion growth rate, anyway?

2007-05-29 Thread Michael Fuhr
9). PostgreSQL doesn't currently support such conversions but it's something to be aware of. -- Michael Fuhr ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] What is the maximum encoding-conversion growth rate, anyway?

2007-05-28 Thread Michael Fuhr
3, not 6? Or does that 2-byte SHIFT_JIS_2004 sequence have a 1-byte sequence in another supported encoding? Or am I missing something? -- Michael Fuhr ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [HACKERS] Fate of pgsnmpd

2007-04-07 Thread Michael Fuhr
urrently using MRTG to execute Perl scripts that query the statistics views and I've been thinking about rewriting those scripts to be AgentX subagents so they'd be queryable via SNMP. -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versi

Re: [HACKERS] sorted results on pgbuildfarm

2007-03-27 Thread Michael Fuhr
On Tue, Mar 27, 2007 at 07:33:08AM -0400, Andrew Dunstan wrote: > We can certainly provide a different view, or sort it by system name, What about making the column headers clickable to control the sort order? -- Michael Fuhr ---(end of broadc

Re: [HACKERS] Bug in UTF8-Validation Code?

2007-03-13 Thread Michael Fuhr
nto the database, and this release properly accepts only valid UTF-8 sequences. One way to correct a dumpfile is to run the command iconv -c -f UTF-8 -t UTF-8 -o cleanfile.sql dumpfile.sql." -- Michael Fuhr ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] Race condition in pg_database_size()

2007-03-10 Thread Michael Fuhr
On Sat, Mar 10, 2007 at 05:39:37PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > I'll submit a patch -- any preferences for silent continuation vs. > > continuation with a notice or warning? > > I think silent is fine for ENOENT cases. We k

Re: [HACKERS] Race condition in pg_database_size()

2007-03-10 Thread Michael Fuhr
On Sat, Mar 10, 2007 at 12:32:04PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > I'm wondering if the code should check for ENOENT if stat() fails > > and either skip this entry silently under the assumption that the > > file had been d

[HACKERS] Race condition in pg_database_size()

2007-03-10 Thread Michael Fuhr
errmsg("could not stat file \"%s\": %m", filename))); dirsize += fst.st_size; } I'm wondering if the code should check for ENOENT if stat() fails and either skip this entry silently under the assumption that the file had been deleted since the call to ReadDir(), or

Re: [HACKERS] \copy (query) delimiter syntax error

2007-02-03 Thread Michael Fuhr
port USING DELIMITERS. COPY tablename does, so it has worked all along. -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] \copy (query) delimiter syntax error

2007-02-03 Thread Michael Fuhr
SING DELIMITERS kept for backward compatibility. 2002-06-15 */ opt_using DELIMITERS Sconst What should be fixed -- COPY or \copy? Does psql's \copy still need backward compatibility to unsupported pre-7.3? -- Michael Fuhr ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[HACKERS] DROP FUNCTION failure: cache lookup failed for relation X

2007-01-21 Thread Michael Fuhr
stumble across it in a test environment. -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] psql display of Unicode combining characters in 8.2

2006-12-27 Thread Michael Fuhr
minor differences in the rendered glyphs, which tells me that I am indeed receiving the decomposed sequences. Thanks! -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail com

Re: [HACKERS] Possible documentation error

2006-12-26 Thread Michael Fuhr
x +-- (0,1) |1 (4,92) | 1000 (2 rows) test=> VACUUM foo; VACUUM test=> SELECT ctid, x FROM foo; ctid | x +-- (0,1) |1 (4,92) | 1000 (2 rows) test=> VACUUM FULL foo; VACUUM test=> SELECT ctid, x FROM foo; ctid | x

Re: [HACKERS] EAN barcode datatype

2006-11-13 Thread Michael Fuhr
inserts. > > Can this code is useful for postgresql community? Are you familiar with the contrib/ian module that will be in 8.2? -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] estimated_count() implementation

2006-10-21 Thread Michael Fuhr
people who ask for the feature would find this a satisfactory answer :-(" http://archives.postgresql.org/pgsql-hackers/2005-11/msg00579.php http://archives.postgresql.org/pgsql-hackers/2005-11/msg00580.php -- Michael Fuhr ---(end of broadcast)--

Re: [HACKERS] ECPG connection target formats

2006-09-14 Thread Michael Fuhr
out releasing 8.1.5 soon I'm hoping to submit a patch before that happens. -- Michael Fuhr ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Release notes

2006-09-12 Thread Michael Fuhr
On Tue, Sep 12, 2006 at 02:31:22PM -0400, Bruce Momjian wrote: > I again will not be able to complete the release notes today as > promised. My next target date is Monday, August 18. Sorry. The next Monday, August 18, is in 2008. Surely that'll be enough time ;-) -- M

Re: [HACKERS] contrib uninstall scripts need some love

2006-09-10 Thread Michael Fuhr
On Sun, Sep 10, 2006 at 07:38:24PM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > I spent a few minutes doing the same tests I did a few months ago > > and found problems with dblink and ltree; I'll submit patches for > > those. Tom, do y

[HACKERS] contrib/xml2 and PG_MODULE_MAGIC

2006-09-10 Thread Michael Fuhr
contrib/xml2 currently has PG_MODULE_MAGIC in xslt_proc.c, which results in a runtime error on systems that built the module without support for libxslt per the comments in the Makefile. Should PG_MODULE_MAGIC be in xpath.c instead? -- Michael Fuhr ---(end of broadcast

Re: [HACKERS] contrib uninstall scripts need some love

2006-09-10 Thread Michael Fuhr
, do you recall which modules gave you trouble? -- Michael Fuhr ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] contrib uninstall scripts need some love

2006-09-10 Thread Michael Fuhr
dule, as shown by getting errors if you then try to reinstall it). > >Seems like this area needs more attention ... anyone want to work on it? > > I'll take it. How long do I have? For reference, here are some comments about the cleanup work I did a while back: http:

Re: [HACKERS] ECPG/OpenBSD buildfarm failures, take I

2006-09-06 Thread Michael Fuhr
ant people to register to read the specification; you can get there from here: http://www.opengroup.org/online-pubs-short?DOC=9699959299&FORM=HTML -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] ECPG connection target formats

2006-08-26 Thread Michael Fuhr
names are passed as written, so I'm not seeing how the case-insensitivity rules are being applied. Should this be reworded or omitted altogether? Or is there something I'm missing? Other comments? Thanks. -- Michael Fuhr ---(end of broadcast)-

Re: [HACKERS] [PATCHES] plpython improvements

2006-08-18 Thread Michael Fuhr
her PyObject_Str() can possibly return NULL, but several occurrences of the above code snippet caught my eye because we had dealt with it before. -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

Re: [HACKERS] Can I assume there's only one _RETURN rule?

2006-08-17 Thread Michael Fuhr
anywhere. > > Damifino ... Jan might remember. Retrieve-Instead-Retrieve, according to this message from Jan: http://archives.postgresql.org/pgsql-hackers/2003-03/msg01219.php -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Custom variable class segmentation fault

2006-08-13 Thread Michael Fuhr
ext=PGC_POSTMASTER) at guc-file.l:152 #3 0x0025d80c in SelectConfigFiles (userDoption=0x1 , progname=0x390610 "postgres") at guc.c:2867 #4 0x0019a450 in PostmasterMain (argc=5, argv=0x391240) at postmaster.c:602 #5 0x001518c8 in main (argc=5, argv=0x391240) at main.c:187 -- Michael

[HACKERS] pgcrypto deprecated functions?

2006-08-04 Thread Michael Fuhr
In README.pgcrypto, Section 2.3 "Deprecated functions" says that digest_exists(), hmac_exists(), and cipher_exists() are planned to be removed in PostgreSQL 8.2. Those functions still exist -- should they be removed or does that section need updating? -- Mi

Re: [HACKERS] [PATCHES] tg_trigtuple/tg_newtuple settings in AFTER triggers

2006-08-03 Thread Michael Fuhr
On Thu, Aug 03, 2006 at 12:05:23PM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > Set tg_trigtuple/tg_newtuple in AFTER triggers according to whether > > old and new tuples were supplied rather than blindly setting them > > according to the eve

[HACKERS] pg_dump dumping entire system catalogs

2006-08-01 Thread Michael Fuhr
pg_dump in HEAD is dumping the entire contents of system catalogs. New feature? :-( -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED

Re: [HACKERS] tg_trigtuple not NULL in AFTER STATEMENT triggers?

2006-07-31 Thread Michael Fuhr
On Mon, Jul 31, 2006 at 11:12:14AM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > I've noticed that tg_trigtuple and tg_newtuple aren't cleared to > > NULL in AFTER STATEMENT triggers. Is that an oversight, > > Probably. S

[HACKERS] tg_trigtuple not NULL in AFTER STATEMENT triggers?

2006-07-31 Thread Michael Fuhr
me other reason? -- Michael Fuhr ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] pgxs problem

2006-07-19 Thread Michael Fuhr
l. Prefixing each command with pgXX is a minor nuisance but by being explicit I always know what version I'm using. What are others doing? -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] url for TODO item, is it right?

2006-07-16 Thread Michael Fuhr
.postgresql.org/pgsql-hackers/2006-02/msg00165.php > > But i don't understand why that thread is related to the TODO item, > i'm missing something? Possibly the message renumbering that Tom griped about: http://archives.postgresql.org/pgsql-www/2006-07/msg00061.php -- Michael

[HACKERS] cursors, current_user, and SECURITY DEFINER

2006-07-09 Thread Michael Fuhr
? If not, are there good reasons for doing it one way or the other? I haven't considered the implications thoroughly enough to have a position either way. -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posting/reading through Usen

Re: [HACKERS] getting type name

2006-07-09 Thread Michael Fuhr
od(), both declared in utils/builtins.h and defined in src/backend/utils/adt/format_type.c. -- Michael Fuhr ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] regresssion script hole

2006-06-18 Thread Michael Fuhr
On Sun, Jun 18, 2006 at 07:18:07PM -0600, Michael Fuhr wrote: > Maybe I'm misreading the packet, but I think the query is for > ''kaltenbrunner.cc (two single quotes followed by kaltenbrunner.cc) Correction: ''.kaltenbrunner.cc -- Michael Fuhr -

Re: [HACKERS] regresssion script hole

2006-06-18 Thread Michael Fuhr
unner.cc" and > failing. Maybe I'm misreading the packet, but I think the query is for ''kaltenbrunner.cc (two single quotes followed by kaltenbrunner.cc) and the DNS server is responding with SRVFAIL. -- Michael Fuhr ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[HACKERS] anoncvs still slow

2006-05-27 Thread Michael Fuhr
anoncvs (svr4, 66.98.251.159) is still slow responding to "cvs update"; it's been spotty for about a week now. Tcpdump shows connections being established but then long delays for ACKs, sometimes long enough for cvs to time out. Any updates on what's going o

Re: [HACKERS] Why is CVS server so slow?

2006-05-23 Thread Michael Fuhr
stgresql.org (66.98.251.159) has been slow for a couple of days -- it just took over five minutes to do a cvs update of HEAD where it usually takes thirty seconds or less. -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have you

Re: [HACKERS] DH_check return value test correct?

2006-05-12 Thread Michael Fuhr
On Fri, May 12, 2006 at 06:39:44PM -0400, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > If $PGDATA/dh1024.pem exists and if SSL connections are enabled, > > then each SSL connection logs the following: > > DH_check error (dh1024.pem): No SSL error re

[HACKERS] DH_check return value test correct?

2006-05-12 Thread Michael Fuhr
the hardcoded parameters. The SSL connection works, but with DH parameters other than intended. -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [HACKERS] Index scans when bitmap scans disabled

2006-04-23 Thread Michael Fuhr
t; a pretty narrow scenario. Thanks -- I was just wondering if the behavior was expected or not. -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

[HACKERS] Index scans when bitmap scans disabled

2006-04-23 Thread Michael Fuhr
6.03 rows=2 width=4) Index Cond: ((id = 1) OR (id = 2)) (2 rows) -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] How to implement oracle like rownum(function or seudocolumn) ?

2006-04-08 Thread Michael Fuhr
|2 | bar-2 5 | 3 | foo-3 |1 | bar-1 6 |3 | foo-3 |2 | bar-2 (6 rows) -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Postgres dies when using an intarray operator

2006-04-01 Thread Michael Fuhr
isplay a stack trace. To see examples search the archives for words like "gdb" and "stack trace" -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Postgres dies when using an intarray operator

2006-04-01 Thread Michael Fuhr
xt)))->type) == T_AllocSetContext", File: "mcxt.c", Line: 612) -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Uninstall script errors

2006-03-05 Thread Michael Fuhr
quot; would be a "limited cascade" whereby DROP TYPE would cascade to the I/O functions but would raise an error if other dependent objects still exist. Comments? Other possibilities? -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versi

Re: [HACKERS] Deleting loid from the database

2006-03-05 Thread Michael Fuhr
On Sun, Mar 05, 2006 at 09:54:02PM +0800, Christopher Kings-Lynne wrote: > contrib/vacuumlo perhaps? vacuumlo only calls lo_unlink(); the data still exists in pg_largeobject due to MVCC. -- Michael Fuhr ---(end of broadcast)--- TIP 3: Have

Re: [HACKERS] Deleting loid from the database

2006-03-03 Thread Michael Fuhr
the space for re-use by PostgreSQL without shrinking the file (unless the table has no live tuples, in which case the file size will be zeroed). -- Michael Fuhr ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] ACCESS EXCLUSIVE LOCK

2006-03-03 Thread Michael Fuhr
ed commands acquire ACCESS EXCLUSIVE, just that certain commands do. TRUNCATE isn't shown. -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] ipcclean in 8.1 broken?

2006-03-03 Thread Michael Fuhr
ire registration to read. If that's true then it seems silly that they're available to anybody who knows the URL.) > Can we assume 'id' is on all unix systems? It's defined in Shell and Utilities (XCU). If the system doesn't have it then one must wonder what else t

Re: [HACKERS] Uninstall script errors

2006-03-02 Thread Michael Fuhr
On Thu, Mar 02, 2006 at 02:49:13PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > Would it make sense for DROP TYPE to have some kind of limited > > cascade so you could drop a type and its I/O functions at the same > > time, but still get an error

Re: [HACKERS] Uninstall script errors

2006-03-02 Thread Michael Fuhr
On Thu, Mar 02, 2006 at 12:52:05AM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > ... I started to work on a patch but I wasn't sure how > > to handle the chicken-and-egg situation of dropping a type and its > > I/O functions. Is there an

Re: [HACKERS] display processing time?

2006-03-01 Thread Michael Fuhr
l.conf. -- Michael Fuhr ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] bug in 7.3.2

2006-03-01 Thread Michael Fuhr
have no gaps. -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] Uninstall script errors

2006-02-28 Thread Michael Fuhr
were never created. I started to work on a patch but I wasn't sure how to handle the chicken-and-egg situation of dropping a type and its I/O functions. Is there any way to do that other than DROP TYPE CASCADE? Should the uninstall scripts be doing that? -- Mi

[HACKERS] pg_roles: unrecognized token: ":aliasname"

2006-02-23 Thread Michael Fuhr
t; This breaks several things, including pg_dump. A newly-initdb'd cluster doesn't have the problem. Was something changed that should have bumped the catalog version? -- Michael Fuhr ---(end of broadcast)--- TIP 9: In version

[HACKERS] PL/pgSQL caught exceptions leak memory?

2006-02-21 Thread Michael Fuhr
see the effect). -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] postgresql query string length limit

2006-02-19 Thread Michael Fuhr
this behavior (e.g, psql, Pgadmin etc). Are you cutting and pasting from one window into another? If so then I wonder if something like the terminal's buffer size is the problem. -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Config file for psql

2006-02-18 Thread Michael Fuhr
vice.conf? Hardly anybody ever mentions it even though the libpq documentation refers to it; I wonder how many people even know it exists. http://www.postgresql.org/docs/8.1/interactive/libpq.html#LIBPQ-CONNECT http://www.postgresql.org/docs/8.1/interactive/libpq-envars.html -- Mic

Re: [HACKERS] Updated email signature

2006-02-18 Thread Michael Fuhr
) Did plenty of that, though usually on 3C00-3FFF. -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Updated email signature

2006-02-17 Thread Michael Fuhr
On Fri, Feb 17, 2006 at 09:35:32PM -0400, Marc G. Fournier wrote: > Sorry, I was still in Junior High in '82 :( Man, you are *old* :) Anybody know some reasonable postgresql.conf settings for a system that starts up with Cass? Memory Size? 'cuz I still have one :-) --

Re: [HACKERS] Want to add to contrib.... xmldbx

2006-01-29 Thread Michael Fuhr
ems, PgFoundry ingots? :) Tusks? (Extensions of the elephant.) -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your messa

[HACKERS] Rollback Mountain

2006-01-25 Thread Michael Fuhr
ecstatic, bitter, and conflicted. -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] un-vacuum?

2006-01-19 Thread Michael Fuhr
include creating unanalyzed tables in dire need of vacuuming. 2. Use createdb or CREATE DATABASE to create a new database using the database in (1) as the template. 3. Run tests in the new database. 4. Repeat (2) and (3) as necessary. -- Michael Fuhr ---(end of broa

Re: [HACKERS] un-vacuum?

2006-01-19 Thread Michael Fuhr
familiar with reading the pg_stats view. http://www.postgresql.org/docs/8.1/interactive/catalog-pg-statistic.html -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan

Re: [HACKERS] un-vacuum?

2006-01-19 Thread Michael Fuhr
t this un-vacuum to have? What problem are you trying to solve? -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Error working with Temporary Sequences in plpgsql in 8.1 (8.0 works fine)

2006-01-17 Thread Michael Fuhr
quence functions like nextval() to take a regclass argument (the sequence OID) instead of a text argument (the sequence name); that would affect what gets put in the function's cached plan. -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have y

Re: [HACKERS] cvs update taking a long time

2006-01-10 Thread Michael Fuhr
On Tue, Jan 10, 2006 at 07:44:23PM -0700, Michael Fuhr wrote: > I just ran "cvs update" in my 8.1 source tree and it took nearly > 25 minutes to complete; it usually takes about 30-60 seconds. Is > anybody else seeing problems? I forgot to mention that th

[HACKERS] cvs update taking a long time

2006-01-10 Thread Michael Fuhr
I just ran "cvs update" in my 8.1 source tree and it took nearly 25 minutes to complete; it usually takes about 30-60 seconds. Is anybody else seeing problems? -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, t

Re: [HACKERS] broken 'SHOW TABLE'-like query works in 8, not 8.1.1

2005-12-30 Thread Michael Fuhr
On Fri, Dec 30, 2005 at 11:02:20AM -0700, Michael Fuhr wrote: > On Fri, Dec 30, 2005 at 03:15:03AM -0500, Sebastian wrote: > > Any ideas for a temporary work around? > > You could try querying the system catalogs directly instead of using > the information_schema views;

[HACKERS] Anonymous CVS having problems?

2005-12-30 Thread Michael Fuhr
It's been several hours since Tom's "Repair EXPLAIN failure" commit but anonymous CVS doesn't have it yet. That seems slower than usual; are there any problems? -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posti

Re: [HACKERS] broken 'SHOW TABLE'-like query works in 8, not 8.1.1

2005-12-30 Thread Michael Fuhr
t; to see what kinds of queries to make. See also "System Information Functions" and "System Catalogs" in the documentation. http://www.postgresql.org/docs/8.1/interactive/functions-info.html http://www.postgresql.org/docs/8.1/interactive/catalogs.html -- Michael Fuhr -

Re: [HACKERS] broken 'SHOW TABLE'-like query works in 8, not 8.1.1

2005-12-29 Thread Michael Fuhr
columns; with more columns the time continues to increase although not as sharply. I don't see such an increase in 8.0.5. Querying the views individually doesn't take long; I wonder if the planner is doing something wrong with the join operation. -- Michael Fuhr -

Re: [HACKERS] broken 'SHOW TABLE'-like query works in 8, not 8.1.1

2005-12-29 Thread Michael Fuhr
gt; EXPLAIN SELECT * FROM information_schema.element_types; ERROR: record type has not been registered -- Michael Fuhr ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] where is the output

2005-12-23 Thread Michael Fuhr
e client's stdin and stdout. The client writes data to and reads data from the connection using the API functions for doing so; where the client gets or puts that data is up to the application. -- Michael Fuhr ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] where is the output

2005-12-21 Thread Michael Fuhr
plode("\t", rtrim($row))); } fclose($fh); According to the PHP documentation fputcsv() is new as of 5.1.0RC1; for earlier versions you could probably find a module to generate CSV output. -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] row is too big: size 8916, maximum size 8136

2005-12-06 Thread Michael Fuhr
is too big" error if you have more than about 405 columns. With short, non-TOASTed data you'll be able to insert more columns. -- Michael Fuhr ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to

Re: [HACKERS] Oddity with extract microseconds?

2005-12-06 Thread Michael Fuhr
Does contrary behavior from MySQL count as evidence that PostgreSQL's behavior is correct? :-) -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Oddity with extract microseconds?

2005-12-06 Thread Michael Fuhr
--+ | EXTRACT(MICROSECOND FROM '2003-01-02 10:30:00.00123') | +---+ | 1230 | +---+ 1 row in set (0.01 sec) -- Michael Fuhr ---(end of bro

Re: [HACKERS] Oddity with extract microseconds?

2005-12-06 Thread Michael Fuhr
x27;2003-01-02 10:30:00.00123'); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM '2003-01-02 10:30:00.00123')' at line 1 -- Michael Fuhr ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] inet to bigint?

2005-12-06 Thread Michael Fuhr
ted one just a couple of days ago: http://archives.postgresql.org/pgsql-general/2005-12/msg00191.php > (I'll credit you in the MySQL Compat Library code btw) If you're > interested, you'd be welcome to join the project btw... I haven't been follo

Re: [HACKERS] inet to bigint?

2005-12-06 Thread Michael Fuhr
On Tue, Dec 06, 2005 at 01:05:12AM -0700, Michael Fuhr wrote: > CREATE FUNCTION inet2num(inet) RETURNS numeric AS $$ > DECLARE > a text[] := string_to_array(host($1), '.'); > BEGIN > RETURN a[1]::numeric * 16777216 + >a[2]::numeric * 65536 + >

Re: [HACKERS] inet to bigint?

2005-12-06 Thread Michael Fuhr
RETURN a[1]::numeric * 16777216 + a[2]::numeric * 65536 + a[3]::numeric * 256 + a[4]::numeric; END; $$ LANGUAGE plpgsql IMMUTABLE STRICT; -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posting/reading through U

Re: [HACKERS] inet to bigint?

2005-12-05 Thread Michael Fuhr
, inet_aton($_[0])); $$ LANGUAGE plperlu IMMUTABLE STRICT; SELECT inet2num('127.0.0.1'); inet2num 2130706433 (1 row) -- Michael Fuhr ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Reduce NUMERIC size by 2 bytes, reduce max length to 508

2005-12-05 Thread Michael Fuhr
by the change. Maybe the release notes could mention the new upper limit of factorial(). -- Michael Fuhr ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED

Re: [HACKERS] Strange interval arithmetic

2005-12-01 Thread Michael Fuhr
turns on success, an application wishing to check for error situations should set errno to 0, then call strtol() or strtoll(), then check errno. I don't know if any systems are non-compliant in this respect, but Tom said that "we've been doing it that way (errno test only) for many ye

Re: [HACKERS] Strange interval arithmetic

2005-11-30 Thread Michael Fuhr
4801-01-01 BC (1 row) -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Strange interval arithmetic

2005-11-30 Thread Michael Fuhr
cking *only* errno is sufficient to detect an error. According to the standard it is. -- Michael Fuhr ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] Strange interval arithmetic

2005-11-30 Thread Michael Fuhr
n doing it that way (errno test > only) for many years without complaints. Adding a test on the return > value is venturing into less charted waters. Good, I'll stick with just the ERANGE check then. -- Michael Fuhr ---(end of broadcast)---

Re: [HACKERS] Strange interval arithmetic

2005-11-30 Thread Michael Fuhr
On Wed, Nov 30, 2005 at 05:23:23PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > I usually check both in my own code but I noticed several places > > where PostgreSQL doesn't, so I kept that style. I'll check both > > if that's

Re: [HACKERS] Strange interval arithmetic

2005-11-30 Thread Michael Fuhr
On Wed, Nov 30, 2005 at 05:20:54PM -0500, Tom Lane wrote: > Michael Fuhr <[EMAIL PROTECTED]> writes: > > I'm looking at all the strtol() calls in datetime.c right now; I > > haven't looked anywhere else yet. Should I bother checking values > > that will be r

  1   2   3   >