in this case references more than one row,
if more than one row with
--the given id already exists in my_audit_table.
--
--How do I accomplish what I want to accomplish here? I'd prefer not to use
a sp.
Thanks,
Chad
Howdy!
I'm trying to build some fixture (test) data for a webapp I'm building
for my company. To do this I've taken a dump of data from production,
exported it using pg_dump, and load it via psql database file
The data that is exported from production is about 25K rows and 12MB.
The dump takes
like the
presentation you did at CEC?) to help him build his case?
This is an urgent request from my customer given that his timeline is
relatively short. Any help you can give me will be very appreciated.
Thanks,
Chad Hendren
Original question:
Have you seen any studies (either by Sun
On 2/25/07, Greg Sabino Mullane [EMAIL PROTECTED] wrote:
For the record, anyone using wikipgedia deserves the pain they
get: it is deprecated. The latest version of MediaWiki itself is what
should now be used: it will detect if you have Postgres upon
installation. :)
Some of us are still
On 2/25/07, Magnus Hagander [EMAIL PROTECTED] wrote:
For the record, anyone using wikipgedia deserves the pain they
get: it is deprecated. The latest version of MediaWiki itself is what
should now be used: it will detect if you have Postgres upon
installation. :)
Perhaps the project should
/uri.c 2005-07-20 18:49:23.0 -0400
+++ uri/uri.c 2007-02-24 07:16:29.553130168 -0500
@@ -15,6 +15,10 @@
#include liburi/uri.h
+#ifdef PG_MODULE_MAGIC
+PG_MODULE_MAGIC;
+#endif
+
/*
* Commonly used code snippets
*/
Other than that it appears to still work with 8.2.3.
--
Chad
On 2/23/07, Bill Moran [EMAIL PROTECTED] wrote:
I installed wikipgdia for the WPLUG wiki:
http://wplug.ece.cmu.edu/wiki/
Isn't that the same wikipgedia that is found at pgFoundry? The only issue I
really had the the wikipgedia port is that the codebase is 1.6alpha, and it
seemed like it
On 2/23/07, Bill Moran [EMAIL PROTECTED] wrote:
In any case if anyone is interested I was able to reproduce the changes
that
wikipgedia made and applied those changes (as well as others) all the
way up
to the 1.6.10 codebase. The only reason I mention this is because 1.6is
the only choice
On 2/22/07, Martijn van Oosterhout kleptog@svana.org wrote:
On Thu, Feb 22, 2007 at 12:05:20PM +1100, Chris wrote:
SELECT foo, bar, COUNT(*)
FROM baz
GROUP BY foo
That one actually comes in handy ;) Especially in older versions (4.0)
that don't support subselects..
I must say I don't see
in it's default configuration.
--
Chad
http://www.postgresqlforums.com/
.
--
Chad
http://www.postgresqlforums.com/
just added the SET client_encoding TO LATIN1; since I
knew the source encoding was LATIN1.
--
Chad
http://www.postgresqlforums.com/
On 2/3/07, Bruce Momjian [EMAIL PROTECTED] wrote:
Would someone please confirm that our behavior in the three queries
below matches Oracle's behavior?
Here is output from Oracle:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning,
to work
well enough.
--
Chad
http://www.postgresqlforums.com/
that is as close as it gets.
--
Chad
http://www.postgresqlforums.com/
key could result in
another 100GB of storage requirements.
There should be some thought when you are modeling and these are some of the
things to consider. I don't see a 10 table join being a major performance
penalty, especially when 8 of the tables may be a few MB in size.
--
Chad
http
version it used libpq.so.3.
--
Chad
http://www.postgresqlforums.com/
not, for the date part, the simpler alternative:
SELECT CURRENT_DATE + s.s AS DATE FROM generate_series(1, 365) AS s;
That's one of the problems with having a couple dozen date/time functions
;).
--
Chad
http://www.postgresqlforums.com/
unique. In order to obtain the same
results as a subselect you would need to group or distinct, and I would
imagine the results would be the same as the IN..SUBSELECT
--
Chad
http://www.postgresqlforums.com/
-28 | 4
2007-01-29 | 5
2007-01-30 | 0
2007-01-31 | 6
2007-02-01 | 0
2007-02-02 | 7
2007-02-03 | 8
2007-02-04 | 0
2007-02-05 | 9
2007-02-06 | 0
2007-02-07 | 10
2007-02-08 | 0
2007-02-09 | 11
2007-02-10 | 0
2007-02-11 | 12
2007-02-12 | 0
2007-02-13 | 13
2007-02-14 | 0
--
Chad
http
is a few links discussing the issue:
http://sql-info.de/postgresql/postgres-gotchas.html#1_7
http://archives.postgresql.org/pgsql-hackers/2005-01/msg00247.php
--
Chad
http://www.postgresqlforums.com/
, hardly
production worthy. There also seems to be an increase of chatter about
people coming to PostgreSQL because of the actions that MySQL has taken.
Just my 2 cents.
--
Chad
http://www.postgresqlforums.com/
with BDB embedded in MySQL,
but who knows if that is how it was implemented or what. BDB in general
seems to perform well.
--
Chad
http://www.postgresqlforums.com/
type :(.
Not to mention how misleading it probably is to use a varchar for a data to
the optimizer for calculating selectivity.
--
Chad
http://www.postgresqlforums.com/
can't.
Maybe I am oblivious to the reason, but why is there a need for a special
data type for GUID/UUIDs? Wouldn't you always be doing an equality
anyways? Wouldn't a varchar suffice?
--
Chad
http://www.postgresqlforums.com/
you can use PostgreSQL as a backend (if not
there is easily 50~60 different content management systems out there ranging
from open source to commercial). I certainly wouldn't write your own.
--
Chad
http://www.postgresqlforums.com/
line 6 at SQL statement
postgres=# \d temp_tbl;
Did not find any relation named temp_tbl.
postgres=#
--
Chad
http://www.postgresqlforums.com/
tweak the SQL file).
--
Chad
http://www.postgresqlforums.com/
,
Live Journal, etc.).
--
Chad
http://www.postgresqlforums.com/
generator
--
Chad
http://www.postgresqlforums.com/
you. I would
suggest posting the table definition (columns indexes), the queries you
are running, and the output of EXPLAIN ANALYZE your query here;.
--
Chad
http://www.postgresqlforums.com/
On 9 Jan 2007 13:44:32 -0800, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
SELECT * FROM table WHERE thisfield = 'some text';
How would I rewrite this query to search through the table looking at
the text in the column thisfield for the string some text but have
it perform a case insensitive
I have jotted down some notes on performing a hot backup (which is what Bill
is referring you to), and I included a script called pg_hotbackup that
automates the relatively simple tasks required to take a snapshot of the
cluster data directory.
On 12/31/06, Nikola Milutinovic [EMAIL PROTECTED] wrote:
1. There is no difference (speed-wise) between committing every 1K or
every 250K rows.
It was really some time ago, since I have experimented with this. My las
experiment was on PG 7.2 or 7.3. I was inserting cca 800,000 rows.
Inserting
Thanks Martijn.
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Thanks Martijn/Alban,
This look interesting. I'll make some time to try this problem out
using your approach.
I have a few questions like:
-Could I skip the FETCH FORWARD and go straight to the FETCH BACKWARD
i.e. declare cursor to be at Mal and go backwards from there or is
the cursor limited to
Firstly thank you to all who have taken the time to reply so far.
I need to clarify a few things based on the feedback I have received.
1. I understand the concerns you have about people using internal APIs
that the developers are free to change. I also understand the risks I
take if I use an
In a word: The kind of problems people use Berkeley DB for.
People use BDB for more fine grained cursor access to BTrees. Stuff you
CANNOT do with SQL. There is a market for this. See their website. I'd
like something similar from Postgres so that the data would be stored
in a full fledged RDBMS
/warnings or is he
missing something in not understanding pg better?
Chad, could you say more about what in the BDB/API is missing and needed in
postgres?
TJ O'Donnell
http://www.gnova.com/
---(end of broadcast)---
TIP 4: Have you searched our list
Hi,
In Postgres, is there a C language API which would give me access to
BTrees like Berkeley DB does? eg to seek to a particular key/value pair
and iterate forward from there? If not whats the nearest thing to this
in Postgres?
Cheers.
---(end of
I am not concerned about Sleepycat revoking their open source license
for future versions of BDB. I am less concerned about them revoking
licenses for current and older releases. That would be impossible.
However this deal troubles me and I cant quite put my finger on why.
I'll try to tease it
Hi
all!
Who can tell me what postgres version supports
ALTER TABLE... DROP CONSTRAINT without
the need
of droping the table to remove a simple coinstraint.
(link)
\\\!/ 55
11 5080
9283
!_"""_! Elielson
Fontanezi
(O) (o) PRODAM
- Technical
here). Layer your application
properly and you can say, We think that would be a mistake, but we
can accomodate your need.
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016
from which you're
connecting. For example, if you're running the Apache server on the
same machine as the database engine, a line like:
local all trust
would suffice.
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
Eldorado Computing, Inc. 602-604-3100
5353 North 16th
, but the balance will be
zero, and the created field will have the date/time of the insert.
Mark Muffett
-crl
--
Chad R. Larson (CRL22)[EMAIL PROTECTED]
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228
45 matches
Mail list logo
