Re: [HACKERS] [pgsql-hackers] Patent issues and 8.1

know, I'm getting a little sick of the chicken little act among many of the -hackers --Josh -- __Aglio Database Solutions___ Josh BerkusConsultant josh@agliodbs.comwww.agliodbs.com Ph: 415-752-2500Fax: 415-752-2387 2166 Hayes Suite 200San

Re: [HACKERS] [pgsql-hackers] Allow GRANT/REVOKE permissions to be applied to all schema

, the second sets permissions on existing tables, and this: GRANT SELECT ON ALL, NEW TABLES IN public TO phpuser; ... does both. Of course, this assumes that tables named new or all are not possible ... are those reserved? -- --Josh Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] [pgsql-hackers] Patent issues and 8.1

stuff to the list instead of the To: line you see on the screen. Dammit! Any other Linux-friendly mail GUIs that have list management features and don't have this problem? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] [pgsql-hackers] Patent issues and 8.1

Andrew, On Thu, Jan 27, 2005 at 10:39:52AM -0800, Josh Berkus wrote: Thanks. As you know, I'm getting a little sick of the chicken little act among many of the -hackers I think this is a little bit of a mischaracterisation. Afilias is already a customer of IBM. BTW, if you

Re: [HACKERS] [pgsql-hackers] Patent issues and 8.1

Marc, And to be perfectly frank, I was mostly thinking of Marc when I said that. Sorry, that was uncharitable. I meant that (at the time) you were panicking. Now you have something different to panic about. How goes the server shuffle? -- Josh Berkus Aglio Database Solutions San

Re: [HACKERS] [pgsql-hackers] Patent issues and 8.1

over to neptune :( I doubt that's intentional, why don't you ask him to truncate it? I noticed that you used to grant @postgresql.org addresses as unlimited, I changed the default to 5MB, which is what all the regional contacts now have. -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema

I create views in the first place, 95% of the time. However, I don't want to automatically grant permissions on all existing views to that user in order to get the new default. The analogue here is file permissions vs. umask for unix directories. -- --Josh Josh Berkus Aglio Database

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema

Richard, pg_find --type=table --schema=foo --name='system_*' --execute='GRANT ALL ON % TO myuser' Hey, that's a way keen idea. Regardless of what we do with GRANT/REVOKE. You don't happen to, uh, have any code for that? -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Allow GRANT/REVOKE permissions to be applied to all schema

Tom, Why is that a problem? The complaint seems about analogous to saying we should not have groups because you can't REVOKE rights from an individual user if he has them via a group membership. Oh, mostly I'm just bitching because I had seeing a new feature I can't use ;-) -- Josh Berkus

[HACKERS] Patch Count?

Marc and/or Bruce: Hey, for my information (people ask me this a lot) can one of you do a count of patch submitters for 8.0? For 7.4, it was around 180. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9

Re: [HACKERS] Patch Count?

Marc, How do you get the count? CVS names at the tail of the commit? I don't know; Marc and you did it. I'm looking for the number of *people*, not the number of patches. So part of it would come from your mailbox. --Josh -- __Aglio Database Solutions___ Josh Berkus

Re: [HACKERS] Query optimizer 8.0.1 (and 8.0)

database would allow us to set up a good test case. Does anyone have a well-indexed PG Tiger I could play with? -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [HACKERS] [pgsql-advocacy] Development Plans

- nearly all of which come from clients or interested parties. Does anybody else wish to share theirs? Well, I'll be working on Data Warehousing too. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9

Re: [HACKERS] [pgsql-hackers] Daily digest v1.4988 (21 messages)

of July. And there's a bunch of European conventions in June, for that matter. So I'd advocate either freezing in May, or in September. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe

Re: [HACKERS] Development schedule

is available, like last year. So it's your call. Better, you should maybe check with the committers when people will be available. Also, what do you think of Simon's plan for a 2-stage feature freeze? Maybe not so far apart ... maybe a month apart? -- Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Development schedule

checking, and may affect the implementation of the minor features. I'd suggest a month interval. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] SQL99 Hierarchical queries

, is the simple adjacency list structure. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] 8.0.X and the ARC patent

machines to test. I also want to run one 6-hour or 12-hour test to see if the flattening out is actually flat. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] logging as inserts

should log the inserts to a stderr and thus take advantage of all of the redirection, rotation, etc that we now support for stderr logging. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze

Re: [HACKERS] logging as inserts

I like the idea of using log_destination. It makes it clear that log_line_prefix doesn't work if log_destination 'stderr'. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your

Re: [HACKERS] logging as inserts

with literal quoting, you could do this all through log_line_prefix, as: log_line_prefix='INSERT INTO pg_log VALUES ( %u, %p, ''%t'', ''%$'')' -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget

Re: [HACKERS] logging as inserts

, do we? Incidentally, %$ doesn't tstrike me as ideal - to conform to the way the rest are done we should use an alphabetic character, not $. Sorry, I'm being perlish ;-) -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] buildfarm issues

and Template Toolkit a decided advantage. I can help with the people end of things, but my web skills suck. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] A bad plan

Gaetano, Hi all, running a 7.4.5 engine, I'm facing this bad plan: Please take this to the PGSQL-PERFORMANCE mailing list; that's what that list exists for. Or IRC, where I know your are sometimes. But not -Hackers. Thanks! -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] fool-toleranced optimizer

a user mixed up their table aliases. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Bug 1500

Karel, Yeah. Karel Zak, who wrote that code, is convinced we should remove it, but I don't think anyone else is ... I think I was Peter and Josh Berkus who convinced me that the code is bed. we should remove... is opinion only... I certainly didn't recommend removing it before we have

Re: [HACKERS] Bug 1500

Alvaro, On Sat, Mar 26, 2005 at 02:04:14PM -0800, Josh Berkus wrote: SELECT to_char( INTERVAL '43 hours 20 minutes', 'MI' ) || ' min'; 2600 min Hmm, what if you wanted more than one literal string? Say 1 mon 3 days ... your concatenation idea wouldn't work. ISTM the format string

Re: [HACKERS] Bug 1500

heavily in applications, trying to define what the useful behaviour will be from a user's perspective. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Making oidvector and int2vector variable-length

an application. So if we can make this variable-length, I'd say set the limit at 400 to avoid TOASTing, but otherwise allow users as many parameters as they want. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1

Re: [HACKERS] [PATCHES] DELETE ... USING

= table_1.key AND table_2.col3 = TRUE; ... will no fail with default settings. Either set add_missing_from to TRUE to re-enable them, or modify your application to support the correct syntax, such as the new DELETE FROM ... USING (see below). -- Josh Berkus Aglio Database

Re: [HACKERS] [PERFORM] Functionscan estimates

the current flat 1000 estimate. As I said, even the ability to set a per-function flat constant estimate would be an improvement. BTW, why is this on -performance? It should be on -hackers. 'cause I spend more time reading -performance, and I started the thread. Crossed over now. -- Josh Berkus

[HACKERS] Question regarding clock-sweep

, and incidentally, can I use the same database files for 8.0.2 and 8.1cvs 3/10/05? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Question regarding clock-sweep

Tom, Neil, Oh, and incidentally, can I use the same database files for 8.0.2 and 8.1cvs 3/10/05? Sorry, we forced initdb already several times... D'oh. Better see if I can get a second machine, then, since build of a 100G DBT3 database takes 20 hours. -- Josh Berkus Aglio Database

Re: [HACKERS] Question regarding clock-sweep

/~wew036/research/comprehensive.pdf -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Test coverage for external sorting

on a 100GB table takes about 2 hours on a v40z. And that's not becuase of I/O; disk bandwidth is less than 20% used. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] PLM pulling from CVS nightly for testing in STP

Mark, Just wanted everyone to know what we're pulling CVS HEAD nightly so it can be tested in STP now. Let me know if you have any questions. Way cool.How do I find the PLM number? How are you nameing these? -- --Josh Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Win32 presentation

and you're gold ;-) -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] TODO: read-only tables, select from indexes only.

is true. As soneone who appears to be all about data warehousing these days, let me speak in favor of this idea. And say that you're welcome to submit it to the Bizgres distribution so we can test it out -- --Josh Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks suggested?

accurate enough for planner purposes which in my experience is a range between 0.2x to 5x. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks suggested?

conservative. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(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: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks suggested?

is much less expensive than row-based random sampling. We should really be focusing on methods which are page-based. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Tablepartitioning: Will it be supported in Future?

is this mailing list ? I found nothing about it on bizgres website. Yes, it's under Developer/Projects. I need to provide more links on stuff. I'd be definitely interested! http://www.pgfoundry.org/projects/bizgres --Josh -- __Aglio Database Solutions___ Josh Berkus

Re: [HACKERS] [pgsql-advocacy] Increased company involvement

to be a lot more focused. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [PERFORM] Distinct-Sampling (Gibbons paper) for Postgres

Now, if we can come up with something better than the ARC algorithm ... Tom already did. His clock-sweep patch is already in the 8.1 source. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

pgFoundry is being worked on right now. Josh would have a better idea. We ran into a problem installing GForge. I don't know if Tom had time to work on it over the weekend; if not I'll be tackling it tonight. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [pgsql-advocacy] [HACKERS] Decision Process WAS: Increased company involvement

this, but now you do.) -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [pgsql-advocacy] [HACKERS] Decision Process WAS: Increased company involvement

County which really gotten my PC dander up. Sorry, Dave! -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [pgsql-advocacy] [HACKERS] Decision Process WAS: Increased company involvement

that if their pet feature they create is not in line with core thinking, they will have to earn the credibility to get community buy-in. Substitute major contributors for core, and you have *my* buy-in. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks suggested?

, for example, 10% of rows purely randomly would actually mean loading 50% of pages. With 20% of rows, you might as well scan the whole table. Unless, of course, we use indexes for sampling, which seems like a *really good* idea to me -- --Josh Josh Berkus Aglio Database Solutions San

Re: [HACKERS] [PERFORM] Bad n_distinct estimation; hacks suggested?

John, But doesn't an index only sample one column at a time, whereas with page-based sampling, you can sample all of the columns at once. Hmmm. Yeah, we're not currently doing that though. Another good idea ... -- --Josh Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] inclusions WAS: Increased company involvement

the add-ins you want is the job of commercial distributors and possibly OSS projects like Bizgres. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index

Re: [HACKERS] inclusions WAS: Increased company involvement

that I'm speaking for me, personally) -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] inclusions WAS: Increased company involvement

a proposal of a coherent system of what should and should not get included. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [HACKERS] inclusions WAS: Increased company involvement

it kind of funny that we include the PLs but not the server-side drivers, but that decision precedes my tenure on Core. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] inclusions WAS: Increased company involvement

at least some of the time, like libpqxx and JDBC, as opposed to drivers which are strictly client-only, like pgODBC. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] Views, views, views! (long)

         |   is_insertable   | boolean       |   is_updateable   | boolean       |   is_deleteable   | boolean       |   definition      | text          |   owner           | name          |   comment         | text          | -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Views, views, views! (long)

, and the constraints table assumes that constraint names are universally unique instead of table-unique as they are in PG. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

requirements (FORTRAN) and different licensing (R is GPL). :-( -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Views, views, views! (long)

Tim, A nice thing to add would be a more human-comprehensible view of the pg_locks table. I keep meaning to write a view for it myself, but haven't ever gotten a round tuit. Jim Nasby is working on that; see his other posts. -- Josh Berkus Aglio Database Solutions San Francisco

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

Joe, I've considered relicensing PL/R with a BSD license, but I haven't been able to decide whether I really can do that given libR's GPL status, and I'm afraid it might tick off the R core developers if I do. Seems like you could ask them. -- Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Views, views, views! (long)

. If there are things (like not dropping columns) that you want to change about the spec, fine. But if you think that nobody needs these views, it's because you haven't had much contact with end users lately. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

. Of course, if we can make improvements, that could also lead to having an all drivers tarball that would build easily, and packaging other add-ons for easy build, which would be cool. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] Views, views, views! (long)

becuase it would break the SQL spec. If that's not the case, I personally would love to not duplicate objects. But let's establish that. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

that this system could be extended to other add-ons in the future which are currently more complex builds? And allow us to out some of the wierder things in /contrib? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

wanted to discuss this on a module-by-module basis before feature freeze. Will post my notes on it in a couple weeks. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list

Re: [HACKERS] Views, views, views! (long)

after a rename. Hiding the OIDs in schema views will reduce their usability. Hmmm ... we argued about this. I was in favor of hiding the OIDs because OIDs are not consistent after a database reload and names are. I can see your point though; what do other people think? -- --Josh Josh

Re: [HACKERS] Views, views, views! (long)

what that is might be instructive before deciding how to go forward. This makes sense; I do wish that someone had mentioned it when I originally raised the subject of new system views. It would have saved us some work. --Josh -- --Josh Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Views, views, views! (long)

to fix it. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [pgsql-advocacy] [HACKERS] Increased company involvement

who might be able to help with integrated build issues; I know we're looking into them for Bizgres. Need help? Should I ask? -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our

Re: 'kitchen sink' downloads (Was: Re: [pgsql-advocacy] [HACKERS] Increased company involvement)

currently using ant for the build, and we wouldn't want to. --Josh -- __Aglio Database Solutions___ Josh BerkusConsultant josh@agliodbs.comwww.agliodbs.com Ph: 415-752-2500Fax: 415-752-2387 2166 Hayes Suite 200San Francisco, CA

Re: [HACKERS] Views, views, views! (long)

. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

[HACKERS] Major contributors wanted for magazine interview

Folks, I'd like to find 2 major code contributors to PostgreSQL to be interviewed (via e-mail) for a Brazillian online magazine. Please e-mail me privately. Thanks! -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] Views, views, views! (long)

. But we could make the effort. You volunteering? 3.  Of the fragment that does not fall under 1 and 2, it should be a carefully documented extension that lives in the same place (INFORMATION_SCHEMA) so that we know where to look to find it. -- --Josh Josh Berkus Aglio Database Solutions

Re: [HACKERS] Views, views, views! (long)

the postgresql code base. They are not *meant* to be user-friendly. That's why we need a different interface to be good for a different purpose. Which is what we're trying to do. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] pl/pgsql enabled by default

Neil, Is there a good reason that pl/pgsql is not installed in databases by default? The only one I can think of is security, which is pretty weak -- we've never had a plpgsql security issue that I know of. -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] to_char(interval) issues

Bruce, * Prevent to_char() on interval from returning meaningless values * Allow to_char() on interval values to accumulate the highest unit   requested Sounds like it would cover my use cases. Others? -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] pl/pgsql enabled by default

People: Before we get into more minutia regarding potential security risk of plpgsql, are there any reasons *other* than security to not enable it? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you

Re: [HACKERS] pgFoundry

? With the addition of several companies to our community, it's a possibility, and would make the trouble of using a bug tracker worthwhile, I think. Comments? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5

Re: [HACKERS] Can we get patents?

, it was somewhere around $6000 per patent. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] pl/pgsql enabled by default

to select * from table. -- Josh Berkus Aglio Database Solutions San Francisco ---(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: [HACKERS] Oracle Style packages on postgres

, are they only per-session, or global? If they are global, how do you accomplish this? 3) For that matter, is initialization per session or global? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all

Re: [HACKERS] Inline PL/pgSQL

be much more significant if plpgsql were automatically available on the command line. As such, you'd need to make building it in to the SQL command line a compile-time option so that security-conscious admins could disable it if they want to. -- Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Oracle Style packages on postgres

of the other PLs support that feature today. Also initialization, namespacing, and security. The ability to package bunches of functions, and only allow their calling in the context of a package, is quite valuable in installations which support 1,000's of procedures. -- --Josh Josh Berkus Aglio

Re: [HACKERS] Oracle Style packages on postgres

which can only be called internally to the package 2. variables which are only visible inside the package 3. functions which can only be called as part of the package (thus utilizing the initialization and internal variables) and not on their own. -- --Josh Josh Berkus Aglio

Re: [HACKERS] Oracle Style packages on postgres

I'm trying to help define. I think that private variables and private functions need to be part of the definition. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] Oracle Style packages on postgres

NOT be available to the user or modifiable by them. I know the need for this is probably hypothetical to a lot of -hackers, but it's pretty common programming in the Oracle PL/SQL world. Of course, if there's something in SQL2003 that supports this, it would be really keen to know it ... -- --Josh Josh

Re: [HACKERS] Oracle Style packages on postgres

approach. I, personally, would buy that. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL

Re: [HACKERS] Views, views, views! (long)

in various ways, and those ways are not fixable in a backwards-compatible fashion. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Views, views, views! (long)

it to objects on which you have rights (which our views do as well) vs. restricting it to objects you *own*, which is what the information_schema does, according to Andrew. Yes? More in next e-mail. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] Views, views, views: Summary of Arguments

argument against (3) is that we should use information_schema. Andrew, can you do a more cohesive set of points on the 2nd half of that question? That is, how much SQL spec would we have to break (other than extension) to cover all of the stuff that pg_sysviews currently covers? -- Josh Berkus

Re: [HACKERS] Views, views, views! (long)

. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] Views, views, views: Summary of Arguments

on the -NOVICE and -GENERAL lists and IRC and the people who don't yet use PostgreSQL. Please stop thinking exclusively in terms of whether they would be useful to you, personally. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] Server instrumentation for 8.1

decent tools To support Andrew's assertion, automated server room administration tools (like Hyperic and Embarcadero) could really use the above tools. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

[HACKERS] New Contrib Build?

* more user friendly to me, and easier on the package builders. What's the technical obstacle to it? Also, I think that /contrib modules should have documentation included in the main docs, probably as an appendix. -- --Josh Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] New Contrib Build?

). It would save, me, personally a bunch o' time and troubleshooting, since I regularly install 5-6 different contrib modules. No, not as an appendix, please. Again, that gives the wrong impression. Let's add another main section on optional modules. OK by me. -- --Josh Josh Berkus Aglio Database

Re: [HACKERS] New Contrib Build?

Peter, I don't see how this makes it any more user friendly or easier on package builders.  Is your aim to make building contrib more accessible or building only specific contrib modules more accessible? Building specific contrib modules. -- --Josh Josh Berkus Aglio Database Solutions San

Re: [HACKERS] New Contrib Build?

issues. Anyway, that's a bit incoherent, but do people see what I mean with this? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] New Contrib Build?

Andrew,     * Move some things from /contrib into main tree     * Move some /contrib modules out to their own project sites A contrib shuffle is on my personal TODO list. Look for a list in a couple weeks. -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Server instrumentation for 8.1

the server tools because you, personally, use them. You're against including the new system views because you, personally, won't use them. Do I misunderstand you, or are you failing to put things in a broader context? -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Views, views, views: Summary of Arguments

person to give us any useful feedback on the actual design ... -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

<    1   2   3   4   5   6   7   8   9   10   >