Hi,
When I initialize database, pg_xlog direcory takes almost 17 MB size
Why pg_xlog/WAL takes 17 MB of size while there is no transaction
occurred ?
What is the content of pg_xlog , If it's only wal file it's must be
blank after on write of transaction on database.
regards,
Siddha
Hi,
PostgreSQL 8.1.11
I have created a function that works fine when run for the first time after
that it gives an error until I open another Query window.
The function is as follows
///
CREATE OR REPLACE FUNCTION func_snappointtonetwork(p_pointtobesnapped
"varcha
am Tue, dem 02.12.2008, um 11:11:44 + mailte Wajid Khattak folgendes:
> Hi,
>
> PostgreSQL 8.1.11
>
> I have created a function that works fine when run for the first time after
> that it gives an error until I open another Query window.
Use EXECUTE for DDL-Statements, for instance, creat
Matthew Wilson wrote:
> I have a table shift with a start_time column and a stop_time column and
> I do a lot of queries like:
>
> select * from shift
> where (start_time, stop_time) overlaps ($A, $B);
>
> $A and $B are user-submitted values.
>
> Anyhow, how do I put indexes on my table
Grzegorz Jaśkiewicz wrote:
> hey folks,
>
> browsing psql source,I came across one of the variations of \list / -l
> option, that could also print database size, which would be quite nice. But
> that only seem to work in 'verbose' mode. Now, how can I turn that mode on
> on command line, psql -lv
Richard Huxton wrote:
Siddharth Shah wrote:
Hi,
When I initialize database, pg_xlog direcory takes almost 17 MB size
Why pg_xlog/WAL takes 17 MB of size while there is no transaction
occurred ?
What is the content of pg_xlog , If it's only wal file it's must be
blank after on write
I have certain jobs to be executed automatically at a given interval of time in the postgre SQL database. Is their any utility/feature available in Postgre to do so.with regards, I.P.S. Sethi
On Mon, 2008-12-01 at 22:51 -0500, justin wrote:
> On idiotic benchmark comparisons "Try to carry 500 people from Los
> Angeles to Tokyo in an F-15. No? Try to win a dogfight in a 747. No?
> But they both fly, so it must be useful to compare them... especially
> on the basis of the most simplisti
On Tue, Dec 2, 2008 at 9:51 AM, Picavet Vincent <
[EMAIL PROTECTED]> wrote:
>
> That seems to be kind of a joke, but I heard that the french CNES (spatial
> agency) is doing some huge database replication between two sites thanks to
> big trucks carrying the data once a month, because current netw
Michael Meier wrote:
> Hi,
>
> I am in the process of designing a distributed application (Java EE 5)
> which has demand for database functionality at several points. Some of
> these databases need to provide really mission critical reliability,
> i.e. it would be the end of our world, if we would
Siddharth Shah wrote:
>I am not using wall based replication ? I no not have frequent & long
> transaction , need of checkpoints
> Just want to get what data resides in pg_xlog that it takes 16MB without
> any transactions.
The files are created 16MB long, it is faster to overwrite that than t
am Tue, dem 02.12.2008, um 16:45:16 +0500 mailte IPS folgendes:
> I have certain jobs to be executed automatically at a given interval of time
> in the postgre SQL database. Is their any utility/feature available in Postgre
> to do so.
No, use the scheduler from the OS, CRON for example (UNIX).
am Tue, dem 02.12.2008, um 12:36:26 + mailte Wajid Khattak folgendes:
> Thank for your reply.
>
> Could you please elaborate it a little bit further by referring to the
> fucntion as I am quite new to Postgres.
Sure, read the doku:
http://www.postgresql.org/docs/current/static/plpgsql-stat
Sebastian Tennant wrote:
> Quoth Alvaro Herrera <[EMAIL PROTECTED]>:
> > Sebastian Tennant wrote:
> >
> >> P.S. Emacs users of PostgreSQL might like to know that there's a
> >> texinfo version of the manual (version 8.3.3) available for
> >> download from here:
> >>
> >> http:
iconv -f windows-1251 -t utf-8 bulgarian.dic >bulgarian_utf8.dict
iconv -f windows-1251 -t utf-8 bulgarian.aff >bulgarian_utf8.affix
The locale of the database is fr_FR, and its encoding is UTF8.
I believe that characters 'И', 'А' (non-ascii) and other cyrillic ones are not
acceptable for frenc
On Tue, Dec 2, 2008 at 11:40 AM, Richard Huxton <[EMAIL PROTECTED]> wrote:
> Is \l+ what you mean?
same thing but from command line ?
not the shell
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailp
Teodor Sigaev a écrit :
iconv -f windows-1251 -t utf-8 bulgarian.dic >bulgarian_utf8.dict
iconv -f windows-1251 -t utf-8 bulgarian.aff >bulgarian_utf8.affix
The locale of the database is fr_FR, and its encoding is UTF8.
I believe that characters 'И', 'А' (non-ascii) and other cyrillic ones
are
elekis escribió:
> rcqpgsql.c
> c:\program files\postgresql\8.3\include\server\pg_config.h(116) :
> warning C4005: 'HAVE_FINITE' : macro redefinition
>C:\Program Files\MySQL\MySQL Server
> 5.0\include\config-win.h(286) : see previous definition of
> 'HAVE_FINITE'
You're including a MySQL
Hello,
is it possible to get the time without the seconds and without the usage
of a formatting function?
Example:
CREATE TABLE test.testtime
(
thetime time without time zone
);
INSERT INTO test.testtime (thetime) VALUES ('12:34:56');
INSERT INTO test.testtime (thetime) VALUES ('23:45');
SELECT
Klint Gore írta:
> Scott Marlowe wrote:
>> On Mon, Dec 1, 2008 at 10:42 PM, Joshua D. Drake
>> <[EMAIL PROTECTED]> wrote:
>> > On Tue, 2008-12-02 at 00:37 -0500, Greg Smith wrote:
>> >> Tom on things that might ruin his tape backups:
>> >>
>> >> "Then of course there are the *other* risks, such as
I'm using the following dblink query to connect to another database on
the server. Query itself works fine, however I have the problem that if
the password contains a space character like in "hello world", then
dblink can't connect to that database.
Is there any possibility to get that working
Siddharth Shah wrote:
> I am not using wall based replication ? I no not have frequent &
> long transaction , need of checkpoints
> Just want to get what data resides in pg_xlog that it takes 16MB without
> any transactions.
It contains the transaction log files.
The files are precreated wi
On 02/12/2008 11:45, IPS wrote:
> I have certain jobs to be executed automatically at a given interval of
> time in the postgre SQL database. Is their any utility/feature available
> in Postgre to do so.
cron?
Ray.
--
Raymond O'Do
On 02/12/2008 12:50, A. Kretschmer wrote:
> PG cached the plan and the also the OID for affected tables. To avoid
> this, use EXECUTE 'insert your query here' for create or delete tables
> within plpgsql.
This has been fixed in 8.3 - you no longer have to construct dynamically
any statements whic
Siddharth Shah wrote:
> Hi,
>
>When I initialize database, pg_xlog direcory takes almost 17 MB size
>Why pg_xlog/WAL takes 17 MB of size while there is no transaction
> occurred ?
>
>What is the content of pg_xlog , If it's only wal file it's must be
> blank after on write of transact
I am using Postrges 8.3.5, and I am trying to install a bulgarian ISpell
dictionary (the OpenOffice one) for Textsearch features.
flag *A:
. > А (this is line 24)
. > АТА
. > И
. > ИТЕ
OpenOffice or ISpell? Pls, provide:
- link to download of dictionary
- Locale and encoding setting of your db
Thank for your reply.
Could you please elaborate it a little bit further by referring to the fucntion
as I am quite new to Postgres.
regards,
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: 02 December 2008 11:23:20 o'clock (GMT) Eur
On Tue, Dec 2, 2008 at 10:37 AM, Andreas Kraftl
<[EMAIL PROTECTED]> wrote:
>
> Hello,
>
> is it possible to get the time without the seconds and without the usage
>
> of a formatting function?
regexp and/or date_trunc
--
GJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane a écrit :
> Adrian Klaver <[EMAIL PROTECTED]> writes:
>> Thanks for the explanation. Just so I am clear,the act of updating the row
>> in p_commandeligne_ad creates a new tuple for the row with id of 1. This
>> means the original statement "
Hi!
I wonder what the consequences would be for a PostgreSQL server running on
Linux on a machine where the CMOS battery that gives life to the local system
(time) clock dies.
Note that the machine is not connected to a network, so synchronizing with an
external time server is not an option. Th
I am using the psqlodbc driver to connect to postgresql... But this is not
supporting all the languages that UTF should support.. Database is of the
correct encoding that is UTF... can you please give a solution so that i can
psqlodbc supports multiple languages. Right now there is support for russ
Hi,
> "Never underestimate the bandwidth of a station wagon full of
> tapes hurtling down the highway." -Tanenbaum, Andrew S.
> (1996). Computer Networks. New Jersey: Prentice-Hall, 83.
> ISBN 0-13-349945-6.
>
> A modern chrysler town and country(1) has a cargo capacity of
> 140.1 cubic feet
Teodor Sigaev a écrit :
I am using Postrges 8.3.5, and I am trying to install a bulgarian
ISpell dictionary (the OpenOffice one) for Textsearch features.
flag *A:
. > А (this is line 24)
. > АТА
. > И
. > ИТЕ
OpenOffice or ISpell? Pls, provide:
- link to download of dictionary
- Locale and en
Scott Marlowe wrote:
What is a tape?
Apparently something to do with backups. But I don't know what those
are either... :-P
From The Top Of My Head Dictionary -
Backup Tapes
noun
Thin flimsy strip of plastic with a fine coating of iron oxide or
similar compound which is then wound up arou
On Tuesday 02 December 2008 3:19:11 am Stéphane A. Schildknecht wrote:
> Tom Lane a écrit :
> > Adrian Klaver <[EMAIL PROTECTED]> writes:
> >> Thanks for the explanation. Just so I am clear,the act of updating the
> >> row in p_commandeligne_ad creates a new tuple for the row with id of 1.
> >> Thi
Quoth Alvaro Herrera <[EMAIL PROTECTED]>:
> Sebastian Tennant wrote:
>> Quoth Alvaro Herrera <[EMAIL PROTECTED]>:
>> > Sebastian Tennant wrote:
>> >
>> >> P.S. Emacs users of PostgreSQL might like to know that there's a
>> >> texinfo version of the manual (version 8.3.3) available for
>> >>
[EMAIL PROTECTED] (Tom Lane) writes:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
>> We really need a favorite Tom Lane quotes thread. Mine is (roughly):
>
>> We don't support that, but you're free to try it, you just get to keep
>> both pieces if it breaks.
>
> Hate to disillusion you, but that'
On Tue, 2008-12-02 at 10:40 +, Grzegorz Jaśkiewicz wrote:
> but than you have to add cost of backing up and restoring labour time,
> and that's going to be a massive latency - if you ask me.
Of course it is, but really latency probably isn't the key issue - more
that the data itself isn't los
> Yeah, this is a bug: it's effectively double-counting the
> selectivity of the index clause. The error isn't enormously critical,
> since the join size estimate is right; but it could perhaps lead to
> choosing a plain indexscan when a bitmap scan would be better. I've
> applied a patch.
Tha
2008/12/1 Scott Marlowe <[EMAIL PROTECTED]>:
> On Mon, Dec 1, 2008 at 7:49 PM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote:
>>
>> which reminds me, of my favourite recent quote:
>> "Think I'll go fix this while I'm watching the football game ..."
>
> We really need a favorite Tom Lane quotes thre
Magnus Hagander wrote:
> > I saw that but that only shows total lines, not the number of lines
> > changed, or commits per hour, etc.
>
> I've got a database of all our commits with info like: timestamp,
> author, number of rows added/deleted, number of files modified, which
> files modified, rows
On Tue, 2008-12-02 at 15:47 -0500, Bruce Momjian wrote:
> Magnus Hagander wrote:
> > > I saw that but that only shows total lines, not the number of lines
> > > changed, or commits per hour, etc.
> >
> > I've got a database of all our commits with info like: timestamp,
> > author, number of rows a
I am running postgres 7.4 and solaris 2.9 and I fear I have a
corruption. The database runs fine for a while and then a command will
receive the following:
psql: FATAL: xlog flush request 8/20D70938 is not satisfied -- flushed
only to 6/FDBA6540
CONTEXT:writing block 180816 of relation 1
Hi all,
does it exists a way to know how many records a query returns?
I thought sometime like
DECLARE curs1 CURSOR FOR select * from table ;
I thought if I can write MOVE LAST Is there any way to return
the number of row for select * from table without execute a count(*) ?
Thanks :)
Enrico
On Tue, Dec 2, 2008 at 2:46 PM, Gary Schlachter
<[EMAIL PROTECTED]> wrote:
> I am running postgres 7.4 and solaris 2.9 and I fear I have a corruption.
> The database runs fine for a while and then a command will receive the
> following:
7.4.what? A lot of older 7,4 versions had known data corrup
Select Count(*) from (query) is what i believe you are looking for see
http://www.postgresql.org/docs/8.3/interactive/tutorial-agg.html
Enrico Pirozzi wrote:
Hi all,
does it exists a way to know how many records a query returns?
I thought sometime like
DECLARE curs1 CURSOR FOR select * fr
Albe Laurenz wrote:
Siddharth Shah wrote:
I am not using wall based replication ? I no not have frequent &
long transaction , need of checkpoints
Just want to get what data resides in pg_xlog that it takes 16MB without
any transactions.
It contains the transaction log files.
The
ho f***, that must be multi db.
something say to me that will be funny :D
thanks
for all
a++
On Tue, Dec 2, 2008 at 3:15 PM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> elekis escribió:
>
>> rcqpgsql.c
>> c:\program files\postgresql\8.3\include\server\pg_config.h(116) :
>> warning C4005: 'HA
48 matches
Mail list logo
