> It is not because of the locks. There is only running transaction (and it
> got every locks). Not sure why the backend stucks there, seems it doesn't
> aware of the broken client. In normal situations, if you killed a client,
> then the server will print something like "could not receive data fro
I want to allow access to a table's rows without allowing that table to
be damaged. A problem I have is with my serial primary key 'id' field.
Although I can block its UPDATE, if users INSERT with an explicit 'id'
higher than the sequence, future INSERTs will fail due to the values
colliding.
"Jo De Haes" <[EMAIL PROTECTED]> wrote
>
> CETERROR: XX001: invalid page header in block 22182 of relation
"dunn_main"
>
> My main question is: why is this occuring?
>
I suppose there is no system error happens during the period (like lost
power). Can you attach the gdb at "b bufmgr.c:257" and p
Tom Lane wrote:
Etienne Labuschagne <[EMAIL PROTECTED]> writes:
The strange thing is that both databases are EXACTLY the same with
EXACTLY the same SQL query executed (I restore both DBs from the same
backup file to ensure that everything is the same - data and objects).
Have you vacuu
"Andrus" <[EMAIL PROTECTED]> wrote
> After killing client from XP task manager command
>
> DELETE FROM mytable
>
> runs forever.
>
> This is probably because pgAdmin shows that there are some locks placed
(see
> included picture).
>
It is not because of the locks. There is only running transactio
Yes, it came across my mind immediately atfter sending the mail
yesterday , but didn't help:( (and it's dll - it's on win32).
David Hoksza
22. března 2006, 4:26:07, napsal jste:
TL> [EMAIL PROTECTED] writes:
>> Probably the reason is, that the dll is not loaded y
On 3/22/06, surabhi.ahuja <[EMAIL PROTECTED]> wrote:
I have only one condition that is x = some value, so the sql query will look like select * from table where x = some value.
But what can i do to "restrict the number of rows".
how do i do that?
SELECT * FROM table WHERE x = 'bla' LIMIT 20
I have only one condition
that is x = some value, so the sql query will look like select * from table
where x = some value.
But what can i do to
"restrict the number of rows".
how do i do that?
thanks,
regards
Surabhi
From: Luckys
[mailto:[EMAIL PROTECTED]Sent: Wed 3/22/2006 11:23 AMT
I believe you should restrict number of rows that needs to be returned, or giving a choice to the user, although showing the total count. Even if you display all 20K records, no one is going to see them all, you can even add one more LIKE condition to match the user's criteria.
On 3/22/06, Mic
This looks like an issue for helper threads. In Eclipse, this is easy
(unfortunately, Eclipse in general is not very easy). One creates a
Job and runs the query in it with frequent checks for "cancel" (e.g., at
the beginning of the "for loop". The Job can be shown in a dialog with a
prog
Bruno Wolff III <[EMAIL PROTECTED]> writes:
> Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
>> We (PGDG) don't have RPMs for FC5 yet. However Fedora Core ships with
>> 8.1.3 RPMs already. So I'd install their RPMs. This should not cause a
>> problem since the database versions are the same.
> I wouldn'
""Vlad"" <[EMAIL PROTECTED]>
>
> I have found library "libpq.lib" for visual c++ (package PostgreSQL
> 8), but for borland builder give me error for using this library.
>
> Where I can find "libpq.lib" for borland builder (win2000)?
You can try Borland C++'s tool implib.exe.
1) Start a command l
I copied over the missing libs from one of my other
fc4 systems and postgresql seems happy and I have
not experienced any other problems so far...
Jerry
On Mar 21, 2006, at 11:46 PM, Bruno Wolff III wrote:
On Wed, Mar 22, 2006 at 00:10:53 +0200,
Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
Hi,
On Wed, Mar 22, 2006 at 00:10:53 +0200,
Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Tue, 2006-03-21 at 17:02 -0500, Jerry LeVan wrote:
> > I accidently upgraded my linux/intel to fc5 from fc4 and
> > something happened...
> >
> > Postgres cannot find some needed shared libraries any
>
"Tom Lane" <[EMAIL PROTECTED]> wrote
> "Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> > BTW: I just realized that there is another (better) way to do so is to
> > enable WAL_DEBUG in xlog.h and SET XLOG_DEBUG=true. And that's why we
don't
> > have much error message in xlog redo.
>
> That was proba
"Ken Winter" <[EMAIL PROTECTED]> writes:
> select lov_personinorganization_role_status('Student','Applicant');
> ERROR: set-valued function called in context that cannot accept a set
You need to write
select * from lov_personinorganization_role_status('Student','Applicant');
Bruno Wolff III <[EMAIL PROTECTED]> writes:
>>> Try:
>>> order by count(id)/age::float
>>
>> Or you can use the standard grammer:
>>
>> order by cast(count(id)/age as float)
> Don't you have to cast before the divide?
Yeah. The :: case is OK because :: binds more tightly than /
but the second
I have the following function:
CREATE or REPLACE FUNCTION public.lov_personinorganization_role_status(
varchar,
varchar)
RETURNS SETOF person_status_in_organization AS
$BODY$
DECLARE
rec person_status_in_organization%ROWTYPE;
role ALIAS FOR $1;
from_status ALIAS FOR
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> BTW: I just realized that there is another (better) way to do so is to
> enable WAL_DEBUG in xlog.h and SET XLOG_DEBUG=true. And that's why we don't
> have much error message in xlog redo.
That was probably Vadim's original reasoning for not being very
hi,
i have a small question
I have a table, with one of the fields called x (x
is not the primary key, here)
now i have to make a query like this:
select * from table where x = 1;
the number of rows retrieved from the above query
is of the order of 20,000 or more.
the result is contained in
unsubscribe
Regards,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Wednesday, March 22, 2006 5:49 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] ambuild parameters
I got problems when running gdb. In MINGW I run
"p
On Tue, Mar 21, 2006 at 21:16:03 +0800,
William ZHANG <[EMAIL PROTECTED]> wrote:
>
> "Sigurdur Gunnlaugsson" <[EMAIL PROTECTED]>
> > On Mon, 2006-03-20 at 21:10, Wei Wei wrote:
> >
> > Try:
> >
> > order by count(id)/age::float
>
> Or you can use the standard grammer:
>
> order by cast(count(i
[EMAIL PROTECTED] writes:
> Probably the reason is, that the dll is not loaded yet? But what's the
> right way to set breakpoint into dll, which isn't loaded yet?
Try forcing the .so to be loaded via the SQL "LOAD" command before you
attach to the process with gdb.
regards
"Tom Lane" <[EMAIL PROTECTED]> wrote
>
> While at it, you should extend the error message to include the relation
> ID, so you have some idea which table is affected ... this is certainly
> not a very informative message ...
>
Exactly. Please use the following version:
- elog(PANIC, "heap_update
I got problems when running gdb. In MINGW I run
"postgres -D ... dbname". Then I run gdb, but the problem is:
$ gdb
GNU gdb 5.2.1
Copyright 2002 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies
Tyler MacDonald wrote:
I have a DTD that I want to convert into a database schema. (For the
curious, it's the XML DTD for Kismet's XML output; see
http://www.kismetwireless.net/ and
http://kismetwireless.net/kismet-3.1.0.dtd). After converting it to a W3C
XML schema, it looks like it has the sort
Neil Conway <[EMAIL PROTECTED]> writes:
>> -> Index Scan Backward using merged_weight_date_idx on merged
>> (cost=0.00..31295593.98 rows=141839 width=229) (actual
>> time=3.888..10380.783 rows=500 loops=1)
> The mis-estimation of the result set of the index scan is clearly a
> problem -- have
On Tue, 2006-03-21 at 16:58 -0500, Kevin Murphy wrote:
> I have a table for which PG 8.3 is guessing wrong about a plan when the
> result set gets large.
There is no such thing as "PG 8.3".
>-> Index Scan Backward using merged_weight_date_idx on merged
> (cost=0.00..31295593.98 rows=14183
Hi,
On Tue, 2006-03-21 at 17:38 -0500, Jerry LeVan wrote:
> I might try moving the old versions from an existing
> fc4 over to fc5.
Don't do that. You may break he consistency of your new box.
Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Cons
Hmmm, It appears that they bumped libcryto and libssl
(living in /lib ) by a smidgen.
I might try moving the old versions from an existing
fc4 over to fc5. If that does not work then I guess
I will need to uninstall the PGDG rpms and install
the FC5 rpms.
Thanks
Jerry
On Mar 21, 2006, at 5:10
Hi,
On Tue, 2006-03-21 at 17:02 -0500, Jerry LeVan wrote:
> I accidently upgraded my linux/intel to fc5 from fc4 and
> something happened...
>
> Postgres cannot find some needed shared libraries any
> more.
We (PGDG) don't have RPMs for FC5 yet. However Fedora Core ships with
8.1.3 RPMs already.
Hi,
I accidently upgraded my linux/intel to fc5 from fc4 and
something happened...
Postgres cannot find some needed shared libraries any
more.
Can anyone offer any clues?
Jerry
/usr/bin/postmaster: error while loading shared
libraries: libssl.so.5: cannot open shared object file: No such file
I have a table for which PG 8.3 is guessing wrong about a plan when the
result set gets large. For these large result sets, it uses an Index
Scan Backward/Filter (slower) instead of Sort/Bitmap Heap Scan/Bitmap
Index Scan (faster). See below.
I fooled around with various planner variables, b
I have a DTD that I want to convert into a database schema. (For the
curious, it's the XML DTD for Kismet's XML output; see
http://www.kismetwireless.net/ and
http://kismetwireless.net/kismet-3.1.0.dtd). After converting it to a W3C
XML schema, it looks like it has the sort of infroamtion that is n
Stephan,
Thanks for the reply. We will be upgrading to version 8.x in the third quarter
of the year. As I said, I have a workaround. I just wanted to know why it was
behaving that way and you provided that. Thanks for the help.
On Tuesday 21 March 2006 11:36 am, Stephan Szabo saith:
> > Ok, fin
On Mar 21, 2006, at 11:54 AM, Tom Lane wrote:
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
2006-03-21 10:38:53 CST 1412 :LOG: archive recovery complete
2006-03-21 10:38:53 CST 1412 :LOG: could not truncate directory
"pg_multixact/offsets": apparent wraparound
2006-03-21 10:38:53 CST 141
"Thomas F. O'Connell" <[EMAIL PROTECTED]> writes:
> 2006-03-21 10:38:53 CST 1412 :LOG: archive recovery complete
> 2006-03-21 10:38:53 CST 1412 :LOG: could not truncate directory
> "pg_multixact/offsets": apparent wraparound
> 2006-03-21 10:38:53 CST 1412 :LOG: could not truncate directory
>
"Qingqing Zhou" <[EMAIL PROTECTED]> writes:
> Can you patch the heap/heapam.c/heap_xlog_update() like this:
> - elog(PANIC, "heap_update_redo: no block");
> + elog(PANIC, "heap_update_redo: no block: target block: %u, relation
> length: %u",
> +ItemPointerGetBlockNumber(&(xlrec->target.tid)),
After a successful same-server test of the postgres on-line backup
process, I tried a test from a remote server to simulate a process
I'll need to do in a production environment soon.
After a step-by-step on-line backup, I saw the following in my logs:
2006-03-21 10:38:53 CST 1412 :LOG: arc
> Ok, find attached a script called test.sql that will create three tables
> called parent, child, and totals. It will create a simple AFTER UPDATE
> trigger on child and a BEFORE trigger on parent simply to show that the
> values of batch and chkno are set to NULL right in the beginning. Just loa
Hi,
I tried to connect PostgeSQL 8.1 (Windows 2000) from remote computer
(Windows XP) using pgAdmin 1.4.2 and got error:
"Error connecting to the server: server closed the connection
unexpectedly This probably means the server terminated abnormally before
or while processing the request"
I start
Ok, find attached a script called test.sql that will create three tables
called parent, child, and totals. It will create a simple AFTER UPDATE
trigger on child and a BEFORE trigger on parent simply to show that the
values of batch and chkno are set to NULL right in the beginning. Just load
the
Thank you. You guys rock!On 3/21/06, Stephan Szabo <[EMAIL PROTECTED]> wrote:
On Tue, 21 Mar 2006, Larry White wrote:> I can't figure out how to pass parameters to a trigger function.
>> I checked the documentation and saw that trigger functions don't take> params in the usual fashion,> but couldn
On Mar 21, 2006, at 6:50 AM, Martijn van Oosterhout wrote:
But I'm ademantly against building and maintaining a special UTF-8
collation library just for PostgreSQL. That's just reinventing the
wheel. There already exist cross-platform libraries to handle
collation
and we should work towards
On Mon, Mar 20, 2006 at 06:07:16PM -0500, Vivek Khera wrote:
> So, if I use a UTF8 encoded DB on FreeBSD, all hell will break loose
> or what? Will things not compare correctly? Where from does the
> code to do the collating come, then?
It just won't collate properly. PostgreSQL collation is
Good day!
I have found library "libpq.lib" for visual c++ (package PostgreSQL
8), but for borland builder give me error for using this library.
Where I can find "libpq.lib" for borland builder (win2000)?
thanks.
---(end of broadcast)---
Version: 8.1.3
System: RedHat Linux 3.0 ES
In doing a bulk load with libpq (PQexec, PQputCopyData, PQputCopyEnd), the
COPY is failing with:
COPY (d) command did not complete successfully:
ERROR: end-of-copy marker corrupt CONTEXT: COPY detail, line 47201: ""
There are 50,000 lines in this
On Tue, 21 Mar 2006, Larry White wrote:
> I can't figure out how to pass parameters to a trigger function.
>
> I checked the documentation and saw that trigger functions don't take
> params in the usual fashion,
> but couldn't find an example of a pl-sql trigger function that used
> the original r
Thanks for the response. I'm working on a simplified example now. It will take
a little time to set it up. I will post all the code for creating the much
simplified tables and trigger.
Again, thanks for the response...
On Tuesday 21 March 2006 08:15 am, Martijn van Oosterhout saith:
> On Tue,
On Tue, Mar 21, 2006 at 08:54:36AM -0500, Merlin Moncure wrote:
> Is there any downside to using the C locale with UTF-8 encoding (on
> linux)? I need things to run quickly and proper sort order is not
> critically important (but storage of international characters is).
Sure, why not. C locale is
Hello List:
I posted a question over the weekend regarding this issue but I failed to
communicate effectively what the problem is. I was weary :o[ Let me try
again.
I have a plpgsql function which makes updates to a set of records across two
tables in a One to Many relationship hereinafter re
Hello Guys,
I am trying to export the data out of the database directly to an xml
file. Is there a way that I could this in PostgreSQL.
Thank you,
Murali.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropri
Is there any downside to using the C locale with UTF-8 encoding (on
linux)? I need things to run quickly and proper sort order is not
critically important (but storage of international characters is).
Merlin
---(end of broadcast)---
TIP 5: don't fo
I see in the documentation that when you vacuum a db, the "SELECT
datname, age(datfrozenxid) FROM pg_database" query should show "one
billion". When I do vacuums, I end up seeing things much closer to
pow(2,30). Is this the actual 'clean start' age?
I was wanting to start using the following que
On Tuesday 21 March 2006 09:21 am, Larry White saith:
> I can't figure out how to pass parameters to a trigger function.
>
> I checked the documentation and saw that trigger functions don't take
> params in the usual fashion,
> but couldn't find an example of a pl-sql trigger function that used
> t
On Tue, Mar 21, 2006 at 10:10:53AM -0500, Vivek Khera wrote:
>
> On Mar 21, 2006, at 6:50 AM, Martijn van Oosterhout wrote:
>
> >But I'm ademantly against building and maintaining a special UTF-8
> >collation library just for PostgreSQL. That's just reinventing the
> >wheel. There already exist c
On Tue, Mar 21, 2006 at 09:21:43AM -0500, Larry White wrote:
> I can't figure out how to pass parameters to a trigger function.
>
> I checked the documentation and saw that trigger functions don't take
> params in the usual fashion,
> but couldn't find an example of a pl-sql trigger function that
I can't figure out how to pass parameters to a trigger function.
I checked the documentation and saw that trigger functions don't take params in the usual fashion, but couldn't find an example of a pl-sql trigger function that used the original row data within the function.
What I want is an on u
Consider a service based on several terabytes of data, suffering from a
very high load. Can postgresql be used as database backend in a cluster
system in which both of the following is achieved?
a) Load balancing among a (large) number of cluster nodes
b) High availability (if any node in the
On 3/16/06, Tomi NA <[EMAIL PROTECTED]> wrote:
>
>
> On 3/13/06, Claudio Tognolo <[EMAIL PROTECTED]> wrote:
> >
> > I can disable the Trigger?
> >
>
> I'd like to know how this could be done, as well. What I really need is a
> hold-off-all-triggers-untill-I-tell-you-to command, but
> hey, making a
On Tue, Mar 21, 2006 at 06:56:23AM -0500, Terry Lee Tucker wrote:
> Hello List:
>
> I posted a question over the weekend regarding this issue but I failed to
> communicate effectively what the problem is. I was weary :o[ Let me try
> again.
I think one of the reasons why you're not getting any
"Sigurdur Gunnlaugsson" <[EMAIL PROTECTED]>
> On Mon, 2006-03-20 at 21:10, Wei Wei wrote:
>
> Try:
>
> order by count(id)/age::float
Or you can use the standard grammer:
order by cast(count(id)/age as float)
Regards,
William ZHANG
---(end of broadcast)
Terry Lee Tucker wrote:
Hello List:
I posted a question over the weekend regarding this issue but I failed to
communicate effectively what the problem is. I was weary :o[ Let me try
again.
I have a plpgsql function which makes updates to a set of records across two
tables in a One to Many
""Alex bahdushka"" <[EMAIL PROTECTED]> wrote
>
> Hrm... well i obviously have restored the database by now (using
> pg_resetxlog; pg_dump; initdb; pg_restore). However i did make a
> backup of the broken directory before I created the new database. If
> anyone has any thing they would like me to
64 matches
Mail list logo
