[HACKERS] Update to contrib/chkpass

2016-05-04 Thread D';Arcy J.M. Cain
a GUC variable to select which Cheers. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | what's for dinner. IM: da...@vex.net, VoIP: sip:da...@druid.net /* * PostgreSQL t

Re: [HACKERS] A minor correction in comment in heaptuple.c

2013-06-18 Thread D';Arcy J.M. Cain
I think about it, the more I think that the comment is both confusing and superfluous. The code itself is much clearer. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (DoD#0082)(eNTP) | w

Re: [HACKERS] A minor correction in comment in heaptuple.c

2013-06-18 Thread D';Arcy J.M. Cain
explanatory. Perhaps the comment should explain why we don't test for negative numbers. I assume that that's an impossible situation. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 788 2246 (D

Re: [HACKERS] A minor correction in comment in heaptuple.c

2013-06-18 Thread D';Arcy J.M. Cain
change since it > tells us how nonexisting columns are interpreted. I think that the comment is bad either way. Comments should explain the code, not repeat it. The above is not far removed from... return 5; /* return the number 5 */ How about "check if attnum is out of range accord

Re: [HACKERS] Feedback about Drupal SQL debugging

2009-08-21 Thread D';Arcy J.M. Cain
counter when using PostgreSQL. > > I would be delighted to have your feedback. It looks to me like you could just reference SQL99 rather than mentioning PostgreSQL other than as an example of a standards compliant database engine. How would those constructs work in MS-SQL or Oracl

Re: [HACKERS] Maintenance Policy?

2009-07-10 Thread D';Arcy J.M. Cain
quot; That takes into account longer release schedules. That way we aren't guaranteeing support for a hard term for a release but rather that we will support it for a specified time from the date it is superceded by the next version. -- D'Arcy J.M. Cain | Democracy is three wo

Re: [HACKERS] A deprecation policy

2009-02-11 Thread D';Arcy J.M. Cain
eprecated for one release, so (1) > configuration files can be upgraded without manual work (relevant to > in-place upgrade), and (2) users are alerted that their carefully > crafted configuration might need a review. As long as they can remove the item giving the warning right away. --

Re: [HACKERS] Output filter for psql

2009-01-28 Thread D';Arcy J.M. Cain
On Wed, 28 Jan 2009 14:08:54 -0500 Andrew Dunstan wrote: > D'Arcy J.M. Cain wrote: > > I suppose we could define another line with options that we could > > define for meta information such as the border setting and the table > > name and whatever we define later.

Re: [HACKERS] Output filter for psql

2009-01-28 Thread D';Arcy J.M. Cain
On Thu, 8 Jan 2009 17:22:04 -0500 "D'Arcy J.M. Cain" wrote: > So, I guess psql should pass XML to the user's filter and simply dump > its output to the screen. Is XML the best format? It would allow us > to pass meta information. For example, we could pass the

Re: [HACKERS] Proposal: new border setting in psql

2009-01-13 Thread D';Arcy J.M. Cain
ql as I posted. It's a much bigger change and my simple filter for my simple needs would be way more complicated but there doesn't seem to be any hope down this road. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep v

Re: [HACKERS] Proposal: new border setting in psql

2009-01-12 Thread D';Arcy J.M. Cain
n order to focus discussions? Is it fair to say that our real choices are 0 and 3? Is there anyone who thinks that number 1 is achievable or that number 2 is a good precedent for the project? -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/

Re: [HACKERS] Proposal: new border setting in psql

2009-01-10 Thread D';Arcy J.M. Cain
On Fri, 9 Jan 2009 22:46:06 -0500 (EST) Greg Smith wrote: > On Fri, 9 Jan 2009, D'Arcy J.M. Cain wrote: > > >> "." is on the long list of characters to be escaped I sent out earlier. > > > > I tried escaping the '.' but it didn't change th

Re: [HACKERS] Proposal: new border setting in psql

2009-01-09 Thread D';Arcy J.M. Cain
bout my other proposal under the "Output filter for psql" subject? That would let people create parsers as safe as they need them. I think that this proposal is still useful for those that need something quick and dirty though. -- D'Arcy J.M. Cain | Democracy is three wo

[HACKERS] Output filter for psql

2009-01-08 Thread D';Arcy J.M. Cain
thing like this: \filter This would create a new format that can be set with pset. For example: \filter rest ~/my_filter ... \pset format rest I would imagine that the filter command would normally go into ~/.psqlrc since it would only be activated by the pset call. -- D'Arcy J.M. Cain

Re: [HACKERS] Proposal: new border setting in psql

2009-01-08 Thread D';Arcy J.M. Cain
ld still like to see some sort of plugin system for psql that would allow filters to be created for output. That would make this entire discussion moot as each of us could write whatever filter worked for them. That's a bigger deal though. -- D'Arcy J.M. Cain | Democracy is thr

Re: [HACKERS] Proposal: new border setting in psql

2009-01-08 Thread D';Arcy J.M. Cain
py. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes t

Re: [HACKERS] Proposal: new border setting in psql

2009-01-08 Thread D';Arcy J.M. Cain
nk anyone in this conversation has been confused about what technology we are talking about. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. -- Sen

Re: [HACKERS] Proposal: new border setting in psql

2009-01-08 Thread D';Arcy J.M. Cain
hp -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to

Re: [HACKERS] Proposal: new border setting in psql

2009-01-08 Thread D';Arcy J.M. Cain
d be the next level. That way people who just want the extra lines can get what they want and people who need 100% ReST can use "border 4" instead. That's if there is any difference of course. We could document "border 4" as ReST with no change to my code p

Re: [HACKERS] Proposal: new border setting in psql

2009-01-08 Thread D';Arcy J.M. Cain
On Wed, 07 Jan 2009 18:12:58 -0500 Tom Lane wrote: > "D'Arcy J.M. Cain" writes: > > Bruce Momjian wrote: > >> As I remember, no actual patch was posted for this. > > > There was. I am attaching it again in case there were any changes > > to o

Re: [HACKERS] Proposal: new border setting in psql

2009-01-07 Thread D';Arcy J.M. Cain
On Wed, 7 Jan 2009 17:22:38 -0500 (EST) Bruce Momjian wrote: > D'Arcy J.M. Cain wrote: > > So what have we decided about this suggestion. Should I submit the > > patch or just forget about it? So far some people like it and some > > people think that it is unnecc

Re: [HACKERS] The Axe list

2008-10-12 Thread D';Arcy J.M. Cain
On Sun, 12 Oct 2008 12:57:58 +0300 "Marko Kreen" <[EMAIL PROTECTED]> wrote: > On 10/11/08, D'Arcy J.M. Cain <[EMAIL PROTECTED]> wrote: > > + if (!random_initialized) > > + { > > + srandom((unsigned int) time(NULL)); > > +

Re: [HACKERS] The Axe list

2008-10-11 Thread D';Arcy J.M. Cain
; charstr[9]; + if (!a1 || !a2) + PG_RETURN_BOOL(0); + text_to_cstring_buffer(a2, str, sizeof(str)); PG_RETURN_BOOL(strcmp(a1->password, crypt(str, a1->password)) != 0); } -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves h

Re: [HACKERS] The Axe list

2008-10-11 Thread D';Arcy J.M. Cain
On Sat, 11 Oct 2008 16:07:31 +0200 Magnus Hagander <[EMAIL PROTECTED]> wrote: > D'Arcy J.M. Cain wrote: > > However, if all it needs is a modern encryption scheme that's probably > > an hour's work. The only reason that I haven't done so yet is because

Re: [HACKERS] The Axe list

2008-10-11 Thread D';Arcy J.M. Cain
unctions are missing? I wouldn't mind having a chance to clean it up before it is removed just in case someone else wants to grab it from CVS later. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/|

Re: [HACKERS] Proposal: new border setting in psql

2008-09-26 Thread D';Arcy J.M. Cain
So what have we decided about this suggestion. Should I submit the patch or just forget about it? So far some people like it and some people think that it is unneccessary. No one so far has suggested that it would harm the system or people's use of it. -- D'Arcy J.M. Cain <[EM

Re: [HACKERS] PostgreSQL future ideas

2008-09-20 Thread D';Arcy J.M. Cain
On Sat, 20 Sep 2008 13:47:10 +0300 Hannu Krosing <[EMAIL PROTECTED]> wrote: > On Fri, 2008-09-19 at 16:37 -0400, D'Arcy J.M. Cain wrote: > > I don't think that we should rush into any one language without > > checking the alternatives. Personally I think we should

Re: [HACKERS] PostgreSQL future ideas

2008-09-19 Thread D';Arcy J.M. Cain
re some minor obstacles like a new OO design, > > The plan is to start porting it to Java after the next release - > probably at the beginning of April. I don't think that we should rush into any one language without checking the alternatives. Personally I think we should port ev

Re: [HACKERS] Parsing of pg_hba.conf and authentication inconsistencies

2008-09-12 Thread D';Arcy J.M. Cain
'addr' has incomplete type I was able to fix this by adding the following line to hba.h: #include "libpq/pqcomm.h" /* needed for struct sockaddr_storage */ -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darc

Re: [HACKERS] Noisy CVS updates

2008-09-07 Thread D';Arcy J.M. Cain
oes not remove any source-code changes, only derived > files. Sorry, I was unclear. I meant that I might still be working on some source code changes and I didn't want to do a distclean every morning and then have to rebuild the tree in order to be able to work on my changes again. I

Re: [HACKERS] Noisy CVS updates

2008-09-07 Thread D';Arcy J.M. Cain
On Sun, 07 Sep 2008 03:39:39 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > ...etc. Would it be OK if I went in and added .cvsignore files to keep > > the noise level down? > > Uh, no, at least not be

[HACKERS] Noisy CVS updates

2008-09-06 Thread D';Arcy J.M. Cain
is an unexpected file and I want to follow up on it. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. -- Sent via pgsql

Re: [HACKERS] Proposal: new border setting in psql

2008-08-29 Thread D';Arcy J.M. Cain
lines and any escaping/formatting would get in their way. And what do you mean by "native?" Border 0? Border 1? Border 2? I think that "principle of least surprise" demands that these not change on a user. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> |

Re: [HACKERS] Proposal: new border setting in psql

2008-08-29 Thread D';Arcy J.M. Cain
On Fri, 29 Aug 2008 06:55:45 -0400 "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> wrote: > On Fri, 29 Aug 2008 01:29:14 -0400 > I think that your scan may have been a bit too cursory. Those > characters, while significant in ReST, only matter when used in very > specifi

Re: [HACKERS] Proposal: new border setting in psql

2008-08-29 Thread D';Arcy J.M. Cain
+---+ | 11 | T`est | ++-------+ | 12 | T_est | ++---+ -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. -- Sent v

Re: [HACKERS] Proposal: new border setting in psql

2008-08-24 Thread D';Arcy J.M. Cain
to make a logical extension to the "border [0|1|2]" setting. If you were going to extend border to 3, what would you do? Adding extra row dividers and turning dashes into equal signs for the existing row divider seems pretty logical on its own without referencing any external for

Re: [HACKERS] Proposal: new border setting in psql

2008-08-24 Thread D';Arcy J.M. Cain
as a base and allow filters to process it before output. That's a much larger job though. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | wh

Re: [HACKERS] Proposal: new border setting in psql

2008-08-23 Thread D';Arcy J.M. Cain
t in *any* third party program that's my personal issue. If "border 3" happens to get me closer to my format that's great but it has to stand on its own merit. I think that this proopsal does. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three

Re: [HACKERS] Proposal: new border setting in psql

2008-08-23 Thread D';Arcy J.M. Cain
enough. In fact border 0 has everything we absolutely need. Why have any borders? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what

Re: [HACKERS] Proposal: new border setting in psql

2008-08-23 Thread D';Arcy J.M. Cain
On Thu, 21 Aug 2008 21:04:07 -0400 "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> wrote: > > There's still the question of whether this covers any needs that aren't > > met just as well by XML or CSV output formats. > > Well, we could remove all the displa

Re: [HACKERS] Feeding results back into select

2008-08-23 Thread D';Arcy J.M. Cain
ot;'); > " character was chosen to simplify escaping, To prevent; INSERT INTO table (hfield) VALUES ('''a''=>''b'''); I guess my brain was pointed elsewhere when I asked. Thanks for not treating me like an idiot. :-) -- D

Re: [HACKERS] Feeding results back into select (was: proposal sql: labeled function params)

2008-08-22 Thread D';Arcy J.M. Cain
then a dump and reload would have trashed all the passwords by re-encrypting them. What I did was to make a special case on input. If the string started with ':' then I strip that character and insert the string unchanged. Then I changed the output to prepend the ':'. Now

Re: [HACKERS] Proposal: new border setting in psql

2008-08-22 Thread D';Arcy J.M. Cain
On Fri, 22 Aug 2008 08:23:01 +0200 Martijn van Oosterhout <[EMAIL PROTECTED]> wrote: > On Thu, Aug 21, 2008 at 11:18:24PM -0400, D'Arcy J.M. Cain wrote: > > ReST is nice because it's almost plain text. In fact, a ReST document > > source can easily be read raw.

Re: [HACKERS] Proposal: new border setting in psql

2008-08-21 Thread D';Arcy J.M. Cain
rst, it's such a logical progression from "border 0" to the proposed "border 3" that that syntax makes more sense. In fact, the guide is inches away from describing this behaviour already. Besides, making it a border option adds 12 lines to the code, 5 of which are bl

Re: [HACKERS] Proposal: new border setting in psql

2008-08-21 Thread D';Arcy J.M. Cain
On Thu, 21 Aug 2008 20:36:51 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > No, I meant that one would do any ad hoc query and cut and paste the > > output directly into a tracking tool that supports ReST.

Re: [HACKERS] Proposal: new border setting in psql

2008-08-21 Thread D';Arcy J.M. Cain
L PROTECTED] testdb=> \pset border 0 Border style is 0. [EMAIL PROTECTED] testdb=> SELECT * FROM my_table; -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)

Re: [HACKERS] Proposal: new border setting in psql

2008-08-21 Thread D';Arcy J.M. Cain
On Thu, 21 Aug 2008 15:03:23 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > I would like to propose a new border setting. > > That code is horrendously overcomplicated and unreadable already :-( >

[HACKERS] Proposal: new border setting in psql

2008-08-21 Thread D';Arcy J.M. Cain
to allow the output to be fed directly into any system using Restructured text as described in http://docutils.sourceforge.net/docs/user/rst/quickref.html. If there is any interest I will submit patches for code and documentation. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | D

Re: [HACKERS] modules

2008-04-05 Thread D';Arcy J.M. Cain
eir clients. I will continue to help mine any way I can. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. -- Sent v

Re: [HACKERS] modules

2008-04-05 Thread D';Arcy J.M. Cain
into each customer's database and run an > SQL script. That does seem like more work and more risk than a lot of ISPs > will be willing to take on. Why wouldn't you just run it against template1 so that it is available in every database created after that? -- D'Arcy J.M. Cain

Re: [HACKERS] modules

2008-04-04 Thread D';Arcy J.M. Cain
SQL are probably enterprise users or users running off of their own systems who have all the access they need. How big is this "problem" really? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and

Re: [HACKERS] modules

2008-04-03 Thread D';Arcy J.M. Cain
On Thu, 03 Apr 2008 13:06:25 -0400 Andrew Dunstan <[EMAIL PROTECTED]> wrote: > D'Arcy J.M. Cain wrote: > > In fact, this may be the way to deprecate contrib. Start building > > modules and move the contrib packages to it one at a time. That way > > people using

Re: [HACKERS] modules

2008-04-03 Thread D';Arcy J.M. Cain
On Thu, 03 Apr 2008 09:31:01 -0700 Ron Mayer <[EMAIL PROTECTED]> wrote: > D'Arcy J.M. Cain wrote: > > Check out NetBSD pkgsrc as a model. It is very flexible. One nice > > thing would be the ability to specify where the packages are rather > > than always ins

Re: [HACKERS] modules

2008-04-03 Thread D';Arcy J.M. Cain
On Thu, 3 Apr 2008 09:41:57 -0700 "Joshua D. Drake" <[EMAIL PROTECTED]> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On Thu, 3 Apr 2008 12:35:31 -0400 > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> wrote: > > > On Thu,

Re: [HACKERS] modules

2008-04-03 Thread D';Arcy J.M. Cain
rs that no one has changed the file since it was tested and packaged. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner.

Re: [HACKERS] modules

2008-04-02 Thread D';Arcy J.M. Cain
There are some special considerations for PostgreSQL but I think that the fact that there are unsolved problems shouldn't stop us from solving them. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep vo

[HACKERS] Re: [COMMITTERS] pgsql: Link postgres from all object files at once, to avoid the

2008-02-25 Thread D';Arcy J.M. Cain
enance > tedium. I wonder if there's another way, such as using a file name that > CVS is already programmed to ignore. Why not just add it to CVSROOT/cvsignore? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/

Re: [HACKERS] Including PL/PgSQL by default

2008-02-22 Thread D';Arcy J.M. Cain
t-initdb if thats what they > want to do. And the first time someone uses pl/pgsql to do harm, even if it is due to their mis-configuration, who gets blamed? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/

Re: [HACKERS] Including PL/PgSQL by default

2008-02-21 Thread D';Arcy J.M. Cain
dd it to any DB that needs it, I fail to see why we should add it by default. Personally I would like to see more things removed from PG and have them added as modules when required. Of course, we would need a proper module system first. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]>

Re: [HACKERS] Permanent settings

2008-02-21 Thread D';Arcy J.M. Cain
y work too - that read variables from the database and plugged them into a basic template. That way you can make localized changes to specific servers by changing the database or global changes by changing the template. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> |

Re: [HACKERS] Password policy

2008-01-16 Thread D';Arcy J.M. Cain
ault. However, these things haven't yet been a requirement for me so I have not bothered yet. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)

Re: [HACKERS] Password policy

2008-01-15 Thread D';Arcy J.M. Cain
tions you tend to find a lot more passwords on post-it notes and in clear text files. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(

Re: [HACKERS] Spoofing as the postmaster

2007-12-29 Thread D';Arcy J.M. Cain
On Sat, 29 Dec 2007 10:38:13 -0500 Andrew Dunstan <[EMAIL PROTECTED]> wrote: > > > D'Arcy J.M. Cain wrote: > > - 1: How does the client assure that the postmaster is legit > > - 2: How does the postmaster assure that the client is legit > > And neithe

Re: [HACKERS] Spoofing as the postmaster

2007-12-29 Thread D';Arcy J.M. Cain
erent issues; - 1: How does the client assure that the postmaster is legit - 2: How does the postmaster assure that the client is legit Does anyone think that there is one answer to both? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.drui

Re: [HACKERS] Spoofing as the postmaster

2007-12-23 Thread D';Arcy J.M. Cain
On Sun, 23 Dec 2007 07:57:07 + Gregory Stark <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > It's generally a bad idea to put your database on a public server > > anyway but if you do you should definitely disable

Re: [HACKERS] Spoofing as the postmaster

2007-12-22 Thread D';Arcy J.M. Cain
lhost. That has been our rule for years. It's certainly a corner case. I would think that warnings, perhaps in the config file itself, would be sufficient. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/

Re: [HACKERS] [COMMITTERS] pgsql: Add regression tests for MONEY type.

2007-11-25 Thread D';Arcy J.M. Cain
On Sat, 24 Nov 2007 17:22:35 -0300 Alvaro Herrera <[EMAIL PROTECTED]> wrote: > D'Arcy J.M. Cain wrote: > > Log Message: > > --- > > Add regression tests for MONEY type. > > This has broken the buildfarm ... It worked here. Can you send me the error

Re: [HACKERS] type money causes unrestorable dump

2007-11-04 Thread D';Arcy J.M. Cain
On Sun, 04 Nov 2007 20:38:11 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > Hmm. I think I like Tom's version better. However, since my primary > > goal here is to remove the deprecation I will l

Re: [HACKERS] type money causes unrestorable dump

2007-11-04 Thread D';Arcy J.M. Cain
On Sun, 4 Nov 2007 17:24:10 -0500 (EST) Bruce Momjian <[EMAIL PROTECTED]> wrote: > D'Arcy J.M. Cain wrote: > > + > > +Since the output of this data type is locale-sensitive, it may not > > +work to load money data into a database that has a different >

Re: [HACKERS] type money causes unrestorable dump

2007-11-04 Thread D';Arcy J.M. Cain
Monetary Types -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)---

Re: [HACKERS] type money causes unrestorable dump

2007-11-03 Thread D';Arcy J.M. Cain
On Sat, 03 Nov 2007 14:39:48 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> writes: > > I never received a response on this. Here is the full diff with the > > above change. Since it is documentation and not code,

Re: [HACKERS] type money causes unrestorable dump

2007-11-03 Thread D';Arcy J.M. Cain
On Tue, 9 Oct 2007 13:16:08 -0400 "D'Arcy J.M. Cain" <[EMAIL PROTECTED]> wrote: > On Tue, 9 Oct 2007 19:02:38 +0200 > Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > Am Dienstag, 9. Oktober 2007 schrieb D'Arcy J.M. Cain: > > > +    Due to loc

Re: [HACKERS] Can a C function(server program) be a UDP or TCP server?

2007-10-18 Thread D';Arcy J.M. Cain
cond server that is not PostgreSQL that uses UDP that you want to communicate with and merge info into the PostgreSQL server from? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 42

Re: [HACKERS] Can a C function(server program) be a UDP or TCP server?

2007-10-18 Thread D';Arcy J.M. Cain
omeone about network programming but this is the wrong list. If you are asking if PostgreSQL already does UDP then the answer is no. You need to write a server program that talks UDP in one direction and TCP to PostgreSQL in the other direction. Watch out for security issues. -- D'Arcy

Re: [HACKERS] Release notes introductory text

2007-10-11 Thread D';Arcy J.M. Cain
intent. The indent was to say we got a lot done in > one year. You have a suggestion? What if you changed "were added rapidly" to "were quickly brought to maturity" or something like that? -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is th

Re: [HACKERS] type money causes unrestorable dump

2007-10-09 Thread D';Arcy J.M. Cain
On Tue, 9 Oct 2007 19:02:38 +0200 Peter Eisentraut <[EMAIL PROTECTED]> wrote: > Am Dienstag, 9. Oktober 2007 schrieb D'Arcy J.M. Cain: > > +    Due to locale changes this type may have problems with dump and > > +    restore and care should be taken. > > With

Re: [HACKERS] type money causes unrestorable dump

2007-10-09 Thread D';Arcy J.M. Cain
ision; see Monetary Types -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast

Re: [HACKERS] type money causes unrestorable dump

2007-10-09 Thread D';Arcy J.M. Cain
rdization allowed by just using the functions. Just a thought. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---

Re: [HACKERS] adding operators

2007-10-01 Thread D';Arcy J.M. Cain
CREATE FUNCTION, and then hooking operators > up to them using CREATE OPERATOR. And if you need to add C code you can do that too. Check some examples in contrib such as my chkpass module for examples. -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three wolves h

Re: [HACKERS] more problems with the money type

2007-08-20 Thread D';Arcy J.M. Cain
> > See submitted patch that fixes cash_send and cash_recv as well. > Patch: http://archives.postgresql.org/pgsql-patches/2007-08/msg00117.php I am still waiting for Magnus to restore my CVS access following the move. Can someone else commit these fixes? -- D'Arcy J.M

Re: [HACKERS] more problems with the money type

2007-08-20 Thread D';Arcy J.M. Cain
;SELECT 2 * '3'::money;" do? If that works try changing "64" to "32" in the function cash_mul_int4. Let me know and I will commit the fix as soon as I get CVS access again. > aside: since the money type was deprecated, why was it bumped to 64 bits? See the

Re: [HACKERS] Blowback from text conversion changes

2007-06-25 Thread D';Arcy J.M. Cain
ut really, that isn't necessarily what '' signifies. How about '2007-06-25'? Is that text, date or timestamp? Try this. select 'a'||b from (select 'b'::text as b) as x; -- D'Arcy J.M. Cain <[EMAIL PROTECTED]> | Democracy is three

Re: [HACKERS] Money type todos?

2007-03-21 Thread D';Arcy J.M. Cain
e albeit a very ubiquitous one. > everything in these systems. For a complex general system you often can > get away with integers if you define at the app layer the handling > (including a lookup in system for format, type). Sometimes a "psql -c" is all you need to get usef

Re: [HACKERS] Money type todos?

2007-03-21 Thread D';Arcy J.M. Cain
ith pursuing that path? I still get the odd message from people telling me that they hope it stays in. I suspect that the main reason that more people don't use it is that we keep saying that it is going away. Perhaps we should either put forward an actual schedule for removing it or

Re: [HACKERS] Money type todos?

2007-03-20 Thread D';Arcy J.M. Cain
ta type Actually, this TODO is DONE. It's in HEAD now. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end o

Re: [HACKERS] Ooops ... seems we need a re-release pronto

2007-02-11 Thread D';Arcy J.M. Cain
On Sun, 11 Feb 2007 12:30:45 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" writes: > > How about a rule that says no new ode without a test? > > We've got way too many tests like that already, ie, a bunch of > mostly-redundant function

Re: [HACKERS] Ooops ... seems we need a re-release pronto

2007-02-11 Thread D';Arcy J.M. Cain
ice because the regression test catches those. Of course, while you are creating one test you can always add a few related ones. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 12

Re: [HACKERS] [COMMITTERS] pgsql: Widen the money type to 64 bits.

2007-01-08 Thread D';Arcy J.M. Cain
as requested. What do you mean by "old?" -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. ---(end of broadcast)-

Re: [HACKERS] New version of money type

2006-12-31 Thread D';Arcy J.M. Cain
nt64 i = PG_GETARG_INT32(1); I changed this and a few other things. I didn't see any response to my question though. Shall I go ahead and commit now so that we can test in a wider setting? I haven't committed anything in years and I am hesitant to do so now without consencu

Re: [HACKERS] Possible documentation error

2006-12-26 Thread D';Arcy J.M. Cain
On Tue, 26 Dec 2006 18:12:45 +0100 Martijn van Oosterhout wrote: > On Tue, Dec 26, 2006 at 12:04:40PM -0500, D'Arcy J.M. Cain wrote: > > Now it certainly seems to me that it should behave as described given > > the definition of VACUUM FULL so I am a little confused by my test

[HACKERS] Possible documentation error

2006-12-26 Thread D';Arcy J.M. Cain
sed by my tests. My test table only has two entries in it. Is that the issue? In fact, I find the same behaviour if I do a simple VACUUM on the table. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 42

Re: [HACKERS] New version of money type

2006-12-22 Thread D';Arcy J.M. Cain
nt64 i = PG_GETARG_INT32(1); As I have made the few corrections that you pointed out, should I go ahead and commit so that it can be tested in a wider group? Also, there are further ideas out there to improve the type further that would be easier to handle with this o

Re: [HACKERS] New version of money type

2006-12-21 Thread D';Arcy J.M. Cain
On Thu, 21 Dec 2006 10:47:52 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" writes: > > Very good points. However, like the currency symbol issue I would like > > to separate that into another discussion. The code already exists with > >

Re: [HACKERS] New version of money type

2006-12-21 Thread D';Arcy J.M. Cain
On Thu, 21 Dec 2006 00:21:08 -0800 David Fetter <[EMAIL PROTECTED]> wrote: > On Wed, Dec 20, 2006 at 08:44:07PM -0500, D'Arcy J.M. Cain wrote: > > Now that 8.3 has been branched shall I go ahead and commit? As > > discussed I will put the currency symbol back in

Re: [HACKERS] New version of money type

2006-12-20 Thread D';Arcy J.M. Cain
On Thu, 12 Oct 2006 14:24:22 -0400 "D'Arcy J.M. Cain" wrote: > On Thu, 12 Oct 2006 14:17:33 -0400 > Tom Lane <[EMAIL PROTECTED]> wrote: > > "D'Arcy J.M. Cain" writes: > > > Cool. So what do I do with the patch? Should I add the currency

Re: [HACKERS] Syntax bug? Group by?

2006-10-17 Thread D';Arcy J.M. Cain
x27;t need the GROUP BY clause. However, this doesn't sound like a hackers question. Next time, please ask on another list such as pgsql-sql or even pgsql-novice. You can review the mailing lists and their purpose at http://www.postgresql.org/community/lists/ -- D'Arcy J.M.

Re: [HACKERS] New version of money type

2006-10-12 Thread D';Arcy J.M. Cain
On Thu, 12 Oct 2006 14:17:33 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "D'Arcy J.M. Cain" writes: > > Cool. So what do I do with the patch? Should I add the currency > > symbol back in and commit or should I resubmit the patch to hackers for > >

Re: [HACKERS] New version of money type

2006-10-12 Thread D';Arcy J.M. Cain
e patch? Should I add the currency symbol back in and commit or should I resubmit the patch to hackers for further review? -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP)

Re: [HACKERS] New version of money type

2006-10-12 Thread D';Arcy J.M. Cain
than one major change at a time. The one issue I have with my existing patch though is the removal of the currency symbol from the output. There have been many suggestions that that just gets in the way but, following up on my own statement above, this is two changes, not one, and perhaps should

Re: [HACKERS] New version of money type

2006-09-28 Thread D';Arcy J.M. Cain
currency symbol but I have received complaints about that. It should probably go back just because it is outside of the scope of the primary change. That can be dealt with later. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/| and a

  1   2   3   >