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
-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
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
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'
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
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
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 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;
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
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
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
"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 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
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
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
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
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
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 tran
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
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 wel
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
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
=?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 (tbl_
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
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
[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
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
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
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
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
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
[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\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
"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
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
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
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
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
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
- 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 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
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
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 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
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
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
(BI need to know whether a sequence
(Bobject exists 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 pa
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
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
"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
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
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
59 matches
Mail list logo
