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

[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 8G

[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 describ

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 the

[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. Recen

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

[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 pro

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). htt

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])