Google. And, yes, Google use a modified MySQL for its pigeons.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Wednesday, May 30, 2007 2:41 PM
To: Jeff Davis
Cc: Scott Ribe; PostgreSQL general
?
For a direct example, why should a business upgrade their desktops from
Windows XP to Windows Vista before 2011 if *none* of the new features
are needed?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent
Actually the only reason we have an email disclaimer is for CSIA
compliance. We know they have a highly dubious legal standing, but,
hey, it's what the auditors require.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Konrad Neuwirth [mailto:[EMAIL PROTECTED]
Sent
It's about $20,000 cheaper than ISO (ISA? IEC? One of those TLAs.)
certification. Industrial engineering.
CSIA is industrial control certification:
http://www.controlsys.org/
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED
.
The upgrade question is why? not why not?.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, March 15, 2007 2:00 PM
To: Joshua D. Drake
Cc: Erik Jones; CAJ CAJ; pgsql-general@postgresql.org
It was clear to me after 20 minutes of actually trying to use the OS that UAC
was a gimmick designed to supply plausible deniability for the fact that
Windows XP suffered so many problems with malware. They can simply ask were
you using UAC? every time someone complains that their box got
Why is running on PG so important? Why not look for the best CRM
application for your user's needs?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bradley Kieser
Sent: Thursday, March 08, 2007 8:22 PM
To: pgsql
is a superset of what's needed for unique, so I would expect only
legacy systems to support non-indexed uniques. Any newer DBMS would
implement primary keys and then steal the code for uniques.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
Problem number 6,534 with implementing an abstract concept such as an
RDB on a digital computer with an electro-magno-mechanical storage
system.
:p
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 28, 2007 11
That's why you make a table for every device or every measurement, and
then use a view to consolidate it. With updatable views, there's no
excuse not to.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Steve
is a practical workaround and never a
wise logical design choice from the get-go, you shouldn't feel too bad
about doing it.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tim Tassonis
Sent: Thursday, February 22, 2007
(as are PostgreSQL installations such as the .org
DNS TLD root).
I'd like to see a tuned MySQL vs a similarly tuned PostgreSQL system
(that is, fsync in the same state and with the same level of ACID
compliance) subject to a battery of test schema types (OLTP, OLAP,
etc.).
--
Brandon Aiken
CS/IT Systems Engineer
thing available. PostgreSQL is on
Windows now, MS SQL 2005 Express, SQLite, Oracle Express, Firebird, etc.
4. So is Windows.
MySQL isn't quite as bad as PHP for internal inconsistencies and
developer aggrivations, but it comes close enough for me to want to
avoid them both.
--
Brandon Aiken
CS
You'll have to escape any quotation marks or your SQL will not parse
your strings correctly.
--
Brandon Aiken
CS/IT Systems Engineer
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of deepak pal
Sent: Monday, February 12, 2007 4:07 AM
it, but I've also never
been impressed with the performance of anything that has used JetSQL
(Exchange especially).
--
Brandon Aiken
CS/IT Systems Engineer
From: Justin Dearing [mailto:[EMAIL PROTECTED]
Sent: Monday, February 05, 2007 6:29 PM
To: Brandon Aiken
a virtual impossibility (the most obvious
reason being that a computer database can only store computerized data).
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim C.
Sent: Friday, February 02, 2007 11:37 AM
To: pgsql
a much larger memory footprint and is much more
complicated to administer compared to FB, but is much more configurable
and customizable.
Bottom line: PostgreSQL is more mature because it's several years
older. Firebird is intended for different applications.
--
Brandon Aiken
CS/IT Systems
2007-01-3012h00 d3
2007-01-3013h45 d4
2007-01-3017h20 d5
2007-01-30 9h30 d2
To use your current schema, you need to zero-fill your hours, so 9h30
needs to be 09h30 and so forth.
--
Brandon Aiken
CS/IT Systems Engineer
between tables?. Well, because if one A always means
one B and one B always means one A, shouldn't they ought to be in the
same table already?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Guido Neitzer
Sent: Tuesday
to
affect someone eventually.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Csaba Nagy
Sent: Tuesday, January 23, 2007 4:42 AM
To: Lenorovitz, Joel
Cc: Postgres general mailing list
Subject: Re: [GENERAL] too many
Out of curiosity, has the COUNT(*) with no WHERE clause slowness been
fixed in 8.x? Or is it still an issue of there's no solution that
won't harm aggregates with WHERE clauses?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
to each character.
As far as PostgreSQL is concerned, Unicode is an alias for UTF8,
which is UTF-8 encoding.
See:
http://www.postgresql.org/docs/8.2/interactive/multibyte.html#MULTIBYTE-
CHARSET-SUPPORTED
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED
be
different.
That should get most of 'em.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Ribe
Sent: Thursday, January 18, 2007 1:26 PM
To: pgsql-general postgresql.org
Subject: [GENERAL] Finding bogus dates
Actually, now that I think about it a second you can find them really
easy just by doing:
SELECT * FROM foo
WHERE to_char(to_date(oldDate,'MM/DD/'),'MM/DD/')
oldDate;
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Scott Ribe [mailto:[EMAIL PROTECTED]
Sent
AFAIK, PostgreSQL is only supplied in Win32 and Fedora/Redhat flavors.
Debian, Gentoo, and FreeBSD maintain their own binary packages
themselves.
For HP-UX, you need to build from source.
http://www.postgresql.org/docs/faqs.FAQ_HPUX.html
--
Brandon Aiken
CS/IT Systems Engineer
-Original
Right, but I assumed you checked with HP before coming here. I should
have said for PG 8.2.1 on HP-UX, you will need to build from source.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Al Balmer [mailto:[EMAIL PROTECTED]
Sent: Friday, January 12, 2007 12:39 PM
Read the release notes. 7.4.8 and 7.4.11 require special considerations. By
all means upgrade, but it's not quite seamless.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Marlowe
Sent: Friday, January 12
Shouldn't these be using HAVING?
SELECT COUNT(max_persons) ...
GROUP BY NULL
HAVING max_persons = 5 AND max_persons = 8;
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Alban Hertroys
Sent: Tuesday, January 09
binary files.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Shelby Cain
Sent: Monday, January 08, 2007 3:12 PM
To: Oisin Glynn; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Database Failure on Windows XP Pro
Try a 180-day Win2k3 trial to see if the issue persists. Realistically,
though, if you can't afford the proprietary software don't develop with
it.
If it's a Windows XP bug (or feature) then it's not anything we can
help with since PG is working correctly.
--
Brandon Aiken
CS/IT Systems
://www.postgresql.org/docs/8.2/interactive/runtime-config-client.htm
l#GUC-TIMEZONE
--
Brandon Aiken
CS/IT Systems Engineer
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Rodrigo Sakai
Sent: Thursday, December 21, 2006 12:33 PM
To: pgsql-general
are completely different times.
You should not be storing the timezone information if you just want the
relative time of day and not the absolute time.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Rodrigo Sakai [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 21, 2006 1:37
be a function of the other, for sure, but exactly what does the
autovacuumer use to decide when to clean?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Matthew
O'Connor
Sent: Tuesday, December 19, 2006 5:37 PM
To: Glen
My understanding of VSS is that only one non-VSS aware app can access
the data at any one time. All I meant was that if their NetBackup
version was old that they probably cannot benefit from VSS since I doubt
the Win32 PG port knows about it either.
Brandon Aiken
-Original Message-
From
';
timezone
-
2006-12-16 04:00:00
(1 row)
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard Troy
Sent: Friday, December 15, 2006 5:18 PM
To: Tom Lane
Cc: Richard Huxton; Randy Shelley; pgsql
I wonder if this is related to the Linux memory overcommit problem:
http://www.postgresql.org/docs/current/interactive/kernel-resources.html
#AEN19361
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Angva
Sent
. Should not is often a suggestion, it seems.
As a port, postmaster.exe was presumably not written with VSS in mind,
so it might object to the shadow copy instantiation (which, again, it
*should* not be able to do).
No idea on the frequent autovacuuming. Do you do a lot of deletes?
--
Brandon Aiken
CS
calculate the ordinals declaratively, or use a separate
table to track the parent-child relationship of each object and use that
for numbering.
Brandon Aiken
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Pawley
Sent: Monday, December 04, 2006 10:40 PM
?
This is just a curiosity question. I expect that PostgreSQL would behave in a
similar manner performance wise inside a transaction. It just struck me as odd
when it didn't work.
--
Brandon Aiken
CS/IT Systems Engineer
Confidentiality Notice
This email, including attachments, may include
Cool.
Now I just have to wait for Debian backports, or figure it out for
myself if I can find the time.
*sigh* 8.2 isn't even in Portage yet.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December
you'll need to use to be sure of getting what you want. Double check
the docs and be sure to test it a few times.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of SunWuKung
Sent: Tuesday, December 12, 2006 3:19 AM
If you have, say, an index(x, y) then that index will often double as an
index(x). It will generally not double as an index(y).
I'm not sure if that's how all RDBMSs work, but I'm pretty sure that's
how Oracle works. It never surprises me when PostgreSQL mimics Oracle.
--
Brandon Aiken
CS
forces you to always
silently truncate fractional cents. That may not be what you want.
--
Brandon Aiken
CS/IT Systems Engineer
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Yonatan Ben-Nes
Sent: Monday, December 11, 2006 10:51 AM
To: pgsql
, IIRC. I believe it complains if you try to pg_dumpall a database
with a different version of pg_dumpall.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of SunWuKung
Sent: Monday, December 11, 2006 3:56 PM
To: pgsql
[NULL], but defaults to type
TEXT. An explicit empty integer array would be ARRAY[NULL]::INTEGER[].
NULL arrays are not handled entirely consistently, though. Sometimes it
acts like a NULL, and sometimes it acts like a container of NULL.
--
Brandon Aiken
CS/IT Systems Engineer
-Original
Download the contrib module .tgz from PGFoundry and check out the
readme. Syntax is explained therein. It's a multi-step process, it
appears.
I don't especially care for the term 'full disjunction' to describe this
operation, but it seems to be an understood relational operation.
--
Brandon
understanding is right then running with autovacuum
disabled and no batch process vacuum strategy on a database with lots of
INSERTs and DELETEs is essentially like running without indexes.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
of the relational model.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John McCawley
Sent: Monday, November 27, 2006 1:53 PM
To: Ron Johnson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] IS it a good practice to use
violates the
relational model by allowing you to create tables without primary keys.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: David Morton [mailto:[EMAIL PROTECTED]
Sent: Monday, November 27, 2006 2:30 PM
To: Brandon Aiken
Cc: pgsql-general@postgresql.org
Subject
Shenanigans!
That problem occurs regardless of whether or not you use surrogate keys.
You have exceeded the scope of the example.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Scott Ribe
Sent: Monday, November
Hasn't it been said enough? Don't allow NULLs in your database.
Databases are for storing data, not a lack of it. The only time NULL
should appear is during outer joins.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
comfortable with an id field. Having
that metadata feels like a safety net for some reason.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Allison
Sent: Friday, November 24, 2006 9:54 AM
To: pgsql-general
UCS-2-INTERNAL
UCS-2-SWAPPED
UCS-4-INTERNAL
UCS-4-SWAPPED
Gee, didn't Unicode just so simplify this codepage mess? Remember when it was
just ASCII, EBCDIC, ANSI, and localized codepages?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
with 8.2.0.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of John
Sidney-Woollett
Sent: Friday, October 20, 2006 11:10 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Upgrade 7.4 to 8.1 or 8.2?
We're looking
What about time zones like Tehran (GMT+3:30), Kabul (GMT+4:30), Katmandu
(GMT+5:45) and other non-cardinal-hour GMT offsets? Is this handled in
some *documented* way already?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
big considerations.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Merlin Moncure
Sent: Tuesday, October 10, 2006 1:56 PM
To: PgSQL General
Subject: [GENERAL] more anti-postgresql FUD
http://www.zabbix.com/manual
to table joins take so long? Maybe because a blind monkey created the schema? Normalized databases do tend to perform better, so I hear.
Brandon Aiken
From: [EMAIL PROTECTED] on behalf of Tomi NASent: Sat 10/7/2006 2:06 PMTo: PgSQL GeneralSubject: [GENERAL] performace review
I was just reading
d_at". Those should definitely not be timestamps. "owner". Great field name, that. The only keys that don't allow NULLs are the primaries. Clearly each of the 110 tables will need all these fields, then.
Looking at the indexes, the vast majority of them are against one of these 14 uni
with Notepad
for years and years, and now youre starting to use Word or EMACS.
--
Brandon
Aiken
CS/IT Systems Engineer
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Iulian Manea
Sent: Monday, October 02, 2006
3:38 AM
To: pgsql-general@postgresql.org
be an Administration Guide companion to the Manual.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff Davis
Sent: Monday, October 02, 2006 2:58 PM
To: Oisin Glynn
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL
key combined with a unique constraint on your random field
seems like a better choice here, but that's entirely a subjective
opinion.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Damian C
Sent: Friday, September
be very stable fields.
Brandon Aiken
-Original Message-
From: Bob Pawley [mailto:[EMAIL PROTECTED]]
Sent: Mon 9/25/2006 11:59 AM
To: Brandon Aiken; pgsql-general@postgresql.org
Subject: Re: [GENERAL] serial column
Actually, I am not trying to force keys nor, I don't beleive, am I trying
.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Thomas Peter
Sent: Tuesday, September 26, 2006 9:15 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] change the order of FROM selection to make query work
hi
the order key as a primary key. It should
be unique, to be sure, but primary keys should be very stable. You may
wish to use a serial field as the primary key just for that sake.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Bob Pawley [mailto:[EMAIL PROTECTED]
Sent
) and then set nextval to MAX()+1.
This is rather ugly, however, since you're still forcing the database to
do relationships it doesn't know about, so you technically violate first
normal form by having a multi-valued field (it identifies uniqueness and
order).
--
Brandon Aiken
CS/IT Systems Engineer
Use the AT TIME ZONE construct:
http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#F
UNCTIONS-DATETIME-ZONECONVERT
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Harry Hehl
Sent: Monday
Hm? Works for me:
postgres=# select time with time zone '00:30:00-05' at time zone 'utc';
timezone
-
05:30:00+00
(1 row)
What are you trying to do with the query?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
WHERE myTime = TIME WITH TIME ZONE '19:30:00-00';
If that doesn't work you might try extracting epoch to convert the time to an integer:
SELECT myDate, myTime FROM theTable where EXTRACT(EPOCH FROM myTime) = EXTRACT(EPOCH FROM TIME WITH TIME ZONE '19:30:00-00');
Brandon Aiken
-Original
for the logical model?
--
Brandon Aiken
CS/IT Systems Engineer
Confidentiality Notice
This email, including attachments, may include confidential
and/or proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this email
care less about PG on Vista. Longhorn isn't due
until Vista SP1, so PG support has a long time to go before it's a real
concern. But then I didn't try to answer the question.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED
Define 'quick'.
You could write a script that would transform a .csv file into an INSERT
statement and save it to an .sql file.
Or I suppose you could do silly ODBC stuff with MS Access.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
that this is
a known bug that has already been fixed.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey
Sent: Monday, September 18, 2006 10:06 AM
To: PostgreSQL List
Subject: [GENERAL] server resetting
Postgresql
Are you trying to connect to a remote
server? By default, PostgreSQL only accepts connections from localhost or
127.0.0.1. You will have to change the listen_addresses setting in postgresql.conf
if you wish to connect from a remote node.
--
Brandon
Aiken
CS/IT Systems
even if
you do this.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Friday, September 15, 2006 7:26 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Installation with sources
Fair enough. I've never done it before except with trivial things that
had no dependencies, and I just downloaded the packages with wget.
Another option would be to use Ubuntu server. That's kinda Debian de
facto, and offers more current packages, IIRC.
--
Brandon Aiken
CS/IT Systems Engineer
What about a self-referencing table?
Region
--
region_id
country_id
parent_region_id
PRIMARY KEY (region_id)
FOREIGN KEY (parent_region_id) REFERENCES Region (region_id) ...
--
Brandon Aiken
CS/IT Systems Engineer
From: [EMAIL PROTECTED
And yet this man is smart enough not to run MySQL on Windows. Methinks
this says something
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Thursday, September 14, 2006 5:16 PM
To: [EMAIL
Why drop and recreate the table? Why not TRUNCATE it?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthieu Guamis
Sent: Wednesday, September 13, 2006 6:15 AM
To: [EMAIL PROTECTED]
Subject: Re: [NOVICE] INSERT
.
--
Brandon
Aiken
CS/IT Systems Engineer
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Parris
Sent: Tuesday, September 12, 2006
9:16 PM
To: [EMAIL PROTECTED]
Subject: Re: [NOVICE] Question
About Aggregate Functions
On 9/12/06, Brandon
Aiken
Aggregate Functions
On 9/13/06, Brandon
Aiken [EMAIL PROTECTED]
wrote:
Ah, I did not know what was in your fields, so I did not
assume they were Boolean values. It looked to me like you were trying to
use IS TRUE to substitute for the lack of a GROUP BY, so I didn't know what to
do
Serial fields have a default value of nextval, so if you add an 18th
field to your text file with DEFAULT in every record it should work as
intended.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED
MS Paint. ;)
Literally, there were posts about this
yesterday. Look for DBDesigner4 and Clay (an Eclipse extention/plug-in).
--
Brandon
Aiken
CS/IT Systems Engineer
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Zlatko Matic
Sent: Tuesday
know whats good anymore.
--
Brandon Aiken
CS/IT Systems Engineer
Confidentiality Notice
This email, including attachments, may include confidential
and/or proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader
table. Is that how it's
supposed to be done?
There are several places across the DB where this style relationship
occurs, and I'd like to try to conform to best practices (especially
since the last guy managed to miss just about every single one).
--
Brandon Aiken
CS/IT Systems Engineer
is much more difficult than learning to design a normalized
data model.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 7:09 PM
To: pgsql-general@postgresql.org
Subject
Sure. Any RDBMS can do that. Just create
a user account (login role for PostgreSQL) and only grant the INSERT privilege
to them on your tables, then connect with that account with your program. Any
DELETE or UPDATE statements will automatically fail.
--
Brandon
Aiken
CS
are slow, do some index tuning.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, September 06, 2006 2:05 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Database design and triggers
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 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Precision
The Gregorian calendar was established in the 1500's by Pope Gregory,
so, no, those dates did not exist.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, September 01, 2006 2:22 PM
To: Brandon Aiken
Cc: pgsql general
the year and season something happened is
about the best that can be expected.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, September 01, 2006 2:27 PM
To: Brandon Aiken
Cc: pgsql general
Subject: RE: [GENERAL
Unless it's a read-only database, I would never recommend using flash
media for an RDBMS.
Unless it's a small database, I would never recommend using USB as a
storage interface for an RDBMS.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
well at all.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of AgentM
Sent: Wednesday, August 30, 2006 1:21 PM
To: PostgreSQL General ML
Subject: Re: [GENERAL] PostgreSQL on system with root as only user
On Aug 30
MySQL 5 stores numbers with the DECIMAL data type as text strings, and
does math at 64-bit precision. Where can I find information about how
precise PostgreSQL 8 math is?
--
Brandon Aiken
CS/IT Systems Engineer
---(end of broadcast)---
TIP 3: Have you
Oh, I agree. PostgreSQL is a much more well-behaved RDBMS than MySQL
ever was. I'm more inclined to select PostgreSQL over MySQL, but I may
not be able to convince management that it's a better choice no matter
how technically superior I can show it to be.
--
Brandon Aiken
CS/IT Systems
integrity. It's fine for discussion boards or anything non-critical
where having a database is a convenience instead of a necessity.
Nevermind that MySQL really doesn't have much place between PostgreSQL
and SQLite nowadays.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From
, MonetDB.
The results tell me that people who write databases can write good apps
that use those same databases. And the world collectively says O
RLY?.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony Caduto
Sent
96 matches
Mail list logo
