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
e there were significant fixes in 7.4.8. It's possible 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:
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
asked the same
question to the dev team and that they *might* know something about the
state of PG on that platform.
Frankly, I too could 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'
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]
[mai
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 is
red correctly,
truncate the existing table, delete the sequence (or change the default
on the primary key), copy the data back, and then re-create the sequence
(or change default back to nextval) and then set nextval to MAX()+1.
This is rather ugly, however, since you're still forcing the database to
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]
[mai
me AT TIME ZONE 'UTC' FROM theTable 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 W
ous tables."
--
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
In any case, I would not use 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 [
ake it a unique key to enforce the constraint, but primary keys should generally 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
surrogate 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: Fr
bit
daunting to get started. It’s like you’ve worked with Notepad
for years and years, and now you’re 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
s really helped me in
comming up to speed on Postgres administration."
There should 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,
king about average.
Gee, why 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] perf
_level_delete int4,
And this key:
CONSTRAINT kernel_media_pkey PRIMARY KEY (object_rid, object_oid, object_idx)
Wow, yeah. "modified_at" and "created_at". Those should definitely not be timestamps. "owner". Great field name, that. The only keys that don't all
also 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/m
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] On
live 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
The SRPM appears to be available:
http://www.postgresql.org/ftp/binary/v8.1.5/linux/srpms/redhat/rhel-as-4
/
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Will Reese
Sent: Wednesday, October 25, 2006 2:42 PM
To
CODE11UTF7
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]
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 PRO
also feel more 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
MS is just an
estimated implementation 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
Subjec
new for a DBA. The SQL standard itself 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
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
straints.
Additionally, if my 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: [E
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 op
[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
math also 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
of
PostgreSQL, 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:
which
options 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
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.
--
construct a rather elaborate VIEW to
automatically 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 O
Is that correct, or is this behavior expected to change?
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
Confident
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, Dec
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
;s Windows. "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 delete
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
ect '2006-12-15 20:00 PST'::TIMESTAMP WITH TIME ZONE AT
TIME ZONE
'GMT';
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 T
might
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
in postgresql.conf.
http://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 1
the timezone your server is in,
because those 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
only way to modify the limit is to manually
modify 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
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.
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,
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 1
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, Janua
te","MM/DD/") <>
"oldDate". If a date got changed for sanity reasons, it'll 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 Sco
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/YYYY') <>
"oldDate";
--
Brandon Aiken
CS/IT Systems Engineer
-Origina
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 Messa
#x27;s the case, it's going 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 l
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]
[mai
tly
one relationship 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] O
8h40 d1
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 Aik
top-end enterprise
databases. It has 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
-platform. I've never used 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, Feb
and Cobb 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
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
tem.
3. MySQL is no longer the only 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
and that de-normalization 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 Tassoni
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 Eng
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 Behal
y
key 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:[
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
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:
t contract.
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
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 inf
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]
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 PROT
orious for the latter.)
If "bug fix" is 100% handled by support contract, and "new feature" is
100% not useful, what is my impetus?
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
#x27;ve learned
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)---
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/
h speed at a cost of data
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 Engine
, 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 T
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]
[mai
ect it to scale 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 u
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 PM
To: pgsql-general@postg
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 ge
. Knowing 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
the
queries 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 desi
END
, "UserID"
FROM "Transaction" NATURAL JOIN "TransactionItem";
As far as speed, speed is always an issue. PostgreSQL is going to
perform better than Access, but don't use good performance as a crutch
for bad design.
As far as normalization, it is possib
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
books, and I don’t
know what’s 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
ce both tables are parents to this third 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 singl
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
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
TRUE, FALSE, and NOT YET DETERMINED.
--
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
Subject: Re: [GENERAL] [NOVICE]
Question About 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 t
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
world) I suspect you won't have any major problems 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
S
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 System
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
___
97 matches
Mail list logo
