Re: [HACKERS] Tech details - psql wraps at window width

2008-04-26 Thread Bryce Nesbitt
Bruce Momjian wrote: Hey, I can work with this idea. First, there really is no 'off' mode for wrapped because that is aligned... Well, come to think of it, wrapped is not really a new output format in the sense of html or latex. It could build on aligned: \pset format aligned

[HACKERS] Compiling trigger function with MinGW

2008-04-26 Thread Anton Burkun
Hello All. Now I try to link dll with MinGW from Example in Postgres Help. Linker show me this error: D:\users\anthony\kursor\abzcrm\c\foogcc -shared foo.o -o foo.dll -L d:/files/local/PostgreSQL/8.3/lib -l postgres Cannot export ⌂postgres_NULL_THUNK_DATA: symbol not found collect2: ld

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Andrew Dunstan
Raphaël Jacquot wrote: would seem like a good idea, no ? http://www.murrayc.com/blog/permalink/2008/04/25/postgresql-has-no-bugzilla/ Before you come trolling on this (or any other) subject, please read the voluminous debates that have taken place about it. Apparently you think it's

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Brendan Jurd
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Apr 26, 2008 at 4:13 PM, Andrew Dunstan wrote: Before you come trolling on this (or any other) subject, please read the voluminous debates that have taken place about it. Apparently you think it's something we have never considered,

Re: [HACKERS] Tech details - psql wraps at window width

2008-04-26 Thread Brendan Jurd
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sat, Apr 26, 2008 at 5:08 PM, Bryce Nesbitt wrote: Well, come to think of it, wrapped is not really a new output format in the sense of html or latex. It could build on aligned: \pset format aligned [autowrap|nowrap|nnn] I agree that

Re: [HACKERS] MERGE Specification

2008-04-26 Thread Hannes Dorbath
Simon Riggs wrote: On Fri, 2008-04-25 at 10:03 +0300, Hannu Krosing wrote: On Tue, 2008-04-22 at 00:24 +0100, Simon Riggs wrote: On Mon, 2008-04-21 at 16:38 -0400, A.M. wrote: MERGE will not invoke Rules. Does this imply that MERGE cannot be used on views or that the resulting INSERTs or

Re: [HACKERS] Tech details - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote: Hey, I can work with this idea. First, there really is no 'off' mode for wrapped because that is aligned. What we could do is to have: \pset format wrapped display affect only output to the screen, using the screen width, and: \pset format wrapped nnn

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote: Gregory Stark wrote: I don't see that behavior here on Ubuntu 7.10: $ COLUMNNS=120 ls -C |cat archive cdinitrd lost+found proc srv usr basement.usr dev initrd.img media root sys var bin etc laptop

Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: * Allow adding enumerated values to an existing

2008-04-26 Thread Alvaro Herrera
Andrew Dunstan escribió: Tom Dunstan wrote: So two alternative proposals, both with a 2 byte enum id and a 2 byte value: 1 - We space the values out as evenly as we can across the 65000ish range and allow people to delete, insert and append, but not reorder. If they do the above

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Aidan Van Dyk
* Bruce Momjian [EMAIL PROTECTED] [080426 09:44]: Why does the first 'ls' not honor columns while the second does? How does 'ls' detect that the COLUMNS=120 is somehow different from the default COLUMNS value? I would hazard a guess that COLUMNS isn't exported from your shell environment in

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Bruce Momjian wrote: Oops, Alvaro pointed out I typo'ed the variable name COLUMNS as COLUMNNS. I see now that 'ls -C' does honor columns. See my later posting about '\pset wrapped 0' as a special case where we could honor the ioctl/COLUMNS case. My real confusion is this: $ echo

Re: [HACKERS] FSM fill ratio

2008-04-26 Thread Alvaro Herrera
Jacques Caron wrote: Hi all, Quick question: is there currently a way to see how many slot are used in the FSM (i.e. how many free pages are stored there), or how many are free? If not, wouldn't it be a good idea to add this somewhere? (Don't quite know where... is it possible to have

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Bruce Momjian
Gregory Stark wrote: [Just when I thought I was out, they pull me back in -- argh, I'm weak] Bruce Momjian [EMAIL PROTECTED] writes: FYI, ls -C actually wraps to 72(?) unless you specify another width, I told you exactly what ls did, at least GNU ls. It uses -w if specified, if not

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Joshua D. Drake
Brendan Jurd wrote: Having done that, please endeavour to make an actual contribution to the discussion. Hi Andrew, Let's be fair. It would be an almost impossible task to make any sense of the archives on this topic without dedicating tens of hours to the task, and having access to a

Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: * Allow adding enumerated values to an existing

2008-04-26 Thread Andrew Dunstan
Alvaro Herrera wrote: Andrew Dunstan escribió: Tom Dunstan wrote: So two alternative proposals, both with a 2 byte enum id and a 2 byte value: 1 - We space the values out as evenly as we can across the 65000ish range and allow people to delete, insert and append, but not reorder.

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Andrew Dunstan
Joshua D. Drake wrote: Brendan Jurd wrote: Having done that, please endeavour to make an actual contribution to the discussion. Hi Andrew, Let's be fair. It would be an almost impossible task to make any sense of the archives on this topic without dedicating tens of hours to the task,

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Joshua D. Drake
Andrew Dunstan wrote: I entered bugzilla on the archives search page and got this link, right out of the recent discussion, at the top of the list: http://archives.postgresql.org/pgsql-hackers/2008-04/msg00764.php That and a few similar results might have given the OP some hints about what

Re: [HACKERS] Proposed patch - psql wraps at window width

2008-04-26 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: I don't see that behavior here on Ubuntu 7.10: $ COLUMNNS=120 ls -C |cat archive cdinitrd lost+found proc srv usr basement.usr dev initrd.img media root sys var bin etc laptop mnt

Re: [HACKERS] Re: [COMMITTERS] pgsql: Update: * Allow adding enumerated values to an existing

2008-04-26 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: Alvaro Herrera wrote: Another alternative would be internally creating a different temporary enum, rewriting the tables one by one each on its own transaction, and finish by dropping the original enum and renaming the temporary one. This solves the

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Tom Lane
Joshua D. Drake [EMAIL PROTECTED] writes: How would he know to search at the archives? If he knew enough about the community to post in -hackers (as opposed to, say, -general or -novice) he should certainly have heard of the mailing list archives. *You* might find 'em useless but I don't.

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Joshua D. Drake
Tom Lane wrote: Joshua D. Drake [EMAIL PROTECTED] writes: How would he know to search at the archives? If he knew enough about the community to post in -hackers (as opposed to, say, -general or -novice) he should certainly have heard of the You think so? (not being sarcastic). mailing

[HACKERS] Traveling this week

2008-04-26 Thread Bruce Momjian
I am leaving tomorrow/Sunday for a one-week trip for EnterpriseDB to Mineapolis and Los Angeles. I will be offline most of the trip so I will miss the start of the May commit fest. -- Bruce Momjian [EMAIL PROTECTED]http://momjian.us EnterpriseDB

Re: [HACKERS] we don't have a bugzilla

2008-04-26 Thread Andrew Sullivan
On Sat, Apr 26, 2008 at 08:54:46AM -0700, Joshua D. Drake wrote: How would he know to search at the archives? * There is no archives signature at the bottom of -hackers lists Maybe because there's a perfectly functional archive link in the mail headers? And because there's an RFC that tells