w.my_table_id,
-- new.c);
--
--Apparently, "new.my_table_id" 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 <
The data that is exported from production is about 25K rows and 12MB.
The dump takes less than a
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 or
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 s
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 us
ppears to still work with 8.2.3.
--
Chad
http://www.postgresqlforums.com/
uri.diff
Description: Binary data
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
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 ch
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 wa
On 2/22/07, Martijn van Oosterhout 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 any reaso
y weak at syntax validation in it's default configuration.
--
Chad
http://www.postgresqlforums.com/
ich should be equivalent to the
xid for PostgreSQL) OR a timestamp.
--
Chad
http://www.postgresqlforums.com/
#x27;t like, and I 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, OL
p looking at SQLite, which seems to work
well enough.
--
Chad
http://www.postgresqlforums.com/
InnoDB ;), I think
that is as close as it gets.
--
Chad
http://www.postgresqlforums.com/
ays a good one as a single natural 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
and libpq.so.4 didn't link to the right
version it used libpq.so.3.
--
Chad
http://www.postgresqlforums.com/
n foo ON cal.date = foo.create_date;
Why 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/
Here 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/
007-01-25 | 2
2007-01-26 | 3
2007-01-27 | 0
2007-01-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 |
2.id
which would not result in a sort 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/
oning. I was never really impressed 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/
t
doesn't work right. I gave it a shot and there was tons of problems, 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/
not really much it can do there if don't use the right
data 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/
recall 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/
PostgreSQL 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/
n of a UUID generator
--
Chad
http://www.postgresqlforums.com/
ashdot,
Live Journal, etc.).
--
Chad
http://www.postgresqlforums.com/
he client encoding as "LATIN1", it should write a dump file
with SET client_encoding to 'LATIN1' instead of UTF8 (or you can manually
tweak the SQL file).
--
Chad
http://www.postgresqlforums.com/
INTO temp_tbl (actual_inventory_id) values
(6)"
PL/pgSQL function "test_fxn" line 6 at SQL statement
postgres=# \d temp_tbl;
Did not find any relation named "temp_tbl".
postgres=#
--
Chad
http://www.postgresqlforums.com/
one to help you. I would
suggest posting the table definition (columns & indexes), the queries you
are running, and the output of "EXPLAIN ANALYZE ;".
--
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 insensitiv
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.
http://www.postgresqlforums.com/forums/viewtopic.php
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.
Inserti
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 t
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 undo
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 b
Thanks Martijn,
This is exactly what I am looking for. I'm wondering how easy it is to
sit on top of this backend. Does anybody have any stand alone sample
code? Is it a library that can be linked or do you need to produce a
modified version of the postgres server? Can it be used in shared
library
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 broadcast)-
had's comments/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 broadca
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 ou
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
6 | 6
(6 rows)
nextval
-
8
(1 row)
---
So, no more errors from the database, but it seems to skip the "6" id
completely. Can anybody explain what I'm seeing? This is with postgresql
7.3.3.
Thanks very much in advance!
Chad
ix (replace your favorite
annoying commercial database vendor 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-310
erted rows with no nulls, 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, Suit
GDATA
directory. It should have an entry for the host 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 PROTECT
47 matches
Mail list logo
