Re: [HACKERS] Proposal: XML helper functions

2012-02-19 Thread Larry
But by using the above code: how do we deal with multiple matching values? For example: java c++ In this case, perhaps I would want something like ---+- my_question | java my_question | c++ -- View this message in context: http://postgresql.1045698.n5.nabble.com/

Re: [HACKERS] Mac OS: invalid byte sequence for encoding "UTF8"

2016-02-10 Thread Larry Rosenman
) Ugh. regards, tom lane Definitive FreeBSD Sources: https://svnweb.freebsd.org/base/ -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail: 7011 W Parmer Ln, Apt 1115, Austin,

Re: [HACKERS] Mac OS: invalid byte sequence for encoding "UTF8"

2016-02-10 Thread Larry Rosenman
On 2016-02-10 17:00, Tom Lane wrote: Larry Rosenman writes: On 2016-02-10 16:19, Tom Lane wrote: I looked into the OS X sources, and found that indeed you are right: *scanf processes the input a byte at a time, and applies isspace() to each byte separately, even when the locale is such that

Re: [HACKERS] Renaming some binaries

2016-08-26 Thread Larry Rosenman
code, no confusion because we have just one client tool - psql. Several of them have the ability to connect to several databases, some even do that in parallel. vacuumdb being one that I've needed recently to do a number of DB's in a row. -- Larry Rosenman

Re: [HACKERS] jsonb format is pessimal for toast compression

2014-08-07 Thread Larry White
Apologies if this is a ridiculous suggestion, but I believe that swapping out the compression algorithm (for Snappy, for example) has been discussed in the past. I wonder if that algorithm is sufficiently different that it would produce a better result, and if that might not be preferable to some o

Re: [HACKERS] jsonb format is pessimal for toast compression

2014-08-08 Thread Larry White
I was not complaining; I think JSONB is awesome. But I am one of those people who would like to put 100's of GB (or more) JSON files into Postgres and I am concerned about file size and possible future changes to the format. On Fri, Aug 8, 2014 at 7:10 PM, Peter Geoghegan wrote: > On Fri, Aug

[HACKERS] FW: PGBuildfarm member peripatus Branch REL9_2_STABLE Failed at Stage PLCheck-C

2017-05-23 Thread Larry Rosenman
Looks like the upgrade of this machine to the inode64 commit of FreeBSD busted stuff. I’m rebuilding perl and all the ports to see if that fixes it. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l...@lerctr.org US Mail

[HACKERS] FW: PGBuildfarm member peripatus Branch REL9_2_STABLE Status changed from PLCheck-C failure to OK

2017-05-23 Thread Larry Rosenman
Rebuilding Perl and all it’s related ports fixed it. Dealing with the FreeBSD folks on what all we (FreeBSD) need to put in /usr/ports/UPDATING and / or /usr/src/UPDATING -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 E-Mail: l

Re: [HACKERS] [PATCH] pg_upgrade: support for btrfs copy-on-write clones

2013-10-02 Thread Larry Rosenman
pply SSH access to a FreeBSD 10 system that is totally ZFS. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 214-642-9640 (c) E-Mail: l...@lerctr.org US Mail: 108 Turvey Cove, Hutto, TX 78634-5688 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

[HACKERS] CLUSTER VERBOSE (9.1.3)

2012-03-05 Thread Larry Rosenman
60953511 nonremovable row versions in 4224437 pages DETAIL: 0 dead row versions cannot be removed yet. CPU 168.02s/4324.68u sec elapsed 8379.12 sec. And at this point it's doing something(tm), I assume re-doing the indexes. It would be nice(tm) to get more info. Ideas? - -- Larry Ros

Re: [HACKERS] CLUSTER VERBOSE (9.1.3)

2012-03-07 Thread Larry Rosenman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 3/6/2012 8:32 AM, Robert Haas wrote: > On Mon, Mar 5, 2012 at 4:40 PM, Larry Rosenman > wrote: >> -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >> >> Is there any way to get more info out of CLUSTER VERBOSE so it >>

Re: [HACKERS] CLUSTER VERBOSE (9.1.3)

2012-03-07 Thread Larry Rosenman
CUUM FULL. > +1. I think we should update ps_status as well as pg_stat_activity as all of these table rewrite processes are running. Do I need to cogitate on the code, or is one of the hackers that knows it better interested? Thanks! - -- Larry Rosenman http://www.lerctr.or

Re: [HACKERS] CLUSTER VERBOSE (9.1.3)

2012-03-07 Thread Larry Rosenman
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 3/7/2012 2:42 PM, Tom Lane wrote: > Larry Rosenman writes: >> On 3/7/2012 12:31 PM, Alvaro Herrera wrote: >>> Also, this isn't limited to CLUSTER; anything that rewrites >>> the table and indexes would benefit. Mea

Re: [HACKERS] New email address

2015-11-24 Thread Larry Rosenman
e that, but perhaps those things trigger some popular antispam heuristics. regards, tom lane Any Header or Body changes will invalidate most, if not all, DKIM signatures. Since DKIM is used as part of DMARC, it's a problem. Not sure what MajorDomo2 will allow

Re: [HACKERS] New email address

2015-11-24 Thread Larry Rosenman
On 2015-11-24 13:43, Alvaro Herrera wrote: Larry Rosenman wrote: On 2015-11-24 13:11, Tom Lane wrote: >Kevin Grittner writes: >>On Tue, Nov 24, 2015 at 11:10 AM, Tom Lane wrote: >>>>change the From header (and add a Reply-To, so replies still work). > >>If t

Re: [HACKERS] 10.0

2016-05-13 Thread Larry Rosenman
first part of the version number is only a single digit. Is that likely? That would be remarkably myopic, but I guess possible. Thom We (FreeBSD) had lots of that kind of fallout when 9->10. Autoconf, and other tools thought we were a.out and not ELF. -- Larry Rosenman

[HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-05 Thread Larry Rosenman
as buildfarm clients. What OS's do we need coverage for? LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-05 Thread Larry Rosenman
I might use that as the base then, since the hardware finishes getting here tomorrow. My question still stands on what OS's we need coverage for. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 V

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-06 Thread Larry Rosenman
--- TIP 5: don't forget to increase your free space map settings -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-06 Thread Larry Rosenman
On Fri, 6 Apr 2007, Andrew Dunstan wrote: Larry Rosenman wrote: It doesn't matter as far as MY box is concerned. I use VMWare extensively in my current $DAYJOB, and I want to be able to test/play with things related to that as well. The box I'm building will be using the (fr

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-06 Thread Larry Rosenman
On Fri, 6 Apr 2007, Stefan Kaltenbrunner wrote: Andrew Dunstan wrote: Larry Rosenman wrote: It doesn't matter as far as MY box is concerned. I use VMWare extensively in my current $DAYJOB, and I want to be able to test/play with things related to that as well. The box I'm buildi

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-07 Thread Larry Rosenman
ing Solaris, my question is: 1) what os(s) do we need more coverage on 2) what collection of options for OS' in 1? LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 430 Valona Loop, Round

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-09 Thread Larry Rosenman
r I can get GCC on it. This will take a week or 2, but I have permission now. (This box can get out to the internet via our proxy). LER Cheers, Adrian Maier -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: ler@lerctr.org US Mail: 4

Re: [HACKERS] What X86/X64 OS's do we need coverage for?

2007-04-09 Thread Larry Rosenman
On Mon, 9 Apr 2007, Tom Lane wrote: Larry Rosenman writes: I think I'll be able to set up my HP-UX 11.11 box here, as soon as it gets fixed, and assuming either the bundled compiler will work or I can get GCC on it. If the bundled compiler is still the same non-ANSI-C weakling tha

[HACKERS] CREATE DATABASE foo OWNER bar

2007-04-16 Thread Larry Rosenman
owner. Shouldn't everything that is in the DB be owned by the purported owner? This is on 8.2.3, btw. Thanks! -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: [EMAIL PROTECTED] US Mail: 430 Valona Loop, Round Rock, TX 78681

Re: [HACKERS] CREATE DATABASE foo OWNER bar

2007-04-16 Thread Larry Rosenman
On Mon, 16 Apr 2007, Andrew Dunstan wrote: Larry Rosenman wrote: Greetings, I think I found a bug, or at least a POLA violation. At work, I created a user that is NOT a superuser, nor can that user create databases. When I did a create database foo owner bar, all the schemas are set to

Re: [HACKERS] CREATE DATABASE foo OWNER bar

2007-04-16 Thread Larry Rosenman
On Mon, 16 Apr 2007, Tom Lane wrote: Larry Rosenman <[EMAIL PROTECTED]> writes: When I try and RESTORE a pg_dump in the current state, we get errors because the public schema is owned by postgres, and the grant commands are issued as the user (since I'm restoring as the purp

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Larry McGhaw
e; Gregory Stark; Martijn van Oosterhout; pgsql-hackers@postgresql.org; Larry McGhaw Subject: Re: [HACKERS] Selecting a constant question Dann Corbit wrote: > If the server bound the data as UNICODE, then it will tell me > UNICODE(3). I know how big this will be. > > In the worst case s

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Larry McGhaw
e; Gregory Stark; Martijn van Oosterhout; pgsql-hackers@postgresql.org; Larry McGhaw Subject: Re: [HACKERS] Selecting a constant question Dann Corbit wrote: > If the server bound the data as UNICODE, then it will tell me > UNICODE(3). I know how big this will be. > > In the worst cas

Re: [HACKERS] Selecting a constant question

2007-06-11 Thread Larry McGhaw
uot; postgres in our application until it is addressed. Thanks lm From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Mon 6/11/2007 5:32 PM To: Larry McGhaw Cc: Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van Oosterhout; pgsql-hackers@postgresql.org Subject: Re: [

Re: [HACKERS] Selecting a constant question

2007-06-12 Thread Larry McGhaw
of the 1st column in the resultset is 3 ... it cant be any more plain than that. Thanks lm From: Hannu Krosing [mailto:[EMAIL PROTECTED] Sent: Mon 6/11/2007 10:43 PM To: Larry McGhaw Cc: Tom Lane; Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van Oosterh

Re: [HACKERS] Selecting a constant question

2007-06-12 Thread Larry McGhaw
ne out of the box. It is in your hands now :) Thanks lm -Original Message- From: Andrew Dunstan [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 4:50 AM To: Larry McGhaw Cc: Hannu Krosing; Tom Lane; Alvaro Herrera; Dann Corbit; Gregory Stark; Martijn van Oosterhout; pgsql-hack

Re: [HACKERS] Selecting a constant question

2007-06-12 Thread Larry McGhaw
t '123'::varchar(3) libpq returns the following: Pqfsize returns -1 Pqfmod returns -1 Thanks lm -Original Message- From: Brian Hurt [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 11:09 AM To: Larry McGhaw Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Sele

Re: [HACKERS] Selecting a constant question

2007-06-12 Thread Larry McGhaw
That one surprised me as well. Thanks lm -Original Message- From: Andrew Dunstan [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 12:00 PM To: Larry McGhaw Cc: Brian Hurt; pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Selecting a constant question Larry McGhaw wrote

Re: [HACKERS] Selecting a constant question

2007-06-12 Thread Larry McGhaw
to encounter this problem .. Its just been covered up by assigning An arbitrary maximum size .. So I guess we will do the same and make it configurable like the official postgres driver. Thanks lm -Original Message- From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] Sent: Tuesday,

Re: [HACKERS] Selecting a constant question: A summary

2007-06-12 Thread Larry McGhaw
ckers@postgresql.org; Larry McGhaw Subject: Re: [HACKERS] Selecting a constant question: A summary "Dann Corbit" <[EMAIL PROTECTED]> writes: > In the case of a SELECT query that selects a fixed constant of any > sort, it would be a definite improvement for PostgreSQL to give so

[HACKERS] Makefile support for Mac OS X Fat Binaries?

2008-01-21 Thread Larry Rosenman
would the community accept a patch that would allow the making of 4-way fat binaries on Mac OS X 10.5+? (Obviously for 8.4+). I'm thinking about attempting it for an inside project here at work, but was wondering if there was community interest? Thanks! -- Larry Ros

Re: [HACKERS] Makefile support for Mac OS X Fat Binaries?

2008-01-21 Thread Larry Rosenman
On Mon, 21 Jan 2008, Tom Lane wrote: Larry Rosenman <[EMAIL PROTECTED]> writes: would the community accept a patch that would allow the making of 4-way fat binaries on Mac OS X 10.5+? (Obviously for 8.4+). Depends on how big and ugly it is, I think. If you can do it just by hacking

Re: [HACKERS] Makefile support for Mac OS X Fat Binaries?

2008-01-21 Thread Larry Rosenman
On Tue, 22 Jan 2008, Gregory Stark wrote: "Tom Lane" <[EMAIL PROTECTED]> writes: Larry Rosenman <[EMAIL PROTECTED]> writes: would the community accept a patch that would allow the making of 4-way fat binaries on Mac OS X 10.5+? (Obviously for 8.4+). Depends on how

Re: [HACKERS] Sought after architectures for the PostgreSQL buildfarm?

2009-12-08 Thread Larry Rosenman
I might be able to help with: Sparc PA-Risc (HP-UX) IA64 -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: l...@lerctr.org US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -Original Message- From: pgsql-hackers-ow

Re: [HACKERS] 8.5 vs. 9.0

2010-01-21 Thread Larry Rosenman
ion-bump? Is there a link somewhere? AFAIR, it was stated if Hot Standby AND Streaming Replication hit the tree, the release number would go to 9.0. Both are in the tree. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: l...@le

Re: [HACKERS] Rules: A Modest Proposal

2009-10-04 Thread Larry Rosenman
ke changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-hackers >> > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers > -- Larry Ros

Re: [HACKERS] [PATCHES] Fix for large file support (nonsegment mode support)

2008-03-11 Thread Larry Rosenman
largefiles option, per filesystem. At least that was the case on SCO UnixWare (No, I no longer run it). LER regards, tom lane -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [EMAIL PROTECTED] US Mail: 430

[HACKERS] Need 8.4 chm.

2009-05-27 Thread Larry Silvermintz
Greetings, Please help provide a chm file for 8.4b2. Unlike prior Windows installations, the postgreSQL.chm is absent. This file format provides very valuable searching capabilities. Appreciatively! --LS Larry Silvermintz, Ph.D.| Biologist & Engineer (510) 705-1432 -- Sent

Re: [HACKERS] Use of /etc/services?

2002-06-07 Thread Larry Rosenman
ereafter). > > Mike. > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-

Re: [HACKERS] Feature request: Truncate table

2002-06-12 Thread Larry Rosenman
RUNCATE Description: empty a table Syntax: TRUNCATE [ TABLE ] name ler=# > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Larry Rosenman

Re: [HACKERS] Feature request: Truncate table

2002-06-12 Thread Larry Rosenman
now in PostgreSQL, but I simply >emulate it by drop table/create table. > > What is a TRUNCATE TABLE but a drop create anyway? Is there some > technical difference? > It doesn't kill indexes/triggers/constraints/Foreign Key Stuff, etc. -- Larry Rosenman

Re: [HACKERS] Integrating libpqxx

2002-06-12 Thread Larry Rosenman
ly move his CVS/ files to your repository, and add appropriate entries stuff. LER > > > -- > Bruce Momjian| http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > +

Re: [HACKERS] Integrating libpqxx

2002-06-12 Thread Larry Rosenman
On Wed, 2002-06-12 at 19:41, Bruce Momjian wrote: > Larry Rosenman wrote: > > > > > > I think we will just give you CVS access. Not sure how to get the CVS > > > history. I think if you send me the CVS root I can use CVS import to > > > load it. >

Re: [HACKERS] First cut at SSL documentation

2002-06-13 Thread Larry Rosenman
; [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup.| Drexel Hill, Pennsylvania 19026 > > ---(end of broadcast)--- > TIP 6: Have you search

Re: [HACKERS] What is wrong with hashed index usage?

2002-06-21 Thread Larry Rosenman
bug the DBA on EVERY index that is a hash? I know I personally hate the FreeBSD linker warnings about certain functions, and don't like that precedent. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail:

Re: [HACKERS] What is wrong with hashed index usage?

2002-06-21 Thread Larry Rosenman
On Fri, 2002-06-21 at 15:12, Bruce Momjian wrote: > Larry Rosenman wrote: > > On Fri, 2002-06-21 at 11:51, Bruce Momjian wrote: > > > Tom Lane wrote: > > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > > > > > > > > &

Re: [HACKERS] test 2, first failed ...

2002-06-21 Thread Larry Rosenman
n appropriate > > subscribe-nomail command to [EMAIL PROTECTED] so that your > > message can get through to the mailing list cleanly > > > > > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9&#x

Re: [HACKERS] Buffer Management

2002-06-25 Thread Larry Rosenman
rc, can one do mmap in a BSD jail?) I believe the answer is YES. I can send you the man pages if you want. > > regards, tom lane > > > > ---(end of broadcast)------- > TIP 4: Don't &#x

Re: [HACKERS] Postgres idea list

2002-06-26 Thread Larry Rosenman
ven bother. I have some consulting clients, but using pay for stuff generally won't work for them, plus I can't usually afford the fees for my own use, so therefore are not conversant with the commercial tools. Nothing against them, but... Just my $.02 worth. -- Larry Rose

Re: [HACKERS] Database comparison ideas

2002-06-26 Thread Larry Rosenman
tgres+PHP+Apache > -- Win32 Port I know I (not knowing Oracle PL/SQL) have a hard time find enough docs on PL/pgSQL, even with buying Bruce's and the German PG Developers books. I'm personally having a hard time learning all the in's and out's of the trigger/rule stuff. I know

Re: [HACKERS] Virus Emails

2002-07-28 Thread Larry Rosenman
: Have you checked our extensive FAQ? > > > > http://www.postgresql.org/users-lounge/docs/faq.html > > > > > ---(end of broadcast)--- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so t

Re: [HACKERS] Virus Emails

2002-07-30 Thread Larry Rosenman
but can't seem to find it in their eStore > anywhere ... > > > On 28 Jul 2002, Larry Rosenman wrote: > > > On Sun, 2002-07-28 at 20:10, Marc G. Fournier wrote: > > > > > > God, I go through 200+ of those almost daily as moderator ... imagine if > &

Re: [HACKERS] Virus Emails

2002-07-30 Thread Larry Rosenman
alternatives ... > > On Wed, 31 Jul 2002, Christopher Kings-Lynne wrote: > > > I would also like to know this! They don't mention it anywhere on their > > site! > > > > Chris > > > > > -Original Message- > > > From: [EMAIL PRO

Re: [GENERAL] [HACKERS] Linux Largefile Support In Postgresql RPMS

2002-08-13 Thread Larry Rosenman
ing systems where 64 bit file access can be disabled or > unconfigured require more care - possibly (sigh) 2 binary RPMS with a > distinctive 32 and 64 bit label ...(I think the "big O" does this for > Solaris). Then, of course, there are systems where Largefiles support is a fi

Re: [HACKERS] Open 7.3 items

2002-08-16 Thread Larry Rosenman
aticularly sadistic DBA to deal with? ;-) And of course, this being > free software and all, noone is forcing an upgrade on you. AND, I thought the general consensus was **AWAY** from configure time directives and to GUC variables whenever **POSSIBLE**. LER -- Larry Rosenman

Re: [HACKERS] Proposed GUC Variable

2002-08-27 Thread Larry Rosenman
> > > > > > > > > > > > > ---(end of broadcast)--- > > TIP 2: you can get off all lists at once with the unregister command > > (send "unregister YourEmailAddressHere" to [EMAIL PR

Re: [HACKERS] Proposed GUC Variable

2002-08-27 Thread Larry Rosenman
On Tue, 2002-08-27 at 16:05, Bruce Momjian wrote: > Larry Rosenman wrote: > > On Tue, 2002-08-27 at 15:54, Bruce Momjian wrote: > > > > > > I had an idea on this. It seems pretty pointless to show a query error > > > without a query, but some queries are very

Re: [HACKERS] Proposed GUC Variable

2002-08-27 Thread Larry Rosenman
On Tue, 2002-08-27 at 16:14, Bruce Momjian wrote: > Larry Rosenman wrote: > > > But we should have some default to print some of the query, because > > > right now we print none of it. I am not saying it is perfect, but it is > > > better than what we have, and is a

Re: [HACKERS] Proposed GUC Variable

2002-08-27 Thread Larry Rosenman
; A settable trim length would probably be a good idea, I suppose, for > those slinging 'bytea' and toasted texts around. Yes, but the default should be NO TRIM or in 1K-4K range. IMHO -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-

Re: [HACKERS] [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

2002-08-28 Thread Larry Rosenman
rsonally hope y'all do *NOT* remove the old syntax. > > But I think it'd be sufficient to document only the new syntax. Why? If both old and new are acceptable, why not document it? (Just curious, I'm not wedded to it). -- Larry Rosenman http://www.lerc

Re: [HACKERS] [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

2002-08-28 Thread Larry Rosenman
On Wed, 2002-08-28 at 08:52, Bruce Momjian wrote: > Larry Rosenman wrote: > > On Tue, 2002-08-27 at 23:29, Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > OK, patch attached. It was actually easier than I thought. We have to > >

Re: [PATCHES] [HACKERS] Proposed GUC Variable

2002-08-28 Thread Larry Rosenman
t; > 3. Not sure what the "original" is for -- you're not transforming > > anything. > > Agreed. Just call it "Error query". Seems clear to me. What about rule(s) transformation(s)? Will we see the real query or the transformed query? -- Larry Rosenman

Re: [HACKERS] [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

2002-08-28 Thread Larry Rosenman
details should go a long way. I suspect that Bruce's suggestion is best, modulo a spell check :-). > > Robert Treat -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat S

Re: [HACKERS] tweaking MemSet() performance

2002-08-29 Thread Larry Rosenman
at longer sizes. Should I > > pull out my Solaris kernel source and see what memset() is doing? > > No, because memset() belongs to the libc AFAICS... Do you have source > code for that? and if you do, what vintage is it? I believe Solaris has mucked with stuff ove

Re: [HACKERS] Proposed GUC Variable

2002-08-29 Thread Larry Rosenman
ber by the GUC code). > > Naturally, the problem with each option can be cleared up with > documentation. my gut feeling is use the words. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 S

Re: [HACKERS] Running postgres on a read-only file system

2002-08-30 Thread Larry Rosenman
more idea, is it possible to "fake" a read-write file system. I.e. > supply the files that postgresql will be looking for? (I know it's a > stretch, but hey, this IS the "hackers" list) :) The problem is every query wants to write the clog files. -- Larry Ros

Re: [HACKERS] Bug in Makefile.shlib

2002-09-04 Thread Larry Rosenman
post up if you want. > > regards, tom lane > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > -- Larry Rosenman http:/

Re: [HACKERS] PL/Perl?

2002-09-04 Thread Larry Rosenman
On Wed, 2002-09-04 at 17:54, Tom Lane wrote: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > I upgraded PostgreSQL to 7.2.1 from a 7.2beta (yeah, I know). One of my > > users requested plperl, so I got it to createlang, but it SIGSEGV's on > > any simple perl.

Re: [HACKERS] PL/Perl?

2002-09-05 Thread Larry Rosenman
On Wed, 2002-09-04 at 19:41, Larry Rosenman wrote: > On Wed, 2002-09-04 at 17:54, Tom Lane wrote: > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > I upgraded PostgreSQL to 7.2.1 from a 7.2beta (yeah, I know). One of my > > > users requested plperl, so I got i

Re: [HACKERS] PL/Perl?

2002-09-05 Thread Larry Rosenman
On Thu, 2002-09-05 at 15:16, Larry Rosenman wrote: > On Wed, 2002-09-04 at 19:41, Larry Rosenman wrote: > > On Wed, 2002-09-04 at 17:54, Tom Lane wrote: > > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > > I upgraded PostgreSQL to 7.2.1 from a 7.2beta (yea

Re: [HACKERS] hacker help: PHP-4.2.3 patch to allow restriction of

2002-09-27 Thread Larry Rosenman
e virtual host from those initiated on behalf of another? Nope, you can't to the best of my knowledge. You just get a standard connect string. (Assuming NAME based vHosts here, which is what most should be, modulo SSL based ones). [snip] -- Larry Rosenman http://www.le

Re: [HACKERS] cross-posts (was Re: [GENERAL] Large databases,

2002-10-07 Thread Larry Rosenman
ot;all" mailing list is not supported at PostgreSQL User Support Lists. What do I need to send now? Marc? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Gar

Re: [HACKERS] cross-posts (was Re: [GENERAL] Large databases,

2002-10-07 Thread Larry Rosenman
do I need to send now? > > > > Marc? > > it is: > set ALL unique your-email > > if you also don't want to get emails that have already been cc'd to you, you > can use: > > set ALL eliminatecc your-email > > for a full list of set options send

[HACKERS] PG_DUMP and Adding columns/Types

2002-10-14 Thread Larry Rosenman
for txtidx happens AFTER the CREATE TABLE comments. I haven't tried to reload this dump script yet. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland

Re: [HACKERS] v7.3 Branched ...

2002-10-16 Thread Larry Rosenman
if someone comes up with the list. That would be useful, and port(s) for the rest of contrib as well (like contrib/tsearch). :-) -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Dri

Re: [HACKERS] PL/Perl and Perl 5.8

2002-10-16 Thread Larry Rosenman
> CONTEXT > Built under linux > Compiled at Sep 14 2002 17:36:21 > @INC: > /etc/perl > /usr/local/lib/perl/5.8.0 > /usr/local/share/pe

Re: [HACKERS] pg_dump and large files - is this a problem?

2002-10-21 Thread Larry Rosenman
> space to test larger files. I can make an account for anyone that wants to play on UnixWare 7.1.3. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Driv

Re: [HACKERS] pg_dump and large files - is this a problem?

2002-10-21 Thread Larry Rosenman
On Mon, 2002-10-21 at 20:52, Bruce Momjian wrote: > Larry Rosenman wrote: > > On Mon, 2002-10-21 at 20:47, Bruce Momjian wrote: > > > > > > Here is a modified version of Philip's patch that has the changes Tom > > > suggested; treating off_t as an integr

[HACKERS] UnixWare 7.1.3 (BETA), C99 compiler, current CVS, error...

2002-10-26 Thread Larry Rosenman
line" functions cannot use "static" identifier: myFunctionCall2 UX:acomp: ERROR: "tuplesort.c", line 1885: "inline" functions cannot use "static" identifier: myFunctionCall2 UX:acomp: ERROR: "tuplesort.c", line 1897: "inline" functions

[HACKERS] UnixWare 7.1.3 (BETA), compile error (with cc -Xb)

2002-10-26 Thread Larry Rosenman
tor is not of function type UX:acomp: ERROR: "ascii_and_mic.c", line 56: operands must have integral type: op "&" UX:acomp: ERROR: "ascii_and_mic.c", line 58: left operand of "->" must be pointer to struct/union UX:acomp: ERROR: "

Re: [HACKERS] UnixWare 7.1.3 (BETA), C99 compiler, current CVS,

2002-10-26 Thread Larry Rosenman
On Sat, 2002-10-26 at 10:07, Tom Lane wrote: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Without specifying the -Xb switch to kill the C99 interpretation of > > inline, I get the following from current CVS: > > > UX:acomp: ERROR: "tuplesort.c",

Re: [HACKERS] ECPG and bison

2002-10-18 Thread Larry Rosenman
oon? > > (Guess I'd better get it loaded on my own machines, too...) Looks like threre is a 1.75 out (based on a FreeBSD PR I just saw fly by). LER > > regards, tom lane > > ---(end of broadcast)------- &

Re: [HACKERS] ECPG and bison

2002-10-18 Thread Larry Rosenman
On Fri, 2002-10-18 at 22:03, Marc G. Fournier wrote: > On Fri, 18 Oct 2002, Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > Larry Rosenman wrote: > > >> Looks like threre is a 1.75 out (based on a FreeBSD PR I just saw fly &

Re: [HACKERS] Please help

2002-10-21 Thread Larry Rosenman
On Mon, 2002-10-21 at 12:57, Larry Rosenman wrote: > On Mon, 2002-10-21 at 12:39, Olivier PRENANT wrote: > > Hi larry, > > > > Glad to see you around... > > On 21 Oct 2002, Larry Rosenman wrote: > > > > > Date: 21 Oct 2002 12:34:48 -0500 > > >

[HACKERS] UnixWare 7.1.3: with current CVS, and cc -Xb.,..

2002-10-26 Thread Larry Rosenman
We pass all regression test. this is UnixWare 7.1.3, with the native cc compiler. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

[HACKERS] assignment type mismatch complaints

2002-10-26 Thread Larry Rosenman
How concerned are we about assignment type mismatch warnings? I got a bunch in the mb stuff, and some in other places from the UnixWare 7.1.3 compiler. We still pass all regression tests. LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812

[HACKERS] copy from ... with delimiter '\n'

2002-10-29 Thread Larry Riedel
I recognize is documented behavior). If the copy command expected a 1:1 relationship between the fields in the "copy from" file and the fields in the target table, then it seemed to me it could read the file correctly? I can see that it might be considered too dicey to allow. La

Re: [HACKERS] 7.3b3 ok on unixware 71[12] here

2002-10-30 Thread Larry Rosenman
On Wed, 2002-10-30 at 12:16, Olivier PRENANT wrote: > On 30 Oct 2002, Larry Rosenman wrote: > > > Date: 30 Oct 2002 12:14:01 -0600 > > From: Larry Rosenman <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: Re:

Re: [HACKERS] Please help

2002-10-21 Thread Larry Rosenman
On Mon, 2002-10-21 at 12:39, Olivier PRENANT wrote: > Hi larry, > > Glad to see you around... > On 21 Oct 2002, Larry Rosenman wrote: > > > Date: 21 Oct 2002 12:34:48 -0500 > > From: Larry Rosenman <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > Cc:

Re: [HACKERS] UnixWare 7.1.3: with current CVS, and cc -Xb.,..

2002-10-26 Thread Larry Rosenman
lumn back to UnixWare. (and footnote that OpenUNIX 8.0.0 is really UnixWare 7.1.2). > > --- > Larry Rosenman wrote: > > We pass all regression test. > > > > this is Unix

Re: [HACKERS] assignment type mismatch complaints

2002-10-26 Thread Larry Rosenman
On Sat, 2002-10-26 at 18:27, Tom Lane wrote: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > How concerned are we about assignment type mismatch warnings? > > They're probably all "char versus unsigned char" complaints? Probably. The first few I looked at ar

Re: [HACKERS] assignment type mismatch complaints

2002-10-27 Thread Larry Rosenman
On Sat, 2002-10-26 at 18:34, Larry Rosenman wrote: > On Sat, 2002-10-26 at 18:27, Tom Lane wrote: > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > How concerned are we about assignment type mismatch warnings? > > > > They're probably all "cha

Re: [HACKERS] FreeBSD 4.7: BETA3 (from port): regression failures...

2002-10-27 Thread Larry Rosenman
On Mon, 2002-10-28 at 00:09, Larry Rosenman wrote: Ignore the first one, stupid me forgot about permissions. Here is the real one (horology and geometry): (and I expect horology is due to DST change day). LER *** ./expected/geometry-positive-zeros-bsd.out Tue Sep 12 16:07:16 2000

[HACKERS] FreeBSD 4.7: BETA3 (from port): regression failures...

2002-10-28 Thread Larry Rosenman
unique1 LIMIT 5 OFFSET 900; five | unique1 | unique2 | stringu1 --+-+-+-- ! | 900 | 913 | QI ! | 901 | 931 | RIAAAA ! | 902 | 702 | SI ! | 903 | 641 | TI ! | 904 | 793 | UI ! (5

  1   2   3   4   5   6   7   8   9   >