On Wed, Sep 4, 2013 at 2:10 AM, Jeff Janes wrote:
> On Tuesday, September 3, 2013, Gregory Haase wrote:
>
>> I am working on a date-based partitioning framework and I would really
>> like to have a single function that could be used as trigger for any table
>> that needs to be partitioned by day.
On Wed, 04 Sep 2013 00:08:52 +0200
Andreas 'ads' Scherbaum wrote:
>
> PostgreSQL folks!
>
> We are looking for the next big thing. Actually, it's a bit smaller: a
> new design for mugs. So far we had big blue elephants, small blue
> elephants, frosty elephants, white SQL code on black mugs ..
Hi,
I'm on PostgreSQL 9.2.2 and trying to use no scroll cursor for some data fetch.
But when moving cursor ahead one record and the fetching the actual record the
error "cursor can only scan forward" is returned. I don't know if I'm doing
something wrong but I don't think I'm going backward with
When I use pg_restore with --clean to restore a PostgreSQL 9.2.4database
into a new, blank database it generates thousands of error messages like
this:
pg_restore: [archiver (db)] could not execute query: ERROR: schema
"myschema" does not exist
Command was: DROP INDEX myschema.some_index
On 09/04/2013 07:02 AM, Evan Martin wrote:
Also, even without --clean I get 3 errors:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 6755; 2618 4417788 RULE
geometry_columns_delete em
pg_restore: [archiver (db)] could not execute query:
Hello, everbody
I have the following problem: My vacuum is running since 2013-08-27
18:58:41.527238-03.
billing=# SELECT localtimestamp(0);
-[ RECORD 1 ]--
timestamp | 2013-09-04 11:23:06
billing=# SELECT
pg_stat_activity.procpid,pg_stat_activity.current_query,pg_stat_activity.qu
Hi Trigve,
Il 04/09/2013 15:06, Trigve Siver ha scritto:
Hi,
I'm on PostgreSQL 9.2.2 and trying to use no scroll cursor for some data fetch. But when
moving cursor ahead one record and the fetching the actual record the error "cursor
can only scan forward" is returned. I don't know if I'm doin
On 09/03/2013 04:38 PM, Gregory Haase wrote:
>
> So, my conclusion is that the generic function will work, and it will
> make administration (even automated administration) of partitioned
> tables much simpler.
>
> My question is... Is there a compelling reason why I should NOT do
> this. I must
I'm not sure I see the problem. The rule name is only unique within the
table, so it would not replace a rule on a different table (or view, as
is the case here) than the one being restored. Functions names should be
schema-qualified and if I'm restoring a function from a backup I would
want an
> From: Tom Lane
> To: Trigve Siver
> Cc: "pgsql-general@postgresql.org"
> Sent: Wednesday, September 4, 2013 7:04 PM
> Subject: Re: [GENERAL] FETCH FORWARD 0 and "cursor can only scan forward"
> error
>
>T rigve Siver writes:
>> yes I know that when specifying "FORWARD 0" that no move is
Trigve Siver writes:
> yes I know that when specifying "FORWARD 0" that no move is done and
> actual record is returned. But my question is why it is forbidden by "NO
> SCROLL"?
Because it's implemented as "back up 1 row and re-fetch".
regards, tom lane
--
Sent via pgs
Raphael Araújo e Silva escribió:
> My doubt: Is there some way to get all sequences attributes at once
> without execute repeatedly SELECT * FROM [sequence_name]?
I don't think there is, yet.
> Also, I'm wondering if there is some way to resolve a sequence OID into
> it's real representation. L
Evan Martin wrote
> When I use pg_restore with --clean to restore a PostgreSQL 9.2.4database
> into a new, blank database it generates thousands of error messages like
> this:
>
> pg_restore: [archiver (db)] could not execute query: ERROR: schema
> "myschema" does not exist
> Command was:
Evan Martin wrote
> Also, even without --clean I get 3 errors:
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 6755; 2618 4417788 RULE
> geometry_columns_delete em
> pg_restore: [archiver (db)] could not execute query: ERROR: rule
>
>
> From: Giuseppe Broccolo
>To: pgsql-general@postgresql.org
>Sent: Wednesday, September 4, 2013 6:26 PM
>Subject: Re: [GENERAL] FETCH FORWARD 0 and "cursor can only scan forward"
>error
>
>
>
>Hi Trigve,
>
>Il 04/09/2013 15:06, Trigve Siver ha scritto:
>
>Hi,
Trigve Siver wrote
> I want to iterate all records with cursor from beginning to end. This
> sample could be rewritten using FETCH FORWARD 1 ... without using MOVE but
> I'm interested with solution which throws error.
Is you interest purely academic or is there some reason you were evaluating
thi
On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wrote:
On 09/04/2013 10:13 PM, Marc Balmer wrote:
Am 04.09.13 22:02, schrieb Gavin Flower:
On 04/09/13 22:47, Eduardo Morras wrote:
On Wed, 04 Sep 2013 00:08:52 +0200
Andreas 'ads' Scherbaum wrote:
PostgreSQL folks!
We are looking for the next b
On 9/3/2013 3:08 PM, Andreas 'ads' Scherbaum wrote:
We are looking for the next big thing. Actually, it's a bit smaller: a
new design for mugs. So far we had big blue elephants, small blue
elephants, frosty elephants, white SQL code on black mugs ... Now it's
time to design something new.
Wh
Hello people.
I'm developing a reverse engineering feature for my project and I'm having
problems with sequences.
Basically, I'm trying to get sequence attributes by query
pg_catalog.pg_class as well information_schema.sequences. But in PostgreSQL
9.0 this latter table is not filled in all fields
On 9/4/13, Andreas 'ads' Scherbaum wrote:
> On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wrote:
>> On 09/04/2013 10:13 PM, Marc Balmer wrote:
>>> Am 04.09.13 22:02, schrieb Gavin Flower:
On 04/09/13 22:47, Eduardo Morras wrote:
> On Wed, 04 Sep 2013 00:08:52 +0200
> Andreas 'ads' Sche
On 04/09/13 22:47, Eduardo Morras wrote:
On Wed, 04 Sep 2013 00:08:52 +0200
Andreas 'ads' Scherbaum wrote:
PostgreSQL folks!
We are looking for the next big thing. Actually, it's a bit smaller: a
new design for mugs. So far we had big blue elephants, small blue
elephants, frosty elephants, wh
On 09/04/2013 10:55 PM, Erik Rijkers wrote:
On Wed, September 4, 2013 22:26, Andreas 'ads' Scherbaum wrote:
Do you have a cool idea? Please let us know. Either reply here or send
http://imgur.com/eMyw6
Not really new (nor my own) but I think it could work well on a black mug.
I think we a
On 05/09/13 08:40, patrick keshishian wrote:
On 9/4/13, Andreas 'ads' Scherbaum wrote:
On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wrote:
On 09/04/2013 10:13 PM, Marc Balmer wrote:
Am 04.09.13 22:02, schrieb Gavin Flower:
On 04/09/13 22:47, Eduardo Morras wrote:
On Wed, 04 Sep 2013 00:08:5
On 9/4/2013 2:59 PM, Andreas 'ads' Scherbaum wrote:
On 09/04/2013 10:55 PM, Erik Rijkers wrote:
On Wed, September 4, 2013 22:26, Andreas 'ads' Scherbaum wrote:
Do you have a cool idea? Please let us know. Either reply here or send
http://imgur.com/eMyw6
Not really new (nor my own) but I th
How about an elephant flying around Earth.
Caption: PostgreSQL - Used all around the World
On Wed, Sep 4, 2013 at 1:58 PM, Gavin Flower
wrote:
> On 05/09/13 08:40, patrick keshishian wrote:
>
> On 9/4/13, Andreas 'ads' Scherbaum
> wrote:
>
> On 09/04/2013 10:17 PM, Stefan Kaltenbrunner wro
On Wed, September 4, 2013 22:26, Andreas 'ads' Scherbaum wrote:
> Do you have a cool idea? Please let us know. Either reply here or send
http://imgur.com/eMyw6
Not really new (nor my own) but I think it could work well on a black mug.
Erik Rijkers
--
Sent via pgsql-general mailing li
On 09/04/2013 02:04 PM, Richard Sickler wrote:
How about an elephant flying around Earth.
Caption: PostgreSQL - Used all around the World
I can hear the Disney lawyers cranking up the legal machinery as we speak:)
--
Adrian Klaver
adrian.kla...@gmail.com
--
Sent via pgsql-general mailing
Hi,
Anyone has any experience of using LogStash for analysing DB server logs
real time. I used Pgbadger and find it very useful but need to test
Logstash as well.
Any link where I can find more details ?
Thanks
Hello Friends,
I want start contributing in Postgres in code level. I read some ppts and some
tutorials in postgres manual.
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
2. Query procession and possible optimizations.
3. How to
Hello Friends,
I want start contributing in Postgres in code level. I read some ppts and some
tutorials in postgres manual.
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
2. Query procession and possible optimizations.
3. How to
David Johnston yahoo.com> writes:
>
> Trigve Siver wrote
> > I want to iterate all records with cursor from beginning to end. This
> > sample could be rewritten using FETCH FORWARD 1 ... without using MOVE but
> > I'm interested with solution which throws error.
>
> Is you interest purely acade
On 9/4/2013 10:13 PM, M Tarkeshwar Rao wrote:
Can you please suggest me some links where I can learn:
1.Transaction Isolation in Database
the documentation
2.Query procession and possible optimizations.
the source code. if there were any easy optimizations, I'm sure
they've already
Read Manual First : http://www.postgresql.org/docs/9.2/static/index.html
However you should ask this in separate thread. This thread is related to :
LogStash For Analysing Postgres DB server Logs
Thanks
On Thu, Sep 5, 2013 at 10:40 AM, M Tarkeshwar Rao <
m.tarkeshwar@ericsson.com> wrote:
>
Hi all,
I have moved a lot of old records from one table say original_data_table to
another table say old_data_table which is newly created for the old records.
There were around 15 milliion old records to move. After this migration I have
done standard vacuum on new old_data_table as well as o
Hi there,
Le mercredi 04 septembre 2013 à 14:04 -0700, Richard Sickler a écrit :
> How about an elephant flying around Earth.
> Caption: PostgreSQL - Used all around the World
Why not, but I has to be at least at an orbital altitude, since
PostgreSQL is also used by some space companies, and o
35 matches
Mail list logo
