Re: [HACKERS] Negative LIMIT and OFFSET?

2007-12-15 Thread Simon Riggs
On Fri, 2007-12-14 at 18:42 -0500, Tom Lane wrote: Simon Riggs [EMAIL PROTECTED] writes: How do people feel about applying this to 8.3, rather than holding it? One possible objection is that we're past string freeze, but I noted Peter doing some message editorializing as recently as today, so

Re: [HACKERS] VLDB Features

2007-12-15 Thread Simon Riggs
On Fri, 2007-12-14 at 18:22 -0500, Tom Lane wrote: Neil Conway [EMAIL PROTECTED] writes: By modifying COPY: COPY IGNORE ERRORS or some such would instruct COPY to drop (and log) rows that contain malformed data. That is, rows with too many or too few columns, rows that result in constraint

Re: [HACKERS] EXPLAIN ANALYZE printing logical and hardware I/O per-node

2007-12-15 Thread Gregory Stark
Gokulakannan Somasundaram [EMAIL PROTECTED] writes: Hi, I already made a discussion about it. We can view the Logical I/Os. If we enable the log_statement_stats in the conf file and apply the following patch, it is possible. But putting it in Explain analyze makes more sense to me. I

Re: [HACKERS] Negative LIMIT and OFFSET?

2007-12-15 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: On Dec 14, 2007 6:42 PM, Tom Lane [EMAIL PROTECTED] wrote: How do people feel about applying this to 8.3, rather than holding it? I think it would have been better to apply before beta. We would have found out if

Re: [HACKERS] WORM and Read Only Tables (v0.1)

2007-12-15 Thread Albert Cervera i Areny
Read-Only Tables Postgres supports the concept of freezing tuples, so they can live forever within the database without needing further writes. Currently there is no command that will guarantee that a table has been completely frozen. This makes it difficult to reliably

Re: [HACKERS] EXPLAIN ANALYZE printing logical and hardware I/O per-node

2007-12-15 Thread Gokulakannan Somasundaram
I was going to say that I'm really only interested in physical I/O. Logical I/O which is satisfied by the kernel cache is only marginally interesting and buffer fetches from Postgres's shared buffer is entirely uninteresting from the point of view of trying to figure out what is slowing down

Re: [HACKERS] pgwin32_open returning EINVAL

2007-12-15 Thread Magnus Hagander
Alvaro Herrera wrote: Magnus Hagander wrote: On Thu, Dec 13, 2007 at 09:55:33AM -0300, Alvaro Herrera wrote: Many of these are nonsensical -- we know this is not a device, nor network access. Still there is more than one possibility, and I don't know which ones should be really acceptable in

Re: [HACKERS] pgwin32_open returning EINVAL

2007-12-15 Thread Andrew Dunstan
Magnus Hagander wrote: Alvaro Herrera wrote: Magnus Hagander wrote: On Thu, Dec 13, 2007 at 09:55:33AM -0300, Alvaro Herrera wrote: Many of these are nonsensical -- we know this is not a device, nor network access. Still there is more than one possibility, and I don't know

[HACKERS] idea for 8.4. using partitioning for temporary tables?

2007-12-15 Thread Pavel Stehule
Hello I am thinking about global temporary tables. Current problem is frequent modification some system tables pg_class, pg_attribute and others. We need merge metadata for real tables and for temporary tables. Currently we use metadata of temp tables like metadata of normal tables with known

Re: [HACKERS] EXPLAIN ANALYZE printing logical and hardware I/O per-node

2007-12-15 Thread Heikki Linnakangas
Gokulakannan Somasundaram wrote: I was going to say that I'm really only interested in physical I/O. Logical I/O which is satisfied by the kernel cache is only marginally interesting and buffer fetches from Postgres's shared buffer is entirely uninteresting from the point of view of trying to

Re: [HACKERS] pgwin32_open returning EINVAL

2007-12-15 Thread Gregory Stark
Andrew Dunstan [EMAIL PROTECTED] writes: Magnus Hagander wrote: Alvaro Herrera wrote: Magnus Hagander wrote: Note that their behavior on finding SHARING_VIOLATION or LOCK_VIOLATION is to retry forever until the error goes away, on the theory that the antivirus/backup software will

[HACKERS] stored procedures to webservices

2007-12-15 Thread ivo nascimento
Hi everybody, I' m work on a software to create automatic webservices for stored procedure in any language. It's almost like the explain above: have one table pg_plwebservice Have one sp hello, develope in any languages like sql, plpgsql(trusted or untrusted)like for example. The DBA

Re: [HACKERS] pgwin32_open returning EINVAL

2007-12-15 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: Andrew Dunstan [EMAIL PROTECTED] writes: Interesting. Maybe forever is going a bit too far, but retrying for n seconds or so. I think looping forever is the right thing. Having a fixed timeout just means Postgres will break sometimes instead of all the

Re: [HACKERS] stored procedures to webservices

2007-12-15 Thread Josh Berkus
Hey, Ivo, I' m work on a software to create automatic webservices for stored procedure in any language. Seems like the new XML and XLST support should fit in here somewhere. -- Josh Berkus PostgreSQL @ Sun San Francisco ---(end of

Re: [HACKERS] stored procedures to webservices

2007-12-15 Thread ivo nascimento
Hello Josh, the XML and XLST are data presentation only? the idea is provide some like one Http request where I can post data for a Stored procedure and receive one Http response using WSDL description and SOAP transport to implement the web service. Where can I find more info about this new

Re: [HACKERS] VLDB Features

2007-12-15 Thread Neil Conway
On Tue, 2007-12-11 at 19:11 -0500, Greg Smith wrote: I'm curious what you feel is missing that pgloader doesn't fill that requirement: http://pgfoundry.org/projects/pgloader/ For complicated ETL, I agree that using an external tool makes the most sense. But I think there is still merit in

Re: [HACKERS] VLDB Features

2007-12-15 Thread Pavel Stehule
On 16/12/2007, Neil Conway [EMAIL PROTECTED] wrote: On Tue, 2007-12-11 at 19:11 -0500, Greg Smith wrote: I'm curious what you feel is missing that pgloader doesn't fill that requirement: http://pgfoundry.org/projects/pgloader/ For complicated ETL, I agree that using an external tool makes

Re: [HACKERS] psql's describe command (for sequences) output improvement

2007-12-15 Thread Bruce Momjian
Aftab Hussain wrote: In general, \d command is working perfectly for database objects. For sequences, I think the current \d some_sequence command's output is displaying information which does not help the end user very much. Also isn't the newly display information (same as information