Hi,
Are there any tools available for converting XML files for which a dtd
is available into a PostgreSQL table without any programming on my
part?
The files are basically XML formatted table dumps, with some elements
having attributes.
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
good morning,
I have a demo database, but it's empty.
if you tell me where is the creation script, I will try it
2009/3/23 Dave Page dp...@pgadmin.org
On Mon, Mar 23, 2009 at 1:56 PM, josep porres jmpor...@gmail.com wrote:
well, now a log with only trying to debug setting a breakpoint
Hmmm
On Mon, 2009-03-23 at 21:51 -0700, Aimon Bustardo wrote:
Hi, I ran into a recovery problem where I have a single missing WAL
file in a long sequence. I need a way to recover past that missing WAL
archive. I am desperately hoping there is a way to do this. Any help
that can be given
how to access large objects from the database when using
PGAdmin like client applications? When a normal select is
executed on lo type columns it gives only the number which
refers to large objects stored in 'pg_largeobjects' table.
When records from pg_largeobjects are fetched using
Thomas Kellerer wrote:
I'm getting a new notebook and want to confirm that my idea
on how to move my Postgres installation will work This is a
development/test installation and not a production system, so
it doesn't need to be 100% fail safe.
Both systems are Windows XP 32bit.
My plan
Aimon Bustardo wrote:
Hi, I ran into a recovery problem where I have a single missing WAL
file in a long sequence. I need a way to recover past that missing WAL
archive. I am desperately hoping there is a way to do this. Any help
that can be given will be extremely appreciated!
I am
Hello,
I'm having a problem with a warm standy-by / continuous archiving setup.
The archive of WAL segments on the slave server sometimes (and only
sometimes) grows _huge_.
I'm using a warm standy-by / continuous archiving setup with two
servers. The slave servers, in stand-by mode, is
On 2009-03-18, cifroes cifr...@netcabo.pt wrote:
This is a multi-part message in MIME format.
--_=_NextPart_001_01C9A7E6.B32BBA87
Content-Type: text/plain;
charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Hi,
I have a DB in utf-8 and postgres 8.3.x.=20
How can I
Albe Laurenz, 24.03.2009 10:34:
Thomas Kellerer wrote:
I'm getting a new notebook and want to confirm that my idea
on how to move my Postgres installation will work This is a
development/test installation and not a production system, so
it doesn't need to be 100% fail safe.
Both systems are
Seems I've missed something important about time zones. On my server
i've got local timezone 'W-SU' (Moscow time):
= show timezone;
TimeZone
--
W-SU
= select now();
now
---
2009-03-24 13:23:39.655057+03
Till now all seems ok. Than
RebeccaJ wrote:
Thanks, everyone, for your contribution to this thread. I'm
approaching the database design of my web application differently,
now. Before, I was planning to have CHECK constraints in all of my
text or char fields, to keep out all semicolons, single quotes, and
anything
Tom Lane schrieb:
Marinos Yannikos m...@geizhals.at writes:
i_a btree (a)
i_ab btree (a, b)
I suspect that these indexes are exactly the same size --- look at
pg_class.relpages or use the pg_relation_size() function to verify.
For some reason, the first one is actually about twice the size
On Tue, Mar 24, 2009 at 7:50 AM, josep porres jmpor...@gmail.com wrote:
Ooops, I haven't realized the second schema, I've found the function.
Here you are your test log.
OK, I think we've tracked down the problem. Can I send you some
updated DLLs to try offlist?
--
Dave Page
EnterpriseDB
i've just upgraded the server to 8.3.7 holding the same data directory
select * from pldbg_get_proxy_info();
serverversionstr,serverversionnum,proxyapiver,serverprocessid
PostgreSQL 8.3devel on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special),80300,3,2948
is it ok for testing
by the way, after upgrading, i get the same behaviour
even executing the function in a query window created after setting the
breakpoint.
2009/3/24 josep porres jmpor...@gmail.com
i've just upgraded the server to 8.3.7 holding the same data directory
select * from pldbg_get_proxy_info();
On Tue, Mar 24, 2009 at 1:42 PM, josep porres jmpor...@gmail.com wrote:
i've just upgraded the server to 8.3.7 holding the same data directory
select * from pldbg_get_proxy_info();
serverversionstr,serverversionnum,proxyapiver,serverprocessid
PostgreSQL 8.3devel on i686-pc-mingw32, compiled
=?UTF-8?B?0KDQvtC80LDQvSDQnNCw0YjQuNGA0L7Qsg==?= m...@nandu.ru writes:
Seems I've missed something important about time zones. On my server
i've got local timezone 'W-SU' (Moscow time):
= show timezone;
TimeZone
--
W-SU
= select now();
now
I went to upgrade an installation and was stopped with (approximately)
the following message after clicking Next on the step where I told it
to use the same data directory:
The existing data directory (date time: floating-point numbers) is
not compatible with this server (date time: 64-bit
Torsten Zühlsdorff schrieb:
Hello,
i have a problem with understanding fulltext search in PG 8.3.
[..]
I solved it. I have to specify the language in to_tsquery(). -.-
Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8
verschiedenen Datenbanksystemen
[..]
I've just noticed, that i forgot to change the subject. While writing i
figured out, that the question is not the one, i want to ask.
I am sorry for confusions.
Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8
verschiedenen Datenbanksystemen
Hello,
i have a problem with understanding fulltext search in PG 8.3.
Example:
CREATE TABLE tfulltext (body text, fulltext tsvector);
INSERT INTO tfulltext VALUES ('title und description sind wichtige
grundlagen', to_tsvector('pg_catalog.german', 'title und description
sind wichtige
Thank you guys for your replies!
It is definitely something wrong with my code, here is the thread which does
the listening:
http://mitek.id.au/flex/DBListener.cpp
The rest of application is fairly big and does not relate to the database.
For libpq calls I am using the SPTK (http://sptk.net)
asss
asd
fas
dfasdffddsssa
asdf
asdf
Hi.
I have a little problem with user names and Postgres commands.
Due to quirks in corporate account management using ADS, some user names
come out as, say, Mickey when you log into Linux instead of mickey.
This unfortunate user tries to run Postgres commands and gets for
instance:
$
Will Rutherdale (rutherw) wrote:
When I try going into psql as user postgres to change the user name, I
get this problem:
postgres=# alter user mickey rename to Mickey;
ERROR: role “mickey” already exists
you might try...
alter user mickey rename to Mickey;
--
Sent via pgsql-general
aer
ggg
Yes, that worked, thanks.
After also doing this:
alter database mickey rename to Mickey;
it solved the problem.
Pardon my newness to Postgres.
-Will
-Original Message-
From: John R Pierce [mailto:pie...@hogranch.com]
Sent: 24 March 2009 16:21
To: Will Rutherdale (rutherw)
Cc:
On Mon, Mar 23, 2009 at 4:46 AM, Sam Mason s...@samason.me.uk wrote:
On Fri, Mar 20, 2009 at 05:37:33PM -0700, Randall Lucas wrote:
I added a functional index.
create table example (id serial primary key, stuff text, parent_id
int);
create index example_root_idx on example
On 24/03/2009 20:38, Will Rutherdale (rutherw) wrote:
Pardon my newness to Postgres.
We've all been there at some point! - except of course for Tom Lane.
:-)
Ray.
--
Raymond O'Donnell, Director of Music, Galway Cathedral,
On 24/03/2009 20:25, Berdam wrote:
aer
?
--
Raymond O'Donnell, Director of Music, Galway
Hi Peter,
If you want to use Postgres to store/manage/query spatial data, I strongly
recommend you look at PostGIS, not the native Postgres geometry types.
Brent Wood
Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand
Peter Willis pet...@borstad.com 03/24/09 10:35 AM
Hello,
I
On Mar 23, 2009, at 5:00 PM, Craig Ringer wrote:
Erik Jones wrote:
Am I missing something obvious here? If not, has anyone come up
with a reliable way to do this?
Triggers on all your tables that append to a logging table?
Have the client do it?
Note that you do *NOT* want to have
Erik Jones ejo...@engineyard.com writes:
These are all client databases at the web hosting company I work at.
I can't go putting triggers on all of their tables. I think I'll just
start taking snapshots of pertinent data from pg_stat_activity and
after I've been collecting data for a
asdsss
sss
sss
asdfasdfasdfasdfasdfasdfasdfasdfasdfasd
asdfasdff
asdfasdfasdfasdfasdfasdfasdfasdfasdfasd
asdfasdff
asdfasdfasdfasdfasdfasdfasdfasdfasdfasd
asdfasdff
how to unsubscribe of this list??
Simon Riggs escreveu:
On Mon, 2009-03-23 at 21:51 -0700, Aimon Bustardo wrote:
Hi, I ran into a recovery problem where I have a single missing WAL
file in a long sequence. I need a way to recover past that missing WAL
archive. I am desperately
36 matches
Mail list logo
