Re: [GENERAL] To Postgres or not

options, as you've mentioned. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] faking writable views as tables

storage file, which simply doesn't exist on views ? Are my changes to pg_class dangerous in any way ? Yes. The current way to do writeable VIEWs is through the RULE system, not with TRIGGERs :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415

Re: [GENERAL] Viewing non-system objects in psql

the system operators, etc. +1 :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] return next and pl/perl

that spi_return_next may not be implemented? Is this correct? If so, is there a workaround? For 8.0, not exactly, although you can batch the entire rowset into an array ref of hash references, then return that. In the forthcoming 8.1 (CVS TIP), there is a return_next() method. Cheers, D -- David

Re: [GENERAL] which commands under PostgreSQL do the similar func provided by show processlist under mysql

for something like SELECT * FROM pg_stat_activity; Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 7: don't forget to increase your free space

Re: [GENERAL] PostgreSQL vs. InnoDB performance

/tpc-w-php/ As you might imagine, it's hard to argue when the customer sees these kinds of numbers. So I'd take any FUD I can send back at them. :) HTH :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote

Re: [GENERAL] Just a crazy idea!

On Thu, May 26, 2005 at 05:04:37PM -0400, Hrishikesh Deshmukh wrote: Is it possible to connect a DB in Postgresql to a DB in MySQL! I know its a crazy idea! It's called DBI-Link. http://pgfoundry.org/projects/dbi-link/ Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1

Re: [GENERAL] Changing column data type on an existing table

, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [GENERAL] Trigger that spawns forked process

tables with the result of the XSLT, which table(s) Slony replicates to the other servers. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 4

Re: [GENERAL] PostGreSQL - SQL server

-link/ Should you need to change that data and hand it back in PostgreSQL form, you will be able to do it easily. Is there someplace we can find out how SPAWAR or the Navy in general is using PostgreSQL for non-classified projects? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org

Re: [GENERAL] Array manipulation/syntax question

put it this way... how do I do this: -- my_array is an INT[] _my_array := select some_column from some_table; ... in plpgsql? DECLARE foo INTEGER[]; BEGIN SELECT INTO foo ARRAY(SELECT some_int_col FROM some_tab); /* Your Stuff Goes Here */ END; HTH :) Cheers, D -- David

Re: [GENERAL] Immutable attributes?

examples are ID or creation time.) Currently, I use triggers: You could use RULEs instead, but the effect would be similar. PostgreSQL 7.4, switching to 8.0 would be difficult. Now is easier than later. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100

Re: [GENERAL] What are the consequences of a bad database design

://pgfoundry.org/projects/dbi-link/ I think that you should try to move the system to your own way of thinking and doing things and leave them the alternatives. Sooner or later they will use your system as it is better. That, or you'll get sacked. :/ Cheers, D -- David Fetter [EMAIL PROTECTED

Re: [GENERAL] Lost in Foreign Key land

on the file_fk_ref table. * ON DELETE, decrement the counter for the file_id in the file_fk_ref table. HTH :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast

Re: [GENERAL] sequence advances on failed insert

, but there is no attempt to make this a gap-free sequence, and your apps should not depend on the actual value of said ID. HTH :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast

Re: [GENERAL] sequence advances on failed insert

On Thu, Apr 07, 2005 at 11:27:41PM -0400, Sven Willenberger wrote: David Fetter presumably uttered the following on 04/07/05 20:16: On Thu, Apr 07, 2005 at 07:59:52PM -0400, Matthew Terenzio wrote: I'm noticing that a sequence is advancing even if the insertion fails. Is this weird

Re: [GENERAL] PL/PERL: raise notice, exception ?

On Tue, Apr 05, 2005 at 04:28:10PM +0200, Philippe Lang wrote: Hi, Is there in PL/PERL, under PG 8.01, an equivalent for the raise notice, exception commands of PL/PGSQL? Use the elog() function. :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100

Re: [GENERAL] Statistics with PostgreSQL

be a big help. Hrishi, For statistics beyond avg() and stddev(), check out PL/R http://www.joeconway.com/plr/ Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast

Re: [GENERAL] Reading from Mysql writting in PGsql

tools in contrib: my2pg.pl and mysql2pgsql, and of course you can use the database-independent access in your favorite scripting language (DBI.pm in perl, for example) to attach to both databases, then stream from one to the other. HTH :) Cheers, D -- David Fetter [EMAIL PROTECTED] http

Re: [GENERAL] insert data from an microsoft excel

/ Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining

Re: [GENERAL] insert data from an microsoft excel

On Wed, Feb 16, 2005 at 08:05:55AM -0700, Ed L. wrote: On Wednesday February 16 2005 7:48, David Fetter wrote: On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote: Is there is way to load data from as Microsoft excel into database tables in postgresql7.4.x Once you've

Re: [GENERAL] Functions with more than 32 parameters

unwind that. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your

Re: [GENERAL] Understanding EXPLAIN ANALYZE output

files need to change to effect this? Or have I drastically misunderstood what's involved? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast

Re: [GENERAL] Understanding EXPLAIN ANALYZE output

On Thu, Feb 10, 2005 at 05:19:41PM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: I'd be delighted to, but I'm not sure how to see to it that EXPLAIN gets the CMD_SELECT flag. What all files need to change to effect this? Or have I drastically misunderstood what's involved

Re: [GENERAL] Understanding EXPLAIN ANALYZE output

codes... This sounds *really* bad. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [GENERAL] Understanding EXPLAIN ANALYZE output

) be? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [GENERAL] security

well does the security solution mitigate those risks? 4. What other risks does the security solution cause? 5. What costs and tradeoffs does the security solution impose? Until you have answered questions 1 and 2, you can't even start on an implementation. Cheers, D -- David Fetter [EMAIL

Re: [GENERAL] mysql load_file() function

(or whatever the latest is when you get this message ;) 3. Apache 1.3.26 Thanks in advance, Ben-Nes Yonatan HTH :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast

Re: [GENERAL] Questions about functionality

this in advance, but it's PostgreSQL or Postgres or PG. Postgre raises hackles the way 'Frisco does for people who live in the City By The Bay. Sorry if my questions are kind of newbie. We are all n00b at some level. Welcome to the community :) Cheers, D -- David Fetter [EMAIL PROTECTED] http

Re: [GENERAL] Is there a peer-to-peer server solution with PG?

of replicating to a slave database, then letting you decide to promote it to master, which is just what you'd need. Why are you asking about multi-master? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote

Re: [GENERAL] Is there a peer-to-peer server solution with PG?

and pay /mucho dinero/. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [GENERAL] more information for SRF function

WITH CONTEXT; This would be really great. As I understand it, in the current implementation, by the time a RULE kicks in, the WHERE clause is unavailable. Could it be made available? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778

Re: [GENERAL] convert mdb files to pg?

and to your PostgreSQL one. Loop through SELECT on the mdb and do INSERTs on PostgreSQL. 2. DBI-Link, which is probably overkill for this. http://pgfoundry.org/projects/dbi-link/ Of course, there are other ways, but those are the two that came to mind :) Cheers, D -- David Fetter [EMAIL PROTECTED

Re: [GENERAL] convert mdb files to pg?

On Thu, Jan 27, 2005 at 02:50:11PM -0500, Stephen Frost wrote: * David Fetter ([EMAIL PROTECTED]) wrote: On Thu, Jan 27, 2005 at 02:14:32PM -0500, Rick Schumeyer wrote: Is there a way to import mdb files from Access into pg? I found a web page for mdbtools but I can't get

Re: [GENERAL] Oracle and PostgreSQL

production databases. The best benchmark, of course, is your application. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 6: Have you searched

Re: [GENERAL] pg SQL question

it with builtins. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [GENERAL] high unicode chars

in the 8.0 dev cycle... D'oh! How big is the fix? 8.0.x, or 8.1? Meanwhile, how to fix the problem? I'm ok with hacking dump files if need be. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote

Re: [GENERAL] serial increments on failed insert

) which are guaranteed to be unique. Because they have this uniqueness property, they are *not* guaranteed to be gapless. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast

Re: [GENERAL] int4 - unix timestamp - sql timestamp; abstime?

'; /* ^^ */ to conform with the *n*x standard. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 5: Have you checked

Re: [GENERAL] int4 - unix timestamp - sql timestamp; abstime?

On Tue, Jan 11, 2005 at 07:44:46PM -0500, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: The recommended locution is SELECT TIMESTAMP WITH TIME ZONE 'epoch' + x * INTERVAL '1 second'; I think this should read: SELECT TIMESTAMP WITH TIME ZONE 'epoch' AT TIME ZONE 'UTC' + x

Re: [GENERAL] [ANNOUNCE] PostgreSQL 8.0.0 Release Candidate 4

for the 15th (or earlier). As always, this release is available on all mirrors, as listed at: http://wwwmaster.postgresql.org/download/mirrors-ftp For those using Bittorrent, David Fetter hasn't had a chance to update the .torrents, but should be available later today from: http

Re: [GENERAL] Problem creating trigger-function with arguments (8.0rc4)

arguments? I stubbed my toe on this in re: dbi-link, and would like to be able to write a trigger with arguments :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast

Re: [GENERAL] Function Parameters

application, re-doing all of it if needed, because if you go down the road of having a hand-hacked PostgreSQL, you severely limit the community's ability to help you when you encounter a problem. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415

Re: [GENERAL] Problem with pl/perl in postgresql 8.0rc1

/perl(u) creation should Do The Right Thing. This will be fixed in the next (S)RPMs :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 5

Re: [GENERAL] What's faster

that will be built and disk pages used (cached or otherwise), which mechanism would be faster for searching. It's a lot easier to search under option 2, and besides, speed isn't everything ;) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235

Re: [GENERAL] [ANNOUNCE] PostgreSQL 8.0.0 Release Candidate 1

her regression tests, and report any/all problems, and bugs, to [EMAIL PROTECTED] Once more, on behalf of all of the developers, Happy Bug Hunting ... It's also on http://bt.postgresql.org/ :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893

Re: [GENERAL] regular expression searches

PL/PGSQL to accomplish this using mapping tables for the different components. Perhaps PL/Perl or PL/Python would be more appropriate for this. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote

DDL triggers [was Re: [GENERAL] database constraints]

it be to have generalized DDL triggers? Apart from resource allocation, what are some downsides of providing such a facility? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end

Re: [GENERAL] database constraints

foo ( a INT REFERENCES bar(id), b INT REFERENCES baz(id), CHECK((a IS NULL AND b IS NOT NULL) OR (a IS NOT NULL AND b IS NULL)) ); Is it even reasonable? What's reasonable? ;) BTW, id is a terrible name for a column. Better call it foo_id. Cheers, D -- David Fetter [EMAIL

Re: [GENERAL] database constraints

other self-documentation, is a big plus. Cheers, D P.S. As a rule, SELECT * doesn't belong in production code./nit -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast

Re: [GENERAL] database constraints

tries to name an object any of the SQL keywords. Other possible rules: * Every table must have a comment * noCamelCaps * downcase all entities * underbar_separators_required * abbrev_w_beg, nt_by_rmvng_vwls * Your favorite algorithmic coding standard here What do y'all think? Cheers, D -- David

Re: [GENERAL] Spacing in output

On Tue, Sep 14, 2004 at 06:37:40PM -1000, Jerome Lyles wrote: On Tuesday 14 September 2004 11:27 am, David Fetter wrote: On Tue, Sep 14, 2004 at 11:05:46AM -1000, Jerome Lyles wrote: I have a small training database: sql_tutorial. It works fine but the spacing between the output lines

Re: [GENERAL] division by zero issue

(user_tasks.task_id) 0 I know it's a little weird to have WHERE for non-aggregate and HAVING for aggregates, but that's the SQL standard... Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end

Re: [GENERAL] Spacing in output

of broadcast)--- TIP 8: explain analyze is your friend -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [GENERAL] The future of built-in geometric data types

, are there other barriers to adoption? Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

Re: [GENERAL] [HACKERS] Coming soon: PG 7.4.4, 7.3.7, 7.2.5

On Wed, Aug 11, 2004 at 09:57:58PM -0400, Tom Lane wrote: David Fetter [EMAIL PROTECTED] writes: I'm thinking I should only put the latest, greatest on the bt server, but if others think otherwise, I'd be happy to put up more. The 8.0 beta and the latest stable (7.4.3, soon 7.4.4) would

Re: [GENERAL] Equivalent to DBMS_JOB

. What issues are those? Please be specific. Cheers, David. -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778 The laissez-faire argument relies on the same tacit appeal to perfection as does communism

Re: [GENERAL] Graphical Mapping a Database

format ? PDF, GIF, JPG, etc. Try DBVisualizer at http://www.minq.se/. HTH :) Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100cell: +1 415 235 3778 Everyone who lives, dies. Not everyone who dies has ever lived. ---(end

<    1   2   3   4   5   6