On 27/05/2012 04:46, F. BROUARD / SQLpro wrote:
It's a little out of date (I've been meaning to update it for about 2 years
now) and has some gaps, but try the Database Rosetta Stone.
http://www.grantondata.com/community/dbrosettastone.html
Very out of date...
Yep, agreed, as you found
On 26/05/2012 00:04, Andreas wrote:
Hi,
I'm not into comparing which DBMS is better as we all know ... kind of ...
well ...
I'd like to find ressources to look up how one can do X in MSSQL when one
knows how it is done in PG's SQL and the other way around.
regards
Andreas
Hi
versions I've
used too.
-Allen
existed. That does give me a way to have consistent output for
reporting.
Thanks to everyone who replied!
-Allen
Hi Raymond,
From a strictly relational viewpoint, this is as easy as
(select users.uid, apps.appcode from apps, users)
except
(select canaccess.uid, canaccess.appcode from canaccess)
In english, that's the cartesian product of all users' uid and apps appcode
minus the known set of user+app
Scott Marlowe wrote:
On Mon, Mar 9, 2009 at 2:55 PM, Paul Vercellotti pverce...@yahoo.com wrote:
Hi there,
I hope this hasn't been covered in FAQ's; I couldn't find it specifically
mentioned. So we'd like to build a single-user application that uses
PostgreSQL as a database back end because
Mark Roberts wrote:
- It'd be nice if the query planner was more stable - sometimes the
queries run fast, and then sometimes they randomly take 2 hours for a
delete that normally runs in a couple of minutes.
I was going to stay silent, because my pet peeves were already covered or had been
Tom Lane wrote:
=?utf-8?Q?=E5=B0=8F=E6=B3=A2_=E9=A1=BE?= [EMAIL PROTECTED] writes:
[ snip a lot of marketing for SQL Server ]
I think the part of this you need to pay attention to is
Of course, nothing is entirely free, and this reduction in space and
time come at the expense of
Ron Mayer wrote:
Grant Allen wrote:
...warehouse...DB2...IBM is seeing typical storage savings in the
40-60% range
Sounds about the same as what compressing file systems claim:
http://opensolaris.org/os/community/zfs/whatis/
ZFS provides built-in compression. In addition to
reducing space
access controls).
It's complicated in Oracle, but there's a lot of possibilities there
that we simply cannot reproduce. But this could be extended one day. :)
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general
access controls).
It's complicated in Oracle, but there's a lot of possibilities there
that we simply cannot reproduce. But this could be extended one day. :)
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general
to put a lot
of faith in the perl code - an exploit poses a lot of risk. If Slony
exposed it's own data to PG via custom SQL extensions, this would be
more secure by design.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list
development has been going, personally. :)
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to clarify that I'm not saying anything like PostgreSQL
needs / should have SAR support in this thread, although I would
personally find them handy. I just wanted to clarify that what
roles means to an Oracle DBA is a lot different from what it means
to a PostgreSQL DBA.
Cheers,
--
Casey Allen
.
I don't find this functionality useful, but I also don't think that
it's completely worthless. There are enterprises with very different
needs and perspectives.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql
around it by querying the catalog tables as a
non-superuser.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
than it is
about the feature itself.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
for this,
though it's a small minority of those who think they do.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
their security architecture and keep production
isolated from development, not go down the obfuscation rathole. If
they do that and still have a threat that they think code obfuscation
would help manage, I'd love to see it.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
of business. This is
much the opposite of a business that provides a service.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref
, because then once you've
killed the competitor or lost the ability to steal more, you no longer
have the ability to keep up with customer demand, but many businesses
don't care about the long-term so much as a quick buck, unfortunately.
Cheers,
--
Casey Allen Shobe
Database Architect
-detrimental way thanks to proper implementation
techniques. Most people use a fraction of possible SQL techniques,
let alone most of the awesome functions that come provided in
pg_catalog. But the implementation is not bloated, so you don't see
it as a problem. :)
Cheers,
--
Casey Allen Shobe
On Sep 25, 2008, at 1:14 PM, David Fetter wrote:
On Thu, Sep 25, 2008 at 01:05:26PM -0700, Casey Allen Shobe wrote:
On Sep 15, 2008, at 7:19 PM, Tom Lane wrote:
The problem is that the people who ask for this type of feature are
usually imagining that they can put their code on
customer
corner case.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to put a lot
of faith in the perl code - an exploit poses a lot of risk. If Slony
exposed it's own data to PG via custom SQL extensions, this would be
more secure by design.
Cheers,
--
Casey Allen Shobe
Database Architect, The Berkeley Electronic Press
--
Sent via pgsql-general mailing list
Yes the table does have a primary key defined.
-Original Message-
From: Adrian Klaver [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 06, 2008 7:07 PM
To: Ken Allen; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Cannot update table with OID with linked server
in SQl Server
I would replace the ',' with something else such as a '#' first then
replace the decimal with the ',' then replace the '#' with a decimal '.'
If you do the ',' with a '.' first then all of them will be '.' and you
wont know which ones to change.
-Original Message-
From: [EMAIL PROTECTED]
is also
german :-( DD.MM.YY or
DD.MM.. So if I just exchange '.' and ',' the date will be
unreadable for the import :-(
The (current) file is 1.4 GB so it will take ages to let awk chew on it
I guess.
Christian
Ken Allen wrote:
I would replace the ',' with something else such as a '#' first
I have a linked server on SQL server 2005. I can update or write to a
table in Postgres that does not have a OID. But the Table I have has an
OID and I cannot write or update to that table. Anyone have any ideas.
to use MySQL are scurvy dogs.
I fear you've jumped the gun, sir - Talk Like A Pirate Day isn't until
tomorrow :-).
Ron Johnson, Jr.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au
his opinion rather than
tell him it's not his business.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end of broadcast)---
TIP 1: if posting/reading
Q3C module for POstgreSQL (q3c.sf.net). We use it for providing access
to very big astronomical catalogs.
Oleg
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end
_delighted_ that the core postgres developers
spend their time improving postgres, rather than spending their time on
random beauty contests.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au
cannot see how at the
moment...
I can't see it either :). Decide what you want to do first, _then_ work
out how to implement it.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au
experience,
so I could be wrong.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
it happen (no
telling how long that will be), or helping to make it happen (for which
we would all thank you :-) ). In the meantime you'll have to work around
it, as you suggested.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Tino Wildenhain wrote:
Tim Allen schrieb:
[snip]
The way to tell PostgreSQL what encoding you want to use is by use of
the client_encoding GUC variable, eg
set client_encoding to 'LATIN1';
If you cant educate your client application to set this option on connect,
you can set this per
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end of broadcast)---
TIP 6: explain analyze is your friend
is considered to be acceptable, if not good, practice on
all other platforms and distributions too. If a particular build would be
totally broken/untested/known to eat your soul it would be hardmasked.
-h
Tim
--
---
Tim Allen [EMAIL PROTECTED
Oops, I apoligize for the noise, this does seem to be working. I had an
invalid regular expression in the column.
Allen
Allen Fair wrote:
Hi! I have a table with a character column (called match_regex)
containing a POSIX regular expression, hoping to have Postgres use it
while evaluating
of the
operator. Perhaps I can cast this 'character varying(100) column' to a
regular expression type if there is such a thing... though I have not
found one in the docs?
where 'blah blah blah' ~ match_regex::regularexpression;
Thanks,
Allen
---(end of broadcast
to use EUC-KR
encoding, not UTF-8. Perhaps whatever client you're using to put data
into your database is using that encoding too?
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end of broadcast)---
TIP 6: explain analyze is your friend
what you want.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http
want to find the best way to plan for
when a database outgrows its current server.
How about a replication scheme and cutover? If so, is there a preferred
replication package to support this?
Thanks again! You folks are great, and that makes postgres great!
Allen
Tom Lane wrote:
Allen Fair
Hi!
Looking at the create tablespace command in the docs, I was wondering
how easy it is to move a database/tablespace to another server/instance
of PostgreSQL.
We have lots of databases, with the same definitions, with 1 database
per client account on the server. I can setup the database
/ to the new
server? I assume the same PG version must be running on each server.
Will we have problems with the catalog tables? Would we still need to
dump/restore without data to copy over the catalog information and table
structures?
Thanks,
Allen
---(end of broadcast
want to find the best way to plan for
when a database outgrows its current server.
How about a replication scheme and cutover? If so, is there a preferred
replication package to support this?
Thanks again! You folks are great, and that makes postgres great!
Allen
Tom Lane wrote:
Allen Fair [EMAIL
David Fetter wrote:
== PostgreSQL Weekly News - December 05 2005 ==
Chris Campbell of Big Nerd Ranch shows how to lower a query's priority.
http://weblog.bignerdranch.com/?p=11
I wouldn't normally bother nitpicking news items, but since this is
presumably being held up as expert advice and
- interval ?
execute argument: '21 days'
DBD::Pg::st execute failed: ERROR: syntax error at or near $1 at
character 74
The value '21 days' is achieved computationally so shouldn't be
hard-coded in the query.
How should this be specified?
Allen
Sample code follows:
#!/usr/bin/perl -w
use strict
about Python or Ruby?
Thanks,
Allen
Martijn van Oosterhout wrote:
On Sat, Oct 22, 2005 at 03:46:18PM -0400, Allen wrote:
I am trying to select a result set from a 2-table join, which should be
returning 5,045,358 rows. I receive this error:
DBD::Pg::st execute failed: out of memory for query
: This may not be the cleanest code, but works!
#!/usr/local/bin/perl -w
use strict;
use DBI;
my $dbName='allen';
my $host='localhost';
my $dbUser=$dbName;
my $dbPassword='';
my $dbh = DBI-connect(DBI:Pg:dbname=$dbName;host=$host, $dbUser,
$dbPassword,
{ RaiseError = 0, AutoCommit = 0
suggestions on how to avoid this? Should i be using the API
differently with Perl?
Thanks,
Allen
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do
.
Solutions are to either use UTF-8 as your encoding, or to tell the
database what encoding you really want to use, eg by
set client_encoding to latin1;
to set the encoding that a particular session is going to use.
Tim
--
---
Tim Allen [EMAIL
,
Allen
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
- must be
very subtle.
regards, tom lane
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
http://www4.tpg.com.au/users/rita_tim/
---(end of broadcast)---
TIP 9
, post it!
Good luck!
Allen
[EMAIL PROTECTED] wrote:
At office we have a Win2k LAN to which my freebsd postgresql server box
is connected via Samba. On this box I have a script, called 'crono', which
is dealt by /usr/bin/cron every working day's night at 1 am. As you can
see below this crono script
not hard to then write a script that compares the
current schema version at a site with that expected by the new
application version, and incrementally runs each update script.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http
, but I did have to do WITH NULL as '' since some of the
datetimes in MSSQL were empty.
By default the copy will bomb out on NULL fields even if you don't
have a NOT NULL constraint on the column, for one reason or another.
I suppose WITH NULL as NULL would've worked just as well, in hindsight.
-Allen
Tom Lane wrote:
David Wheeler [EMAIL PROTECTED] writes:
bric=3D# reindex index udx_keyword__name;
REINDEX
bric=3D# select * from keyword where name =3D'=BA=CF=C7=D1=C0=C7';
id | name | screen_name | sort_name | active
--++-+---+
1218 |
-Original Message-
From: Shachar Shemesh [mailto:[EMAIL PROTECTED]
Sent: Thursday, 25 March 2004 05:39
To: Grant Allen
Cc: [EMAIL PROTECTED]; PostgreSQL OLE DB development;
[EMAIL PROTECTED]
Subject: Re: [GENERAL] ole db
Grant Allen wrote:
It's a dead project ...
Used
on their desktop.
Of course, if your server didn't have X11 compiled (I don't see why it would),
then the graphical components would not (because they could not) be
compiled :).
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
http://rivyn.livejournal.com
---(end
a distribution of
PostgreSQL including extras, so that may be a possible route as well.
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
http://rivyn.livejournal.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
http://rivyn.livejournal.com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
medical advice
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 December 2003 15:09
To: Grant Allen
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] Any way to disable backslash as a
string literal
escape character?
Grant Allen [EMAIL PROTECTED] writes
* find PostgreSQL to be a better alternative to
MySQL, since that's the nature of this thread. I have *not* told you to go
and switch to it.
I think...you read my E-mail quite a bit differently than how I wrote it.
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
http
before execution)
So I guess my real question is, how can I address the same issues in
PostgreSQL?
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
http://rivyn.livejournal.com
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
;-).
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
http://rivyn.livejournal.com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
with un-normalized tables, and that's why they like to say it's faster? I
don't know, but I really don't care if that's the case.
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
[EMAIL PROTECTED] / http://rivyn.livejournal.com
Jabber: [EMAIL PROTECTED]; ICQ: 1494523; AIM/Yahoo
the exact same thing when they come attacking you for choosing
PostgreSQL.
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
[EMAIL PROTECTED] / http://rivyn.livejournal.com
Jabber: [EMAIL PROTECTED]; ICQ: 1494523; AIM/Yahoo: SomeLinuxGuy
Free development contributor of:
KDE toolbar icons
(Casey Allen Shobe)
[EMAIL PROTECTED] / http://rivyn.livejournal.com
Jabber: [EMAIL PROTECTED]; ICQ: 1494523; AIM/Yahoo: SomeLinuxGuy
Free development contributor of:
KDE toolbar icons
Kopete user interface, usability, and testing
X11 Icelandic Dvorak keymaps
Reporting of over 100 Kopete bugs
of the already very good documentation.
Vertu sæll,
--
Sigþór Björn Jarðarson (Casey Allen Shobe)
[EMAIL PROTECTED] / http://rivyn.livejournal.com
Jabber: [EMAIL PROTECTED]; ICQ: 1494523; AIM/Yahoo: SomeLinuxGuy
Free development contributor of:
KDE toolbar icons
Kopete user interface, usability
Tom, this discussion brings up something that's been bugging me about the
recommendations for getting more performance out of PG.. in particular the
one that suggests you put your WAL files on a different physical drive from
the database.
Consider the following scenario:
Database on drive1
WAL
, as another example. But, we would
need a good supplementary document that goes along with whatever
materialized, perhaps guiding new users along in a tutorial manner.
--
Michael D. Allen
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 7: don't forget
I just ran into that too, and find it most undesirable. I don't know
whether that is part of the SQL spec or not, but it seems very odd. The
queries seem to be converted to lowercase before they ever reach the SQL
engine.
Brian
+
Flash web sites from $149/year w/
to ease the transition and point out the differences and gotchas
would be very helpful.
Thanks for the help,
Brian
+
Flash web sites from $149/year w/ hosting
http://www.eflashcash.com/er/websuccess/
+
On Thu, 5 Apr 2001, Brian T. Allen wrote
flow error. Getting warm, it seems, but not there yet. And
there doesn't seem to be a negative equivalent.
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
http://www4.tpg.com.au/users/rita_tim/
ome future version :-).
Tim
--
---
Tim Allen [EMAIL PROTECTED]
Proximity Pty Ltd http://www.proximity.com.au/
http://www4.tpg.com.au/users/rita_tim/
81 matches
Mail list logo