Re: [HACKERS] Do we really want to migrate plproxy and citext into PG core distribution?

2008-07-24 Thread Josh Tolley
On Thu, Jul 24, 2008 at 2:37 PM, Tom Lane <[EMAIL PROTECTED]> wrote: > Hannu Krosing <[EMAIL PROTECTED]> writes: >> And it would be nice, if some well-maintained sample language (pl/sh or >> even pl/dummy) which serves as a sample of latest ways to make use of >> pl/function support in core pg code

Re: [HACKERS] Problem returning strings with pgsql 8.3.x

2008-05-13 Thread Josh Tolley
On Tue, May 13, 2008 at 8:19 AM, Josh Tolley <[EMAIL PROTECTED]> wrote: > On Tue, May 13, 2008 at 8:01 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > > > On Mon, May 12, 2008 at 11:23:17PM -0600,

Re: [HACKERS] Problem returning strings with pgsql 8.3.x

2008-05-13 Thread Josh Tolley
On Tue, May 13, 2008 at 8:01 AM, Tom Lane <[EMAIL PROTECTED]> wrote: > Martijn van Oosterhout <[EMAIL PROTECTED]> writes: > > On Mon, May 12, 2008 at 11:23:17PM -0600, Josh Tolley wrote: > >> SPI_push(); > >> retval = > >> InputFunct

[HACKERS] Problem returning strings with pgsql 8.3.x

2008-05-12 Thread Josh Tolley
Having posted this to -general [1] per -hackers list instructions [2] to try elsewhere first, and waited (not very long, I admit) in vain for a response, I'm posting this to -hackers now. My apologies if my impatience in that regard annoys. While developing PL/LOLCODE, I've found something wrong w

Re: [HACKERS] relations diagram of tables in the catalog system

2007-10-23 Thread Josh Tolley
On 10/23/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > i am new in this, and i need help with catalog system of postgresql, i need > know > how are the relationship between the tables of the system catalog, and how > work > each table, if anybody know about this please, answer me. > >

Re: [HACKERS] A Silly Idea for Vertically-Oriented Databases

2007-09-07 Thread Josh Tolley
On 9/7/07, Avery Payne <[EMAIL PROTECTED]> wrote: > > Avery, > > > > >If someone writes the rest of the code, I doubt the syntax will be the > >holdup. But writing an efficient C-store table mechanism is much harder > >than I think you think it is; Vertica worked on it for a year and failed, > >a

Re: [HACKERS] Per-function search_path => per-function GUC settings

2007-09-01 Thread Josh Tolley
On 9/1/07, Tom Lane <[EMAIL PROTECTED]> wrote: > Jeff Davis <[EMAIL PROTECTED]> writes: > > Can we also provide syntax which would be equivalent to setting "var" > > for the function to be whatever the current value happens to be when the > > ALTER FUNCTION is run? Possible syntax might be somethin

Re: [HACKERS] how to "pg_dump", based in select command

2007-07-03 Thread Josh Tolley
On 7/3/07, Jeferson Kasper <[EMAIL PROTECTED]> wrote: Hello folks. I want to know how to dump some parts of a database? I need to extract the records in a "select * from table" and the pg_dump or other tool will create a file with the records found in this "select command", and after this, i will

[HACKERS] \d omits schema on inherited tables (Was: EXPLAIN omits schema?)

2007-06-13 Thread Josh Tolley
On 6/13/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Josh Tolley" <[EMAIL PROTECTED]> writes: > On a different sideline based on the original note of this thread, > much as EXPLAIN doesn't include the schema, \d doesn't include the > schema to describe IN

Re: [HACKERS] EXPLAIN omits schema?

2007-06-13 Thread Josh Tolley
On 6/13/07, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: Magnus Hagander wrote: > On Wed, Jun 13, 2007 at 02:02:24PM +0100, Heikki Linnakangas wrote: >> DB2 has the concept of "explain tables". Explain output is written to >> tables, which tools query and pretty print the output. I like that ide

Re: [HACKERS] Fate of pgsnmpd

2007-04-07 Thread Josh Tolley
who's working on the MySQL implementation. I'll drop them a line, and cc pgsnmpd-devel. Thanks. - Josh Tolley ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Fate of pgsnmpd

2007-04-07 Thread Josh Tolley
ming at RFC 1697 compliance first. Since the RFC's MIB is designed to apply to *any* database, it doesn't cover lots of the specific statistics a pgsql person would likely want to see, so after the RFC work is done we'll be adding a pgsql-specific MIB.. - Josh Tolley