Re: [DOCS]
On Monday, November 10, 2003, at 01:16 AM, Peter Eisentraut wrote: I don't mind including graphics, but there needs to be a maintenance path. SVG might be something to try. You could even create a simpler catalog description file in an ad-hoc XML format and then create the SVG automatically. InDesign does have an SVG export option. I haven't done anything with it, and it's something I'll look into. By the way, when done well, pictures like the catalog layout, the backend flow chart, or a graphical representation of a query plan also make nice posters. Now there's a thought. The docs might be pretty much taken care of, but when's your next presentation? :) On Monday, November 10, 2003, at 06:08 AM, Josh Berkus wrote: OpenOffice.org draw is easy to use & understand and generates both PDF and XML. Not terribly sophisticated, but OSS and widely cross platform. If you want a better drawing tool, try KDE's Kontour. I think Elein would be happy to host it on General Bits while we work on re-inventing Techdocs. Thanks for the offer. I'll let you know once I've updated the diagram to match what's in 7.4. On Monday, November 10, 2003, at 11:53 AM, Bruce Momjian wrote: My performance tuning PDF has a system table chart written using xfig so it has almost infinite resolution: http://candle.pha.pa.us/main/writings/pgsql/performance.pdf It is the second to last slide. Thanks, Josh and Bruce, for alternative apps. I'll take a look! Michael grzm myrealbox com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [DOCS]
Guys, > > By the way, when done well, pictures like the catalog layout, the > > backend > > flow chart, or a graphical representation of a query plan also make > > nice > > posters. > > Now there's a thought. The docs might be pretty much taken care of, but > when's your next presentation? :) That's a *great* idea. I smell PostgreSQL benefit merchandise here. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your friend
Re: [DOCS]
Michael Glaesemann writes: > > By the way, when done well, pictures like the catalog layout, the > > backend > > flow chart, or a graphical representation of a query plan also make > > nice > > posters. > > Now there's a thought. The docs might be pretty much taken care of, but > when's your next presentation? :) I already have posters like that. I'm just saying, keep that application in mind when you make new pictures. -- Peter Eisentraut [EMAIL PROTECTED] ---(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: [DOCS] Runtime Basics
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours to HEAD and 7.4.X. --- Josh Berkus wrote: > Peter, > > > Please send a context diff (diff -c). > > Attached. > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco [ Attachment, skipping... ] > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [DOCS] Runtime Basics
Bruce, > Your patch has been added to the PostgreSQL unapplied patches list at: > > http://momjian.postgresql.org/cgi-bin/pgpatches > > I will try to apply it within the next 48 hours to HEAD and 7.4.X. Please kill this patch. Peter pointed out a number of SGML mistakes and contextual problems which I don't have time to fix. -- -Josh Berkus __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [DOCS] Runtime Basics
Josh Berkus wrote: > Bruce, > > > Your patch has been added to the PostgreSQL unapplied patches list at: > > > > http://momjian.postgresql.org/cgi-bin/pgpatches > > > > I will try to apply it within the next 48 hours to HEAD and 7.4.X. > > Please kill this patch. Peter pointed out a number of SGML mistakes and > contextual problems which I don't have time to fix. I was wondering if this was the same patch, and I was sure you would tell me if it was --- withdrawn. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [DOCS] Runtime Basics
Patch withdrawn by author. --- Josh Berkus wrote: > Peter, > > > Please send a context diff (diff -c). > > Attached. > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco [ Attachment, skipping... ] > > ---(end of broadcast)--- > TIP 6: Have you searched our list archives? > >http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [DOCS] Runtime Basics
Bruce, > I was wondering if this was the same patch, and I was sure you would > tell me if it was --- withdrawn. Yeah, sorry. I thought that it wouldn't be considered "submitted" until I sent it to pgsql-patches. -- Josh Berkus Aglio Database Solutions San Francisco ---(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: [DOCS] Runtime Basics
Bruce Momjian <[EMAIL PROTECTED]> writes: > Your patch has been added to the PostgreSQL unapplied patches list at: Wasn't this patch withdrawn? regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [DOCS] Runtime Basics
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Your patch has been added to the PostgreSQL unapplied patches list at: > > Wasn't this patch withdrawn? Yep, removed from queue. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [DOCS] Annotated release notes
OK, release notes updated to:
Allow polymorphic PL/pgSQL functions (Tom, Joe)
Allow polymorphic SQL functions (Joe)
Allow functions to accept arbitrary data types for input, and return arbitrary
types.
---
Joe Conway wrote:
> Bruce Momjian wrote:
> > http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-7-4
> >
> > I need people to check this and help me with the items marked 'bjm'. I
> > am confused about the proper text for those sections.
>
> > Allow polymorphic SQL functions (Joe)
> > bjm ??
>
> What isn't clear about this? Should/can we refer to related sections of
> the manual?
> http://developer.postgresql.org/docs/postgres/xfunc-sql.html#AEN28722
> http://developer.postgresql.org/docs/postgres/extend-type-system.html#EXTEND-TYPES-POLYMORPHIC
>
> > Allow user defined aggregates to use polymorphic functions (Joe)
> > bjm ??
>
> Same question. From this url:
> http://developer.postgresql.org/docs/postgres/xaggr.html
> see this paragraph:
>
> Aggregate functions may use polymorphic state transition functions or
> final functions, so that the same functions can be used to implement
> multiple aggregates. See Section 33.2.1 for an explanation of
> polymorphic functions. Going a step further, the aggregate function
> itself may be specified with a polymorphic base type and state type,
> allowing a single aggregate definition to serve for multiple input data
> types. Here is an example of a polymorphic aggregate:
>
> CREATE AGGREGATE array_accum (
> sfunc = array_append,
> basetype = anyelement,
> stype = anyarray,
> initcond = '{}'
> );
>
> Joe
>
>
> ---(end of broadcast)---
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup.| Newtown Square, Pennsylvania 19073
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
