Thanks George. I just returned from the bookstore and was looking at an XSLT
solution in one of the books there. I want to import the data into the DB as
regular data, not as XML. I'll look into Saxon and TagSoup as well as the perl
module you mentioned. As far as this being outside the scope of
On Fri, 27 Jan 2006, Matthew Hixson wrote:
The problem is that the JDO layer is looking for the table name in a system
table like so:
When using DatabaseMetaData calls to determine what tables and columns are
available you must be aware of what case the search terms need to be
passed in wi
On Jan 27, 2006, at 4:10 PM, Thomas Kellerer wrote:
Matthew Hixson wrote on 28.01.2006 00:53:
I'm trying to get a large Java application which makes use of an
Oracle JDO layer to work with Postgres. Set aside for a moment
the discussion of whether or not that is going to work.
What I have
The problem is that the JDO layer is looking for the table name in a
system table like so:
SELECT
n.nspname,c.relname,a.attname,a.atttypid,a.attnotnull,a.atttypmod,a.attl
en,a.attnum,def.adsrc,dsc.description FROM pg_catalog.pg_namespace
n JOIN pg_catalog.pg_class c ON (c.relnamespace =
Matthew Hixson wrote on 28.01.2006 00:53:
I'm trying to get a large Java application which makes use of an Oracle
JDO layer to work with Postgres. Set aside for a moment the discussion
of whether or not that is going to work.
What I have found is that different parts of this application are
> I'm sure that this has been asked before but I can't find any
> reference to it in google, and the search facility on
> postgresql.org is currently down.
http://groups.google.com/groups?q=group%3Apgsql.*
provides the same with a slight delay but arguably a better user
interface.
> I have a l
testdb=# CREATE TABLE foo (field_one int4);
CREATE TABLE
testdb=# INSERT INTO foo VALUES (1);
INSERT 0 1
testdb=# INSERT INTO foo VALUES (2);
INSERT 0 1
testdb=# SELECT * FROM foo;
field_one
---
1
2
(2 rows)
testdb=# SELECT * FROM FOO;
field_one
---
I'm trying to get a large Java application which makes use of an
Oracle JDO layer to work with Postgres. Set aside for a moment the
discussion of whether or not that is going to work.
What I have found is that different parts of this application are
referring to a table in all uppercase an
Just rejoined after a year of so of being away and have a question. The
Search from the PostgreSQL.org mail-archives site isn't working ( or
maybe not working like I think it should ) I get a 503 Server error.
The quesion just came up, as we start the process of moving from MySQL
to PostgreSQ
John Gray wrote on
Friday, January 27, 2006 12:24 PM
> On Wed, 25 Jan 2006 17:11:04 -0800, George Pavlov wrote:
>
>> Not sure what the correct forum for pgxml/xml2 questions is. I was
>> wondering what is the definition of "valid" that the xml_valid(text)
>> function that is part of that module u
Oliver Fürst <[EMAIL PROTECTED]> writes:
> But is nowhere stated if (multiple) commands inside a rule are treated
> as an implicit transaction as a whole.
If you don't specifically open a transaction at the top level (i.e. in
'psql' or SQL from your application's code), PG will encapsulate every
Hi Doug,
thanks for your answers so far. I think I should try to discuss that
matter in [pgsql-sql] instead.
On 27.01.2006 21:21, Doug McNaught wrote:
Oliver Fürst <[EMAIL PROTECTED]> writes:
Basically I'm worried that the whole "relying on the last value of a
sequence" isn't such a great i
Hello,
I'm trying to write an Apache 1.3.29 module connecting to PostgreSQL 8.1.0
on OpenBSD -current and have few probably simple questions:
When an Apache child is initialized, I'd like to establish connection to
the database and to prepare 2 queries. And then later in the repeating
response ph
On Fri, 2006-01-27 at 15:21, John Gray wrote:
> I know that - my point was just that when I was naming the functions, I
> (perhaps foolishly, in hindsight) decided that xml_wellformed seemed a
> longish name for a basic function. The README does in fact state that it
> checks well-formedness and n
Oliver Fürst <[EMAIL PROTECTED]> writes:
> Basically I'm worried that the whole "relying on the last value of a
> sequence" isn't such a great idea.
'currval()' is specifically written to Do The Right Thing. See the
docs.
-Doug
---(end of broadcast)-
On Fri, 2006-01-27 at 12:32 -0800, Roger Hand wrote:
> John Gray wrote on
> Friday, January 27, 2006 12:24 PM
> > On Wed, 25 Jan 2006 17:11:04 -0800, George Pavlov wrote:
> >
> >> Not sure what the correct forum for pgxml/xml2 questions is. I was
> >> wondering what is the definition of "valid" th
Hi Doug,
On 27.01.2006 21:01, Doug McNaught wrote:
Oliver Fürst <[EMAIL PROTECTED]> writes:
I have a question regarding rules on views. Are the commands inside a
ON INSERT (or UPDATE) DO INSTEAD (implicit) transactions for postgres?
I tried to put BEGIN; and COMMIT; around the commands in a ON
On Fri, 27 Jan 2006, Dave E Martin wrote:
When a query of this form:
/* from xxx where yyy = ? */ select a,b,c,d from xxx where yyy = ?
is sent to the jdbc driver (as a prepared statement), it complains that
parameter 2 is not set. This is a query from hibernate3.1, with hibernate's
"gener
When a query of this form:
/* from xxx where yyy = ? */ select a,b,c,d from xxx where yyy = ?
is sent to the jdbc driver (as a prepared statement), it complains that
parameter 2 is not set. This is a query from hibernate3.1, with
hibernate's "generate comments in sql" option turned on.
I'm n
Oliver Fürst <[EMAIL PROTECTED]> writes:
> Hi all,
>
> I have a question regarding rules on views. Are the commands inside a
> ON INSERT (or UPDATE) DO INSTEAD (implicit) transactions for postgres?
> I tried to put BEGIN; and COMMIT; around the commands in a ON ... DO
> INSTEAD ( ) block, but keep
Hi all,
I have a question regarding rules on views. Are the commands inside a ON
INSERT (or UPDATE) DO INSTEAD (implicit) transactions for postgres? I
tried to put BEGIN; and COMMIT; around the commands in a ON ... DO
INSTEAD ( ) block, but keep getting a syntax error.
The following example
"Steve Oualline" <[EMAIL PROTECTED]> writes:
> We have a system with 1202 files in the WAL directory (pg_xlog).
> When we start postmaster, it goes into the starting state for 5 minutes
> and then crashes.
Define "crash". If you don't show us the *exact* messages you're
seeing, it's difficult to
On Wed, 25 Jan 2006 17:11:04 -0800, George Pavlov wrote:
> Not sure what the correct forum for pgxml/xml2 questions is. I was
> wondering what is the definition of "valid" that the xml_valid(text)
> function that is part of that module uses? It seems different from the
> W3C definition of "valid"
contrib_regression=# insert into pg_ts_dict values (
'norwegian_ispell',
(select dict_init from pg_ts_dict where dict_name='ispell_template'),
'DictFile="/usr/local/share/ispell/norsk.dict" ,'
'AffFile ="/usr/local/share/ispell/norsk.aff"',
(select d
Title: WAL questions
We have a system with 1202 files in the WAL directory (pg_xlog).
When we start postmaster, it goes into the starting state for 5 minutes
and then crashes.
Questions:
1) What is the biggest number of WAL files you've seen and what were
you doing to the database at
On Fri, Jan 27, 2006 at 10:40:05 -0600,
Aaron Colflesh <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III wrote:
> >On Fri, Jan 27, 2006 at 10:25:00 -0600,
> > Aaron Colflesh <[EMAIL PROTECTED]> wrote:
> >
> >>#2 would seem to be the simplest except I'm really not too keen on the
> >>idea of manipu
Teodor,To all: May be, we should put all snowball's stemmers (for all available
languages and encodings) to tsearch2 directory?Yes, that would be VERY helpfull. Up to now I do not dare to use tsearch2 because "get stemmer here, get dictionary there..."Harald
-- GHUM Harald Massapersuadere et progra
On Fri, 27 Jan 2006, Stefano B. wrote:
> Hi,
>
> I have two identical tables
>
> table1 (f1,f2,f3,f4 primary key (f1,f2,f3,f4))
> table2 (g1,g2,g3,g4 primary key (g1,g2,g3,g4))
>
> How can I find the difference between the two tables?
> table1 has 1 records
> table2 has 9900 records (these re
I'm sure that this has been asked before but I can't find any reference to it
in google, and the search facility on postgresql.org is currently down.
I have a large number of entries (possibly 10,000+) in an XML file that I need
to import into the database (7.4 on Debian) on a daily basis. Does
I guess my email wasn't all that clear. I will try to rephrase. I
am moving from using the old style pg_dump for backups to using
incrementals and want to make sure I understand the process before I
go about writing a bunch of scritps.
To me setting up incremental backup consists of the f
"A. Kretschmer" <[EMAIL PROTECTED]> writes:
> am 27.01.2006, um 14:21:31 + mailte Matthew Henderson folgendes:
>> Okay, so if I have 7.4 installed and I have the old
>> harddisk mount under /mnt/hda can I do something
>> like
>>
>> pg_dump /mnt/hda/path_to_old_database > dump.txt
>
> No,
Alexander,
could you try tsearch2 from CVS HEAD ?
tsearch2 in 8.1.X doesn't supports UTF-8 and works for someone
only by accident :)
Oleg
On Fri, 27 Jan 2006, Alexander Presber wrote:
Tsearch/isepll is not able to break this word into parts, because of the
"s" in "Produktion/s/interva
On Friday 27 January 2006 08:25, Aaron Colflesh wrote:
> Hello folks,
> I've run into a challenge that doesn't appear to have been discussed in
> the archives anywhere.
>
> I'm designing a database that users need to have the ability to
> customize some. They just need the ability to add extra fiel
Bruno Wolff III wrote:
On Fri, Jan 27, 2006 at 10:25:00 -0600,
Aaron Colflesh <[EMAIL PROTECTED]> wrote:
#2 would seem to be the simplest except I'm really not too keen on the
idea of manipulating a table like that on the fly (even though I did
proof of concept it and it seems
Sorry for my sharp reply! It looks like we are after the same thing
so that does help a little although it doesn't really answer my
question. I set up my backups system using pg_dump back in 7.3
because that's all there was. I am finally moving to 8.1 and want to
switch to doing incremen
On Fri, Jan 27, 2006 at 10:25:00 -0600,
Aaron Colflesh <[EMAIL PROTECTED]> wrote:
>
> #2 would seem to be the simplest except I'm really not too keen on the
> idea of manipulating a table like that on the fly (even though I did
> proof of concept it and it seems to be simple enough to be fairl
Hello folks,
I've run into a challenge that doesn't appear to have been discussed in
the archives anywhere.
I'm designing a database that users need to have the ability to
customize some. They just need the ability to add extra fields to an
existing table (oh and they can't touch the predefin
"Ilja Golshtein" <[EMAIL PROTECTED]> writes:
>> On Wed, Jan 25, 2006 at 11:26:39AM -0500, Tom Lane wrote:
> That's just plain bizarre. Would you try it with \set VERBOSITY verbose
> so we can see exactly where the error is coming from?
> No extra information. Just "ERROR: "ddd" is not a table".
"Marcus Couto" <[EMAIL PROTECTED]> writes:
> Here's a basic question. On working with backing up and restoring it =
> seems like if I keep on doing it in a row, the backup file size keeps on =
> increasing in size. It almost doubles in size for every backup/restore. =
> I want the restore the backu
Ted Powell <[EMAIL PROTECTED]> writes:
> Has this not been done simply because nobody has gotten around to it, or
> are there pitfalls?
What are you going to do with binary parameter values? Calling the
type's output converter is possible but not very pleasant.
> Also, the Datum params[i].value,
Hi!
>On Wed, Jan 25, 2006 at 11:26:39AM -0500, Tom Lane wrote:
>> "Ilja Golshtein" <[EMAIL PROTECTED]> writes:
>> > postgres=# create table ddd(f1 int4);
>> > CREATE TABLE
>> > postgres=# drop table ddd;
>> > ERROR: "ddd" is not a table
>>
>> That's just plain bizarre. Would you try it with \se
frank church <[EMAIL PROTECTED]> writes:
> I repeatedly get this error whenever I try to backup a database
> pg_dump: ERROR: invalid memory alloc request size 4294967290
> pg_dump: SQL command to dump the contents of table "cc_ratecard" failed:
> PQendcopy() failed.
Looks like a corrupt-data pro
am 27.01.2006, um 14:21:31 + mailte Matthew Henderson folgendes:
> Okay, so if I have 7.4 installed and I have the old
> harddisk mount under /mnt/hda can I do something
> like
>
> pg_dump /mnt/hda/path_to_old_database > dump.txt
No, this is imposible IMHO. You need a PG-Server with this
I should add that, with the minimal dictionary and .aff file,
"vertrags" gets reduced alright, dropping the trailing 's':
tstest=# SELECT tsearch2.ts_debug('vertrags');
ts_debug
-
(german,lword,"La
Okay, so if I have 7.4 installed and I have the old
harddisk mount under /mnt/hda can I do something
like
pg_dump /mnt/hda/path_to_old_database > dump.txt
???
On Fri, Jan 27, 2006 at 02:47:21PM +0100, Peter Eisentraut wrote:
> Am Freitag, 27. Januar 2006 11:30 schrieb Matthew Henderson:
>
I wrote:
Note that IN and EXCEPT are essentially set operators - if you have
duplicates in either table, you might not get what you expect.
If what you want is the =bag= difference of the two tables, you'll
have to do something more complicated.
and then I immediately saw Pandurangan's mess
Tsearch/isepll is not able to break this word into parts, because
of the "s" in "Produktion/s/intervall". Misspelling the word as
"Produktionintervall" fixes it:
It should be affixes marked as 'affix in middle of compound word',
Flag is '~', example look in norsk dictionary:
flag ~\\:
[^S
Marcus Couto wrote:
Here's a basic question. On working with backing up and restoring it
seems like if I keep on doing it in a row, the backup file size keeps
on increasing in size. It almost doubles in size for every
backup/restore. I want the restore the backup to overwrite the
database and not
On Jan 27, 2006, at 08:59, Stefano B. wrote:
select f1,f2,f3,f4 from table1 where (f1,f2,f3,f4) NOT IN (select
f1,f2,f3,f4 from table2)
but it seems not work (as I want). It returns me no records. If I use
the IN clause it returns me all 1 table1 records.
The standard way to do this i
select f1,f2,f3,f4 from table1 EXCEPT ALL select f1,f2,f3,f4 from table2
http://www.postgresql.org/docs/8.1/static/sql-select.html
On 1/27/06, Stefano B. <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have two identical tables
>
> table1 (f1,f2,f3,f4 primary key (f1,f2,f3,f4))
>
> table2 (g1,g2,g3,g4 p
am 27.01.2006, um 14:59:47 +0100 mailte Stefano B. folgendes:
> How can I find the difference between the two tables?
> table1 has 1 records
> table2 has 9900 records (these records are in table1 as well)
>
> I'd like to find 100 missing records.
> I have try this query
>
> select f1,f2,f3,
Hi,
I have two identical tables
table1 (f1,f2,f3,f4 primary key
(f1,f2,f3,f4))
table2 (g1,g2,g3,g4 primary key
(g1,g2,g3,g4))
How can I find the difference between the two
tables?
table1 has 1 records
table2 has 9900 records (these records are in
table1 as well)
I'd like to fin
Am Freitag, 27. Januar 2006 11:30 schrieb Matthew Henderson:
> How should I go about doing this? Are there any problems
> I should be aware of in moving from version 7.4 to 8.1?
For one thing you won't be able to read the 7.4 database using 8.1 binaries,
so you need to get 7.4 installed first in
Hi,
Is there any way to change a SERIAL type to an INTEGER? I think that it
should be easy, since SERIAL is, in fact, an INTEGER with some conditions.
There serial column is just a integer, with default as nextval from a
sequence, so there is no neccessity to change the datatype of the
column. Yo
I repeatedly get this error whenever I try to backup a database
The command used is:
pg_dump -Fc -O -U username tablename > tablename.20060122
pg_dump: ERROR: invalid memory alloc request size 4294967290
pg_dump: SQL command to dump the contents of table "cc_ratecard" failed:
PQendcopy() faile
http://archives.postgresql.org/pgsql-general/2006-01/msg01259.php
On 1/27/06, Emil Rachovsky <[EMAIL PROTECTED]> wrote:
>
> Hi,
> I am using PostgreSQL 8.1.0 . How can I find a temp
> table from my session, having the name of the table?
> Can anyone show me what query should I execute? I've
> tri
Here's a basic question. On working with
backing up and restoring it seems like if I keep on doing it in a row,
the backup file size keeps on increasing in size. It almost doubles in size for
every backup/restore. I want the restore the backup to overwrite the database
and not add to it. Is
Hi everybody:
In a computer which is un production, I have a PostgreSQL 7.4 database.
In a couple of tables, I have just realised that I made a small mistake:
the primary key is SERIAL but what I really need is an INTEGER, since I
do not need the auto-increment feature or the sequence. Until n
Dear all,
I am a novice user, so any help with the following problem
would be greatly appreciated.
I had Suse 9.1 installed on one hard disk in my machine
(/dev/hda). On this machine Postgresql 7.4 was installed
and I had one database which, I believe, was installed
in the default location
This
Our development group needs to have the option of logging all SQL
statements including substituted parameter values. Getting output in the
form:
... WHERE contact.login_con = $1 AND company.login_co = $2
was no problem, but nothing that I tried turning on in the config file
yielded values for
For administration try pgAdmin III but to make applications you could try
Gambas see: http://gambas.sourceforge.net/ or even Lazarus see:
http://www.lazarus.freepascal.org/
For internet stuff try Ruby on Rails. It has a bit of a steep learning
curve to start with but it's a RAD tool when you g
Hi,
I am using PostgreSQL 8.1.0 . How can I find a temp
table from my session, having the name of the table?
Can anyone show me what query should I execute? I've
tried some things but I receive mixed results of
tables from different sessions, which is strange.
Sergey Karin wrote:
Maybe someone have a comparision results of Postgres, DB2, Oracle
and Informix (or postgres and any of commertial DBMS) when this DBMS manage
with VLDB? I will VERY, VERY respect to that man for the information...
It is against the rules of your Oracle licence to publish per
Hi,
On Thu, 26 Jan 2006, Eric B. Ridge wrote:
hahaha, *blush*. I could just use "now()", right? pg8.1 docs say that
now()/CURRENT_TIMESTAMP "return the start time of the current transaction;
their values do not change during the transaction". I could use a composite
of (now(), GetTopTra
Rick Gigger wrote:
Um, no you didn't read my email at all. I am aware of all of that and
it is clearly outlined in the docs. My email was about a specific
detail in the process. Please read it if you want to know what my
actual question was.
I'm not sure your email is quite right as regard
OK, that was before going home from work, so it could be excusable :-D
I read your mail now in more detail, and I can't answer it other than
that we use here a standby data base based on WAL log shipping, and the
procedure of building the standby finishes with a script
inserting/deleting a few 1000
Hi, List!
Some times ago in this list was discussed next question: Which databases are small and which are large?
The answer was:
1-2 GB - small
50 and around - large
As I think, hundreds of GB and more - very large (VLDB).
How Postgres works with VLDB? And what about speed? Can I expect that
p
Hello!
In my PostgreSQL logfile, I see that the following entries occur
very frequently:
2006-01-27 10:37:29 FATAL could not read from statistics collector
pipe: No error
2006-01-27 10:37:30 LOGstatistics collector process (PID 5940)
was
On 1/26/06, Eric B. Ridge <[EMAIL PROTECTED]> wrote:
> Outside of "VACUUM FREEZE", is there any way the "xmin" column in a
> relation can change, assuming of course the tuple is never updated
> again? I'm considering using this as a way to identify all tuples
> modified in the same transaction (in
Robert Korteweg wrote:
Robert Korteweg writes:
I have a problem with a database i'm maintaining. I first noticed
the problem because i could not make a backup of the database i got
the following error:
pg_dump: missing pg_database entry for database "xxx"
I verified this by selecting t
70 matches
Mail list logo
