Looking at archives seem to indicate missing pg_clog files is some form
of row or page corruption.
In an old thread from back in 2003 Tom Lane recommended
(http://tinyurl.com/jushf):
If you want to try to narrow down where the corruption is, you can
experiment with commands like
select ctid
Andreas Kretschmer <[EMAIL PROTECTED]> schrieb:
> gustavo halperin <[EMAIL PROTECTED]> schrieb:
>
> > Hello
> >
> > I Always get "syntax error" for every function that I try to create, for
> > example:
> > mydb'>create or replace function f_sum () returns void as '
> > mydb'> select 2+2
The world rejoiced as [EMAIL PROTECTED] (Tom Lane) wrote:
> Flemming Frandsen <[EMAIL PROTECTED]> writes:
>> I just looked at the pg_listener table:
>> ... and noticed the complete lack of indexen, surely this must be a bug?
>
> No, that was intentional. It's been a long time but I think the
> arg
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Flemming
Frandsen) wrote:
> I just looked at the pg_listener table:
>
> zepong-> \d+ pg_listener
> Table "pg_catalog.pg_listener"
> Column| Type | Modifiers | Description
> --+-+---+---
Flemming Frandsen <[EMAIL PROTECTED]> writes:
> I just looked at the pg_listener table:
> ... and noticed the complete lack of indexen, surely this must be a bug?
No, that was intentional. It's been a long time but I think the
argument was that the cost of updating the indexes would outweigh
thei
On Gentoo Linux, you can run:
$ emerge --config dev-db/postgresql
It will setup the default database and tell you which kernel settings
you need to tweak (kernel.sem,kernel.shmmax, etc).
On 7/29/06, Habib Seifzadeh <[EMAIL PROTECTED]> wrote:
> > Is there any installer that installs PostgreSQL
You are missing the BEGIN and END section. Make your function like this:CREATE OR REPLACE FUNCTION f_sum() RETURNS void AS 'BEGIN select 2+2; END;' LANGUAGE plpgsql;Thanks,-- Shoaib Mir
EnterpriseDB (www.enterprisedb.com)On 7/30/06,
gustavo halperin <[EMAIL PROTECTED]> wrote:
HelloI Always get
gustavo halperin <[EMAIL PROTECTED]> schrieb:
> Hello
>
> I Always get "syntax error" for every function that I try to create, for
> example:
> mydb'>create or replace function f_sum () returns void as '
> mydb'> select 2+2;
> mydb'> ' LANGUAGE plpgsql;
> ERROR: syntax error at
Habib Seifzadeh <[EMAIL PROTECTED]> schrieb:
> > > Is there any installer that installs PostgreSQL
> > > without any question from the user and assumes
> > default
> > > options?
> >
> > For what operating system?
>
> If there was a way for all of OSes, it would be great
> :-) but I specially ne
Hello
I Always get "syntax error" for every function that I try to create, for
example:
mydb'>create or replace function f_sum () returns void as '
mydb'> select 2+2;
mydb'> ' LANGUAGE plpgsql;
ERROR: syntax error at or near "select" at character 56
LINE 2: select 2+2;
^
> > Is there any installer that installs PostgreSQL
> > without any question from the user and assumes
> default
> > options?
>
> For what operating system?
If there was a way for all of OSes, it would be great
:-) but I specially need it for windows in this case,
Anyway, thank you for your reply
Habib Seifzadeh wrote:
> Is there any installer that installs PostgreSQL
> without any question from the user and assumes default
> options?
For what operating system?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of broadcast)-
I have created a function that I use to help automate the creation of
partition tables. Basically it:
1. Creates a new table inherited from the parent table (which is empty)
2. creates or replaces a sole rule on the parent table to insert into
the new table:
EXECUTE 'CREATE OR REPLACE RULE paren
Hi dear friends,
Is there any installer that installs PostgreSQL
without any question from the user and assumes default
options?
By the way, I searched the archives but didn't find
any thread discussing this question. if you know any
thread, please show me the url.
Cheers,
Habib
__
"Alistair Bayley" <[EMAIL PROTECTED]> writes:
>> Magnus, did you have a specific reason for choosing Europe/Dublin,
>> or was it just alphabetically first? Europe/London looks at least
>> marginally closer to what one would think "GMT" means:
> Does it have to be a specific city? I'd rather it ju
Michael Fuhr wrote:
What's the output of "VACUUM VERBOSE pg_listener"? If you vacuum
pg_listener do the listens run faster?
Actually now that You mentioned vacuming, I tried doing a VACUUM and
after it was done request time was down to around a tenth of what it was
before.
iow. requests th
Michael Fuhr wrote:
How long is "a very long time"?
More than 2ms, typically 50-150ms.
The other queries (that actually fetch data from tables and do real
work) execute in 1-4ms.
The funny thing is that if I run the select 6*7 after ping (which does a
select 'somestring') then the select 6
On Sat, Jul 29, 2006 at 12:44:14PM +0200, Flemming Frandsen wrote:
> Michael Fuhr wrote:
> >Also, based on a 60ms-per-listen time I suspect you're not doing
> >the listens in a transaction, so each listen is its own transaction
> >that has to be committed, resulting in a disk hit. Try doing them
>
Oh, you didn't say you were on Windows
I did, but it was buried in the first paragraph...
Magnus, did you have a specific reason for choosing Europe/Dublin,
or was it just alphabetically first? Europe/London looks at least
marginally closer to what one would think "GMT" means:
Does it have
Michael Fuhr wrote:
Also, based on a 60ms-per-listen time I suspect you're not doing
the listens in a transaction, so each listen is its own transaction
that has to be committed, resulting in a disk hit. Try doing them
all in one transaction.
I think I am doing the listens in a transaction, a
20 matches
Mail list logo
