Venkat Balaji wrote:
> Our problem is -
>
> We had mistakenly executed "rsync" on the running PostgreSQL data
directory (production) and we did
> not run "pg_start_backup()".
>
> Will this harm production ? can this lead to corruption ?
I assume that you used rsync to copy *from* the data direc
Hi Tuan Hoang Anh,
Are you able to bring up the cluster ??
Please let us know what problem you are facing.
Thanks
Venkat
On Tue, Sep 27, 2011 at 12:08 PM, tuanhoanganh wrote:
> I am running PostgreSQL 9.0.1 32bit on windows 2003. Last night my disk had
> some problem and i lost some file in d
In article ,
Marti Raudsepp writes:
> Ah, the reverse() function is not included with PostgreSQL 9.0 yet.
> This is what I use:
> CREATE FUNCTION reverse(input text) RETURNS text
> LANGUAGE plpgsql IMMUTABLE STRICT AS $$
> DECLARE
> result text = '';
> i int;
> BEGIN
> FOR i IN 1..length(i
On Tue, Sep 27, 2011 at 13:00, Harald Fuchs wrote:
> Pavel Stehule has found a better solution for that:
>
> CREATE OR REPLACE FUNCTION reverse(text) RETURNS text AS $$
> SELECT string_agg(substring($1 FROM i FOR 1), '')
> FROM generate_series(length($1), 1, -1) g(i)
> $$ language sql;
I don't
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Harald Fuchs
> Enviada em: terça-feira, 27 de setembro de 2011 07:01
> Para: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL] Does postgresql 9.0.4 use index on PREF
Alban, you forgot to reply to the mailing list. Please use the "reply
to all" button in your email client. :)
On Tue, Sep 27, 2011 at 14:21, Alban Hertroys wrote:
> If performance is an issue, I'd suggest coding it as a C function.
>
> A quick google search turned up:
> http://discuss.fogcreek.co
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: terça-feira, 27 de setembro de 2011 09:59
> Para: Alban Hertroys
> Cc: PG-General Mailing List
> Assunto: Re: [GENERAL] Does postgresql 9.0.4
> -Mensagem original-
> De: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] Em nome de Marti Raudsepp
> Enviada em: segunda-feira, 26 de setembro de 2011 17:42
> Para: Edson Carlos Ericksson Richter
> Cc: pgsql-general@postgresql.org
> Assunto: Re: [GENERAL
Yes, accumulative functions may be used for sorting,groupping and
merge joins with limit.
Groupping looks simplest to implement, and comparable to performance
of functional index
.
2011/9/27, Marti Raudsepp :
> 2011/9/25 pasman pasmański :
>> My english is not perfect, by accumulative i think abo
On Tue, 2011-09-27 at 12:18 +0530, Adarsh Sharma wrote:
> Dear all,
>
> I googled a lot and find data of all countries , cities ,
> location etc from Geo Spatial websites but I am able to find the data
> that shows all states & their respective capitals in world.
> Please let me know if an
On Mon, 26 Sep 2011, planas wrote:
Which version of LO are you using and which Linux? I have some experience
with using LO as a front-end when pgAdmin is not the best tool.
LO-3.4.3 on Slackware-13.1/32-bit.
I have noticed that with Ubuntu you need to use the 3.3.x series from the
reposito
Thanks for the response Laurenz. I will give it a go...
Jeff
-Original Message-
From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
Sent: Monday, September 26, 2011 7:50 AM
To: Jeff Adams *EXTERN*; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Sending Results From One Function As I
On Tue, Sep 27, 2011 at 9:15 AM, Rich Shepard wrote:
> A Google search for 'libreoffice-sdbc-postgresql' actually turns up a link
> that supposed to have a .txz version for Slackware, but the only packages on
> the site are .deb. Oh, well. I'll keep looking.
I'd recommend using JDBC ODBC driver
On Tue, 27 Sep 2011, Richard Broersma wrote:
I'd recommend using JDBC ODBC driver for PostgreSQL. Open Office via
direct JDBC has a hard time with some PostgreSQL data-types. ODBC handles
this by converting these to a text representation that Open Office can
handle.
Richard,
LibreOffice t
On Tue, 27 Sep 2011, Richard Broersma wrote:
ODBC handles this by converting these to a text representation that Open
Office can handle.
Richard,
Progress has been made. I built and installed unixODBC from
slackbuilds.org and now the hangup is identifying the location and name of
the databa
You will need to use the PostgreSQL ODBC driver. I should mention
that I haven't used ODBC from a Linux client before. I found the some
instructions in the mailing list archive:
http://archives.postgresql.org/pgsql-odbc/2002-02/msg00023.php
On Tue, Sep 27, 2011 at 11:20 AM, Rich Shepard wrote:
On 09/27/11 11:20 AM, Rich Shepard wrote:
All my postgresql databases are in /usr/local/pgsql/data/base/ in
numbered
subdirectories. I've no idea in which one resides the database I want.
Is there a way to determine where my database is located?
Eeek! you NEVER directly access the postg
/* Created by Diego Augusto Molina in 2011 for Tucuman
Government,
Argentina. */
/*
-- Execute the following accordingly to your needs.
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql';
CREATE TRUSTED PROCEDURAL LANGUAGE 'plperl';
*/
CREATE ROLE auditor NOSUPERUSER NOINHERIT
Sh*#@, the code was wrapped! if you can suggest me an external web to
host the code I can put it there and send the link.
Maybe the wiki
Nevertheless, I can't seem to publish in the wiki. I think I've
followed all the steps but still can't.
Anyway, there aren't many long-long lines, excep
2011/9/27, Diego Augusto Molina :
> Honestly, I don't remember why I used triggers instead of rules in the
> "audit" and "audet" tables.
I remember now, that's because in my case, operations over tuples are
done very lightly (one or two in the same sentence at a time). So, for
a case as such, rule
On Tue, 27 Sep 2011, John R Pierce wrote:
Eeek! you NEVER directly access the postgres data files. rather, you
connect to postgres via a socket, and ask it to fetch the data for you,
thats just how it works.
Well, when the LO odbc window asks for the location of the database to which
to con
2011/9/27 Diego Augusto Molina :
> /* Created by Diego Augusto Molina in 2011 for Tucuman
> Government,
> Argentina. */
OK, few random comments:
*) when posting schema definitions, particularly in email format, try
not to use dumped definitions from pg_dump or pgadmin. This creat
Thanks Marti for inspiration :). Monotonic functions allows to skip
some sorts in window expressions containing them:
select winfun1(...) over(order by x), winfun2(...) over(order by f(x)) from ...
2011/9/27, pasman pasmański :
> Yes, accumulative functions may be used for sorting,groupping an
Hi:
How does one make a metadata change to a DB that's actively being used.
Specifically, I want to drop a view, drop some columns from a table that's used
in the view, recreate the view without those columns.
In the past, I've resorted to connecting as a super user, running "select
procpid f
On Tue, Sep 27, 2011 at 1:51 PM, Gauthier, Dave wrote:
> How does one make a metadata change to a DB that's actively being used.
> Specifically, I want to drop a view, drop some columns from a table that's
> used in the view, recreate the view without those columns.
BEGIN TRANSACTION;
DROP VIEW
I have an application with a couple hundred views and a couple hundred
tables.
Is there some way I can find out which views have been accessed in the
last 6 months or so? Or some way to log this?
I know there are views and tables that are no longer in used by my
application and I am looking for
My application uses a bytea column to store some fairly large binary
values (hundreds of megabytes).
Recently I've run into a problem as my values start to approach the 1GB
limit on field size:
When I write a 955MB byte array from Java into my table from JDBC, the
write succeeds and the numb
the process explorer was the big help for me. what i did while the
installation was running was open up process explorer saw what it was
running and obviously figured out what it was trying to do and i just went
and manually did it myself then i'd kill the icalc.exe...after that another
one popped
On 09/28/2011 01:01 AM, David North wrote:
testdb=# select * from problem_table;
ERROR: invalid memory alloc request size 2003676411
What Pg version are you using?
On which platform?
32-bit or 64-bit OS? If 64-bit, with a 32-bit or 64-bit build of PostgreSQL?
--
Craig Ringer
--
Sent via pg
On 09/28/2011 04:51 AM, Jason Long wrote:
I have an application with a couple hundred views and a couple hundred
tables.
Is there some way I can find out which views have been accessed in the
last 6 months or so? Or some way to log this?
I know there are views and tables that are no longer in
This Link gives the capitals of all countries but I need the states and
their capitals in all these countries too..
But I think this is not possible because very few countries are divided
into states and some into cantons, county etc.
Thanks
planas wrote:
On Tue, 2011-09-27 at 12:18 +0530, A
On Wed, 2011-09-28 at 09:39 +0530, Adarsh Sharma wrote:
> This Link gives the capitals of all countries but I need the states
> and their capitals in all these countries too..
> But I think this is not possible because very few countries are
> divided into states and some into cantons, county etc.
- Original Message -
> From: "Adarsh Sharma"
>
> This Link gives the capitals of all countries but I need the states
> and their capitals in all these countries too..
> But I think this is not possible because very few countries are
> divided into states and some into cantons, county etc
On Wed, 2011-09-28 at 09:04 +0800, Craig Ringer wrote:
> On 09/28/2011 04:51 AM, Jason Long wrote:
> > I have an application with a couple hundred views and a couple hundred
> > tables.
> >
> > Is there some way I can find out which views have been accessed in the
> > last 6 months or so? Or some
34 matches
Mail list logo