[HACKERS] Update to contrib/chkpass

2016-05-04 Thread D'Arcy J.M. Cain
variable to select which Cheers. -- D'Arcy J.M. Cain <da...@druid.net> | 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 /* * Post

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

2013-06-18 Thread D'Arcy J.M. Cain
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 according to the tupdesc instead? -- D'Arcy J.M. Cain da

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

2013-06-18 Thread D'Arcy J.M. Cain
. I assume that that's an impossible situation. -- D'Arcy J.M. Cain da...@druid.net | 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...@vex.net

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

2013-06-18 Thread D'Arcy J.M. Cain
think that the comment is both confusing and superfluous. The code itself is much clearer. -- D'Arcy J.M. Cain da...@druid.net | 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

Re: [HACKERS] Feedback about Drupal SQL debugging

2009-08-21 Thread D'Arcy J.M. Cain
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 Oracle? -- D'Arcy J.M. Cain da

Re: [HACKERS] Maintenance Policy?

2009-07-10 Thread D'Arcy J.M. Cain
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 da...@druid.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] A deprecation policy

2009-02-11 Thread D'Arcy J.M. Cain
are alerted that their carefully crafted configuration might need a review. As long as they can remove the item giving the warning right away. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212

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 da...@druid.net 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 border setting so

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 and...@dunslane.net 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. E.g

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

2009-01-13 Thread D'Arcy J.M. Cain
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 da...@druid.net | 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

2009-01-12 Thread D'Arcy J.M. Cain
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 da...@druid.net | 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 gsm...@gregsmith.com 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 the behaviour. I did try that specific exapmle

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

2009-01-09 Thread D'Arcy J.M. Cain
useful for those that need something quick and dirty though. -- D'Arcy J.M. Cain da...@druid.net | 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

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 t...@sss.pgh.pa.us wrote: D'Arcy J.M. Cain da...@druid.net writes: Bruce Momjian br...@momjian.us 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 original files

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

2009-01-08 Thread D'Arcy J.M. Cain
% 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 patch until we find some case where border 3 breaks ReST. -- D'Arcy J.M. Cain da...@druid.net | Democracy is three wolves http://www.druid.net/darcy

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

2009-01-08 Thread D'Arcy J.M. Cain
-- D'Arcy J.M. Cain da...@druid.net | 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

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

2009-01-08 Thread D'Arcy J.M. Cain
anyone in this conversation has been confused about what technology we are talking about. -- D'Arcy J.M. Cain da...@druid.net | 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] Proposal: new border setting in psql

2009-01-08 Thread D'Arcy J.M. Cain
. -- D'Arcy J.M. Cain da...@druid.net | 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

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

2009-01-08 Thread D'Arcy J.M. Cain
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 da...@druid.net | Democracy is three wolves http://www.druid.net/darcy

[HACKERS] Output filter for psql

2009-01-08 Thread D'Arcy J.M. Cain
this: \filter format path 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 da

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 br...@momjian.us 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 unneccessary. No one so far

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)); + random_initialized = true; + } This is bad idea, postgres

Re: [HACKERS] The Axe list

2008-10-11 Thread D'Arcy J.M. Cain
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/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. -- Sent via

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 I have no use case. If I am storing encrypted

Re: [HACKERS] The Axe list

2008-10-11 Thread D'Arcy J.M. Cain
)); PG_RETURN_BOOL(strcmp(a1-password, crypt(str, a1-password)) != 0); } -- 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

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 [EMAIL PROTECTED

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 port everything to Intercal. My

Re: [HACKERS] PostgreSQL future ideas

2008-09-19 Thread D'Arcy J.M. Cain
, 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 everything to Intercal. -- D'Arcy J.M. Cain [EMAIL PROTECTED

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

2008-09-12 Thread D'Arcy J.M. Cain
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/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP

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 before you've explained why you get those messages and others

Re: [HACKERS] Noisy CVS updates

2008-09-07 Thread D'Arcy J.M. Cain
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 use CVS in enough projects to understand how it works. -- D'Arcy J.M. Cain [EMAIL PROTECTED

[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-hackers mailing

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

2008-08-29 Thread D'Arcy J.M. Cain
? I think that principle of least surprise demands that these not change on a user. -- 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] Proposal: new border setting in psql

2008-08-29 Thread D'Arcy J.M. Cain
| ++---+ -- 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-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

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 specific ways. The following works just fine

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

2008-08-24 Thread D'Arcy J.M. Cain
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 wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP

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

2008-08-24 Thread D'Arcy J.M. Cain
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) | what's for dinner. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

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

2008-08-24 Thread D'Arcy J.M. Cain
|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 formats. -- D'Arcy J.M. Cain [EMAIL PROTECTED

Re: [HACKERS] Feeding results back into select

2008-08-23 Thread D'Arcy J.M. Cain
. :-) -- 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-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

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 display formats except XML. After all, it can always

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

2008-08-23 Thread D'Arcy J.M. Cain
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's for dinner. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

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. I presume by ReST you mean this: http

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

2008-08-22 Thread D'Arcy J.M. Cain
. If the string started with ':' then I strip that character and insert the string unchanged. Then I changed the output to prepend the ':'. Now dump and reload work. Just curious. -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy

[HACKERS] Proposal: new border setting in psql

2008-08-21 Thread D'Arcy J.M. Cain
for this is 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] | Democracy

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 :-( I'm not too eager to add more variants to it. Actually, I

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

2008-08-21 Thread D'Arcy J.M. Cain
| ++---++ +| 4 | four | ++---++ +(4 rows) + [EMAIL PROTECTED] testdb=gt; userinput\pset border 0/userinput Border style is 0. [EMAIL PROTECTED] testdb=gt; userinputSELECT * FROM my_table;/userinput -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http

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. There's still the question of whether this covers

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

2008-08-21 Thread D'Arcy J.M. Cain
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 blank. I wouldn't want to think about the changes if it was a different setting. -- D'Arcy J.M. Cain [EMAIL PROTECTED

Re: [HACKERS] modules

2008-04-05 Thread D'Arcy J.M. Cain
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 [EMAIL PROTECTED] | Democracy is three

Re: [HACKERS] modules

2008-04-05 Thread D'Arcy J.M. Cain
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 via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] modules

2008-04-04 Thread D'Arcy J.M. Cain
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 a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP

Re: [HACKERS] modules

2008-04-03 Thread D'Arcy J.M. Cain
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. -- Sent via pgsql-hackers mailing list (pgsql-hackers

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, 3 Apr 2008 13:54:11 - Greg Sabino Mullane [EMAIL PROTECTED] wrote: Right

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 insisting that they be on pgfoundry. Yup

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 contrib have some time to switch and we can

Re: [HACKERS] modules

2008-04-02 Thread D'Arcy J.M. Cain
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 voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner. -- Sent via pgsql-hackers mailing list (pgsql

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

2008-02-25 Thread D'Arcy J.M. Cain
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/| and a sheep voting on +1 416 425 1212

Re: [HACKERS] Including PL/PgSQL by default

2008-02-22 Thread D'Arcy J.M. Cain
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/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] Permanent settings

2008-02-21 Thread D'Arcy J.M. Cain
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] | 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
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] | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] Password policy

2008-01-16 Thread D'Arcy J.M. Cain
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)(eNTP) | what's for dinner. ---(end of broadcast

Re: [HACKERS] Password policy

2008-01-15 Thread D'Arcy J.M. Cain
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)(eNTP) | what's for dinner. ---(end of broadcast)--- TIP 2: Don't

Re: [HACKERS] Spoofing as the postmaster

2007-12-29 Thread D'Arcy J.M. Cain
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.druid.net/darcy/| and a sheep

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 neither answers the original problem: Which seems

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 unix domain sockets and connect over TCP to localhost

Re: [HACKERS] Spoofing as the postmaster

2007-12-22 Thread D'Arcy J.M. Cain
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/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP

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 output. -- D'Arcy J.M. Cain [EMAIL PROTECTED

Re: [HACKERS] type money causes unrestorable dump

2007-11-04 Thread D'Arcy J.M. Cain
=datatype-money-table titleMonetary Types/title tgroup cols=4 -- 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] 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: + para +Since the output of this data type is locale-sensitive, it may not +work to load typemoney/ data into a database that has a different +setting of varnamelc_monetary

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 let you guys duke it out over the additional clause

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 locale changes this type may have problems with dump and +    restore

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, is it OK to commit this now? The added text needs

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

2007-10-18 Thread D'Arcy J.M. Cain
. 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 J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http

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

2007-10-18 Thread D'Arcy J.M. Cain
. The dynamic function resides in the server. The query runs in the server. Where is the remoteness in any of this? Are you saying that there is a second 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

Re: [HACKERS] Release notes introductory text

2007-10-11 Thread D'Arcy J.M. Cain
? 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 three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's

Re: [HACKERS] type money causes unrestorable dump

2007-10-09 Thread D'Arcy J.M. Cain
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. ---(end of broadcast

Re: [HACKERS] type money causes unrestorable dump

2007-10-09 Thread D'Arcy J.M. Cain
between +this type and others. + /para + table id=datatype-money-table titleMonetary Types/title tgroup cols=4 -- 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

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 respect, this kind of advice is useless. What

Re: [HACKERS] adding operators

2007-10-01 Thread D'Arcy J.M. Cain
. 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 http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082

Re: [HACKERS] more problems with the money type

2007-08-20 Thread D'Arcy J.M. Cain
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 archives. -- D'Arcy J.M. Cain [EMAIL PROTECTED] | Democracy is three wolves http

Re: [HACKERS] more problems with the money type

2007-08-20 Thread D'Arcy J.M. Cain
://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. Cain [EMAIL PROTECTED] | Democracy is three wolves http://www.druid.net/darcy/| and a sheep

Re: [HACKERS] Blowback from text conversion changes

2007-06-25 Thread D'Arcy J.M. Cain
'? 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 wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212 (DoD#0082)(eNTP) | what's for dinner

Re: [HACKERS] Money type todos?

2007-03-21 Thread D'Arcy J.M. Cain
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 stop telling people that it is deprecated. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net

Re: [HACKERS] Money type todos?

2007-03-21 Thread D'Arcy J.M. Cain
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 useful information. -- D'Arcy J.M. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] Money type todos?

2007-03-20 Thread D'Arcy J.M. Cain
. It's in HEAD now. -- D'Arcy J.M. Cain darcy@druid.net | 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] Ooops ... seems we need a re-release pronto

2007-02-11 Thread D'Arcy J.M. Cain
, while you are creating one test you can always add a few related ones. -- D'Arcy J.M. Cain darcy@druid.net | 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] 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 darcy@druid.net 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 functional tests of isolated new features

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

2007-01-08 Thread D'Arcy J.M. Cain
. What do you mean by old? -- D'Arcy J.M. Cain darcy@druid.net | 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
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 consencus. -- D'Arcy J.M. Cain darcy@druid.net

[HACKERS] Possible documentation error

2006-12-26 Thread D'Arcy J.M. Cain
. 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 darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy/| and a sheep voting on +1 416 425 1212

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 kleptog@svana.org 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 tests. My

Re: [HACKERS] New version of money type

2006-12-22 Thread D'Arcy J.M. Cain
); 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 out of the way. -- D'Arcy J.M. Cain darcy@druid.net

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 just so that it can be discussed

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 darcy@druid.net writes: Very good points. However, like the currency symbol issue I would like to separate that into another discussion. The code already exists with the warts you mention (and more

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 darcy@druid.net wrote: On Thu, 12 Oct 2006 14:17:33 -0400 Tom Lane [EMAIL PROTECTED] wrote: D'Arcy J.M. Cain darcy@druid.net writes: Cool. So what do I do with the patch? Should I add the currency symbol back in and commit or should I

Re: [HACKERS] Syntax bug? Group by?

2006-10-17 Thread D'Arcy J.M. Cain
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. Cain darcy@druid.net | Democracy is three wolves http://www.druid.net/darcy

Re: [HACKERS] New version of money type

2006-10-12 Thread D'Arcy J.M. Cain
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 be left out of the patch for that reason. -- D'Arcy J.M. Cain darcy@druid.net

Re: [HACKERS] New version of money type

2006-10-12 Thread D'Arcy J.M. Cain
resubmit the patch to hackers for further review? -- D'Arcy J.M. Cain darcy@druid.net | 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-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 darcy@druid.net 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 further review? Well, one thing you

Re: [HACKERS] New version of money type

2006-09-28 Thread D'Arcy J.M. Cain
On Thu, 14 Sep 2006 10:35:03 -0400 D'Arcy J.M. Cain darcy@druid.net wrote: For years I have been promising that a 64 bit version of the money type was on the way. Here it is. So far it compiles and I have done some basic testing on it and it seems to work fine. Note that the currency symbol

  1   2   3   >