From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
DownsSent: 14 May 2006 23:12To:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] GUI
Interface
gentoo linux on an AMD. here are some stats, if you tell me any
other packages you need versions
Hi,
my postgresql version 7.4.5 cannot start until this
morning, when i check the log file, it give me this error
this is part of my log file
DEBUG: vacuuming
"pg_catalog.pg_class"DEBUG: "pg_class": found 9823 removable, 1017
nonremovable row versions in 205 pagesDETAIL: 0 dead row
After you install postgres using 'root', create your postgres database
cluster (initdb ) as postgres rather than root. Your database
files therefore should be owned by postgres not root.
--
Husam
http://firstdba.googlepages.com
Martijn van Oosterhout wrote:
On Thu, May 11, 2006 at
On Fri, 2006-05-12 at 07:31 -0500, Tony Caduto wrote:
Dave Page wrote:
Only runs on Windows though doesn't it?
Regards, Dave
Hardly a limitation since Linux and other Unix based operating systems
account for a trivial percent of the desktop market. I would guess that
more
Using PL/PGSQL, I am trying to create a procedure to display the count
of rows in any single table of a database. The End-user would pass in a
table name and the prodecure would display the table name with the row
count.
I am able to hardcode the variable for table and get the appropriate
results
Hi to all!
I am a student in Computer Science, and in Databases' Technology
course I must to write
a report on physical structures of DBMS's. I choosed PostgreSQL; I
looked the sources, and
I have understood the block structure. And relations? And databases?
How are structured?
Thanks!!!
Hello all,
I think I found a little but annoying bug in views when ordering is
involved. First, my version of Postgres:
PostgreSQL 8.1.3 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC)
3.4.4 [FreeBSD] 20050518
Please try the following:
CREATE TABLE datum (
projekt_id INTEGER NOT
Hi,
I have done the below command and restarted the server and built my
triggers with the -g command using gcc, but I cannot seem to find any
core files nor any reference to where postgres may place them. Where
would they normally appear?
Cheers
Chris
Probably the easiest thing to do is make
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] (Tom Lane) wrote:
Martijn van Oosterhout kleptog@svana.org writes:
I beleive you can set it to EXTERNAL, which it will always toast.
I don't think that will help; if the overall row size is below the
threshold, the code is not going to pick
The core file usually appears in the data directory of the backend.
If you still can't find it, you can try attaching gdb to the running
backend. After the connection has started, find the backend (not the
postmaster) and attach using:
gdb -p pid
Once connected, type cont and proceed with the
am 13.05.2006, um 14:15:52 -0700 mailte [EMAIL PROTECTED] folgendes:
Using PL/PGSQL, I am trying to create a procedure to display the count
of rows in any single table of a database. The End-user would pass in a
table name and the prodecure would display the table name with the row
count.
I
Use 'EXECUTE' to dynamically build SQL:http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
-MikeOn 13 May 2006 14:15:52 -0700, [EMAIL PROTECTED] [EMAIL PROTECTED]
wrote:Using PL/PGSQL, I am trying to create a procedure to display the count
of
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Florian G. Pflug
Sent: 14 May 2006 18:50
To: Tino Wildenhain
Cc: Kenneth Downs; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
It only happens in pgAdmin III, though, so it
Hello
all,
I would like to ask
if anyone can explain or point me to some sort of query that would get the
sequences for a database along with the current value they
contain.
I have been able to
get the sequence names, but I can get their values all in one query. >From the
documentation
Dave Page wrote:
kernel 2.6.8
KDE 3.3.2
gtk+ 2.4.14
pgadmin3 1.2.2
The window manager would be whatever the default for KDE is.
OK, the first thing you reallyshould do is
upgrade to pgAdmin 1.4.2 and (if building form source) wxWidgets 2.6.3.
There have
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
DownsSent: 15 May 2006 14:24Cc:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] GUI
Interface
Dave Page wrote:
kernel 2.6.8KDE
3.3.2gtk+ 2.4.14pgadmin3 1.2.2The window
Sebastian Böck wrote:
Hello all,
I think I found a little but annoying bug in views when ordering is
involved. First, my version of Postgres:
PostgreSQL 8.1.3 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC)
3.4.4 [FreeBSD] 20050518
Please try the following:
CREATE TABLE datum (
Chun Yit(Chronos) [EMAIL PROTECTED] wrote
saw from the log file, it's possible that server crash during
vacuum process...
Question :
1) what happen to my database server? what the error meaning?
It looks like index pg_class_relname_nsp_index (which is an index on
pg_class) is corrupted.
Qingqing Zhou [EMAIL PROTECTED] writes:
But not sure why it reports the following error
message (which looks like a post-commit cleanup caused error):
DEBUG: AbortCurrentTransaction
PANIC: cannot abort transaction 14135438, it was already committed
I think this is an artifact of
On Mon, May 15, 2006 at 03:55:49PM +0300, Forums @ Existanze wrote:
Hello all,
I would like to ask if anyone can explain or point me to some sort of query
that would get the sequences for a database along with the current value
they contain.
I have been able to get the sequence names,
Kenneth Downs wrote:
Dave Page wrote:
kernel 2.6.8
KDE 3.3.2
gtk+ 2.4.14
pgadmin3 1.2.2
The window manager would be whatever the default for KDE is.
OK, the first thing you reallyshould do is
upgrade to pgAdmin 1.4.2 and (if
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Kenneth
DownsSent: 15 May 2006 15:14To:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] GUI
Interface
Kenneth Downs wrote:
Dave Page wrote:
kernel 2.6.8KDE
Nis Jorgensen [EMAIL PROTECTED] writes:
Try removing the DISTINCT ON from your view - that should make things
clearer to you. When t.approved is true, the row is joined to all rows
of the datum table satisfying the criteria. The sort order you specify
does not guarantee a unique ordering of
Martijn van Oosterhout kleptog@svana.org writes:
On Mon, May 15, 2006 at 03:55:49PM +0300, Forums @ Existanze wrote:
I have been able to get the sequence names, but I can get their values all
in one query.
Select sequence.last_value;
The hard part of the request is to do it all in one query,
On Mon, May 15, 2006 at 10:44:15AM -0400, Tom Lane wrote:
I haven't been able to think of a way to do that, unless you want to
assume the existence of a plpgsql helper function. There's an open
request to list last_values in psql's \ds, and it'd be real nice
to be able to do it all in one
Martijn van Oosterhout kleptog@svana.org writes:
On Mon, May 15, 2006 at 10:44:15AM -0400, Tom Lane wrote:
I haven't been able to think of a way to do that, unless you want to
assume the existence of a plpgsql helper function. There's an open
request to list last_values in psql's \ds, and
Mark Campbell wrote:
Hi All
I downloaded version 7.3 and compiled that.
First I had to compile newer versions of m4 and bison
At least I now have an up and running postgres server
Thanks for all the help
Mark Campbell
Confidentiality Notice: http://ucs.co.za/conf.html
Estou com problemas ao tentar inserir um array de
bytes em um campo do tipo oid.
Caused by: org.springframework.jdbc.UncategorizedSQLException:
Hibernate operation: could not insert:
[br.com.atlantico.maragato.cadastrosauxiliares.model.ImagemTO]; uncategorized
SQLException for SQL [insert
On May 14, 2006, at 12:27 AM, Ed L. wrote:
While watching a 9-hour 60GB network load from 7.4.6 pg_dump into
8.1.2, I noticed the order in which indices and constraints are
created appears to be their creation order.
If you use the 8.1.2 pg_dump to make the dump from your 7.4.6 DB,
what is
Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Florian G. Pflug
Sent: 14 May 2006 18:50
To: Tino Wildenhain
Cc: Kenneth Downs; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
It only happens in pgAdmin III, though,
Hello-
I currently have a 1.4 TB database (pg version 7.4.8) that is
experiencing transaction id wraparound. I plan to pg_dump the database
and initdb and reload. I may reload into an 8.1 database at this
time.
I am curious how to make sure that I indeed get all the data out of the
tables from
On Mon, May 15, 2006 at 11:44:01AM -0700, Michael L. Boscia wrote:
Hello-
I currently have a 1.4 TB database (pg version 7.4.8) that is experiencing
transaction id wraparound. I plan to pg_dump the database and initdb and
reload. I may reload into an 8.1 database at this time.
I am
-Original Message-
From: Florian G. Pflug [mailto:[EMAIL PROTECTED]
Sent: 15 May 2006 19:05
To: Dave Page
Cc: Tino Wildenhain; Kenneth Downs; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GUI Interface
Here are the details of my configuration which shows the problem:
On Mon, 2006-05-15 at 13:48, Martijn van Oosterhout wrote:
On Mon, May 15, 2006 at 11:44:01AM -0700, Michael L. Boscia wrote:
Hello-
I currently have a 1.4 TB database (pg version 7.4.8) that is experiencing
transaction id wraparound. I plan to pg_dump the database and initdb and
On Mon, May 15, 2006 at 08:48:54PM +0200, Martijn van Oosterhout wrote:
Vacuum will make anything that disappeared by wraparound in the last
billion transactions reappear, so a databasewide vacuum should solve
all your problems, no need to dump...
Also, for future reference. If you have a lot
Michael L. Boscia [EMAIL PROTECTED] writes:
My current plan is selectively dump a portion of the data (most current,
organized in tables by date ex xxx_2006_may) and reload. I plan to vaccuum
each table before dumping. Please warn me if this is not enough. Any
assistance is greatly
Martijn van Oosterhout kleptog@svana.org writes:
Vacuum will make anything that disappeared by wraparound in the last
billion transactions reappear, so a databasewide vacuum should solve
all your problems, no need to dump...
Oh, I had forgotten about that. Did we establish that 7.4.* works
On 5/15/06, Scott Marlowe [EMAIL PROTECTED] wrote:
On Mon, 2006-05-15 at 13:48, Martijn van Oosterhout wrote:
On Mon, May 15, 2006 at 11:44:01AM -0700, Michael L. Boscia wrote:
Hello-
I currently have a 1.4 TB database (pg version 7.4.8) that is experiencing
transaction id wraparound.
On Mon, 2006-05-15 at 14:07, Michael L. Boscia wrote:
On 5/15/06, Scott Marlowe [EMAIL PROTECTED] wrote:
This is one of those rare instances when I'd shut down the server and
take a file system backup if I could. However, at 1.4 TB, that might be
a bit difficult... :)
What do I do with
On Mon, May 15, 2006 at 03:04:47PM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
Vacuum will make anything that disappeared by wraparound in the last
billion transactions reappear, so a databasewide vacuum should solve
all your problems, no need to dump...
Oh, I
entendi, só que o problema é q estou usando
annotations do hibernate p/a gerar esse campo
@NotNull(message =
FramexMessages.FRAMEX_REQUIRED_FIELD) @Lob @Basic(fetch = FetchType.EAGER)
public byte[] getArquivoImagem() {
return arquivoImagem; }
alguém jah passou por esse problema, de usar
-Original Message-
From: Tony Caduto [mailto:[EMAIL PROTECTED]
Sent: 13 May 2006 14:58
To: Dave Page
Subject: Re: [GENERAL] GUI Interface
All that page mentions is the weird quirks on win32, I am
sure you know what those are, i.e. windows suddenly lose
there size and
On Fri, May 05, 2006 at 12:41:56PM -0600, Brendan Duddridge wrote:
They both have a click_count column that we update with update
attribute set click_count = click_count + 1; and the same for the
attribute_value table. Postgres is getting hung up on any transaction
that attempts to
On Sat, May 06, 2006 at 12:08:32AM -0300, Marcelo Fabiano da Silveira wrote:
Hi,
I Have some questions of use PQtrace in Windows' systens
1- The implementation of PQtrace, is possible ONLY with non bloking
connections ???
2- Please, I need same samples of implementation of PQtrace.
I've written some extensions to postgres to implement
chemical structure searching. I get inquiries about
the performance of postgres vs. oracle. This is a huge
topic, with lots of opinions and lots of facts. But,
today I got some feedback stating the opinion that:
Postgres performance
On Mon, 2006-05-15 at 14:24, TJ O'Donnell wrote:
I've written some extensions to postgres to implement
chemical structure searching. I get inquiries about
the performance of postgres vs. oracle. This is a huge
topic, with lots of opinions and lots of facts. But,
today I got some feedback
On Mon, May 08, 2006 at 04:17:53PM -0700, Casey Duncan wrote:
From personal experience (and others will disagree), I find putting
logic in the database to be a bad idea. I only use stored procedures
for triggers and the like, and I try to avoid those whenever possible.
Here are my
On Tue, May 09, 2006 at 10:10:50AM +0200, Houssais Hugues wrote:
Each distant database works on its own domain of data. Then no conflict
should happen during updates.
One thing I have not specified is that the distant databases don't handle
global data but only data collected at the local
On Tue, May 09, 2006 at 08:57:57AM -0700, John Purser wrote:
I am running postgres 7.4.7 on debian sarge.
First:
psql -U PGSQL USER -o OUPUT FILE NAME --pset format=unaligned
--pset fieldsep=',' -c 'SQL COMMAND HERE' -d DATABASE NAME HERE
I think that will give you the output you were
On Wed, May 10, 2006 at 11:55:49AM +0200, Houssais Hugues wrote:
Hi,
In order to unify many distant Postgres databases, we decided to use WAL
archiving. The idea is to concatenate a distant WAL archive at the
beginning of a local WAL archive before launching PITR restore.
Does anyone know
On Wed, May 10, 2006 at 11:00:14PM +1000, chris smith wrote:
On 5/10/06, Alban Hertroys [EMAIL PROTECTED] wrote:
Sim Zacks wrote:
Something such as: with this explain data, adding an index on table tbl
column A would drastically improve the efficiency. Or at least an
application that would
On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
Sometime ago I saw a project with the purpose of creating Oracle views over
the PostgreSQL catalog.
I can't remember/find it anymore. Do you know if it's still available?
Is there any other project aiming to create
On Fri, May 12, 2006 at 02:02:27PM -0400, Bruce Momjian wrote:
Scott Marlowe wrote:
On Fri, 2006-05-12 at 11:39, Joshua D. Drake wrote:
I am regularly dealing with customers, and specifically developers that
are running Linux+PostgreSQL on the server... but their desktop of
choice
Hi guysi have a database on WINXP machine unfotunatly, the OS crashed . i want to retriev my data how can this be done.Regards
Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
And I just demonstrated it on a test 7.4.7 database here (Debian
7.4.7-6 to be precise).
test=# select ctid, xmin, xmax, cmin, cmax, * from test;
ctid |xmin| xmax | cmin | cmax | x
---++--+--+--+---
(0,1) |541 |0 |0 |0 | 1
(0,2) |
On Mon, 15 May 2006, dfx wrote:
I am spending about 10 hours on little problem: to pass a parameter (text)
to a PostgreSQL (v. 8.1 on Win2000). The
relevant code is:
java side:
private CallableStatement cs;
cs = conn.prepareCall(INSERT_CONGRESSO);
cs.setString(1,
Hi,
I'm writing a set of casts to/from various user defined
types. As is unexpected, there are cases where one
data type doesn't neatly map to another (for certain
values). In these cases I emit an INVALID_PARAMETER_VALUE
or OUT_OF_RANGE error -- depending on the situation.
But, should I also
Don Y [EMAIL PROTECTED] writes:
I'm writing a set of casts to/from various user defined
types. As is unexpected, there are cases where one
data type doesn't neatly map to another (for certain
values). In these cases I emit an INVALID_PARAMETER_VALUE
or OUT_OF_RANGE error -- depending on the
You should try the new MacBook Jim! The 17 is out now. I used to
have the 17 PB G4, but now I have a 15 MacBook Pro with 2GB of RAM.
It's a sweet machine! Very fast too.
Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL
On Mon, 2006-05-15 at 17:12 -0500, Jim C. Nasby wrote:
On Wed, May 10, 2006 at 02:08:46PM -0300, Bruno Almeida do Lago wrote:
Sometime ago I saw a project with the purpose of creating Oracle views over
the PostgreSQL catalog.
I can't remember/find it anymore. Do you know if it's still
4) how can i solve this problem?
The base table pg_class should be ok(pg_class_oid_ind indicates both have
the same cardinality). Try to reindex pg_class as the superuser.
but not i not be able to reindex the table because i cannot start the
postmaster.
postmaster give me error every time
Qingqing Zhou [EMAIL PROTECTED] writes:
But not sure why it reports the following error
message (which looks like a post-commit cleanup caused error):
DEBUG: AbortCurrentTransaction
PANIC: cannot abort transaction 14135438, it was already committed
I think this is an artifact of
Chun Yit\(Chronos\) [EMAIL PROTECTED] writes:
PANIC: btree_delete_page_redo: uninitialized right sibling
LOG: startup process (PID 5043) was terminated by signal 6
LOG: aborting startup due to startup process failure
That's pretty ugly :-(. I think your only hope to get out of it is to
use
Chun Yit(Chronos) [EMAIL PROTECTED] wrote
postmaster give me error every time i try to start it
LOG: redo starts at A/46315F50
PANIC: btree_delete_page_redo: uninitialized right sibling
So the last resort I can think of is to use pg_resetxlog to pass the startup
failure -- but no gaurantee
64 matches
Mail list logo