Re: [HACKERS] [PATCHES] ALTER SEQUENCE

2003-03-04 Thread Rod Taylor
On Mon, 2003-03-03 at 20:47, Christopher Kings-Lynne wrote: Hey, with this new ALTER SEQUENCE patch, how about this for an idea: I submitted a patch to always generate non-colliding index and sequence names. Seemed like an excellent idea. However, 7.3 dumps tables like this: CREATE TABLE

[HACKERS] Best setup for RAM drive

2003-03-04 Thread Chris Sutton
Hello, I need some insight on the best way to use a RAM drive in a Postgresql installation. Here is our situation and current setup: Postgresql 7.2.1 Dual PIII 800 RAID 5 SCSI disks Platypus 8GB PCI QikDrive (the RAM drive). http://www.platypus.net The Platypus RAM drive is a PCI card with

[HACKERS] Problem with foreign keys (performance and deadlocks)

2003-03-04 Thread Brian Walker
I posted this message to psql-bugs in December but I have not heard if this has been fixed or not. This is holding up our development and testing of our product using Linux and PostgreSQL. Thanks ** ORIGINAL MESSAGE *** Sorry for this being so long but I want to

Re: [HACKERS] XML ouput for psql

2003-03-04 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The XML standard does not call for any table format. But a number of table formats have been established within the XML framework. Some of them are formatting-oriented (e.g., the HTML model, or CALS which is used in DocBook) and some of them

[HACKERS] Updateable views...

2003-03-04 Thread Eric D Nielsen
Let me preface this by expressing my appreciation for all the hard work for the people who develop, maintain, and support PostGreSQL. I've been using it for a little over two years for a variety of projects and have been extremely happy with both the software and the support on these lists.

Re: [HACKERS] XML ouput for psql

2003-03-04 Thread Alan Gutierrez
* [EMAIL PROTECTED] [EMAIL PROTECTED] [2003-03-04 14:21]: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The XML standard does not call for any table format. But a number of table formats have been established within the XML framework. Some of them are formatting-oriented (e.g., the

[HACKERS] Error codes revisited

2003-03-04 Thread greg
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 As promised, I've been looking over the error handling (especially the archived discussions) and it's a real rat's nest. :) I'm not sure where we should start, but just getting some error codes enabled and out there would be a great start. The

Re: [HACKERS] Best setup for RAM drive

2003-03-04 Thread Hannu Krosing
Chris Sutton kirjutas T, 04.03.2003 kell 17:03: Hello, I need some insight on the best way to use a RAM drive in a Postgresql installation. Here is our situation and current setup: Postgresql 7.2.1 Dual PIII 800 RAID 5 SCSI disks Platypus 8GB PCI QikDrive (the RAM drive).

Re: [HACKERS] Best setup for RAM drive

2003-03-04 Thread Gavin Sherry
On Tue, 4 Mar 2003, Chris Sutton wrote: Hello, I need some insight on the best way to use a RAM drive in a Postgresql installation. Here is our situation and current setup: Postgresql 7.2.1 First suggestion: upgrade to 7.2.4 to address several bugs. The concern of course is if

[HACKERS] test to be ignored ...

2003-03-04 Thread Marc G. Fournier
---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])