task?
That's turning the RDBMS into the job scheduler.
Take a look at http://pgfoundry.org/projects/pgjob/
I did.
Latest File Releases
Package Version DateNotes / Monitor Download
This Project Has Not Released Any Files
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common
of system
RAM, you *still* have to write the data back to the disk, and that
takes time.) But that's only if you've got a small db that needs
*really* high tps rates.
I'd rather spend my money on enough system RAM to keep the active
portion of my DB in the OS cache.
- --
Ron Johnson, Jr.
Jefferson LA
so as I know next time. :)
Unix is chock full of streaming text manipulation tools. In this
case, awk, Perl or Python would work well.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks
:
Ron Johnson wrote:
On 10/26/06 01:20, Chris wrote:
Coder At Heart wrote:
Hi!
[snip]
So,
- What OS?
- What version of PG?
- what kind of disk system does the DB live on?
- How many controllers?
- What kind of tape drive?
- Is it on it's own SCSI controller?
in addition
THEN
UPDATE
END-IF.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong.
-BEGIN PGP SIGNATURE
On 10/27/06 05:10, Gurjeet Singh wrote:
On 10/27/06, Ron Johnson [EMAIL PROTECTED] wrote:
That doesn't help at all during multi-table transactions
What problem do you think you would face in multi-table scenario? I tried
the following and it worked for me; hope this is what you meant
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/27/06 06:48, Gurjeet Singh wrote:
On 10/27/06, Ron Johnson [EMAIL PROTECTED] wrote:
Dueling examples. Attached are two examples of errors.
I think you completely missed that I am recommending using '\set
ON_ERROR_ROLLBACK on' in psql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/27/06 08:41, Alexander Staubo wrote:
On Oct 27, 2006, at 14:56 , Ron Johnson wrote:
I think you completely missed that I am recommending using '\set
ON_ERROR_ROLLBACK on' in psql.
Please refer to my previous post and see the effect
kind of disk system does the DB live on?
- - How many controllers?
- - What kind of tape drive?
- - Is it on it's own SCSI controller?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks
, ok, the other RDBMSs that *I* have worked with)
don't do that, and there's a lot of code written in the form:
INSERT INTO ...
IF PK-ERROR THEN
UPDATE
END-IF.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists
insight as to weather it's fact or FUD?
It is 100% FUD.
What would be the incentive for OpenCRX spreading FUD about PostgreSQL?
Does anyone know?
That implies malice. The people at OpenCRX apparently really
believe what they wrote.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really
site license, why add extra complexity?
Adding postgresql into that mix is a hard sell. Enterprise software
that can support both postgresql and oracle backends is a much
easier sell (even into those places that end up using postgresql).
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 07/06/06 23:02, Joshua D. Drake wrote:
On Thursday 06 July 2006 19:55, Ron Johnson wrote:
Being an HP/Compaq shop, I'm looking at an Opteron-and-SATA-based
DL145 G2 and an MSA20 SATA enclosure with a U320 interface to use
with RHES4
process without
| letting it relay the signal to its subprocesses, so it will be
| necessary to kill the individual subprocesses by hand as well.
`
But it can't be fatal, can it? After all, that's what a system
crash is, right?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really
and 8.2 significant? Is 8.2 more about
speed or new features?
8.2 is not released yet. Can you risk your app on beta software?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks
need to ask an attorney.
Remember that the law is all about interpretation.
Exactly. The Linus View is that dynamic linking and socket
conversations are *not* linking in the GPL2 meaning, but the FSF
RMS think differently. The GPL3 seems to codify that strictness.
- --
Ron Johnson, Jr
is a meta-
package, then:
$ aptitude show lamp
$ sudo aptitude install the non-MySQL lamp dependencies
And file an RFP bug (does Ubuntu use reportbug?) asking for a lapp
meta-package.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense
outside the box for techniques to break that million-
row UPDATE statement into short-time committable chunks.
Canditate key tables and PL/pgSQL or a scripting language are one
possibility.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/17/06 22:14, Michael Glaesemann wrote:
On Oct 18, 2006, at 9:46 AM, Ron Johnson wrote:
SMALLINT(2)
INTEGER(2)
BIGINT(2)
Are these data-types not in PG, or am I missing something?
http://www.postgresql.org/docs/current
binary quite a bit and only found it to be a win if moving
blobs in and out of the database. On 'normal' tables of mixed fields
types of small size, it can actually be slower. Binary is a bit
faster for native types and bytea, and slower for character types.
native types?
- --
Ron Johnson, Jr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 09:47, Merlin Moncure wrote:
On 10/18/06, Ron Johnson [EMAIL PROTECTED] wrote:
I tested binary quite a bit and only found it to be a win if moving
blobs in and out of the database. On 'normal' tables of mixed fields
types of small
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 14:08, [EMAIL PROTECTED] wrote:
Is there any command to drop all the database at once
drop database dbname
drops the individual database.
I am using ver8.1
thanks,
DROP DATABASE db_name;
- --
Ron Johnson, Jr.
Jefferson LA USA
8TB
database, and in-place upgrade is the only way that we'd be able to
migrate from $EXISTING_VERSION to $NEW_VERSION.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 17:22, Jim C. Nasby wrote:
On Wed, Oct 18, 2006 at 04:27:21PM -0500, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 16:08, Jim C. Nasby wrote:
On Mon, Oct 16, 2006 at 06:10:18PM +0300, Adrian Suciu wrote
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 17:56, Jim C. Nasby wrote:
On Wed, Oct 18, 2006 at 05:42:22PM -0500, Ron Johnson wrote:
In any case, you'll be much, much happier if you do this project on at
least 8.1.x, as 7.4 is pretty long in the tooth. Due to Red Hat's
support
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 18:08, Tom Lane wrote:
Ron Johnson [EMAIL PROTECTED] writes:
We'll be using RHES4, I guess, so if it uses 7.4, then I'll have to
convince the SysAdmin to install 8.1 or 8.2.
plug
Red Hat is now selling an Application Stack addon
/18400: No such file or directory
pg_dump: The command was: COPY public.file (vfs_id, vfs_type, vfs_path,
vfs_name, vfs_modified, vfs_owner, vfs_data) TO stdout;
What happens when you fsck the relevant partitions?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example
web_database owner web_user;
ERROR: could not write to file base/16390/2682: No space left on device
template1=# exit
template1-# \q
Any ideas what may be causing this to happen?
No space left on device
Maybe your disk is full?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense
of Google
search would have been welcome.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a hardware
failure
how much time and money it takes.
Or... are you asking if there are automated tools?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful. I think this is a little beyond
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/17/06 03:51, Sandeep Kumar Jakkaraju wrote:
Can we convert from Postgres to Oracle !!???
Are you asking permission?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists
I missing something?
Also, how do you calculate the size of a NUMERIC?
Lastly, I know they are the same, but which is the
preferred/standard type: NUMERIC or DECIMAL?
Thanks
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power
-8.1-main.log gives the same
error that psql does, and there's nothing in syslog.
Any help appreciated.
--
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
response... 200 OK
Length: 0 [text/html]
[ = ] 0
- --.--K/s
21:45:10 (0.00 B/s) - `index.html' saved [0/0]
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites
READ ONLY tells the engine that these statements won't have to take
out concurrent write locks, and can thus take a different, faster
code path.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior
it in and have it on cassette tape here
somewhere. I'll send it via parcel post with two 13 cent stamps as soon
as I finish watching War Games on my betamax.
Is Carter still president?
No, Reagan is. WG was released in 1983 and the Vic-20 in 1981.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common
together, so the optimizer could decide a
table scan would be much more efficient.
In some ways, this would be similar in functionality to the existing
histogram created by ANALYZE, but would provide a slightly different
picture.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid
partitioning or a viewed UNION ALL, which will the query
optimizer and constraint_exclusion be more friendly towards?
Thanks,
Ron
--
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks
appear that ALTER TABLE can change constraint characteristics.
You'd have to drop/recreate, no?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud
* online users and had a
*relational* database (CA Datacom-DB).
Of course, the FEPs, block-mode terminals and CICS were the crucial
difference.
Damned shame that Unix killed that mentality, and that client-server
was usually implemented so poorly.
/GEEZER
- --
Ron Johnson, Jr.
Jefferson LA USA
it works on a 50M row table.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong.
-BEGIN PGP
of the ALTER TABLE ... ADD CONSTRAINT column.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/11/06 19:10, Geoffrey wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/11/06 14:48, Chris Browne wrote:
[EMAIL PROTECTED] (Andrew Sullivan) writes:
On Tue, Oct 10, 2006 at 02:50:44PM -0400, Tom Lane wrote
not a very efficient way to handle large data sets.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously
parsing modules, and can of course deal
with fixed-width data, let you skip comments, commit every N rows,
skip over committed records in can the load crashes, etc, etc, etc.
Probably not what you wanted to read, though, since performance
takes a big hit. But it definitely works...
- --
Ron Johnson, Jr
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You know, I'd have sworn that I changed extra 4 to extra 9
Sorry.
On 10/10/06 12:49, Alex Turner wrote:
Awesome - thank you!
Alex
On 10/9/06, *Ron Johnson* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
On 10/09/06 19:10, Alex Turner
.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong.
-BEGIN PGP SIGNATURE-
Version: GnuPG
the trick, no?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong.
-BEGIN PGP SIGNATURE
do not
match
And the default data type for a scalar constant is int4.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However
metadata records as
the image is inserted.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong
, pg_dumpall' won't work.
Doesn't /etc/mtab get recreated at boot?
And since it's a text file, can't someone fix it with $EDITOR?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those
to lose my database,
so I am tring to backup the database.
Booting from Knoppix should let you fix it.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
each
time it's needed.
BTW: our reason for keeping the thumbnails in fields is so they can be
replicated with Slony along with the rest of the database.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites
xyz()
Is this possible with postgres or do I have to store all these at
the client side?!
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown
that when there are lots of numeric fields,
fixed-width text records are approx 2.5x larger than the original
binary records.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks
what I thought when I read that in his book. I was
thinking back to the sha1 and md5 algorithms, maybe a special crc
algorithm is safe from this.
I doubt it. The typical CRC is 32 bits, whereas the MD5 hash is 128
bits and SHA1 is 160 bits.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common
that serves the species very well, most
of the time.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense
sue.
- how attractive the sales rep is.
Back in my youth, working for the family business (roofing/siding
distributor, not many women, fewer attractive women), the most
successful salespeople were always... young attractive women.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really
and keep on loading.
A fields option would also be handy. This is for when the number
of fields in the input file does not equal those in the table.
Just MHO, of course.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white
the
configuration variable log_statement (found in postgresql.conf) to
'all'. Then you can see exactly what queries are being sent and which
one causes the error.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/18/06 21:19, brian wrote:
Ron Johnson wrote:
On 09/18/06 19:25, Jeff Davis wrote:
On Mon, 2006-09-18 at 19:47 -0300, [EMAIL PROTECTED] wrote:
Hi,
I'm trying to create a table with a PRIMARY KEY. The CREATE
statement looks
like
on time.
But then, people who use Windows are just as scurvy as those scurvy
dogs who use PHP and MySQL. A.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong.
-BEGIN PGP SIGNATURE-
Version
-minded people know that PostgreSQL is manifestly superior
and that people who want to use MySQL are scurvy dogs.
I fear you've jumped the gun, sir - Talk Like A Pirate Day isn't until
tomorrow :-).
Practice, matey, practice. And a wee tankard o' grog. Or 10.
- --
Ron Johnson, Jr.
Jefferson LA
never used a hammer to put in a screw.
You haven't?
All right-minded people know that PostgreSQL is manifestly superior
and that people who want to use MySQL are scurvy dogs.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power
On 09/14/06 21:32, AgentM wrote:
On Sep 14, 2006, at 21:25 , Bruce Momjian wrote:
I am not going to ask how you got to 135MPH.
Obviously he was running MySQL under the hood.
No wonder he spun out and crashed into a telephone poll...
--
Ron Johnson, Jr.
Jefferson LA USA
Is common
WHERE COLNAME1 = :X.COLNAME1
LIMIT TO 1 ROWS);
DELETE FROM BIGTABLE_PK
WHERE COLNAME1 = :X.COLNAME1;
END FOR;
IF (SELECT COUNT(*) FROM BIGTABLE_PK) == 0 THEN
SET LOOP_FLAG = 0;
END IF;
COMMIT;
END ;
- --
Ron Johnson, Jr
to insert a record?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong.
-BEGIN PGP SIGNATURE
that:
sszabo=# insert into bar default values;
ERROR: null value in column col1 violates not-null constraint
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
if you can partition indexes, though.
And too bad that compressed bit-map indexes have not been
implemented yet. For indexes with high key cardinality, they save
a *lot* of space, and queries can run a lot faster.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example
PosgSQL
recognize these types? Or there are other solution that you recommend to
use ?
Thank you, Gustavo
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Joshua D. Drake wrote:
Ron Johnson wrote:
Eliminating 21 line .signatures would be nice, too.
How about your 16 lines ;)
??? It's 8 lines.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson
Sent: 05 September 2006 20:36
To: pgsql-general@postgresql.org
Subject: [OT] sig sizes (was Re: [GENERAL] Porting from
of the attributes of the event being
recorded.
Does the timestamp reflect an insert time, update, widget creation
date, etc, etc, etc? All these attributes modify TIMESTAMP.
For example, UPDATE_TIMESTAMP, CURRENT_TIMESTAMP,
TRANSACTION_TIMESTAMP, CREATION_TIMESTAMP, etc, etc, etc.
- --
Ron Johnson
overhead?
How difficult would it be to add a zlib(?) hook? (No, really. I'm
*not* assuming that it would be trivial.)
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those
, MySQL lets you create a date on February 31st, or
prior to the year 1500, both of which are obviously nonsensical.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson
Sent: Monday, August 28, 2006 6:27
and let other people maintain it then to try and maintain your
own fork of the code and cross patch their changes into your own.
Ultrix and SunOS are two counter-examples.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
Ron Johnson [EMAIL PROTECTED] writes:
Scott Marlowe wrote:
... It's much easier to donate your code to the project
and let other people maintain it then to try and maintain your
own fork of the code and cross patch their changes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
Ron Johnson [EMAIL PROTECTED] writes:
Tom Lane wrote:
Ron Johnson [EMAIL PROTECTED] writes:
Scott Marlowe wrote:
... It's much easier to donate your code to the project
and let other people maintain it then to try and maintain
a strong deceleration
of all system performace?
If either or both are heavily exercised, then it's quite possible that
you would see system performance worsen.
If both RDBMSs are pounding the disk(s)...
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example
and plan to replicate it to another box.
Pg_dump reports and error while I was dumping.
My Linux Boxes are all Ubuntu.
What can i do?
Install v8.1?
Seriously, why install such an old version? Some arcane data
requirement?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid
changed quite a bit in 5 years.
If PG uses any new functions, thhtt goes the build.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However
= RGT + 2
WHERE REPLIYID = :X.REPLYID;
END FOR;
END;
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Does PostgreSQL support them?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
David Fetter wrote:
On Tue, Aug 29, 2006 at 11:02:12AM -0500, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Does PostgreSQL support them?
Not yet.
Any plans? Don't see it on the TODO?
- --
Ron Johnson, Jr.
Jefferson
implement Decimal?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong.
-BEGIN PGP SIGNATURE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alvaro Herrera wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Seneca Cunningham wrote:
On 29-Aug-2006, at 13:13 :48, Andrew Baerg wrote:
[snip]
Take a look at http://www2.hursley.ibm.com/decimal/decifaq.html for
some
something beyond the range of the
DB's parameters.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that common sense is obviously wrong
for the Query str such as 500M, 1G, etc?
Or the query can be as long as it is.
Wouldn't the need to create such a huge query indicate that that
is the wrong solution to the problem?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white
(~~,
- -9, etc).
Then create a single-field table called, for example, CUR_MAX_VALUE
that gets incremented as part of each transaction. To serialize
access, transactions would need an EXCLUSIVE lock on the table.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jorge Godoy wrote:
Ron Johnson [EMAIL PROTECTED] writes:
Pre-allocate records. The (primary key?) field would have the
numbers already filled in, but all the rest of the fields in each
record be NULL, blanks, zeros or indicator values
aggressively does PostgreSQL keep b-trees in balance?
Inserting the range [1..1000] should result in a right-
unbalanced tree.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks
in the background in whatever way is most convenient.
Open database or closed database?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Davis wrote:
On Mon, 2006-07-31 at 09:53 -0500, Ron Johnson wrote:
The evasive answer is that you probably don't run regular full pg_dump
on such databases.
Hmmm.
You might want to use PITR for incremental backup or maintain a standby
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
On Mon, 2006-08-07 at 13:51, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Davis wrote:
On Mon, 2006-07-31 at 09:53 -0500, Ron Johnson wrote:
pg_dump just produces output. You could pretty easily
it serializes access. Fill up one tape, go to
the next, then the 3rd, etc.
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense really valid?
For example, it is common sense to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
On Mon, 2006-08-07 at 14:51, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
On Mon, 2006-08-07 at 13:51, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jeff Davis
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
On Mon, 2006-08-07 at 15:18, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Marlowe wrote:
Oh, I see where you were headed.
I've found a bit here and there googling about for multiplex and tar
401 - 500 of 625 matches
Mail list logo