On 11/3/06, Shane Ambler <[EMAIL PROTECTED]> wrote:
Mike G wrote:> I have noticed that in the event logs that I am again seeing errors about the renaming:> LOG: could not rename file> "pg_xlog/000100690021" to "pg_xlog/000100690030" continuing to try
Sounds to me like it mig
Jeff Davis <[EMAIL PROTECTED]> writes:
> On Mon, 2006-11-06 at 16:40 -0800, Matthew Peter wrote:
>> v_value text := null;
>> -- ^^^ right here, NULL makes the querystring fail by setting cmd =
>> null
>> BEGIN
>> cmd := 'INSERT INTO test (
>> col
>> ) values ( '
>> || quote_literal(v_value) || ');
Dev--> The site which u sent has postgis rpm which need
postgres-8.1.3 ... and i cant find RPMS for postgres-8.1.3 ...anywhere
??
what version of Postgis should i install for Postgres-8.1.5 ??
And where can i find its RPM for RHEL 4 -AS ...???
Thanks in advance
-
sandeep
On 11/7/06, Paul Ra
what version of Postgis should i install for Postgres-8.1.5 ??
And where can i find its RPM for RHEL 4 -AS ...???
Thanks in advance
-- Sandeep Kumar Jakkaraju WeBlog:http://jakkarajus.blogspot.com
I assume you've seen pl/R?
http://www.joeconway.com/plr/
On Mon, 6 Nov 2006, Reece Hart wrote:
I'd like to get R to talk to postgresql, but my head's spinning among a
web of broken links, way outdated web pages, project deprecation
announcements and a terrible signal:link ratio.
Rdbi and Rdbi
On Monday 06 November 2006 07:38 pm, Reece Hart wrote:
> On Mon, 2006-11-06 at 19:13 -0800, Adrian Klaver wrote:
> > You might want to take a look at PL/R a procedural language for R in
> > Postgres.
> > http://www.joeconway.com/plr/
>
> PL/R is indeed neat, but I want to go the other way: within R
On Mon, 2006-11-06 at 16:43 -0800, Jeff Davis wrote:
You can use "ALTER DATABASE name RENAME TO newname;". Does that help?
This is what I do now to evolve from development to staging to production, as well as to deprecate versions. That indeed solves most of the problem.
Aliases might s
On Mon, 2006-11-06 at 19:13 -0800, Adrian Klaver wrote:
You might want to take a look at PL/R a procedural language for R in Postgres.
http://www.joeconway.com/plr/
PL/R is indeed neat, but I want to go the other way: within R, fetch data from postgres and manipulate it (plot, histo
On Monday 06 November 2006 04:58 pm, Reece Hart wrote:
> I'd like to get R to talk to postgresql, but my head's spinning among a
> web of broken links, way outdated web pages, project deprecation
> announcements and a terrible signal:link ratio.
>
> Rdbi and RdbiPgSQL seem to be the answer, despite
Dear Richard,
Regarding the information you give to me, I understand that this information is a thing that normally used by PostgreSQL system. And the information seem to be placed on a comment area. So, Who need to have a clearly understanding on the header information?
Thank you
>>> Rich
Hi Mathew,whats happening here in your case is that when you
use the concatenation operator || and an element in your command is
NULL the whole concat chain ends up being NULL so the execute command
runs as
EXECUTE NULLwhat you can do is to write your command as such:cmd := 'INSERT INTO test (
On Mon, 2006-11-06 at 16:40 -0800, Matthew Peter wrote:
> create table test (col text);
> create or replace function tester() RETURNS void AS $$
> DECLARE
> cmd text;
> v_value text := null;
> -- ^^^ right here, NULL makes the querystring fail by
> setting cmd =
> null
> B
I'd like to get R to talk to postgresql, but my head's spinning among a web of broken links, way outdated web pages, project deprecation announcements and a terrible signal:link ratio.
Rdbi and RdbiPgSQL seem to be the answer, despite both being apparently defunct projects.
What is the Right
On Mon, 2006-11-06 at 16:29 -0800, Reece Hart wrote:
> On Tue, 2006-11-07 at 04:54 +0500, Talha Khan wrote:
> > You can do this by using a script. I mean whenever you are creating
> > a new version of the database. you can do that by running a script
> > that creates a database and then stores the
On Nov 6, 2006, at 19:29 , Reece Hart wrote: On Tue, 2006-11-07 at 04:54 +0500, Talha Khan wrote: You can do this by using a script. I mean whenever you are creating a new version of the database. you can do that by running a script that creates a database and then stores the name of that dat
create table test (col text);
create or replace function tester() RETURNS void AS $$
DECLARE
cmd text;
v_value text := null;
-- ^^^ right here, NULL makes the querystring fail by setting
cmd =
null
BEGIN
cmd := 'INSERT INTO test (
col
) values ( '
On Tue, 2006-11-07 at 04:54 +0500, Talha Khan wrote:
You can do this by using a script. I mean whenever you are creating a new version of the database. you can do that by running a script that creates a database and then stores the name of that database in an environmental variable . Now
Hi Reece,You can do this by using a script. I mean whenever you are creating a new version of the database. you can do that by running a script that creates a database and then stores the name of that database in an environmental variable . Now you can run psql by connecting to a database through
I'd like to be able to have several versions of a database available concurrently and one database alias that refers to the most recent of these. For example:
dbname_1-1
dbname_1-2
dbname_1-3
dbname -> dbname_1-3
and
$ psql -d dbname
would connect to dbname_1-3.
Any ideas?
Thanks,
Reece
On Mon, 2006-06-11 at 22:27 +0100, Alexander Staubo wrote:
> On Nov 6, 2006, at 21:00 , Marc Munro wrote:
>
> > For an alternative approach, you might want to check out Veil:
> > http://pgfoundry.org/projects/veil
>
> Addendum: I took Veil to be undocumented since the source archive
> only come
On Nov 6, 2006, at 21:00 , Marc Munro wrote:
For an alternative approach, you might want to check out Veil:
http://pgfoundry.org/projects/veil
Addendum: I took Veil to be undocumented since the source archive
only comes with Doxygen scripts; I thought the small "here" link on
the Veil home
On Nov 6, 2006, at 21:00 , Marc Munro wrote:
A fairly cursory look at your proposed model suggests that it will
work,
but is likely to have serious performance problems. The issue is
not so
much the simple queries on single views, but the complex queries your
developers will almost certainl
On 11/6/06, Alain Roger <[EMAIL PROTECTED]> wrote:
Hi,
Finally, i've come to the following solution for my stored procedure :
---
-- Function: "SP_U_001"("TypeOfArticle" "varchar")
-- DROP FUNCTION "SP_U_001"("TypeOfArticle" "varchar");
CREATE OR REPLACE FUNCTIO
Hi,Finally, i've come to the following solution for my stored procedure :- Function: "SP_U_001"("TypeOfArticle" "varchar")-- DROP FUNCTION "SP_U_001"("TypeOfArticle" "varchar");
CREATE OR REPLACE FUNCTION "SP_U_001"("TypeOfArticle" "varchar") RETURNS SETOF activ
Tom Lane wrote:
meltedown <[EMAIL PROTECTED]> writes:
Short version: I'm trying to turn a unix timestamp into a psql
timestamp, but there is a 5 hour difference. Is this because of
timezones ? Can I just subtract 5 hours to get the right value ?
"select timestamp '1970-01-01' + interval '$sta
On Nov 6, 2006, at 5:59 , Ben wrote:
Hello Folks,
i've been a postgresql user for a lot of years, mainly using it on
common x86 hw; now for a personal project of mine i wish to know your
opinion on porting it on an embedded platform.
I'm currently using PostgreSQL in my home automation project
--- Richard Huxton wrote:
> Matthew Peter wrote:
> > I have DB1 and DB2 pg_databases... I then have a function in DB2 that
> > wants some results from DB1, is it possible to query another db? Like
> > how \! lets you hit the command line... but I need it in plpgsql if
> > possible.
>
> Look into
On Sat, 2006-04-11 at 06:13 -0400, [EMAIL PROTECTED]
wrote:
> Date: Fri, 3 Nov 2006 23:08:47 +0100
> From: Alexander Staubo <[EMAIL PROTECTED]>
> To: PgSQL General
> Subject: Per-row security
> Message-ID: <[EMAIL PROTECTED]>
>
> I am designing an application which requires fine-grained role-base
Any one you want. Using the latest won't hurt.On 6-Nov-06, at 11:36 AM, Sandeep Kumar Jakkaraju wrote:What version of Postgis should i install for postgres 8.1.5 ??On 11/7/06, Paul Ramsey <[EMAIL PROTECTED] > wrote:PgSQL 7.4 is still supported by the latest PostGIS versions.As is PgSQL 8.1 and (wh
Hi,Before (in version 8.0.1), i did the following thing and it was working well...now (in version 8.1.4) it seems that it does not work anymore...problem is with FOR rec IN loop...So how can i tell "FOR all RECORDS from select * from articles, articletypes, department where ..." LOOP ... ?
thanks,A
What version of Postgis should i install for postgres 8.1.5 ??On 11/7/06, Paul Ramsey <[EMAIL PROTECTED]
> wrote:PgSQL 7.4 is still supported by the latest PostGIS versions.As is PgSQL
8.1 and (when it comes) 8.2.POn 6-Nov-06, at 8:07 AM, Joshua D. Drake wrote:> Kumar Jakkaraju wrote:>> Ya...
PgSQL 7.4 is still supported by the latest PostGIS versions.
As is PgSQL 8.1 and (when it comes) 8.2.
P
On 6-Nov-06, at 8:07 AM, Joshua D. Drake wrote:
Sandeep Kumar Jakkaraju wrote:
Ya...
That was my next question ...
if i build the source (the tar.gz) on the postgis.org site ..
will it be
Hi,How to retrieve the IN parameter of a function for later use ?i tried this :CREATE OR REPLACE FUNCTION "public"."SP_U_001" ("TypeOfArticle" varchar) RETURNS SETOF "public"."active_articles" AS
$body$DECLARE TypeArt VARCHAR := TypeOfArticle; rec RECORD; res active_articles;/***
How to force server to accept only strong passwords:
At least 6 characters, must contain one digit, one upper and one lowercase
letter ?
Andrus.
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.post
meltedown <[EMAIL PROTECTED]> writes:
> Short version: I'm trying to turn a unix timestamp into a psql
> timestamp, but there is a 5 hour difference. Is this because of
> timezones ? Can I just subtract 5 hours to get the right value ?
> "select timestamp '1970-01-01' + interval '$startofday sec
On Mon, Nov 06, 2006 at 03:30:35PM +, meltedown wrote:
> Short version: I'm trying to turn a unix timestamp into a psql
> timestamp, but there is a 5 hour difference. Is this because of
> timezones ? Can I just subtract 5 hours to get the right value ?
Not sure what you're using, but by my c
cvs HEAD does this to me when I try to initdb:
[EMAIL PROTECTED]:~$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale e
Short version: I'm trying to turn a unix timestamp into a psql
timestamp, but there is a 5 hour difference. Is this because of
timezones ? Can I just subtract 5 hours to get the right value ?
Detailed version:
I start with a unix timestamp:
$startofday =1162789200;
Which has this date:
Array
(
Hello Folks,
i've been a postgresql user for a lot of years, mainly using it on
common x86 hw; now for a personal project of mine i wish to know your
opinion on porting it on an embedded platform.
I'm currently using PostgreSQL in my home automation project (x86
platform) not for storing huge amoun
Cool!
That explains it fully. So i guess there will be a better performance
to the pre-generated views at the price of more views.
Thanks!
On 11/6/06, Merlin Moncure <[EMAIL PROTECTED]> wrote:
On 11/6/06, Just Someone <[EMAIL PROTECTED]> wrote:
> I have a database with multiple schemas all wit
* Richard Huxton:
> I take it SELECT DISTINCT bar... shows the same problem?
SELECT bar FROM baz does *not* show the duplicate row.
> If so, can you do:
> SELECT OID,xmin,cmin,xmax,cmax,bar FROM baz
> WHERE bar =
Even if I force a complete index scan, I get xmin = 1007617 for both
rows, the
Have you checked your webserver error logs?
On Mon, 6 Nov 2006, Desmond Coughlan wrote:
X-No-Archive: true
Hi,
I'm sure that it's a typo or something, but as I'm getting into PhP and
PostgreSQL for the first time, I can't be sure.
I have a db, called 'cdi' ..
A 'SELECT * FROM stock;' ge
* Tom Lane:
>> According to EXPLAIN, an index scan on the bar column is used (using
>> the underlying B-tree index).
>
> Do you mean an indexscan followed immediately by a Unique node? If
> so, yeah, that would depend entirely on correct ordering of the
> indexscan output to produce distinct resu
On 11/6/06, Just Someone <[EMAIL PROTECTED]> wrote:
I have a database with multiple schemas all with the same structure
(but of course different data...).
I want to create a view that will be created in a shared schema, and
when executed will be executed against the current schema. Whenever I
tr
2006/11/6, Just Someone <[EMAIL PROTECTED]>:
I have a database with multiple schemas all with the same structure(but of course different data...).I want to create a view that will be created in a shared schema, andwhen executed will be executed against the current schema. Whenever I
try it, it seem
Sandeep Kumar Jakkaraju wrote:
> Ya...
>
> That was my next question ...
> if i build the source (the tar.gz) on the postgis.org site ..
> will it be compatible with... postgres-8.1.5
Probably not. You will need a postgis version for 7.4.
Joshua D. Drake
>
> Thanks
> Regards
> Sandeep
>
>
>
I have a database with multiple schemas all with the same structure
(but of course different data...).
I want to create a view that will be created in a shared schema, and
when executed will be executed against the current schema. Whenever I
try it, it seems the view is linked to a specific schem
Ya...That was my next question ... if i build the source (the tar.gz) on the postgis.org site ..will it be compatible with... postgres-8.1.5ThanksRegardsSandeep
On 11/6/06, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
Hi,On Mon, 2006-11-06 at 21:04 +0530, Sandeep Kumar Jakkaraju wrote:> The site u gave
Hi,
On Mon, 2006-11-06 at 21:04 +0530, Sandeep Kumar Jakkaraju wrote:
> The site u gave me has ..
> has postgis rpm ..but it needs postgres-7.4 !! i need
> postgis rpm for postgres-8.1.5
So use the SRPMs to build RPMs for you. I don't have 7.4+RHEL4 around to
build you an RPM for that. :(
Hi Dev,The site u gave me has ..has postgis rpm ..but it needs postgres-7.4 !! i need postgis rpm for postgres-8.1.5ThankssandeepOn 11/4/06,
Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
Hello,On Sat, 2006-11-04 at 13:21 +0530, Sandeep Kumar Jakkaraju wrote:> I am unable to find PostGIS Binary RPM
On 11/6/06, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> check out dblink contrib module for starters. Maybe take a look at
> pl/sh, which looks pretty neat.
Is there really such a thing as PL/SH? or are you refering to piping sql
queries into psql?
http://plsh.projects.postgresql.org/
> check out dblink contrib module for starters. Maybe take a look at
> pl/sh, which looks pretty neat.
Is there really such a thing as PL/SH? or are you refering to piping sql
queries into psql?
Regards,
Richard Broersma Jr.
---(end of broadcast)--
Florian Weimer <[EMAIL PROTECTED]> writes:
> I run this innocent query
> CREATE TABLE foo AS SELECT DISTINCT bar FROM baz ORDER BY bar;
> and the resulting table contains duplicate rows. 8-(
> According to EXPLAIN, an index scan on the bar column is used (using
> the underlying B-tree index).
Do
Desmond Coughlan wrote:
Firstly, rewrite this as
$sql = "SELECT * FROM stock";
$res = pg_query($sql);
echo "pg_query($sql) = $res";
echo "num rows = ".pg_num_rows($res)."";
// start the output
while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) {
echo "Title: ".$row['isbn_no'].
Florian Weimer wrote:
I run this innocent query
CREATE TABLE foo AS SELECT DISTINCT bar FROM baz ORDER BY bar;
and the resulting table contains duplicate rows. 8-(
According to EXPLAIN, an index scan on the bar column is used (using
the underlying B-tree index). This is with PostgreSQL 8.1.4
On 11/6/06, Matthew Peter <[EMAIL PROTECTED]> wrote:
I have DB1 and DB2 pg_databases... I then have a function in DB2 that wants
some results from DB1, is it possible to query another db? Like how \! lets
you hit the command line... but I need it in plpgsql if possible.
Also, I know functions a
# [EMAIL PROTECTED] / 2006-11-06 12:26:43 +0100:
> On Sun, 05 Nov 2006, CSN wrote:
>
> > Anybody know of a script that dumps all databases into
> > corresponding dump files
>
> I've written this one in bash:
>
> #
> #!/bin/bash
>
> pg_dump
# [EMAIL PROTECTED] / 2006-11-06 15:05:25 +0100:
> I'm sure that it's a typo or something, but as I'm getting into PhP
> and PostgreSQL for the first time, I can't be sure.
> pg_connect ("dbname=cdi user=cdi password=toto") or die
> ("Couldn't Connect: ".pg_last_error());
> $query="SELECT
I run this innocent query
CREATE TABLE foo AS SELECT DISTINCT bar FROM baz ORDER BY bar;
and the resulting table contains duplicate rows. 8-(
According to EXPLAIN, an index scan on the bar column is used (using
the underlying B-tree index). This is with PostgreSQL 8.1.4 (Debian
package 8.1.4-6)
In response to Desmond Coughlan <[EMAIL PROTECTED]>:
> X-No-Archive: true
X-WTF: huh?
[snip]
> I copy that file to my apache server, in php_experimental/base.php
> and access it via a browser.
>
> I don't get an error message. I instead get a blank page.
Check the applicable php.ini fo
X-No-Archive: true Hi, I'm sure that it's a typo or something, but as I'm getting into PhP and PostgreSQL for the first time, I can't be sure. I have a db, called 'cdi' .. A 'SELECT * FROM stock;' gets me this in psql .. cdi=> SELECT * from stock ;-[ RECORD 1 ]-+-
surabhi.ahuja wrote:
Answer to Question 1:
I forgot to mention this: before i start running this program (refer
to the mail below) I clean up (rm -rf) and create the data directory
(PGDATA, by doing initdb) then i create the 4 tables (stored
procedures etc)
and then run the program Please see t
Title: Re: [GENERAL] postmaster slowing down
Answer to Question
1:
I forgot to mention
this:
before i start running this program
(refer to the mail below)
I clean up (rm -rf) and create the data directory (PGDATA, by doing
initdb)
then i create the 4 tables (stored procedures etc)
an
On Sun, 05 Nov 2006, CSN wrote:
> Anybody know of a script that dumps all databases into
> corresponding dump files
I've written this one in bash:
#
#!/bin/bash
pg_dumpall -g > /var/lib/pgsql/backups/globals.sql
for dbname in `psql -qXtc "
am Mon, dem 06.11.2006, um 12:16:08 +0100 mailte Sandro Dentella folgendes:
> > >Is there any possibility to call a table or a column with different
> > > names
> > >-sort of a symbolic link?
> >
> > Yes, you can create VIEWS.
>
> I think I cannot UPDATE or INSERT into a view, is that c
am Mon, dem 06.11.2006, um 11:45:28 +0100 mailte Sandro Dentella folgendes:
> Hi,
>
>I'm migrating a system from php/mysql to django/postgresql. I'd like to
>change the names of columns and tables but I need to retain the old ones
>for compatibility issues (it must still work with the
Sandro Dentella wrote:
Hi,
I'm migrating a system from php/mysql to django/postgresql. I'd like to
change the names of columns and tables but I need to retain the old ones
for compatibility issues (it must still work with the old interface).
Is there any possibility to call a table
surabhi.ahuja wrote:
I am using postgres 8.0.0
In my program I have a single connection to a database.
in side this connection i do the following
1. begin transaction
2. insert rows to table/s. (max number of tables = 4)
3. commit transaction
the above 3 steps take place around 800, 000 time
Hi,
I'm migrating a system from php/mysql to django/postgresql. I'd like to
change the names of columns and tables but I need to retain the old ones
for compatibility issues (it must still work with the old interface).
Is there any possibility to call a table or a column with differen
Title: Re: [GENERAL] upgrade to 8.0.9
I am using postgres
8.0.0
In my program I have a
single connection to a database.
in side this connection i do the
following
1. begin transaction
2. insert rows to table/s. (max number of
tables = 4)
3. commit transaction
the above 3 steps take pl
> I have a postgreSQL database in UNICODE (UTF-8 in v8.1.4 and
> UNICODE in v8.0.1).
>
> Via my web application i type a sentence in Slovak language
> and it is stored into DB without any slovak characters.
> Instead of that, all particular characters are replace with
> \303\251 or \303\206 or
> I am currently using 8.0.0 and I want to upgrade to 8.0.9
> Please tell if i can just install the rpms for 8.0.9
>
> Will I not have to rebuild my application with new libpq.so?
> or does the libpq.so still remain the same.
If you linked dynamically, your program should be able to work with
th
Premsun Choltanwanich wrote:
Dear All,
I had open the backup file of PostgreSQL created by pg_dump command. I found
that pg_dump make a comment line as header for each module it backup. I try to
understand the meaning of value contained on header for my sample header
--
-- TOC entry 1427 (
Tsakiridis Orestis wrote:
Hi,
I'm looking for a way to monitor all the queries that are executed by
the server and to be able, by using these queries, to reproduce the
data in all databases.
Beware - query shipping runs into problems with
DELETE FROM my_table WHERE ts < now()
> The idea is
Matthew Peter wrote:
I have DB1 and DB2 pg_databases... I then have a function in DB2 that
wants some results from DB1, is it possible to query another db? Like
how \! lets you hit the command line... but I need it in plpgsql if
possible.
Look into the db_link or dbi_link packages. These are ex
I have DB1 and DB2 pg_databases... I then have a function in DB2 that wants some results from DB1, is it possible to query another db? Like how \! lets you hit the command line... but I need it in plpgsql if possible.Also, I know functions are local to db (unless it inserted into template1 prior to
Hi,
I'm looking for a way to monitor all the queries that are executed by the
server and to be able, by using these queries, to reproduce the data in all
databases. The idea is to periodicaly (e.g. every two minutes) store the newly
executed queries in a sort of wal segment file. I first tried
77 matches
Mail list logo
