Re: [GENERAL] Alter view with psql command line

functions. > > > > In 9.6: > > > > That's why in 9.1 I didn't find that command... You can use the 9.6 client without problems on 9.1, well, apart from the fact that 9.1 is already past its end of life. Best, David. -- David Fetter <david(at)fetter(dot)org> http://f

Re: [GENERAL] Pg Tcl - is it dying out?

might have been asking about that you forgot to include in this email? If so, what was it? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com

Re: MODERATOR WARNING Re: [GENERAL] Exception Handling in C-Language Functions?

) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Álvaro Herrerahttp://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [GENERAL] Moving from Java 1.5 to Java 1.6

mydb.dump Hope this helps. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

[GENERAL] Test, please ignore.

$subject! -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [GENERAL] Chaining inserts ... This would be cool

difference is the number of round trips to the database. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [GENERAL] exclusive OR possible within a where clause?

Factoring in NULLable columns, that's: (x IS NOT DISTINCT FROM y) (a IS NOT DISTINCT FROM b) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [GENERAL] live metadata changes v8.3.4

those users offline and not doing the change. V8.3.4 on linux. Upgrade to 8.3.16 immediately, if not sooner. Oh, and start planning the 9.1 migration, too. December of 2012 is closer than you think. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

Re: [GENERAL] [Solved] Generic logging system for pre-hstore using plperl triggers

tuples are done very lightly (one or two in the same sentence at a time). So, for a case as such, rules end up beeing more expensive than triggers (right?). There's an even better reason not to use rules: they're going away in a not too distant version of PostgreSQL. Cheers, David. -- David Fetter

Re: [GENERAL] [pgadmin-support] Help for Migration

difference: they can't control transactions. Any stored procedures that have a COMMIT or ROLLBACK in them will have to be re-architected in a fundamental way. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [GENERAL] Help needed with PostgreSQL clustering/switching from MySQL

which arise as a result of email transmission. If verification is required please request a hard copy version. In future, please to elide these disclaimers. The serve no legal or practical purpose, but they do give people they annoy a convenient excuse not to reply. Cheers, David. -- David Fetter

Re: [GENERAL] unnest with generate_subscripts and same array

the testing I've done it's worked, but I don't know if I was just lucky :) That would be more of the SQL standard UNNEST, with the WITH ORDINALITY clause. We don't have it yet :/ Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [GENERAL] [HACKERS] PostgreSQL Core Team

Europe. Regards, Dave. -- Dave Page PostgreSQL Core Team http://www.postgresql.org/ -- Sent via pgsql-hackers mailing list (pgsql-hack...@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- David Fetter da...@fetter.org http

Re: [GENERAL] How to realize ROW_NUMBER() in 8.3?

. While you will of course need to do tests with your applications, 9.0 has no significant backward-incompatibility with 8.3. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [GENERAL] postgres conferences missing videos?

on the shoulders of the conference organizers, who are already working hard just to pull off the live show. never said that it's not so just that i'm surprised/disappointed that it's so low priority. Who proposes, volunteers! How are you going to help? Cheers, David. -- David Fetter da...@fetter.org http

Re: [GENERAL] postgres conferences missing videos?

On Mon, Mar 21, 2011 at 11:55:20PM +0100, Aljoša Mohorović wrote: On Mon, Mar 21, 2011 at 9:45 PM, David Fetter da...@fetter.org wrote: Who proposes, volunteers!  How are you going to help? being on a different continent and unable to attend doesn't actually enable me to do something

Re: [GENERAL] Table inheritance foreign key problem

, David (hoping PostgreSQL will be able to infer how to automate this some day). -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [GENERAL] What is the name pseudo column

, i.e. the one that casts to name, on the entire row from your accounts table. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical

Re: [GENERAL] What is the name pseudo column

On Wed, Dec 15, 2010 at 03:43:45PM -0800, Adrian Klaver wrote: On Wednesday 15 December 2010 1:27:19 pm David Fetter wrote: On Wed, Dec 15, 2010 at 01:50:54PM -0600, Jack Christensen wrote: I was just surprised when accidentally selecting a non-existent name column there was no error

Re: [GENERAL] Pgadmin for Fedora 14?

are 9.0, 8.4, 8.3, etc., not 9 and 8 :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote

Re: Fwd: [GENERAL] [pgsql-www] Forums at postgresql.com.au

over the internet, guaranteed to be picked up by spiders, make sure you have a good anti-spam. If you imagine that not signing up for a mailing list in any way alleviates this need, I have a bridge to sell you. It connects Manhattan with Brooklyn. Cheers, David. -- David Fetter da

Re: [GENERAL] Alter table to on update cascade

whether you can do this. You can do it like this: BEGIN; ALTER TABLE foo DROP CONSTRAINT your_constraint; ALTER TABLE foo ADD FOREIGN KEY ...; COMMIT; Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [GENERAL] Re: Storing old and new tuple values after an UPDATE, INSERT or DELETE

gig. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres

Re: [GENERAL] Re: Storing old and new tuple values after an UPDATE, INSERT or DELETE

. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres

Re: [GENERAL] good settings for DB parameters such as shared_buffers, checkpoint_segment in Postrgesql 9

(no 2PC) or the bounded from below by max_connections. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [GENERAL] PostgreSQL 8.2.3

for PostgreSQL upgrades, or failing that, find something to do with your life, because processes like that are a bright red warning sign of the kind of dysfunction that tanks organizations, no matter how big or important they are. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [GENERAL] what can depend on index

On Tue, Oct 26, 2010 at 10:13:04AM +0200, Szymon Guz wrote: Hi, today I noticed that in the documentation there is DROP INDEX CASCADE. I've got one question: what is that for? What can depend on index? A foreign key can, if the index is unique. Cheers, David. -- David Fetter da

Re: [GENERAL] Problem with initdb: creates database which do not exists

there. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [GENERAL] NoSQL -vs- SQL

thanking everyone for their questions. To make this work requires that it be rather carefully done; sadly, sufficient care doesn't seem to have been taken :-(. Maybe they stored it in MySQL ;) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [GENERAL] Postgres won't start after setting ssl=on

On Sun, Oct 10, 2010 at 12:08:13AM -0700, Mike Christensen wrote: While I do appreciate the vote of confidence, rest assured you will never see a post from me that starts with So I've been hacking the pg code and... Actually, we get *plenty* of those. Cheers, David. -- David Fetter da

Re: [GENERAL] What was new in 8.4 8.3?

/wiki/Version_History Haven't updated that yet to include anything but the one big 9.0 article you were referring to so far. Should we have a 9.1 one? There's already been at least one large, new feature, namely INSTEAD OF triggers. Cheers, David. -- David Fetter da...@fetter.org http

Re: [GENERAL] Implicit CAST is not working in Postgresql 8.4

in workarounds, as they don't actually fix the bugs you've found. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

[GENERAL] Commitfest: The Good, The Bad, and the Ugly

step 5 is not doable, let me know. If you think it is, this is your chance to help make it happen. Write back either way. Cheers, David. [1] If you do have them, help out with step 6, too. [2] If you are one, help out with step 6, too. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [GENERAL] How to dump only the the data without schema?

. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http://www.postgresql.org

Re: [GENERAL] Exclusion constraint issue

? All of them? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating

Re: [GENERAL] Exclusion constraint issue

On Sun, Sep 26, 2010 at 10:15:00AM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Fri, Sep 24, 2010 at 05:22:15PM -0400, Tom Lane wrote: period() might be immutable, but those casts from date to timestamptz are not, because they depend on the TimeZone parameter. How

Re: [GENERAL] value

/cGm617Cp [etc.] Does anybody have any idea what is going on? Yes. You're using RULEs where TRIGGERs would do. Change to TRIGGERs. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [GENERAL] workaround steps for autovaccum problem

On Wed, Sep 15, 2010 at 02:39:26AM +0530, tamanna madaan wrote: Hi All I am using postgres-8.1.2. I am getting the following error while autovacuum. Please upgrade your software to PostgreSQL 8.1.21 and try again. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [GENERAL] workaround steps for autovaccum problem

On Wed, Sep 15, 2010 at 05:30:51AM +0530, tamanna madaan wrote: I know upgrading postgres will resolve the problem permanently . But I wanted some workaround for now before I actually upgrade. I want a pony, but I'm not getting one. Upgrade PostgreSQL :) Cheers, David. -- David Fetter da

Re: [GENERAL] Post Install / Secure PostgreSQL

installed, try: su - postgres psql -l Happy PostgreSQLing :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people

Re: [GENERAL] Frustration with \copy

Should I just INSERT? Nope. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

Re: [GENERAL] regexp on null

Oracle properties, but it needs to stay confined there. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [GENERAL] error while autovacuuming

. Your idea is silly. Change the binary, restart, and have done. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [GENERAL] error while autovacuuming

On Fri, Sep 10, 2010 at 02:35:29AM +0530, tamanna madaan wrote: Hi David You mean to say , change the binary to postgres-8.1.21 and then restart postgres . that's it ?? please confirm.. Yes. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [GENERAL] Table update problem works on MySQL but not Postgres

://www.postgresql.org/docs/current/static/sql-update.html Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [GENERAL] Restore referencial integrity

; COMMIT; Hope this helps :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

Re: [GENERAL] Restore referencial integrity

accessed in item 1 run an index scan on posicoes to check if the key is in the table posicoes 3) If the parent found is not found on posicoes then remove the row from posicoes_controles Am I thinking correctly? I believe so. Cheers, David (whose pt_BR is pretty w34k) -- David Fetter da

Re: [GENERAL] select from pipe-delimited field

function. http://www.postgresql.org/docs/current/static/functions-matching.html#FUNCTIONS-LIKE Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal

Re: [GENERAL] deadlock

more like a down time event. Maybe when we have real partitioning... Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people

Re: [GENERAL] Using AND in query

. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [GENERAL] Using AND in query

On Sun, Aug 08, 2010 at 12:33:40PM -0700, David Fetter wrote: On Sun, Aug 08, 2010 at 01:55:19AM -0700, John R Pierce wrote: The condition and table.item = 'laptop' and table.item = 'Desktop' says: I want all rows where the column item has the value 'Laptop' and *at the same time

Re: [GENERAL] Using AND in query

(ARRAY['Laptop','Desktop']) = array_sort(array_agg(item)); Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [GENERAL] Could you teach me, How can we specify password when using psql....

.. Overall, it's better to use a .pgpass (pgpass.conf on Windows) http://www.postgresql.org/docs/current/static/libpq-pgpass.html It's also possible, but not recommended, to set an environment variable. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [GENERAL] Postgresql database procedures?

it from some arbitrary point is just barely more helpful than not specifying one, i.e. not terribly. Perhaps asking a few more questions would be. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [GENERAL] Nodes and trees...

*/ UNION SELECT e.head FROM edges e JOIN descendants d ON (e.tail = d.head) ) SELECT * FROM descendants; You might want to index edges.tail and edges.head. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [GENERAL] order in which rules are executed

order? They're executed in alphabetical order, to the extent that that is deterministic, which is not very, and that's not even the wackiest thing about them. If you have any alternative of any nature, do NOT use rules. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1

Re: [GENERAL] sql dump

! Scott -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [GENERAL] cache lookup failed for function 19119

the upgrade to 9.0 right now. You will likely need to clean up some client code in order for that to work, as modern versions of PostgreSQL don't allow some of the sloppy and dangerous things (casting automatically to and from text, e.g.) that former versions did. Cheers, David. -- David Fetter da

Re: [GENERAL] Need help doing a CSV import

any speed benefit of bulk COPY. You can do your transformations and hand the stream off to the COPY interface. See the pg_putcopydata() section of the DBD::Pg manual for examples. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [GENERAL] Planner features, discussion

WITH, as are some others. See this thread for the latest: http://archives.postgresql.org/pgsql-hackers/2010-07/msg00463.php Cheers, David (who's not mentioning extending WITH to include DCL or DDL yet...oops! ;) -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666

Re: [GENERAL] [pgsql-advocacy] Anyone in Madison?

to mention that Josh is going to the one in Wisconsin. Cheers, David -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [GENERAL] Find users that have ALL categories

; to get only exact matches. As to speed, you'd have to test on your actual data sets. Indexing user_id may help here. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

Re: [GENERAL] Find users that have ALL categories

On Thu, Jul 01, 2010 at 12:37:55PM +0100, Sam Mason wrote: On Thu, Jul 01, 2010 at 04:26:38AM -0700, David Fetter wrote: On Wed, Jun 30, 2010 at 12:11:35AM -0700, Nick wrote: Is this the most efficient way to write this query? Id like to get a list of users that have the categories 1, 2

Re: [GENERAL] DBI::Oracle problems

-Link using the Download Source link at http://github.com/davidfetter/DBI-Link There is also a low-traffic mailing list for the project, where questions like this are more on point :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql

as well optimised as Postgres. Having it divided off at the place where it's divided in MySQL is certainly such a barrier. Having a storage API, as PostgreSQL used to have, and will have again with SQL/MED, doesn't necessarily present such a barrier. Cheers, David. -- David Fetter da

Re: [GENERAL] Converting a Simple Database from MySQL to PostgreSQL in 40 hours?

over are the first two steps in a much longer process, wherein all the apps use the database as an active database rather than a passive one, the latter being all MySQL really allows. Hope this helps :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [GENERAL] A thought about other open source projects

-mentioned strong-arm tactics--making a wide selection of non-proprietary RDBMSs--has succeeded. Just pick an RDBMS and max out its capabilities. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP

Re: [GENERAL] A thought about other open source projects

db but won't take advantage of db-specific features. As with phrases like, the quickest way to grill a unicorn steak, that it can be stated in a few words does not make in possible. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [GENERAL] A thought about other open source projects

they want to write. Or what sort of performance requirements are tied to that app. It's not performance requirements that tend to tank such projects, but the amount of maintenance involved. Extending the app gets quadratically painful. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org

Re: [GENERAL] High Availability with Postgres

are your priorities for both? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

Re: [GENERAL] A thought about other open source projects

code is reasonable. I'd take a hard look at the trade-offs first. Database agnostic code sounds like a reasonable idea until you've had to maintain such code for a few years. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [GENERAL] use window as field name in 8.4

pg_dump on the running 8.3 database, and your problem will be fixed :) Cheers, David (oh, and pg_dump -Fc will let pg_restore, an enormously powerful utility, do its magic). -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype

Re: [GENERAL] Move data from DB2 to Postgres any software/solutions/approach?

/lapug -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [GENERAL] Is it possible to make the order of output the same as the order of input parameters?

)) SELECT i, a[i] FROM s CROSS JOIN t; $$; You can then use that set-returning function in your query. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal

Re: [GENERAL] server-side extension in c++

, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [GENERAL] Is it possible to make the order of output the same as the order of input parameters?

On Wed, Jun 02, 2010 at 03:33:16PM +0100, Sam Mason wrote: On Wed, Jun 02, 2010 at 06:28:14AM -0700, David Fetter wrote: On Tue, Jun 01, 2010 at 06:16:06PM -0400, m. hvostinski wrote: I have a simple query like: SELECT * FROM customer WHERE id IN (23, 56, 2, 12, 10) The problem

Re: [GENERAL] Is it possible to make the order of output the same as the order of input parameters?

. The array-based approaches are there pretty much for convenience, i.e. for not having to input the numbers more than once, as they could easily get mistyped if you need to repeat them. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo

Re: [GENERAL] server-side extension in c++

On Wed, Jun 02, 2010 at 05:41:10PM +0100, Mark Cave-Ayland wrote: David Fetter wrote: Is PostGIS following these guidelines? In short, no. Due to various problems in the early days with C++ exceptions generated by the GEOS library causing problems in C (and also ABI changes forcing

Re: [GENERAL] server-side extension in c++

. These two paragraphs, suitably changed to be more like the rest of the docs, would be a great start for people interested in using C++. Would some short bits of sample code help? Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

On Sat, May 29, 2010 at 08:21:46PM -0700, Richard Broersma wrote: On Sat, May 29, 2010 at 6:25 PM, David Fetter da...@fetter.org wrote: I wondering if write-able CTE's will be the silver bullet that will make rule based update-able views based multiple vertically partitioned table robust

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

become a mechanism for doing what you describe, but I suspect there would be significant work involved in harnessing them to that task. They'll be pretty nice even without the automated view stuff, though :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

Re: [GENERAL] Write-able CTEs, Update-able views, Hierarchical data, and optimistic locking

On Sat, May 29, 2010 at 09:38:30PM -0400, Bruce Momjian wrote: David Fetter wrote: On Sat, May 29, 2010 at 01:29:50PM -0700, Richard Broersma wrote: This might be a premature question considering write-able CTEs are not in core, but... I wondering if write-able CTE's

Re: [GENERAL] Moving from Mysql

://www.postgresql.org/docs/current/static/client-authentication.html Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Re: [GENERAL] Alter column position

the SELECT * case doesn't interest me too much, it would be part of the infrastructure needed for PostgreSQL to optimize storage by placing all fixed-length columns before any variable-length ones. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM

Re: [GENERAL] [HACKERS] Retiring from the PostgreSQL core team

serious hacking. I hope to see many of you in Ottawa. You can run, but you can't hide ;) Thanks for your deep and broad contributions so far, and I'm sure I speak for many when I say we're looking forward to upcoming ones. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone

Re: [GENERAL] Pulling data from a constraint def

On Thu, May 13, 2010 at 12:33:08AM -0400, Tom Lane wrote: Josh Kupershmidt schmi...@gmail.com writes: On Wed, May 12, 2010 at 12:58 AM, David Fetter da...@fetter.org wrote: If you've measured a performance issue for a table that tiny, it's a bug that needs fixing in PostgreSQL. �What

Re: [GENERAL] Pulling data from a constraint def

On Thu, May 13, 2010 at 08:08:31PM -0400, Tom Lane wrote: David Fetter da...@fetter.org writes: On Thu, May 13, 2010 at 12:33:08AM -0400, Tom Lane wrote: I'm surprised no one has yet suggested an ENUM type. I didn't suggest it because I didn't know about it, but because I've found ENUM

Re: [GENERAL] Inheritance efficiency

be made, please feel free to do so after 9.0 comes out. In the mean time, please test 9.0beta1 along with any ensuing betas and release candidates, and report back the results of the aforementioned testing. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778

Re: [GENERAL] Inheritance efficiency

. Proprietary forks exist, but they don't fix this kind of problem. :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [GENERAL] partitioned lookup table?

primary key (i); NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index foo_2_pkey for table foo_2 ALTER TABLE Kinda. http://people.planetpostgresql.org/dfetter/index.php?/archives/51-Partitioning-Is-Such-Sweet-Sorrow.html Cheers, David. -- David Fetter da...@fetter.org http

Re: [GENERAL] autoscale cluster

how the trick is accomplished, you still have this goal, you'll know how. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people

Re: [GENERAL] best practice in archiving CDR data

. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [GENERAL] text search in 8.1

of this year, to 9.0. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider

Re: [GENERAL] GROUP BY column alias?

assume in many spots, and we need to make them stop including this idea. The only standard actually worth citing today is SQL:2008, and the day the next one comes out, we need to change all our references to cite it. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415

Re: [GENERAL] Possible to set postgres in case insensitive mode ?

9.0 ? How is that going to be offered ? When it's ready! :) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74

Re: [GENERAL] postgres external table

, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics Remember to vote! Consider donating to Postgres: http

Re: [GENERAL] FOSDEM dinner

On Thu, Jan 14, 2010 at 09:51:34AM +0200, Dave Coventry wrote: Yes, I'm in South Africa, which might make it problematic! You're on the right land mass, assuming you count being able to cross the Suez canal on foot ;) Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1

Re: [GENERAL] replication from multiple master servers to a single read-only slave

to be sync'd). Would it be possible to use PostgreSQL PITR feature to support this functionality ? No, but you could use something like Slony to do this. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter

Re: [GENERAL] How psql source code can be protected?

to avoid. The appropriate place to protect your IP is in legal agreements. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com iCal: webcal://www.tripit.com/feed/ical

Re: [GENERAL] set-level update fails with unique constraint violation

the whole UPDATE would have succeeded if it had completed. The DEFERRED uniqueness constraints in 8.5alpha3 fix this problem. Cheers, David. -- David Fetter da...@fetter.org http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fet...@gmail.com

  1   2   3   4   5   6   >