On Thu, 2003-06-19 at 08:39, Jonathan Bartlett wrote:
The problem is that you can't do the check on the _field_ since it has
already been converted to a date.
You're right. How about a before insert trigger?
On 19 Jun 2003, Ron Johnson wrote:
On Thu, 2003-06-19 at 05:35, Bruno Wolff III
, I check it :)
But you could code programatic to validate the date.
--
+---+
| Ron Johnson, Jr. Home: [EMAIL PROTECTED] |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson
On Sun, 2003-06-22 at 15:47, Bruce Momjian wrote:
Ron Johnson wrote:
On Sun, 2003-06-22 at 12:46, Bruce Momjian wrote:
Ron Johnson wrote:
On Sun, 2003-06-22 at 00:05, Bruce Momjian wrote:
Bruce Momjian wrote:
Reading the subject, creepy ... dates, that is exactly how I
it into a
multibyte locale result in information/precision loss?
Link.
--
+---+
| Ron Johnson, Jr. Home: [EMAIL PROTECTED] |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson
.
--
+---+
| Ron Johnson, Jr. Home: [EMAIL PROTECTED] |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| Oh, great altar of passive entertainment, bestow upon me |
| thy discordant images at such speed as to render
.
Let the developer decide!!!
--
+---+
| Ron Johnson, Jr. Home: [EMAIL PROTECTED] |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| 4 degrees from
?
--
+---+
| Ron Johnson, Jr. Home: [EMAIL PROTECTED] |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| 4 degrees from Vladimir Putin
On Sat, 2003-07-19 at 08:31, Andrew Gould wrote:
--- Ron Johnson [EMAIL PROTECTED] wrote:
On Fri, 2003-07-18 at 19:56, The Hermit Hacker
wrote:
On Sat, 12 Jul 2003, Daniel Seichter wrote:
Hello,
see news.us.postgresql.org for now, while we
deal with some issues locally
in a color
table. Likewise with raw_material, wavelength and voltage
tables.
Then, using Foreign Keys, you can link the product table to the
static fact tables to ensure the integrity of the data.
--
+-+
| Ron Johnson, Jr
not affiliated with the
site in any way, I just want to see PgSQL at more than 8% :( It's right
on the homepage.
http://codewalkers.com/
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
-08-10 17:48:41 | 1993-08-11 | 1993-08-11 | 1993-08-11
(1 row)
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
by this.
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA |
| |
| I'm not a vegetarian
?
Hope I'm not asking too much...
Thanks !
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
can apply to all
commonly used two-digit-year formats, or we are going to lose
functionality.
Or drop YY because it's not y2k compliant.
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
in stone
yet but RH is the distro that I am most familiar with.
Thanks for you help so far!
PS. Just in case theres an amazing system for 60K or less point it out
in case i can get more funding!
--
+-+
| Ron Johnson, Jr
into the database, all within
the *same* transaction?
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
.
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA |
| |
| I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables
-a |grep postgresql
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA |
| |
| I'm
:
Hi!
Is there any quick way to determine how many rows exist in a given table?
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
template1=# select * from foo;
1
2
1
3
template1=# update foo set f1 = 1 where f1 = 1;
UPDATE 2
template1=# select * from foo;
2
3
1
1
Looks like it does what you tell it to do...
--
+-+
| Ron Johnson, Jr
.
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA |
| |
| I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate
of the data, so some times I
would want to access the inheritted tables and other times the parent/main
table.
Isn't this when you'd really want child tables, instead?
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED
?
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA |
| |
| I'm not a vegetarian because I love animals, I'm a vegetarian
:
http://www.commandprompt.com/entry.lxp?lxpe=260
Is there a possibility of getting this in v7.5?
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
currval() and nextval().
What if his PK isn't a sequence?
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
\, and the last
field has it's trailing \.
Thanks
[snip]
On Sun, 3 Aug 2003 05:36 pm, Ron Johnson wrote:
Hi,
PostgreSQL 7.3.3 on i386-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.3 (Debian)
I must load a file in which each field in each row is contained
in double quotes, i.e.
1,foo
2,bar
3
not write to tar member (wrote 47,
attempted 317)
Has anyone seen this error before?
TIA
--
+-+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA USA
On Mon, 2003-08-11 at 18:40, Roderick A. Anderson wrote:
On 11 Aug 2003, Ron Johnson wrote:
Maybe this will do it:
http://www.postgresql.org/docs/7.3/static/sql-set-constraints.html
Saw this but my take was it required the original constraint to be created
with the deferred(able) option
development
and testing.
Sounds like a job for the postmaster. Maybe messages going to the
log file could be tee'd off somehow and piped to a mail script?
--
+---+
| Ron Johnson, Jr.Home: [EMAIL PROTECTED] |
| Jefferson, LA
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
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
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
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
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 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
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
, 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
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
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
.
- --
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
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
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
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
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
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
-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
-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
-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
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 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
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
, 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
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
:
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
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
, I wish one day it
can be achieved with a SQL Statament thanks again .
You can do it in PL/pgSQL.
- --
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
.
Or you can concat several table-dumps to one big dump.
Note that the latter option does not guarantee that you get a consistent
dump.
What about creating a new schema that just has views back to the
base tables you want to dump. Then pg_dump the schema.
- --
Ron Johnson, Jr.
Jefferson LA USA
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
3.75 years later?
- --
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
(sounds like you do), then you can do that to create the copy
rather than shutting the database down.
How does SAN-snapshot ensure transactional consistency?
- --
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 11/15/06 14:28, Martijn van Oosterhout wrote:
On Wed, Nov 15, 2006 at 01:41:47PM -0600, Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/15/06 09:47, Jim Nasby wrote:
On Nov 14, 2006, at 3:44 PM, Paul Silveira wrote
, in order to copy the WAL to a new directory, no?
Lastly: in order to do SAN splitting without risking your data,
wouldn't you have to configure the disks as RAID-15 (mirrored
RAID-5), since splitting a RAID10 would leave you with stripesets?
- --
Ron Johnson, Jr.
Jefferson LA USA
Is common sense
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 11/15/06 15:51, Martijn van Oosterhout wrote:
On Wed, Nov 15, 2006 at 03:25:38PM -0600, Ron Johnson wrote:
However, what if the WAL is not on the SAN? You'd have to shut down
pg anyway, in order to copy the WAL to a new directory, no?
You
1 - 100 of 625 matches
Mail list logo