Nick wrote:
> Trying to install postgis on LINUX machine [...]
>
> during ./configure of postGIS errors out looking for geos-config
>
> during ./configure of geos errors out looking for g++
>
> to the best of my knowledge g++ is part of gcc and we have a current
> version of the gcc compiler on
Dmitry Koterov wrote:
Hello.
Is there a GUI utility to visually edit Postgres DATA (not a database
schema!), which allows at least:
- insert/update rows using screen windowed forms (possibly ugly
auto-generated forms, but - still forms)
- insert foreign key references by selecting them from a
On Mon, 28 Dec 2009 21:20:17 +0100
Ivan Sergio Borgonovo wrote:
> pg_dump -Fc -Z9 -s -t *.cache* -d mydb > schema_only.bak
> pg_dump -Fc -Z9 -T *.cache* -d mydb > nearly_full.bak
> cat nearly_full.bak schema_only.bak | pg_restore -1 -d mydb
> It seems it is working... I'll test if everything is
Thanks, but seems Lightning Admin does not support foreign keys choice (at
least, its demo version).
Any other solutions?
On Thu, Dec 31, 2009 at 10:47 AM, Tony Caduto <
tony_cad...@amsoftwaredesign.com> wrote:
> Dmitry Koterov wrote:
>
>> Hello.
>>
>> Is there a GUI utility to visually edit Post
Hello,
this fails with "duplicate key value":
CREATE TABLE x (
i INT NOT NULL UNIQUE
);
INSERT INTO x (i) VALUES (1), (2), (3);
UPDATE x SET i = i + 1;
are there any plans to make this work?
--
Roman Neuhauser
--
Sent via pgsql-general mailing list (pgsql-general@postgr
2009/12/31 neuhauser+pgsql-general#postgresql.org
:
> Hello,
>
> this fails with "duplicate key value":
>
> CREATE TABLE x (
> i INT NOT NULL UNIQUE
> );
> INSERT INTO x (i) VALUES (1), (2), (3);
> UPDATE x SET i = i + 1;
>
> are there any plans to make this work?
Sure. 8.5 (curre
On Thu, Dec 31, 2009 at 10:52:20AM +0100,
neuhauser+pgsql-general#postgresql@sigpipe.cz wrote:
> Hello,
>
> this fails with "duplicate key value":
>
> CREATE TABLE x (
> i INT NOT NULL UNIQUE
> );
> INSERT INTO x (i) VALUES (1), (2), (3);
> UPDATE x SET i = i + 1;
>
>
Hi everyone.
I am using postgresql 8.3.7 on Fedora Core 10. I have 1 table called
evaluation which contains about 1 million records, and another called
evaluationentry which contains about 9 million records.
evaluationentry.veto and evaluation.relevancedt both have indexes on
them. I have run ANAL
On 1/01/2010 12:05 AM, Chris McDonald wrote:
FOR matchRecord IN
same query as above
LOOP
RETURN NEXT matchRecord.evaluationid;
END LOOP;
And when I execute the function with the same parameters it takes well
over 5 minutes to execute.
It's as if you PREPAREd the query once, and each
Hi All -
We have 2 databases test and prod. Now they are out of sync ( of
course they will be to some extent ). But there are some functions in some
schemas. we have to sync from prod to test. What I wanted to ask, is there
any tool that you recommend for version control. Because we are
2009/12/31 akp geek :
> Hi All -
> We have 2 databases test and prod. Now they are out of sync ( of
> course they will be to some extent ). But there are some functions in some
> schemas. we have to sync from prod to test. What I wanted to ask, is there
> any tool that you recommend for v
On Thu, Dec 31, 2009 at 1:45 PM, akp geek wrote:
> Hi All -
> We have 2 databases test and prod. Now they are out of sync ( of
> course they will be to some extent ). But there are some functions in some
> schemas. we have to sync from prod to test. What I wanted to ask, is there
> any t
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> And when I execute the function with the same parameters it takes well
> over 5 minutes to execute.
>
> It seems as though inside a function, the optimizer wants to tablescan
> my 8M row table. Is there a way that I can see the query plans tha
Can't help myself, but I've used mysql in the past, and got on a list of
some sort once upon a time about that. Just received an email petition from
Monty to help save mysql. Certainly you know the story: Oracle buys Sun,
which currently owns mysql, and the little dolphin get's flushed down the
akp geek wrote on 31.12.2009 21:45:
Hi All -
We have 2 databases test and prod. Now they are out of sync (
of course they will be to some extent ). But there are some functions in
some schemas. we have to sync from prod to test. What I wanted to ask,
is there any tool that you recomme
Andrew,
I don't think it's becoming of the Postgres community to gloat about
this. Your contention that MySQL will "get flushed down the drain"
sounds almost as misguided as Monty's contention that Oracle will
divest in, and ultimately somehow "kill" MySQL as a means of cornering
the RDBMS market.
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of Peter Geoghegan
> Sent: Thursday, December 31, 2009 8:23 PM
> To: Andrew Lardinois
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Save MySQL? HA
>
> Andr
Dann Corbit wrote:
I suspect that Oracle could be interested in collection of revenue from
MySQL users who are using it commercially without a license in violation
of the current license agreement for MySQL. (Commercial use of MySQL
without paying a license fee requires that projects using the da
On Thu, Dec 31, 2009 at 7:20 PM, Andrew Lardinois wrote:
> Can't help myself, but I've used mysql in the past, and got on a list of
> some sort once upon a time about that. Just received an email petition from
> Monty to help save mysql. Certainly you know the story: Oracle buys Sun,
> which cu
On Thu, 2009-12-31 at 21:08 -0800, John R Pierce wrote:
> Dann Corbit wrote:
> > I suspect that Oracle could be interested in collection of revenue from
> > MySQL users who are using it commercially without a license in violation
> > of the current license agreement for MySQL. (Commercial use of My
Still having problems installing the geos file when trying to install
postgis...have a printout of errors we are still getting
computer/compiler/postgis info
rhel 5,
gcc-4.1.2-46el14.4.1
postgis1.4.0
below is our process and the errors we are getting, can anyone tell us
where the issue is?
[r
Dear sir,
I work as a new DBA in postgresql, please recommend some good books, website
for tutorial.
thanks
Shu
_
Hotmail: Powerful Free email with security by Microsoft.
http://clk.atdmt
Hi Tom,
I think I've confirmed the fix. Using a dirty disconnect generator, I was
able to reliably recreate the problem within about 30-60 seconds. The
symptoms were the same as before, however it occurred around SSL_write
instead of SSL_read - I assume this was due to the artificial nature of the
23 matches
Mail list logo
