Inpreet Singh wrote:
Hello,
I am working on live server where we have installed postgres database as
our back end. But now the problem is due to continues work on postgres,
size of log files has become problem for us. And the partition where our
postgres exists is full. Postmaster is not working
Hi, all
As I understood PostgreSQL allows to store large
objects 2GB size maximum.
Are there any plans to increase or removing that
limitation?
If no, are there any abilities to store 10-20GB
raster data (aero foto image) in postgreSQL?
Thanks
Sergey Karin
Hi
What would cause a connection to automatically close within a java program.It
gets to a point where I have an inner loop that calls a recursive method that
creates resultsets.But I am closing all my result sets, so I do not know why
the connection simply closes itself.Please help.
Clifton Z
This sort of thing has been seen to occur when multiple client-side
threads try to use the same database connection without proper locking
to ensure only one thread uses it at a time. See for example
http://archives.postgresql.org/pgsql-hackers/2004-09/msg00104.php
On Tue, 12 Apr 2005, Richard Huxton wrote:
Inpreet Singh wrote:
Hello,
I am working on live server where we have installed postgres database as
our back end. But now the problem is due to continues work on postgres,
size of log files has become problem for us. And the partition where our
postgres
Clifton Zama wrote:
Hi
What would cause a connection to automatically close within a java program.It
gets to a point where I have an inner loop that calls a recursive method that
creates resultsets.But I am closing all my result sets, so I do not know why
the connection simply closes itself.Plea
I want to be 100% sure.
Currently my server runing 8.0.1 and my HTTP server ( another computer )
runing php which compiled on PG 7.4.7 and its working great.
I need to recompile all the clients on all the other servers ( php /
psql ) including PHP ?
THanks
Marc G. Fournier wrote:
For those alre
Hello all!
There is an extrange error in my logfile:
update articles set online='t' where id = 391 ;
ERROR: duplicate key violates unique constraint "articles_pkey"
(the error exists only with this id)
I've checked (well, almost imposible) if there was more than one
article with this id:
sele
Carlos Costa wrote:
Hello all!
There is an extrange error in my logfile:
update articles set online='t' where id = 391 ;
ERROR: duplicate key violates unique constraint "articles_pkey"
(the error exists only with this id)
I've checked (well, almost imposible) if there was more than one
article wit
Hi,
We are updating from v7.3 to v8.0.1
as well as transferring the database to a new machine. We use Crystal
Reports 9 to access the data on a production basis. Unfortunately,
Crystal Reports 9 fails to recognise some of the data fields on the new
database. In particular, it does not recognise
Thank you very much.
Here is the output:
SELECT oid,xmin,xmax,ctid,id FROM articles WHERE id=391;
oid | xmin| xmax| ctid | id
-+---+---+--+-
3032469 | 152691945 | 152886684 | (104,6) | 391
3032469 | 152886687 | 156995994 | (104,13) | 391
Hi,
I would like to get
the elapsed time in milliseconds between 2 dates...
Does anyone have an
idea of how to do it ?
Thanks
Patrick
---
Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36
18
On Tue, 12 Apr 2005, [UTF-8] Poul Møller Hansen wrote:
> I have rewritten the application so every client thread is opening a new
> database connection, and yesterday it happened again.
> ---
> 2005-04-11 12:27:54 ERROR: invalid string enlargement request size
> 1358954492
> 2005-04-11 12:27
No. Clients on other machines should work fine since nothing changed in the
wire protocol.
On Tuesday 12 April 2005 05:24, Michael Ben-Nes wrote:
> I want to be 100% sure.
>
> Currently my server runing 8.0.1 and my HTTP server ( another computer )
> runing php which compiled on PG 7.4.7 and
Hi,
I have just upgraded my (thank God test) database server to Postgres to
8.0.1 from 7.4.7. I do a stand dump, shutdown, upgrade, restore
procedure.
On the server i have 5 databases. All of them work fine except one
where I can "select" fine but an not insert, update or delete!!!
I get errors
"Sergey Karin" <[EMAIL PROTECTED]> writes:
> As I understood PostgreSQL allows to store large objects 2GB size maximum.
> Are there any plans to increase or removing that limitation?
I don't think anyone's really thought about it. To do it without
breaking backward compatibility, we'd have to inv
On Monday 11 April 2005 05:39, Jinane Haddad wrote:
> Hi everyone,
>
> i just got a new job in a small entreprise and they are using postgres as a
> database for their application. I was stupefied cause the database design
> is so bad : we can even say it has been done by amateurs. I observed the
>
Carlos Costa <[EMAIL PROTECTED]> writes:
> SELECT oid,xmin,xmax,ctid,id FROM articles WHERE id=391;
>oid | xmin| xmax| ctid | id
> -+---+---+--+-
> 3032469 | 152691945 | 152886684 | (104,6) | 391
> 3032469 | 152886687 | 156995994 | (104,1
Looks like your ODBC settings might have changed in the switch. In
particular, look at the " text as longvarchar" setting.
If you cannot find a solution, try posting to the pgsql-odbc list.
"Kristina Magwood" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> We are updating f
Is there anything
like a client library for postgres that does not use tcp/ip as the protocol? As
part of the performance tuning of our application, the question was posed to me
whether there was a more "direct" sort of API that would not require going
through the tcp/ip stack. I assume the
I'm sorry, was working on little sleep yesterday. You
are right, the table was created with the columns in
the following order:
d1, obj_id, d2, val, correction, delta, evt_id
The insert command looks something like:
INSERT INTO EVENT_TBL VALUES(1039850293991, 145,
1039110343000, '10.25', 1, 739
"David Parker" <[EMAIL PROTECTED]> writes:
> Is there anything like a client library for postgres that does not use
> tcp/ip as the protocol?
Local connections generally go through Unix sockets, which is not the
tcp stack.
regards, tom lane
---(end
On Tue, Apr 12, 2005 at 10:51:09AM -0400, David Parker wrote:
>
> Is there anything like a client library for postgres that does not use
> tcp/ip as the protocol? As part of the performance tuning of our
> application, the question was posed to me whether there was a more
> "direct" sort of API tha
in
which language ?
-Message d'origine-De :
[EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]Envoyé : mardi 12 avril 2005
15:25À : pgsql-general@postgresql.orgObjet :
[GENERAL] Get Number of milliseconds for an intervall
Hi,
I would like to
get the elapsed time in mi
Sorry,
I forgot to say in PL/pgSQL
---
Patrick Fiche email : [EMAIL PROTECTED] tél : 01 69 29 36
18 ---
-
On Tue, Apr 12, 2005 at 07:59:55AM -0700, Bill Chandler wrote:
> I'm sorry, was working on little sleep yesterday. You
> are right, the table was created with the columns in
> the following order:
>
> d1, obj_id, d2, val, correction, delta, evt_id
>
> The insert command looks something like:
>
I was able to get a pg_dump of the table in question.
It has 23040 rows in it. evt_id column ranges from 1
to 23040.
I used the dump to create a new database. All inserts
fail with same error (unique constraint violation).
However, I am wondering if this is just the result of
the fact that
On Tue, Apr 12, 2005 at 08:48:15AM -0700, Bill Chandler wrote:
> How does one find out the current sequence value? Is
> there a way to change it?
Using the function setval() you can change it. SELECT * from
sequencename to find out.
--
Alvaro Herrera (<[EMAIL PROTECTED]>)
"Si quieres ser crea
I did not intend to put explicit values in the
'evt_id' column. I thought the six values in the
insert command correspond to the 1st six columns in
the create table command, namely d1, obj_id, d2, val,
correction and delta and 'evt_id' is set to the
nextval() automagically. Is that not correct?
On Tue, Apr 12, 2005 at 08:58:41AM -0700, Bill Chandler wrote:
> I did not intend to put explicit values in the
> 'evt_id' column. I thought the six values in the
> insert command correspond to the 1st six columns in
> the create table command, namely d1, obj_id, d2, val,
> correction and delta an
All,
In the pg_dump output is the command:
COPY event_tbl (d1, ..., evt_id) FROM stdin;
followed by all the data for the table. There are
23040 rows. The last value for evt_id is 23040. So
far so good. Then the last statement in the pg_dump
output is:
SELECT pg_catalog.setval('event_tbl_evt
Hi All,
I am recently planning to
use PostgreSQL to be my backend for my Java web based application in
JBoss application server. This is to be moved to the production environment. I
don't want to change the postgresql version for next few years. So, I
want a stable version of postgre
[EMAIL PROTECTED] ("Magnus Naeslund(t)") wrote in message news:<[EMAIL
PROTECTED]>...
> Fritz Bayer wrote:
> > Hello,
> >
> > I`m using postgresql 7.2.1. According to the following lines data in
> > my database gets encoded as unicode. Server and client communication
> > seems to use unicode as w
Hi,
I have used Daffodil replicator in a similar situation earlier.
It is necessary that master and slave database should be exposed to
each
other.
The problem might have occurred due to deployment of firewall in the
network
that is preventing the connection to establish.
The solution could be
The following statement runs VERY slowly on large tables.
Any idea how to speed it up ?
UPDATE rid SET dokumnr=NULL WHERE
dokumnr NOT IN (SELECT dokumnr FROM dok);
Tables:
CREATE TABLE dok ( dokumnr INTEGER,
CONSTRAINT dok_pkey PRIMARY KEY (dokumnr) );
CREATE TABLE rid ( dokumnr
[EMAIL PROTECTED] ("Daniel Verite") wrote in message news:<[EMAIL PROTECTED]>...
> Fritz Bayer wrote:
>
> > I have a java program, which writes words containing german umlauts
> > like äöü into the database. As you probably know, those characters
> > belong to the ISO-8859-1 character encoding set
On Tue, 2005-04-12 at 12:27, Santharam wrote:
> Hi All,
> I am recently planning to use PostgreSQL to be my backend for
> my Java web based application in JBoss application server. This is to
> be moved to the production environment. I don't want to change the
> postgresql version for next
On Apr 12, 2005, at 6:39 AM, Fritz Bayer wrote:
But in which encoding? I guess utf8 or utf16...
But why doesn that fail only for äüö? Shouldn't any other letter
encoded in utf16 also fail?
I mean unicode itself is 16 bit long. So "münchen" should expand to 14
characters. But only ü expands to two c
Suppose I'm adding row to a table, and one of the columns is
a pathname.
I would like to generate in a separate table parent/child
relationships based on the path.
For example, adding "/foo/bar/baz" and "/foo/bar/bot" would
generate the following relationships
parent child
-- -
/f
On Apr 12, 2005 9:40 AM, Andrus <[EMAIL PROTECTED]> wrote:
The following statement runs VERY slowly on large tables.Any idea how to speed it up ?UPDATE rid SET dokumnr=NULL WHERE dokumnr NOT IN (SELECT dokumnr FROM dok);Tables:CREATE TABLE dok ( dokumnr INTEGER, CONSTRAINT dok_pkey PRIM
Sometimes life has an irony of itself.
Today I modified some of my gentoo USE flags for something totally
unrelated to postgres.
Tonight I built postgres in debug mode : the offending query worked.
I thught "hm."
I rebuilt it without debug, and it still works.
I don't know what made it NOT
pgadmin3 does this (from pg's log with level set at debug5):
INSTRUCTION : SELECT db.oid, datname, datpath, datallowconn, datconfig,
datacl, pg_encoding_to_char(encoding) AS serverencoding,
pg_get_userbyid(datdba) AS datowner,has_database_privilege(db.oid,
'CREATE') as cancreate
PFC <[EMAIL PROTECTED]> writes:
> ERREUR: 42703: la colonne <> n'existe pas
> EMPLACEMENT : transformColumnRef, parse_expr.c:1099
> Do you know if this is normal, should this column exist, is it a
> problem
> with pgadmin ?
You need a newer pgadmin --- pg_database.datpath went away in
You need a newer pgadmin --- pg_database.datpath went away in 8.0.
I'm installing the new version. Thanks.
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Tue, Apr 12, 2005 at 10:51:09 -0400,
David Parker <[EMAIL PROTECTED]> wrote:
> Is there anything like a client library for postgres that does not use
> tcp/ip as the protocol? As part of the performance tuning of our
> application, the question was posed to me whether there was a more
> "direc
I'm trying to experiment with domains and composite types under 8.0.2.
It seems that domain constraints don't fire when the domain is embedded
within a composite type:
---
create domain simple as smallint default 0 constraint limits check
(VALUE IN (0,1,2,3));
create type comp_simple as ( simp_
James Robinson <[EMAIL PROTECTED]> writes:
> insert into simple_table values (null, '(43)'); -- GRR works!!! It'll
> let any smallint in. What happened to the constraint?
The composite-type input routine doesn't check any constraints ...
and that includes domains. You can make it work if you don
I've been experimenting with loading a large amount of data into a
fairly simple database using both psql and perl prepared statements.
Unfortunately I'm seeing no appreciable differences between the two
methods, where I was under the impression that prepared statements
should be much faster (in m
Matt Van Mater <[EMAIL PROTECTED]> writes:
> I've been experimenting with loading a large amount of data into a
> fairly simple database using both psql and perl prepared statements.
> Unfortunately I'm seeing no appreciable differences between the two
> methods, where I was under the impression t
But the people i am working with are not considering the restructuring of
the database. They are even thinking of expanding it by adding new modules.
Please can someone advise me, or tell me what to do, what may be the
consequences
My advice is to not go to them with the "we need to totally r
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
After an extended vacation from development activities on my computer,
I tried to get back to work, but the PostGreSQL backend was no longer
running. (Normally its part of my startup scripts.)
I tried su'ing over to postgres and running pg_ctl start. No luck,
seems like it lost the path. Typ
On Tue, Apr 12, 2005 at 08:30:39PM -0400, Eric D. Nielsen wrote:
> LOG: ReadRecord: unexpected pageaddr 0/364000 in log file 0, segment
> 2, offset 3555328
> LOG: redo is not required
> PANIC: XLogWrite: write request 0/2364000 is past end of log 0/2364000
> LOG: startup process (pid 784) was
"Eric D. Nielsen" <[EMAIL PROTECTED]> writes:
> PANIC: XLogWrite: write request 0/2364000 is past end of log 0/2364000
This is a known corner-case bug in some 7.3 releases. If you care about
getting the data out of it, you can update-in-place to the latest 7.3
release. If not, well, 7.3 was a l
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> What version is this exactly? IIRC there was a version of 7.3 that
> would refuse to start if the last XLog record fell at the edge of a
> segment. I may be misremembering though (i.e. maybe it was one of the
> 7.4 series), plus I can't find the releva
Thanx guys for the advices.
i think i will have to find some "POLITICAL" approach in order to
restructure the existing database, which i am not so good at but worse
trying. Note that even the code is Bad (they are using PHP for a big
application - no object oriented design - a lot of code redund
56 matches
Mail list logo
