Re: [PATCHES] [HACKERS] Patch to make Turks happy.
Bruce Momjian [EMAIL PROTECTED] writes: Are you 64-bit s390? The patch is for GNU/Linux on S/390 hardware. This platform is sane and it uses ASCII. Only the traditional UNIX subsystem for OS/390 uses EBCDIC. -- Florian Weimer[EMAIL PROTECTED] University of Stuttgart http://CERT.Uni-Stuttgart.DE/people/fw/ RUS-CERT fax +49-711-685-5898 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] pg_conversion
What do the columns conforencoding and contoencoding refer to in pg_conversion? How would I convert those numbers to a string encoding name, just using SQL? Chris Use pg_encoding_to_char(). -- Tatsuo Ishii ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] [SQL] SELECT FOR UPDATE locks whole table
On December 6, 2002 02:10 pm, Bruce Momjian wrote:
It should lock only the rows you retrieved, but I have no idea how FOR
UPDATE and INTO TEMP behave. My guess is that it should work fine, but
I have never seen those two used together before.
Turns out that it wasn't the SELECT ... FOR UPDATE that was causing the
problem. I did a test like this.
SELECT certificate_id
INTO TEMP TABLE x_certs
FROM certificate
WHERE cert_status = 0 AND
certificate_id BETWEEN AND AND
client_id IN (1, 2, 3)
ORDER BY certificate_id
FOR UPDATE;
Basically this query after a BEGIN TRANSACTION except without the INTO part.
Then I went to another window and tried to update two certificates, one
inside and one outside the range. The first failed and the second succeeded
as expected. I then updated one of the certs in the range. After that I
could not update any certificates until I closed the transaction. Very weird.
I then built a new database and repeated the experiment with fresh, simple
tables and was able to confirm that normally PostgreSQL does NOT have this
behaviour so then I started thinking about differences between the simple
setup and our real production setup. One thing that I thought of was that
the real database has this trigger on certificate.
CREATE TRIGGER mk_cardnum
BEFORE INSERT OR UPDATE ON certificate
FOR EACH ROW
EXECUTE PROCEDURE mk_cardnum (cardnum, certificate_id, validation);
mk_cardnum is a C function that reads certificate_id and validation and
writes something into cardnum. My understanding is that this only affects
the row(s) being updated. It must since this table has over seven million
records and we would notice if it took minutes to do a simple update.
I couldn't find anything in the docs or web specifically about this. Does
anyone have any ideas?
Adding hackers as this may be an internal issue.
--
D'Arcy J.M. Cain darcy@{druid|vex}.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)---
TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] IPv6 patch rejected
Bruce Momjian [EMAIL PROTECTED] writes: I am pretty sure it is going to fail if your machine isn't INET6 aware, which may be many. That's definitely not gonna do :-( regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] more compile warnings
Bruce Momjian [EMAIL PROTECTED] writes: You would think that would catch it. My problem is that I am compiling with -O0, because I compile all day and I don't care about optimization. You should reconsider that. At -O0 gcc doesn't do any flow analysis, and thus you lose many important warnings. I'd recommend -O1 at least. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Announces
On Wed, 4 Dec 2002, Bruce Momjian wrote: Peter Eisentraut wrote: Marc G. Fournier writes: It isn't, but those working on -advocacy were asked to help come up with a stronger release *announcement* then we've had in the past ... Consider that a failed experiment. PostgreSQL is driven by the development group and, to some extent, by the existing user base. The last thing we need is a marketing department in that mix. Peter, I understand your perspective, but I think you are in the minority on this one. Kinda depends who you're asking now, doesn't it? I happen to agree with him, but as long as you're only going to involve a selected few in the opinion gathering you can pretty much get the answer you want to get. I can survey 100 people and get the opposite result putting you in the minority. Vince. -- Fast, inexpensive internet service 56k and beyond! http://www.pop4.net/ http://www.meanstreamradio.com http://www.unknown-artists.com Internet radio: It's not file sharing, it's just radio. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
Vince Vielhaber wrote: On Thu, 5 Dec 2002, Robert Treat wrote: Well, my previous employer uses postgresql, but they were under constant assault from their clients to use oracle or db2. Technically there was no reason to switch, but if your choice is switch databases or go out of business, there really isn't much choice. That tells me their clients wanted a commercial database, not one that's open source. All the marketing in the world won't change that. Really? Why do you say that? :-) Regards and best wishes, Justin Clift Vince. -- My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there. - Indira Gandhi ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
On Thu, 5 Dec 2002, Brian Knox wrote: Speaking from the perspective of a long time postgresql user, who currently has several very mission critical applications using postgresql on the back end, at a very large company... I can say the one consequence of the problem that I have run into personally, is convincing management to allow me to use postgresql for my projects to begin with. Fortunately, where I am currently employed, I was able to bash my head against the brick wall until they got tired of hearing from me, and allowed me to go with postgresql instead of sybase (which was their first choice, as the corporation already has a sybase site license). The lack of name recognition was a factor that contributed to the difficulty of getting postgresql accepted. The last thing a non technical middle manager wants to tell his or her manager is that some mission critical application that just crashed was running on some database he had never heard of before that he gave the go ahead to use. Not name recognition, but it'd be nice to think that's the reason. Mysql has alot of name recognition but you didn't mention them. You mentioned sybase and having a sybase site license. Marketing wouldn't help here, they want a commercial database used that they've already paid for. What too many people fail to realize is that in a commercial environment many companies want another company to point the finger at in case of disaster. Sybase failed, or HP failed, or IBM failed, or Microsoft failed. They feel they can do something about that. If they lose a few million they have someone they can go after, who are they going to go after if PostgreSQL fails them? Marc? Bruce? Vince. -- Fast, inexpensive internet service 56k and beyond! http://www.pop4.net/ http://www.meanstreamradio.com http://www.unknown-artists.com Internet radio: It's not file sharing, it's just radio. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[HACKERS] Darwin/Mac OS X Startup Script
All, I've simplified the Darwin/Mac OS X startup script I submitted earlier in the year. This version has only the two files required by the Darwin startup bundle design. Plus the sh script now uses Darwin-standard functions to start up PostgreSQL, and it checks for the presence of a variable in /etc/hostconfig, as do other Darwin startup scripts. I suggest that a new directory be created, contrib/start-scripts/darwin, and that these two files be put into it. Folks who want to use the script can read the comments inside it to figure out how to use it. Enjoy, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://david.wheeler.net/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] Darwin.tar.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[HACKERS] Let's create a release team
Hi folks, Let's create a release team. This strategy is one well established in other projects and in industry. For lack of a better starting reference, let me suggest http://www.freebsd.org/releng/charter.html as a starting point for consideration. See also http://www.freebsd.org/releng/index.html. This will also lighten the load on the core team allowing them to focus on development and such. cheers -- Dan Langille : http://www.langille.org/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
What too many people fail to realize is that in a commercial environment many companies want another company to point the finger at in case of disaster. Sybase failed, or HP failed, or IBM failed, or Microsoft failed. They feel they can do something about that. If they lose a few million they have someone they can go after, who are they going to go after if PostgreSQL fails them? Marc? Bruce? This is when you start to shout that RedHat offers commercial support, licencing, etc. INCLUDING a free, non-restrictive source licence to the core components of RHDB. -- Rod Taylor [EMAIL PROTECTED] PGP Key: http://www.rbt.ca/rbtpub.asc signature.asc Description: This is a digitally signed message part
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
On 5 Dec 2002, Robert Treat wrote: On Thu, 2002-12-05 at 03:28, Dave Page wrote: www is a closed group consisting of a few of us who actually do the work on the sites. This is one of the primary reasons the sites are so fractured. We have 4 different mailing lists for website development (and I'm not counting advocacy as one of those) and the folks maintaining those lists seem to be against letting anyone into their fiefdoms. Well we told you a few times which list you were supposed to subscribe to but over and over again you didn't. I just finished approving your subscription to the list we've been telling you to join. Vince. -- Fast, inexpensive internet service 56k and beyond! http://www.pop4.net/ http://www.meanstreamradio.com http://www.unknown-artists.com Internet radio: It's not file sharing, it's just radio. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
On Fri, 6 Dec 2002, Josh Berkus wrote: Dave, BTW, we do coordinate with the Website development group When did that happen then? I think I must have blinked :-) Marc and Justin are periodically keeping the Advocacy group informed of progress on wwwdevel, and we were asked to test it before. Vince asked us for suggestions, too. I did what? When? Vince. -- Fast, inexpensive internet service 56k and beyond! http://www.pop4.net/ http://www.meanstreamradio.com http://www.unknown-artists.com Internet radio: It's not file sharing, it's just radio. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
