Bruno Wolff III wrote:
> On Fri, Sep 19, 2003 at 18:44:24 -0400,
> Mike Mascari <[EMAIL PROTECTED]> wrote:
>
>>In keeping with being off topic, how do people feel about Verisign
>>wild-carding the .com and .net domain names so any miskeys
>>(www.someunregistereddomain.com) resolve to sitefinder.
On Fri, 19 Sep 2003, Tom Lane wrote:
> I think we could definitely adopt a policy of "on-disk changes not
> oftener than every X releases" if we had a working pg_upgrade, even
> without doing any extra work to allow updates. People who didn't want
> to wait for the next incompatible release cou
On Fri, 19 Sep 2003 20:06:39 -0400, Tom Lane <[EMAIL PROTECTED]>
wrote:
>Perhaps you should go back and study what
>pg_upgrade actually did.
Thanks for the friendly invitation. I did that.
> It needed only minimal assumptions about the
>format of either old or new catalogs. The reason is tha
On Fri, 19 Sep 2003 18:51:00 -0400, Tom Lane <[EMAIL PROTECTED]>
wrote:
>transfer the schema into the new installation using "pg_dump -s" and
>then push the user tables and indexes physically into place.
I'm more in favour of in-place upgrade. This might seem risky, but I
think we can expect user
On Fri, 19 Sep 2003 17:38:13 -0400, Tom Lane <[EMAIL PROTECTED]>
wrote:
>> A working pg_upgrade is *not* the first thing we need.
>
>Yes it is.
At the risk of being called a stubborn hairsplitter, I continue to say
that pg_upgrade is not the *first* thing we need. Maybe the second
...
> As you
Johnson, Shaunn wrote:
> howdy:
>
> okay, then i'm doing something silly. :(
>
> what i did the first time was to copy
> data from a text file. basically, i did this:
>
> \copy t_table from 'file.txt' using delimiters '|'
>
> and that was taking too long. i got the bright
> idea to use a per
Johnson, Shaunn wrote:
> howdy - thanks for the reply -
>
> i must be so far out of it, then - i
> have a sinble 1.2Ghz proc with a table
> that has about half a million rows.
>
> no indexes, triggers or anything useful.
Hmm.
> not sure about how to send this; i don't have multiple
> schemas cr
=?ISO-8859-1?Q?Josu=E9_Maldonado?= <[EMAIL PROTECTED]> writes:
> I have a trigger that loop for each column in a table, is there a way to
> identify a dropped column from within a PLTCL trigger?
As of CVS tip, pltcl is fixed to ignore dropped columns, I believe.
regards,
On Fri, 2003-09-19 at 15:32, Johnson, Shaunn wrote:
[snip]
> * Johnson, Shaunn ([EMAIL PROTECTED]) wrote:
> > --i had tried to use 'copy', but it was taking
> > --so long ... it took over a weekend to load
> > --about the same amount of records as using 'insert' (i have
> > --been running this pro
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> hmmm ... k, is it feasible to go a release or two at a time without on
> disk changes? if so, pg_upgrade might not be as difficult to maintain,
> since, unless someone an figure out a way of doing it, 'on disk change
> releases' could still require
Richard Welty <[EMAIL PROTECTED]> writes:
> http://www.averillpark.net/space/booster.html
> I would suggest that if Tom wanted to use the rocket analogy, he might want
> to compare PostgreSQL to maybe a contemporary Atlas 5 medium configuration.
> the Titan II is quite old now and there's only o
On Fri, 19 Sep 2003, Edwin Quijada wrote:
>
> Where can I find that file .pgpass??
> Can I create ?
> How ate the entry in this file???
Not for <7.3:
touch ~/.pgpass
chmod 0600 ~/.pgpass
echo '*:*:*:username:password' > ~/.pgpass
Note that this presumes you are logged in as the user who will b
On Thu, 2003-09-18 at 23:25, Tom Lane wrote:
> expect <[EMAIL PROTECTED]> writes:
[snip]
> Get a life (or at least a spam-blocker).
Even with spam blockers, the spam/virus still must be downloaded
from the server, and if the person is on dial-up, that can be *most*
painful:
In the 24 hour period
Title: RE: [GENERAL] anyone use Ora2Pg?
--howdy - thanks for the reply -
--i must be so far out of it, then - i
--have a sinble 1.2Ghz proc with a table
--that has about half a million rows.
On an old dual pentium 400Mhz intel box with 40MBs SCSI and 7200 RPM
drives I loaded > million row
[I'm not convinced this is a -hackers issue so have cross posted to -general in
the expectation followups will go there]
I also didn't feel there was much I could cut from the earlier posts without
losing relevent info, so I didn't. Sorry.
On Fri, 19 Sep 2003, chakkara rangarajan wrote:
> Chris
* Johnson, Shaunn ([EMAIL PROTECTED]) wrote:
> --how did you use copy to move data?
I set up the Ora2Pg object using the appropriate settings, dumped all
the tables out to a file and then did psql < file. 2 million or so rows
across a bunch of tables, didn't take too long.
Stephen
pgp0
Hi all.
This is off topic and is a cross-post, so I'll be
brief. There is a very nasty virus out there and I urge everybody to get their
AV in order. The virus is known as: "W32.Gibe-F"
or "W32.Swen-A".
Yesterday, I got cca. 200 viral
messages.
Today, it's about 800 viral messages!
I
Title: RE: [GENERAL] anyone use Ora2Pg?
--howdy:
--okay, then i'm doing something silly. :(
--what i did the first time was to copy
--data from a text file. basically, i did this:
\copy t_table from 'file.txt' using delimiters '|'
--and that was taking too long. i got the bright
--id
* Johnson, Shaunn ([EMAIL PROTECTED]) wrote:
> --i had tried to use 'copy', but it was taking
> --so long ... it took over a weekend to load
> --about the same amount of records as using 'insert' (i have
> --been running this program for over 2 days and only
> --have 2800 records to show out of 1
On Fri, 19 Sep 2003 10:10:17 +0100, Rory Campbell-Lange
<[EMAIL PROTECTED]> wrote:
>The sent
>column shows the number of items sent to each recipient from each
>source. The received column [...] is summing the number of messages
> by recipient [and] need to be filtered by source too.
SELECT t_to A
Title: RE: [GENERAL] anyone use Ora2Pg?
--howdy - thanks for the reply ...
--i had tried to use 'copy', but it was taking
--so long ... it took over a weekend to load
--about the same amount of records as using 'insert' (i have
--been running this program for over 2 days and only
--have 28
El Jue 18 Sep 2003 20:34, scott.marlowe escribió:
>
> they still claim to have ACID compliance, an issue I've discussed with a
> few of the folks from MySQL AB. To them, the C in ACID only implies fk
> constraints. The fact that they ignore base type constraints (i.e. insert
> 8 billion into an i
Oliver Elphick wrote:
>>Foreign Key constraints: $1 FOREIGN KEY (pid) REFERENCES products(id) ON
>>UPDATE NO ACTION ON DELETE NO ACTION
>
> Drop the constraint; then add an amended one.
Ok, how do I drop the constraint, it has no name.
The documentation is rather poor on how to get the name of
Am Do, 2003-09-18 um 20.21 schrieb Darko Prenosil:
- Original Message -
From: "Daniel Schuchardt" <[EMAIL PROTECTED]>
To: "Doug McNaught" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, September 18, 2003 4:44 PM
Subject: Re: [GENERAL] psql and blob
> Yes thats it.
>
> Ok
Steve Manes <[EMAIL PROTECTED]> writes:
...
> The problem is making sure that overworked developers actually log all these
> changes.
>
> What would be better is a DDL 'diff' utility that would look at a master and
> target database and generate the necessary ALTER statements needed to make the
> On Friday 19 September 2003 09:00, [EMAIL PROTECTED] wrote:
>> I'm finding that column defaults are not being assigned to nulls when
>> I do an insert by way of a an ON INSERT rule on a view. For example,
>> the following script
> [snip]
>
> Hmm - well, you're explicitly telling it to insert VAL
postgres 7.3.2
I store unicode-data in postgresql. The data is retrieved via webinterfaces,
processed with perl and then stored in postgresql (and viceversa).
All is going nice with one problem. If performing a "select * order by
field"-query the result is not what I expected.
German umlauts (i
My company offers an ASP service for advertising companies using PG.
For contractual reasons, each client gets its own replicated database.
This presents a problem whenever a new feature/fix requires a DDL change
which must be rolled out across N databases. Currently, we keep track of
these cha
Is postgresql have an axisting solution for distibuting the databse
amoungst several servers, so that each one holds a subset of the data
and queries are passed to each one and then collated by a master server?
I have heard erServer mentioned but i got the impression this might
just be for bac
Hi all,
As announced previously I am currently working with other people on the
translation of PostrgreSQL to French, applications and manuals. We have
stumbled on a couple of concepts which are not very clear to us and
thus do not know very well how to translate. Can someone explain the
follo
On Fri, 2003-09-19 at 11:09, Jean-Christian Imbeault wrote:
> Currently I have a table defined as such:
>
> TAL=# \d internal_keywords
> Table "public.internal_keywords"
> Column | Type | Modifiers
> -+-+---
> keyword | text| not null
> pid | integer | not
Currently I have a table defined as such:
TAL=# \d internal_keywords
Table "public.internal_keywords"
Column | Type | Modifiers
-+-+---
keyword | text| not null
pid | integer | not null
Indexes: internal_keywords_pkey primary key btree (keyword, pid)
Foreign
Look at this:
http://www.zend.com/images/survey/14.gif
I belive that there is only one reason why most of people are using
MySQL - it has native, very easy to install version for windows.
---(end of broadcast)---
TIP 3: if posting/reading throug
On 19/09/2003 07:35 Deepa K wrote:
Hi all,
I want to take backup of our online system on daily basis using
crontab. But actually the pg_hba.conf is configured with password
security.
How I can take the backup without setting password. Or is their any
other
way to take backup.
You could su t
On Fri, 2003-09-19 at 02:06, Gregory S. Williamson wrote:
> "Oracle = Saturn IV." ?!???
>
> Perhaps they claim to be. More like a shuttle with pretensions.
> Oracle was utterly unable to support our web site. And then
I'm surprised. There are many huge Oracle databases out there.
> they wanted
On Thu, 2003-09-18 at 16:29, Andrew Sullivan wrote:
> On Sat, Sep 13, 2003 at 10:52:45AM -0500, Ron Johnson wrote:
>
> > So instead of 1TB of 15K fiber channel disks (and the requisite
> > controllers, shelves, RAID overhead, etc), we'd need *two* TB of
> > 15K fiber channel disks (and the requis
On Fri, 2003-09-19 at 00:30, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > ... Being honest and fair will win
> > hearts and minds, and when they need the Saturn 4 instead of the Estes
> > rocket, they'll remember who to come to.
>
> I like this analogy, though maybe you've ov
On Friday 19 September 2003 09:00, [EMAIL PROTECTED] wrote:
> I'm finding that column defaults are not being assigned to nulls when I
> do an insert by way of a an ON INSERT rule on a view. For example, the
> following script
[snip]
> CREATE RULE test_table_ri AS ON INSERT TO test_table_v DO INSTEA
On Friday 19 September 2003 07:35, Deepa K wrote:
> Hi all,
> I want to take backup of our online system on daily basis using
> crontab. But actually the pg_hba.conf is configured with password
> security.
> How I can take the backup without setting password. Or is their any
> other
> way t
I'm having troube doing a left outer self join on a table. The sent
column shows the number of items sent to each recipient from each
source. The received column (generated by the outer join) is incorrect
because although it is summing the number of messages by recipient,
these need to be filtered
I'm finding that column defaults are not being assigned to nulls when I
do an insert by way of a an ON INSERT rule on a view. For example, the
following script
\set ON_ERROR_STOP ON
\c template1
--DROP DATABASE testdb;
CREATE DATABASE testdb;
\c testdb
create table test_table (
field1 char(1) no
On Thu, 18 Sep 2003, Andrew L. Gould wrote:
> On Thursday 18 September 2003 04:45 pm, Scott Holmes wrote:
> > Andrew L. Gould wrote:
> > > On Thursday 18 September 2003 04:04 pm, Sean Chittenden wrote:
> > >>> I think the below just about says it all:
> > >>>
> > >>>http://www.commandprompt.com/i
On Thu, 18 Sep 2003, Joshua D. Drake wrote:
> Hello,
>
>I think the below just about says it all:
>
> http://www.commandprompt.com/images/mammoth_versus_dolphin_500.jpg
Cool !
>
> Sincerely,
>
> Joshua Drake
>
>
>
Regards,
Oleg
___
Christopher Browne wrote:
In the last exciting episode, [EMAIL PROTECTED] (David Link) wrote:
Why does adding SUM and GROUP BY destroy performance?
When you use SUM (or other aggregates), there are no short cuts to
walking through each and every tuple specified by the WHERE clause.
Er... not in
"Oracle = Saturn IV." ?!???
Perhaps they claim to be. More like a shuttle with pretensions. Oracle was utterly
unable to support our web site. And then they wanted a truely preposterous sum for
their wretched software.
Informix, on the other hand, has performed like, well, like a Saturn [which
45 matches
Mail list logo
