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
On 2/24/07, Matthew Peter <[EMAIL PROTECTED]> wrote:
I was wondering if anyone new how to get this package to install for 8.2.3?
When I try to install it I get:
ERROR: incompatible library "/usr/lib/pgsql/uri.so": missing magic block
HINT: Extension libraries are required to use the PG_MODULE_
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
On 2/20/07, gustavo halperin <[EMAIL PROTECTED]> wrote:
I have a friend that ask me why postgresql is better than mysql.
I personally prefer posgresql, but she need to give in her work 3 or 4
strong reasons for that. I mean not to much technical reasons. Can you
give help me please ?
How abo
On 2/15/07, RPK <[EMAIL PROTECTED]> wrote:
Is there any option in PGSQL to undo last changes done on a table? Any
feature similar to "FlashBack Query" in Oracle.
The only way I could imagine that you could implement a flashback query in
PostgreSQL is if you ignored everyone's advice and didn'
On 2/8/07, Clodoaldo <[EMAIL PROTECTED]> wrote:
Use pg_dump to dump the db and use iconv on the generated file:
iconv -f ASCII -t UTF-8 mydb.dump -o mydb_utf8.dump
Wouldn't it be adequate to set the client encoding to SQL_ASCII in the dump
file (if that was infact the encoding on the origina
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
On 2/1/07, RPK <[EMAIL PROTECTED]> wrote:
How is FireBird rated when compared with PostgreSQL?
I don't know how it is rated, but honestly I looked at Firebird and it is
way too "quirky" and I could never get it to compile embedded. The
documentation is very very poor for that project when it
On 1/29/07, Ray Stell <[EMAIL PROTECTED]> wrote:
That said, probably, lasts gasps from a legacy system. I'm wondering
when ora will open up its code ala sun/solaris.
According to a recent Gartner study, Oracle has 48% market share (in other
words they are the market leader by a margin of 26%
On 1/28/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
This is the great synthetic-vs-natural key debate.
Truly. But what the heck!
Surrogate keys are not evil, and they do have value. I see no value in
proclaiming "surrogate keys are evil, do not use them".
Surrogate keys do have advantages:
On 1/24/07, Rich Shepard <[EMAIL PROTECTED]> wrote:
libpq.so.3 => /usr/lib/libpq.so.3 (0xb7f5f000)
So it's finding all the libraries it wants, and it's using the older
libpq.so. Interesting.
Where is your other installation of PostgreSQL installed? I suspect this is
because somewhe
On 1/23/07, Jorge Godoy <[EMAIL PROTECTED]> wrote:
> select cal.date, coalesce(foo.x, 0) AS x
> from (select (date_trunc('day', current_timestamp) + (s.s * interval '1
> day'))::date AS date
> from generate_series(1,365) AS s) AS cal
> left join foo ON cal.date = foo.create_date;
Why
On 1/22/07, Laurent Manchon <[EMAIL PROTECTED]> wrote:
I have a slow response of my PostgreSQL database 7.4 using this query
below
on a table with 80 rows:
select count(*)from tbl;
PostgreSQL return result in 28 sec every time.
although MS-SQL return result in 0.02 sec every time.
Here
On 1/22/07, deepak pal <[EMAIL PROTECTED]> wrote:
i am fatching record's from data base between two date range for
registration_date coloum and than group by an count it using
count(registration_date) i have to show all dates even if date is not there
in registration_date ,it should show date an
On 1/22/07, Harald Armin Massa <[EMAIL PROTECTED]> wrote:
>> select * from table where table_id in (?, ?, ?, ?, ?, ?, ?, ...)
>
>
I usually try to rewrite this kind of queries to
select whatever from table t1 join
(select table_id from x where x) t2 using (table_id)
And 3 out of 4 this
On 21 Jan 2007 08:01:57 -0800, Shashank <[EMAIL PROTECTED]> wrote:
> It seems MySQL just dropped the ball on
> the free version of their product, and it
Not sure what you mean. I can download their latest versions without
any trouble.
The point was they are not going to the effort to roll bi
On 1/20/07, John Meyer <[EMAIL PROTECTED]> wrote:
What I think bothers me is this whole concept that if PostgreSQL is to
flourish, MySQL has to be beaten down. Folks, both products are free,
both can be used in the same shop (maybe not on the same computer if
your running them in production).
On 1/18/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
> Right. In my case I have bad data from a source I didn't control,
exported
> via code that I do control which happens to output -MM-DD. Well,
except
> that I don't do what I need to when MM or DD are more than 2 digits, but
I'm
> going bac
On 1/17/07, Jan Mura <[EMAIL PROTECTED]> wrote:
I would like to ask if there is a genral concept of creating web pages
using
a database and PHP or another scripting language.
What I mean is to store basic entities and relations between pages. Only
the
certain texts or information regarding ever
On 1/17/07, Patrick Earl <[EMAIL PROTECTED]> wrote:
Certainly support for the GUID field type itself is most important.
As for the generators, though they are non-essential, they are very
useful. Other platforms and libraries have standardized on uuid
generators, so I don't see why PostgreSQL c
On 1/16/07, David Lee Lambert <[EMAIL PROTECTED]> wrote:
The problem with a random UUID generator is: where do you get the random
numbers? However, there are really only two platforms to worry about:
POSIX (use libuuid) and Win32 (there is probably a Win32 function to
generate
it, since MS S
On 1/16/07, Thorsten Körner <[EMAIL PROTECTED]> wrote:
The projects Website is a very high traffic site, with about 500 Pi /
sec. we
are facing performance trouble, when using just one server.
Searches etc. we have implemented using lucene on our backend servers, to
keep
the database alive, but
On 1/16/07, Gary Benade <[EMAIL PROTECTED]> wrote:
I used shp2pgsql.exe to create an import sql for my gis database.
The resultant sql has data like this in it.INSERT INTO "gis"."sa_area"
("label","type","level",the_geom) VALUES
('MÔRELIG','0x2','2','01060001000');
The Ô is ascii char 21
It appears that what is happening is PL/pgSQL is caching the table
definition (it appears to do this on first execution), testing it with
dynamic SQL via the EXECUTE clause doesn't exhibit the same issue:
CREATE OR REPLACE FUNCTION test_fxn() RETURNS SETOF RECORD AS $$
DECLARE
test_rec RECORD;
On 1/15/07, carter ck <[EMAIL PROTECTED]> wrote:
I am having slow performance issue when querying a table that contains
more
than 1 records.
Everything just slow down when executing a query though I have created
Index
on it.
You didn't really provide much information for anyone to help y
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
31 matches
Mail list logo