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
-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
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 Kylix
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
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
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 thing I can
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
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;
After
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 to make one
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
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 the
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,
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 one) and
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
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 you
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 that there is
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
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
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:
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 transactions, the
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 to make one
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 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.
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
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
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 heard
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 '
=?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.
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
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 '
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 |
[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 personal favorite pg book?
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
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
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 whose
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 | Command | Time
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
[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
Jochem van Dieten [EMAIL PROTECTED] writes:
I get the following error:
C:\Program Files\PostgreSQL\8.0\binset 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 of an
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
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
just
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
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 0xf463d in
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
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 recovery at
- Original Message -
From: Adam Witney [EMAIL PROTECTED]
To: grupos [EMAIL PROTECTED]; pgsql-general
pgsql-general@postgresql.org
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]
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 fsync,
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 hardware that
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
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 clusters:
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
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);
(B
(B
(BHello list,
(B
(BIneed to know whether a sequence
(Bobjectexists in postgresql.
(Bthe sequence named "seq_serial".
(B
(Bthank you .
(B
(BOuYangJW
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 partial
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.
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
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 dodged this
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 from
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: pgsql-general@postgresql.org
Sent: Tuesday, June 07, 2005 11:33 AM
Subject: Re: [GENERAL] how to get sequence
59 matches
Mail list logo