Why don't you use https://projects.commandprompt.com/public/pgcore ?
This repo provides a fonctionnal postgis rpm, and some more goodies.
If you really want to compile it yourself (bad idea, imho), you'll
need gcc-c++, and a quite a lot other packages.
Laurent.
--
Sent via pgsql-general mailing l
On Wed, 30 Dec 2009 19:39:15 -0600,
Seb wrote:
> CREATE RULE footwear_nothing_upd AS
> ON UPDATE TO footwear DO INSTEAD NOTHING;
> CREATE RULE footwear_newshoelaces_upd AS
> ON UPDATE TO footwear
> WHERE NEW.sl_name <> OLD.sl_name AND OLD.sl_name IS NULL
> DO
> INSERT INTO shoelac
Hi,
I'm trying to create a rule to be applied on update to a view that
consists of two joined tables. Table 'shoes' below is left-joined with
table 'shoelaces' in the view 'footwear'. I'd like to create a simple
update rule on the view, only if the value of a common column
corresponds to an inex
On 31/12/2009 8:51 AM, 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 s
John R Pierce wrote:
It appears you have at least one corrupt block. Where there's one,
there's often more.
I think i'd do a reindex all. and Imight even do a pg_dumpall,
re-initdb, and restore said dumpall to be safeest. to be really
safe, stop pg, and take a file system backup first,
Jeff Amiel wrote:
--- On Wed, 12/30/09, Jeff Amiel wrote:
Subject: PANIC: right sibling 2019 of block 2018 is not next child of 1937 in index
"sl_log_2_idx1"
I am assuming a re-index for that particular index will rebuild/fix the index (if it happens again). Any other thoughts?
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 list (not by typing
the ke
--- On Wed, 12/30/09, Jeff Amiel wrote:
> Subject: PANIC: right sibling 2019 of block 2018 is not next child of 1937
> in index "sl_log_2_idx1"
I am assuming a re-index for that particular index will rebuild/fix the index
(if it happens again). Any other thoughts?
--
Sent via pg
I know I don't have a lot of data right now (still looking for core dump)
Any obvious thoughts or advice until I can get more info?
Dec 30 17:41:57 db-1 postgres[28957]: [ID 748848 local0.crit] [34004622-1]
2009-12-30 17:41:57.825 CST28957PANIC: right sibling 2019 of block 2018 is
not next
On Wed, Dec 30, 2009 at 1:43 PM, APseudoUtopia wrote:
> You're correct to infer that DELETE does not support LIMIT clauses.
> The reason for this is there is no way to tell exactly which rows will
> be deleted (unless ORDER BY is used - but there are still other issues
> with that as well).
>
> Yo
On Wed, 2009-12-30 at 09:11 -0800, shulkae wrote:
> I want to delete all rows exceeding 400 hours (10 days) and I want to
> limit deletion of only 100 records at a time.
If your table has a primary key or you can contrive one, then the
DELETE FROM tbl WHERE pk in (SELECT pk FROM tbl WHERE hours>4
shulkae wrote:
DELETE from mytable WHERE (now() - timestamp_field > INTERVAL '400
hour' ) LIMIT 100;
Force of habit (not sure if the optimizer does this trick for you) is
first to rewrite this as follows:
DELETE from mytable WHERE timestamp_field < (now() - INTERVAL '400
hour' ) LIMIT
shulkae wrote:
> I am newbie to postgres/SQL.
>
> I want to delete all rows exceeding 400 hours (10 days) and I want to
> limit deletion of only 100 records at a time.
>
> I was trying the following in PostgreSQL:
>
> DELETE from mytable WHERE (now() - timestamp_field > INTERVAL '400
> hour'
On Wed, Dec 30, 2009 at 12:11 PM, shulkae wrote:
> I am newbie to postgres/SQL.
>
> I want to delete all rows exceeding 400 hours (10 days) and I want to
> limit deletion of only 100 records at a time.
>
> I was trying the following in PostgreSQL:
>
> DELETE from mytable WHERE (now() - timestamp_f
Trying to install postgis on LINUX machine, need to find the geos-
config file, as seems it is no where to be found after download of
postgis in the ./configure step, is there anyone that can give me a
clue on how to find this file? Ultimate goal is to get postgis working
so we can use geom data ty
The upgrade works, thank you all !
Gastón Quiroga
Allytech S.A.
Adrian Klaver wrote:
- "Gastón Quiroga" wrote:
Thank You Tom:
I'll Try to make an update, but the 2 fields are equals row by row,
how could I make a difference in the "WHERE" statement?
Regards
Gastón Quiroga
Allyt
ESQL = ECPG (Embedded SQL in C)
Thanks
2009/12/30 Albe Laurenz :
> svcntk wrote:
>> I'm doing a comparison between ESQL interfaces and libpq. For libp I
>> use pgbench, based on TCP-C, while for ESQL have a program that also
>> follows the transactions carried out on TCP-C.
>>
>> However, the res
I am newbie to postgres/SQL.
I want to delete all rows exceeding 400 hours (10 days) and I want to
limit deletion of only 100 records at a time.
I was trying the following in PostgreSQL:
DELETE from mytable WHERE (now() - timestamp_field > INTERVAL '400
hour' ) LIMIT 100;
Looks like DELETE syn
It seems that the process goes a little further lowering shared_buffers
but I've reached the minimum (128kB with max_connections = 2)
without reaching the end .
Are there any chances to break the 128kb limit ?
Or do I need to break this process in two smaller parts (not easy for me
) ?
The procedure is create_accessors_methods in the dbi_link package
which you can find at:
http://pgfoundry.org/projects/dbi-link/
I've slightly modified the code to adapt it better to Oracle.
Basically it is a procedure which builds a lot of views and tables based
on objects (synonyms in my case)
On 30/12/2009 6:35 PM, Nicola Farina wrote:
Hello
I am using PostgreSQL 8.3.7, compiled by Visual C++ build 1400 under
win32 on a pc with 2 gb ram.
I need to use a long running plperlu stored procedure which actually
seems to make pg consume lot of memory
till a point in which pg crashes.
Can
On Wed, Dec 30, 2009 at 09:49:52AM +0800, Premila Devi wrote:
>I am having problem as :
>
>
>
>Caused by: org.springframework.transaction.TransactionSystemException:
>Could not roll back Hibernate transaction; nested exception is
>org.hibernate.TransactionException: JDBC roll
svcntk wrote:
> ESQL = ECPG (Embedded SQL in C)
>
>>> I'm doing a comparison between ESQL interfaces and libpq. For libp I
>>> use pgbench, based on TCP-C, while for ESQL have a program that also
>>> follows the transactions carried out on TCP-C.
>>>
>>> However, the result with libpq is much bett
Hello
I am using PostgreSQL 8.3.7, compiled by Visual C++ build 1400 under
win32 on a pc with 2 gb ram.
I need to use a long running plperlu stored procedure which actually
seems to make pg consume lot of memory
till a point in which pg crashes.
I have a log with these messages:
<<
Out of m
svcntk wrote:
> I'm doing a comparison between ESQL interfaces and libpq. For libp I
> use pgbench, based on TCP-C, while for ESQL have a program that also
> follows the transactions carried out on TCP-C.
>
> However, the result with libpq is much better, with about 700
> transactions per second,
On Tue, 2009-12-29 at 17:22 -0800, Nick wrote:
>
> More info did a
>
> rpm -qa | grep gcc
>
> and gave me
>
> gcc-4.1.2-46el14.4.1
>
> Thinking was that this included the g++, is that not the case? Or do
> we need a version gcc-c++?
Did you read the previous e-mails? I remember at least 2 re
Le 29/12/2009 21:21, akp geek a écrit :
> thanks for the repsonse. I appreciate it. are there any limitations on using
> this one? Means that we have to the same user on both databases and same
> passwords.
>
> I have used the command following way
>
> check_postgres.pl --action=same_schema -H
27 matches
Mail list logo
