Michael Fuhr:
thanks!
through the method you supplied,i had resolved the problem.
OuYangJW
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, June 07, 2005 11:33 AM
Subject: Re: [GENERAL] how to get sequence list ?
> On Tue, Jun
On Monday June 6 2005 11:15 pm, Tom Lane wrote:
> It's possible that you are one minor release short of having
> dodged this problem, as I see in the 7.3.5 CVS log
>
> * src/backend/storage/buffer/bufmgr.c (REL7_3_STABLE): Force
> zero_damaged_pages to be effectively ON during recovery
"Ed L." <[EMAIL PROTECTED]> writes:
> Someone flipped a breaker switch, and evidently triggered
> corruption in one of our major clusters:
> 2005-06-06 14:31:11.984 [20124] PANIC: Invalid page header in block 22376
> of 79189398
It's possible that you are one minor release short of having dodg
Jochem van Dieten <[EMAIL PROTECTED]> writes:
> (gdb) bt
> #0 0x16e73f in elog_message_prefix ()
> #1 0x16da26 in elog ()
> #2 0x82b3d in typecast_expression ()
> #3 0x818d9 in transformExpr ()
> #4 0x89d4d in transformTargetEntry ()
> #5 0x8a021 in transformTargetList ()
> #6 0x3cb78 in tra
On Tue, Jun 07, 2005 at 09:42:12AM +0800, [EMAIL PROTECTED] wrote:
>
> I need to know whether a sequence object exists in postgresql.
> the sequence named "seq_serial".
In psql you can use the \d or \ds commands; otherwise you can query
the pg_class system catalog.
http://www.postgresql.org/docs
Dianne Yumul <[EMAIL PROTECTED]> writes:
> We have Fedora Core 4 Test 3 installed on a development box and just
> recently installed Postgresql 8.0.3. Sometimes, when starting
> postgresql with the /etc/rc.d/init.d/postgresql script, it gives me the
> following:
> /usr/bin/chcon: can't apply pa
(B
(B
(BHello list,
(B
(BI need to know whether a sequence
(Bobject exists in postgresql.
(Bthe sequence named "seq_serial".
(B
(Bthank you .
(B
(BOuYangJW
Phil Endecott wrote:
Following up on my own post from last night:
> Could it be that there is some code in autovacuum that is O(n^2) in
> the number of tables?
Browsing the code using webcvs, I have found this:
for (j = 0; j < PQntuples(res); j++)
{
tbl_elem = DLGetHead(dbs->table_list);
Hello list,
We have Fedora Core 4 Test 3 installed on a development box and just
recently installed Postgresql 8.0.3. Sometimes, when starting
postgresql with the /etc/rc.d/init.d/postgresql script, it gives me the
following:
/usr/bin/chcon: can't apply partial context to unlabeled file
/ho
On Mon, 2005-06-06 at 16:39, Ed L. wrote:
> On Monday June 6 2005 3:29 pm, Ed L. wrote:
> > On Monday June 6 2005 3:17 pm, Scott Marlowe wrote:
> > > On Mon, 2005-06-06 at 15:16, Ed L. wrote:
> > > > Someone flipped a breaker switch, and evidently triggered
> > > > corruption in one of our major cl
Tom Lane wrote:
[ studies 7.3 code a bit ] It might work better to set the breakpoint at
elog_message_prefix, assuming you've got logging dialed down to the
point where only actual ERRORs go to the log.
Attaching to process 10284
0x403827df in ?? ()
(gdb) symbol-file postmaster
Reading symbol
On Monday June 6 2005 3:29 pm, Ed L. wrote:
> On Monday June 6 2005 3:17 pm, Scott Marlowe wrote:
> > On Mon, 2005-06-06 at 15:16, Ed L. wrote:
> > > Someone flipped a breaker switch, and evidently triggered
> > > corruption in one of our major clusters:
> >
> > OK, if postgresql is running on hard
On Monday June 6 2005 3:17 pm, Scott Marlowe wrote:
> On Mon, 2005-06-06 at 15:16, Ed L. wrote:
> > Someone flipped a breaker switch, and evidently triggered
> > corruption in one of our major clusters:
>
> OK, if postgresql is running on hardware that doe NOT lie
> about fsyncing, and it is set to
- Original Message -
From: "Adam Witney" <[EMAIL PROTECTED]>
To: "grupos" <[EMAIL PROTECTED]>; "pgsql-general"
Sent: Monday, June 06, 2005 8:17 AM
Subject: Re: [GENERAL] Large Object => invalid input syntax for integer: ""
On 6/6/05 4:58 am, "grupos" <[EMAIL PROTECTED]> wrote:
I
On Mon, 2005-06-06 at 15:16, Ed L. wrote:
> Someone flipped a breaker switch, and evidently triggered
> corruption in one of our major clusters:
>
> $ cat server_log.Mon
> postmaster successfully started
> 2005-06-06 14:31:11.950 [20124] LOG: database system was interrupted being
> in recover
On Monday June 6 2005 2:16 pm, Ed L. wrote:
> Someone flipped a breaker switch, and evidently triggered
> corruption in one of our major clusters:
BTW, this is a 7.3.4 cluster ...
Ed
---(end of broadcast)---
TIP 9: the planner will ignore your desi
Jochem van Dieten <[EMAIL PROTECTED]> writes:
> That's different from backtracing a core dump :) This better?
> Breakpoint 1, 0x16d8f8 in elog ()
> (gdb) bt
> #0 0x16d8f8 in elog ()
> #1 0x110abb in pg_exec_query_string ()
> #2 0x112a91 in PostgresMain ()
> #3 0xf4eae in DoBackend ()
> #4 0xf
Someone flipped a breaker switch, and evidently triggered
corruption in one of our major clusters:
$ cat server_log.Mon
postmaster successfully started
2005-06-06 14:31:11.950 [20124] LOG: database system was interrupted being in
recovery at 2005-06-06 14:29:01 EDT
This probably mean
Tom Lane wrote:
Jochem van Dieten <[EMAIL PROTECTED]> writes:
(gdb) break elog
Breakpoint 1 at 0x16d8f8
(gdb) bt
#0 0x403ca553 in ?? () from /usr/lib/libc.so.28.5
#1 0x10e604 in mdread ()
#2 0x10f31f in smgrread ()
You forgot to "continue" until the breakpoint is reached --- this trace
jus
"show processlist" will display DB, command, time, State, etc under MySQL:
| Id | User | Host| db | Command | Time |
*State * | *Info*
| 21 | admin | server1:40898 | test | *Query* | 104 |
Copying to tmp table | INSERT INTO test (SEL
Jochem van Dieten <[EMAIL PROTECTED]> writes:
> I get the following error:
>> C:\Program Files\PostgreSQL\8.0\bin>set PGOPTIONS="-W 30"
>>
>> "z:\backup\databases\2005-06-06\wedstrijdzeilen.sql"
>> WARNING: postgres: invalid command line arguments
Hm, that's odd ... but never mind, you thought
[EMAIL PROTECTED] (Ying Lu) writes:
> Greetings,
>
> I have a question about how to see current processes running under
> postgreSQL.
>
> "show processlist" will display DB, command, time, State, etc under MySQL:
>
> | Id | User | Host| db | Command | Time |
> *State
Tom Lane wrote:
Jochem van Dieten <[EMAIL PROTECTED]> writes:
Below I have copy pasted the console log which has some
additional information. This bug, or a related one, seems to have
been registered previously as bug #1455
http://archives.postgresql.org/pgsql-bugs/2005-02/msg00021.php
Yea
On Mon, Jun 06, 2005 at 11:22:23AM -0400, Ying Lu wrote:
> Greetings,
>
> I have a question about how to see current processes running under
> postgreSQL.
>
> "show processlist" will display DB, command, time, State, etc under MySQL:
>
> | Id | User | Host| db | Comma
Himanshu Baweja wrote:
> when i enable debug_print_plan and
> debug_pretty_print...
> query plans are written to log file for all
> queries(3 gb of logs in 3 mins) which is of course
> diffcult to analyze and consume too much resources
>
> is it possible to log plans for only the queries w
when i enable debug_print_plan and
debug_pretty_print...
query plans are written to log file for all
queries(3 gb of logs in 3 mins) which is of course
diffcult to analyze and consume too much resources
is it possible to log plans for only the queries whose
duration was more than a particu
On 5/20/2005 2:26 PM, Tom Lane wrote:
numeric_power can in theory deliver an exact answer when the exponent is
a positive integer. Division can deliver an exact answer in some cases
too --- but the spec doesn't say it must do so when possible. So I
would say that there is no spec requirement f
[EMAIL PROTECTED] writes:
> Christopher Browne <[EMAIL PROTECTED]> wrote:
>
>> Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] would write:
>> > "Gevik babakhani" <[EMAIL PROTECTED]> wrote:
>> >
>> >> Beside the documentation, which pg book would you recommend? Which one is
>> >> your per
Greetings,
I have a question about how to see current processes running under
postgreSQL.
"show processlist" will display DB, command, time, State, etc under MySQL:
| Id | User | Host| db | Command | Time |
*State * | *Info*
| 21 | admin | serv
You could use your own type, since it seems you know what values you'll be storing there. You can create it like this:
CREATE TYPE MyResult AS (
dt_inici DATE,
dt_fi DATE
);
Then you must change your functions as follows:
CREATE OR REPLACE FUNCTION test1() RETURNS MyResult AS '
decl
Following up on my own post from last night:
> Could it be that there is some code in autovacuum that is O(n^2) in
> the number of tables?
Browsing the code using webcvs, I have found this:
for (j = 0; j < PQntuples(res); j++)
{
tbl_elem = DLGetHead(dbs->table_list);
while (tbl_
=?ISO-8859-1?Q?=22Rodr=EDguez_Rodr=EDguez=2C_Pere=22?= <[EMAIL PROTECTED]>
writes:
> how can I write a function that return two or more elements?
In existing releases the best way to do this is to create a named
composite type and have the function return that, not RECORD.
You could use your own type, since it seems you know what values you'll be storing there. You can create it like this:
CREATE TYPE MyResult AS (
dt_inici DATE,
dt_fi DATE
);
Then you must change your functions as follows:
CREATE OR REPLACE FUNCTION test1() RETURNS MyResult AS '
decl
Jochem van Dieten <[EMAIL PROTECTED]> writes:
> Below I have copy pasted the console log which has some
> additional information. This bug, or a related one, seems to have
> been registered previously as bug #1455
> http://archives.postgresql.org/pgsql-bugs/2005-02/msg00021.php
Yeah. We never
Title: return two elements
Hello,
how can I write a function that return two or more elements?
I try to return a record but after I don't know how to assign returned value to a variable. For example,
CREATE OR REPLACE FUNCTION test1() RETURNS record AS '
declare
rec record;
begin
Some comments:
> I've just been sent this link by our DBA (pro MySQL but even more
> Anti-Postgres):
I can see skript kiddies preferring MySQL, but a DBA? Time for a
credentials review.
Firebird is a good small database (small resource footprint) that handles
small databases with many users wel
grupos wrote:
Hi Adam,
I am sorry for the misunderstanding, when I compose the e-mail I forgot
the ' ' on the 1 BUT the error is the same, I made:
INSERT INTO test VALUES ('1')
and I get the error:
ERROR: invalid input syntax for integer: ""
I am sure that there is some problem with LO.
Hmm you're right, they do seem to be working OK now.
Thanks for your response - maybe it was just a temporary glitch.
John Sidney-Woollett
Michael Fuhr wrote:
On Mon, Jun 06, 2005 at 08:13:10AM +0100, John Sidney-Woollett wrote:
Can anyone explain why none of the links to download the 8.0.0
grupos <[EMAIL PROTECTED]> writes:
> I need to use large objects BUT I am having problemns... I instaled
> PostgreSQL 8.0.3 windows version with lo module.
> first, I created the table below:
> CREATE TABLE test
> (
> description varchar(20),
> picture lo
> )
> WITHOUT OIDS;
> After trying t
On Mon, Jun 06, 2005 at 09:21:15AM -0400, Douglas McNaught wrote:
> "Surabhi Ahuja " <[EMAIL PROTECTED]> writes:
>
> > say i have two transactions going on simultaneoulsy.
> > in one transaction i do an insertion
> > and the other transaction i do a delete.
> > what will happen if in both the tran
I am experiencing a problem with dumping one specific database on
a cluster. All 143 other databases dump without giving errors.
The server runs PostgreSQL 7.3.2 on OpenBSD (I know :). pg_dump
is version 8.0.3 on Windows (upgraded from 8.0.1 which had the
same problem). The error message is:
do you really need to use lo module ?
try this ...
CREATE TABLE test
(
description varchar(20),
picture oid
)
WITHOUT OIDS;
if you want to import a BLOB :
insert into test values ("toto", lo_import('mypicture'))
and if you want no value
insert into test values ("toto", 0)
-Message d'ori
Hi Douglas,
Thanks for your promptly answer. Here is the "step by step":
CREATE TABLE test
(
description varchar(20),
picture lo
)
WITHOUT OIDS;
INSERT INTO test (description) VALUES ('1');
And then, the error : INSERT INTO test (description) VALUES ('1')
What I am trying to do is insert d
grupos <[EMAIL PROTECTED]> writes:
> Hi Adam,
>
> I am sorry for the misunderstanding, when I compose the e-mail I
> forgot the ' ' on the 1 BUT the error is the same, I made:
> INSERT INTO test VALUES ('1')
>
> and I get the error:
> ERROR: invalid input syntax for integer: ""
>
> I am sure th
grupos <[EMAIL PROTECTED]> writes:
> Hi Doug!
>
> Thanks for your e-mail BUT the point is how I insert data on a table
> when the column lo have no value ( NULL), to insert the lo I have no
> problem BUT the problem is when the column should have no value...
If the "lo" field isn't NOT NULL than
Hi Doug!
Thanks for your e-mail BUT the point is how I insert data on a table
when the column lo have no value ( NULL), to insert the lo I have no
problem BUT the problem is when the column should have no value...
Regards,
Rodrigo Carvalhaes
Douglas McNaught wrote:
grupos <[EMAIL PROTECTE
"Surabhi Ahuja " <[EMAIL PROTECTED]> writes:
> Hello everyone.
> I have the following question:
>
> say i have two transactions going on simultaneoulsy.
> in one transaction i do an insertion
> and the other transaction i do a delete.
> what will happen if in both the transactions, the insert(in o
Hi Adam,
I am sorry for the misunderstanding, when I compose the e-mail I forgot
the ' ' on the 1 BUT the error is the same, I made:
INSERT INTO test VALUES ('1')
and I get the error:
ERROR: invalid input syntax for integer: ""
I am sure that there is some problem with LO.
Regards,
Rodri
On Mon, Jun 06, 2005 at 08:13:10AM +0100, John Sidney-Woollett wrote:
>
> Can anyone explain why none of the links to download the 8.0.0 source
> work? I trying to use links on this page:
>
> http://wwwmaster.postgresql.org/download/mirrors-ftp?file=source/v8.0.3/postgresql-8.0.3.tar.gz
>
> All
Title: transactions
Hello everyone.
I have the following question:
say i have two transactions going on simultaneoulsy.
in one transaction i do an insertion
and the other transaction i do a delete.
what will happen if in both the transactions, the insert(in one) and delete(in the other) are
grupos <[EMAIL PROTECTED]> writes:
> I need to use large objects BUT I am having problemns... I instaled
> PostgreSQL 8.0.3 windows version with lo module.
>
> first, I created the table below:
> CREATE TABLE test
> (
> description varchar(20),
> picture lo
> )
> WITHOUT OIDS;
>
> After trying
On 6/6/05 4:58 am, "grupos" <[EMAIL PROTECTED]> wrote:
> I need to use large objects BUT I am having problemns... I instaled
> PostgreSQL 8.0.3 windows version with lo module.
>
> first, I created the table below:
> CREATE TABLE test
> (
> description varchar(20),
> picture lo
> )
> WITHOUT OIDS;
I need to use large objects BUT I am having problemns... I instaled
PostgreSQL 8.0.3 windows version with lo module.
first, I created the table below:
CREATE TABLE test
(
description varchar(20),
picture lo
)
WITHOUT OIDS;
After trying to make one insert without value for the lo I get the err
On 6/6/05, Russ Brown <[EMAIL PROTECTED]> wrote:
> I've just been sent this link by our DBA (pro MySQL but even more
> Anti-Postgres):
>
> http://www.janus-software.com/fb_fyracle.html
>
> I want to know how they've calculated the numbers that they're created
> those pie graphs from. The only thi
Russ Brown wrote:
I've just been sent this link by our DBA (pro MySQL but even more
Anti-Postgres):
http://www.janus-software.com/fb_fyracle.html
I want to know how they've calculated the numbers that they're created
those pie graphs from. The only thing I can think of that Postgres
doesn't hav
I've just been sent this link by our DBA (pro MySQL but even more
Anti-Postgres):
http://www.janus-software.com/fb_fyracle.html
I want to know how they've calculated the numbers that they're created
those pie graphs from. The only thing I can think of that Postgres
doesn't have for 'transactions'
On 6/3/05, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> Tony Caduto wrote:
> > Can't do that, it's a Delphi 7 application.
>
> Have you heard of Kylix? You should be able to do an almost straight
> native port to Linux.
>
I didn't get chance to try it at home under Wine, but a pative port
using
-Mensaje original-De: Bob
[mailto:[EMAIL PROTECTED]Enviado el: viernes 3 de junio de
2005 23:34Para: Rodríguez Rodríguez, PereCC:
pgsql-general@postgresql.orgAsunto: Re: [GENERAL] writting a large
store procedure
Well first off can you break those 700 lines out into mo
Can anyone explain why none of the links to download the 8.0.0 source
work? I trying to use links on this page:
http://wwwmaster.postgresql.org/download/mirrors-ftp?file=source/v8.0.3/postgresql-8.0.3.tar.gz
All the hostnames fail to resolve.
Can anyone help me to get a 8.0.3 set of source fil
59 matches
Mail list logo
