Hi,
I'm playing with the contrib/pgxml library under PG 8.1.4, and I'm not sure if
what I found with pgxml is a feature of a bug:
I've got the following table:
CREATE TABLE test
(
id int4 NOT NULL,
xml varchar(200),
CONSTRAINT pk PRIMARY KEY (id)
)
WITHOUT OIDS;
INS
Tom Lane wrote:
"Matthew T. O'Connor" writes:
They have talked about changing the messageblks to binary instead of
text. They said that one of their main objections is that bytea data is
not compressed. I'm not sure that's true, but I don't see anything in
the docs about it. I think they
I didn't see any strange number in your log message and 16777212 is 16M,which is not a scary number ... is there any other memory-exhausting program
in the same machine?Besides Windows 2003, PostgreSQL Server and the Oracel CLIENT libraries the only thing running is a script of mine (which uses aro
While this statement is accurate, it isn't very precise. Needs change.
Requirements change. Usage changes. Any one of these changes can
invalidate a very correct initial analysis. A wise designer anticipates
change to minimize impact on both current work *and* future development
effort. Artific
"Tom Lane" <[EMAIL PROTECTED]> wrote
>
> Well, *something* sent that backend a SIGINT.
>
Could something be the backend statement_timeout? I remember [but not sure]
we don't differenciate timeout or explicite SIGINT in 7.4.x.
Regards,
Qingqing
---(end of broadcast)
"H.J. Sanders" <[EMAIL PROTECTED]> writes:
> The next query runs into error 57014 in about 50 % of the cases. We
> certainly have not aborted the request. In the other 50 % it runs OK. The
> statement is executed
> in pgsql 7.4.8
Well, *something* sent that backend a SIGINT. You should look aroun
[EMAIL PROTECTED] wrote:
In the book "Practical Issues in Database Management", Fabian Pascal
notes three reasons for choosing one PK over another - familiarity,
stability, and simplicity.
He notes further that those influenced by OO db design tend to use
simple, surrogate keys for all PKs in al
""Harald Armin Massa"" <[EMAIL PROTECTED]> wrote
> today postgresql 8.1.3 on win32 died:
> 2006-06-08 16:33:12 ERROR: out of memory
> 2006-06-08 16:33:12 DETAIL: Failed on request of size 16777212.
>
I didn't see any strange number in your log message and 16777212 is 16M,
which is not a scary n
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Trent Shipley)
wrote:
> On Thursday 2006-06-08 15:14, David Fetter wrote:
>> On Thu, Jun 08, 2006 at 05:21:07AM -0700, [EMAIL PROTECTED] wrote:
>
>> on bag theory[1] and 3-value logic[2]. Until they come up with a
>> testable system,
Hello,
Does anybody have a link or tutorial of Manual Installation of
PostgreSQL on Windows?
I'd like to install it manually rather than automatically.
Thanks,
Mic
signature.asc
Description: OpenPGP digital signature
Hello.
The next query runs into error
57014 in about 50 % of the cases. We certainly have not aborted the request. In
the other 50 % it runs OK. The statement is executed
in pgsql
7.4.8
Statement:
SELECT pst.typ_stay,
SUM(pst.nr_rooms), SUM(pst.nr_trans), SUM(pst.pst_amnt)
On Thu, Jun 08, 2006 at 06:09:21PM -0700, Trent Shipley wrote:
> On Thursday 2006-06-08 15:14, David Fetter wrote:
> > On Thu, Jun 08, 2006 at 05:21:07AM -0700, [EMAIL PROTECTED] wrote:
>
> > on bag theory[1] and 3-value logic[2]. Until they come up with a
> > testable system, or Hell freezes ove
On Thursday 2006-06-08 05:48, [EMAIL PROTECTED] wrote:
> What am I missing? Why use a composite key *ever* aside from
> "familiarity?" Could someone give a real-world example where
> "familiarity" is a compelling reason to choose a composite PK, and
> trumps stability and simplicity?
Another "fam
On Thursday 2006-06-08 15:14, David Fetter wrote:
> On Thu, Jun 08, 2006 at 05:21:07AM -0700, [EMAIL PROTECTED] wrote:
> on bag theory[1] and 3-value logic[2]. Until they come up with a
> testable system, or Hell freezes over, whichever comes first, Pascal's
> book will make a good companion on y
Johan van der Merwe wrote:
My code is as follows:
Public dbRemote As New Connection
Public rsData As New Recordset
dbRemote.Properties("Data Source").Value = "DSM"
dbRemote.Properties("Initial Catalog").Value = "BCM_DSM"
dbRemote.Properties("User ID").Value = "user"
dbRemote.Properties("P
To balance the discussion, I would like to say that I thoroughly
enjoyed Date's latest "Database In Depth". It gave me a strong
foundation in relational theory and I can say that I think more about
my schema designs thanks to the advice in the text. Just because SQL
may allow something, doesn't
Yeah - I just did a reindex, that fixed the indexes at least.AlexOn 6/8/06, Jim C. Nasby <[EMAIL PROTECTED]
> wrote:On Thu, Jun 08, 2006 at 06:03:23PM -0400, Alex Turner wrote:> I hope I'm reading this query wrong:
>> trend=# select relname, relpages*8192/reltuples from pg_class where> reltuples>0
On Thu, Jun 08, 2006 at 06:03:23PM -0400, Alex Turner wrote:
> I hope I'm reading this query wrong:
>
> trend=# select relname, relpages*8192/reltuples from pg_class where
> reltuples>0 order by relpages desc limit 10;
>relname| ?column?
> --
Gavin M. Roy wrote:
It doesnt sound like an apache problem to me, it sounds like a library
version conflict happening in PHP, so apache shouldn't impact it. What
happens when you try and access pgsql functions from the cli?
Gavin
I already recompiled another configuration and can't test at
Hugo <[EMAIL PROTECTED]> writes:
> If I feed psql with a file with sql sentences, what is the size limit for
> the file,
There is no particular limit.
> I have a more or less 67MB file , with about 439.000 insert
> sentences, but only inserts 3900 rows, what can I do to "see" what insert
> senten
On Thu, Jun 08, 2006 at 05:22:46PM -0500, Scott Marlowe wrote:
> On Thu, 2006-06-08 at 17:14, David Fetter wrote:
>
> > Pascal, Date, and Darwen have been alleging for years, with
> > increasing shrillness, that DBMSs should be based on set theory
> > and 2-value logic. I say "alleging" because t
On Thu, 2006-06-08 at 17:14, David Fetter wrote:
> Pascal, Date, and Darwen have been alleging for years, with increasing
> shrillness, that DBMSs should be based on set theory and 2-value
> logic. I say "alleging" because they have not backed up this idea
> with any actual software that others c
On Thu, Jun 08, 2006 at 05:21:07AM -0700, [EMAIL PROTECTED] wrote:
> I'm reading, and enjoying immensely, Fabial Pascal's book "Practical
> Issues in Database Management."
Be aware that Pascal, along with Date and Darwen, are...how do I put
this gently...cranks. They've been getting more strident
On Thu, 2006-06-08 at 16:17, Chris Browne wrote:
> [EMAIL PROTECTED] (Scott Marlowe) writes:
> > To me, the real argument is, "Is SQL so lacking that it should be
> > replaced". In what REAL measurable ways is SQL lacking so badly we
> > should toss it and start over? It's not perfect, that's for
[EMAIL PROTECTED] (Scott Marlowe) writes:
> To me, the real argument is, "Is SQL so lacking that it should be
> replaced". In what REAL measurable ways is SQL lacking so badly we
> should toss it and start over? It's not perfect, that's for sure.
> But what's the investment on starting over, and
I hope I'm reading this query wrong:trend=# select relname, relpages*8192/reltuples from pg_class where reltuples>0 order by relpages desc limit 10; relname | ?column?---+--
property | 19935.4468376195 resul
sorry again, the psql I am running from a Windows clientOn 6/8/06, Hugo <[EMAIL PROTECTED]> wrote:
Sorry, forgot to mention, running Postgres 8.1 on a SUSE 10 On 6/8/06, Hugo <
[EMAIL PROTECTED]> wrote:
Hello list,If I feed psql with a file with sql sentences, what is the size limit for the file, I
"Matthew T. O'Connor" writes:
> They have talked about changing the messageblks to binary instead of
> text. They said that one of their main objections is that bytea data is
> not compressed. I'm not sure that's true, but I don't see anything in
> the docs about it. I think they would move
Sorry, forgot to mention, running Postgres 8.1 on a SUSE 10 On 6/8/06, Hugo <[EMAIL PROTECTED]> wrote:
Hello list,If I feed psql with a file with sql sentences, what is the size limit for the file, I have a more or less 67MB file , with about
439.000 insert sentences, but only inserts 3900 rows, w
Hello list,If I feed psql with a file with sql sentences, what is the size limit for the file, I have a more or less 67MB file , with about 439.000 insert sentences, but only inserts 3900 rows, what can I do to "see" what insert sentences are failing ?
thanks for any advicebest regardsHugo
In the last exciting episode, [EMAIL PROTECTED] wrote:
> I'm reading, and enjoying immensely, Fabial Pascal's book "Practical
> Issues in Database Management."
>
> Though I've just gotten started with the book, he seems to be saying
> that modern RDBMSs aren't as faithful to relational theory as th
On 8 Jun 2006 04:30:38 -0700
[EMAIL PROTECTED] wrote:
> Here's one Druid "annoyance"
>
> One real pain with the ER Diagram is that it seems to insist on
> including, and often inconveniently repositioning, a little non-entity
> yellow box that says Unamed. I think it's a color legend. Anyone know
It doesnt sound like an apache problem to me, it sounds like a
library version conflict happening in PHP, so apache shouldn't impact
it. What happens when you try and access pgsql functions from the cli?
Gavin
On Jun 8, 2006, at 2:22 PM, [EMAIL PROTECTED] wrote:
Gavin M. Roy wrote:
I'm on
On Thu, 2006-06-08 at 16:22, [EMAIL PROTECTED] wrote:
> Gavin M. Roy wrote:
> > I'm on linux and run PHP 5.1.4, PgSQL 8.1.4 and Apache 2.0.x (current).
> >
> > You shouldnt need to do a clean install, I'd just try in this order:
> >
> > compile and install pgsql 8.1.4
> > ldconfig (to update libr
Gavin M. Roy wrote:
I'm on linux and run PHP 5.1.4, PgSQL 8.1.4 and Apache 2.0.x (current).
You shouldnt need to do a clean install, I'd just try in this order:
compile and install pgsql 8.1.4
ldconfig (to update library stuff, may not be needed)
compile and install php 5.1.4
kick off apache...
I'm on linux and run PHP 5.1.4, PgSQL 8.1.4 and Apache 2.0.x (current).
You shouldnt need to do a clean install, I'd just try in this order:
compile and install pgsql 8.1.4
ldconfig (to update library stuff, may not be needed)
compile and install php 5.1.4
kick off apache...
BTW your other thre
Gavin M. Roy wrote:
I'd check to make sure you dont have extra pgsql.so and postgresql
library files laying about. My off the cuff guess is that pgsql.so is
linked against 8.0 libs and you need to recompile it to link against 8.1
libs?
Gavin
If I do clean install (starting from the OS, Fre
I'd check to make sure you dont have extra pgsql.so and postgresql
library files laying about. My off the cuff guess is that pgsql.so
is linked against 8.0 libs and you need to recompile it to link
against 8.1 libs?
Gavin
On Jun 8, 2006, at 1:47 PM, [EMAIL PROTECTED] wrote:
I wrote abou
On Thu, 2006-06-08 at 07:21, [EMAIL PROTECTED] wrote:
> I'm reading, and enjoying immensely, Fabial Pascal's book "Practical
> Issues in Database Management."
>
> Though I've just gotten started with the book, he seems to be saying
> that modern RDBMSs aren't as faithful to relational theory as th
Daniel Verite wrote:
IMHO they fail to draw the proper conclusion, which is that
either the raw mail should be stored as either as a binary object,
or as a text field in a database with SQL_ASCII encoding, in both
cases providing the level of transparency that they need by design,
their purpose b
I wrote about this, but I lost the thread.
Today I did clean install in a new virtual machine of FreeBSD 5.4,
Apache 1.3.36, php 5.1.4 and PostgreSQL 8.1.4 from ports - and apache
did core dump again.
Commenting pgsql.so in the php extensions solves the problem, but I need it.
Is there anybo
On Wed, 2006-06-07 at 10:09, sergey kapustin wrote:
> Hi all!
> can anybody say me what's wrong with this query. I just try to take
> unique values from table column and print them in random order
>
> select distinct num from (select 1 as num union select 2 as num union
> select 1 as num union sel
Daniel Verite wrote:
Matthew T. O'Connor wrote:
The basic setup is that Postfix hands the email to a program called
dbmail-smtp which parses and insert the message into the database.
DBMail doesn't know anything about encoding.
That's precisely what SQL_ASCII is for. Why not st
In what way could a database like PostgreSQL not be "faithful to relational theory"? Does he give any explanation as to what that means?
Some people mistake the word relational for the meaning of normalization, but they do not have the same meaning. If Fabial is mistaking relational for normal
Tino Wildenhain wrote:
Matthew T. O'Connor schrieb:
Well, to answer my own question, I hacked the source code of DBMail
and had it set the client encoding to LATIN1 immediately after
database connect, this seems to have fixed the problem.
You could also just have set the client_encoding as a
[EMAIL PROTECTED] writes:
> My troubles would be solved if I could reference a SessionID from
> within PG. Any hope?
Create a sequence. At session start, nextval() it to assign a session
ID for your session. Then currval() returns your session ID whenever
you need it.
sergey kapustin wrote:
Hi all!
can anybody say me what's wrong with this query. I just try to take
unique values from table column and print them in random order
select distinct num from (select 1 as num union select 2 as num union
select 1 as num union select 3) t order by random();
ERROR: for
Harry Hehl
DiskStream Incorporated
v: 519.579.8166 x30
f: 519.579.9746
www.diskstream.com
This communication is intended to be received by the individual or entity to whom or to which it is addressed and may contain information that is confidential and/or subject to copyright or othe
Hello All-
I am in the process of replacing the backend for a large MS Access
project with PG.
I really could use a Session ID. I would like to create a view like
this:
CREATE VIEW mysettings
AS
SELECT * FROM mysettingstable
WHERE sessionidcolumn = CURRENTSESSIONID()
It is ess
Thanks Michael.
I suppose I will have to find another way to represent the data, yes.
We are tracking fire progress across a landscape, based on processing of
MODIS (http://modis.gsfc.nasa.gov/) data.
Thanks again,
Meghan
Hi all!
can anybody say me what's wrong with this query. I just try to take
unique values from table column and print them in random order
select distinct num from (select 1 as num union select 2 as num union
select 1 as num union select 3) t order by random();
ERROR: for SELECT DISTINCT, ORDER
In the book "Practical Issues in Database Management", Fabian Pascal
notes three reasons for choosing one PK over another - familiarity,
stability, and simplicity.
He notes further that those influenced by OO db design tend to use
simple, surrogate keys for all PKs in all databases they design; th
OK... so I see now that Access seems to be having a field day with
opening and closing sessions, in a way that seems out of my control.
This explains why my temporary table solutions (and then my plperl
global variable solution) were not working.
I will have to go with plan B.
I'd still
If one decides to use a composite key, beyond how many attributes
should one seriously consider creating a surrogate key instead? 4? 5?
Less? I have seen a composite key composed of 5 attributes and thought
- why? What's the value over a surrogate key?
I guess choosing a candidate key (presuming t
I'm reading, and enjoying immensely, Fabial Pascal's book "Practical
Issues in Database Management."
Though I've just gotten started with the book, he seems to be saying
that modern RDBMSs aren't as faithful to relational theory as they
ought to be, and that this has many *practical* consequences,
> I have used Case Studio 2 (fine, weak on documentation generation), and
> PowerDesigner by Sybase (truly excellent! but $$$)
> John
Thanks John.
I've been playing with Druid and it seems to be able to do what I need
it to do. It wasn't immediately intuitive to use, but the functionality
is ther
On Wed, Jun 07, 2006 at 10:31:22AM -0400, Tom Lane wrote:
: Jonathon McKitrick <[EMAIL PROTECTED]> writes:
: > I'm migrating to a new MacBook, and while I finally got it to compile,
initdb,
: > and start a postmaster, any time I try createdb or createuser, I get a
message
: > that the database 'p
[EMAIL PROTECTED] ("jqpx37") writes:
> Is there any security risk in the postgresql superuser having a
> password?
>
> I installed a Linux distro recently and had it install Postgresql.
> It automatically set up the postgres account; the account was set up
> with no password.
>
> I could of course
On Tue, Jun 06, 2006 at 01:54:01PM -0500, Sergio Duran wrote:
> Hello,
>
> I would like to know if it is possible to create a trigger function which
> does something like
>
> CREATE OR REPLACE FUNCTION table_audit() RETURNS TRIGGER AS $table_audit$
> BEGIN
> INSERT INTO audit SELECT TG_OP, curre
On Thu, 2006-06-08 at 09:08 -0600, jqpx37 wrote:
> Sorry; I meant a password at the operating system level, not at the
> postgresql level.
>
> On my Linux system, without an OS level password, the only way to log in (in
> Linux) to the postgres account is by su'ing from root, which seems more
>
Sorry; I meant a password at the operating system level, not at the postgresql
level.
On my Linux system, without an OS level password, the only way to log in (in
Linux) to the postgres account is by su'ing from root, which seems more secure
than having a password for the postgres account.
---
Hello,today postgresql 8.1.3 on win32 died:2006-06-08 16:33:09 LOG: autovacuum: processing database "ibox"TopMemoryContext: 84400 total in 7 blocks; 12696 free (22 chunks); 71704 usedOperator class cache: 8192 total in 1 blocks; 4936 free (0 chunks); 3256 used
TopTransactionContext: 8192 total in
Is there any security risk in the postgresql superuser having a password?
I installed a Linux distro recently and had it install Postgresql. It
automatically set up the postgres account; the account was set up with no
password.
I could of course create a password, but it's not clear to me that
Tim Allen wrote:
Tino Wildenhain wrote:
Tim Allen schrieb:
[snip]
The way to tell PostgreSQL what encoding you want to use is by use
of the client_encoding GUC variable, eg
set client_encoding to 'LATIN1';
If you cant educate your client application to set this option on
connect,
you
Douglas McNaught wrote:
> I would think it would (at least potentially) vary with each message.
> The dbmail software should really set client_encoding based on the
> Content-Transfer-Encoding header in the message (or whatever it's
> called).
That would be the "charset" parameter of the
My code is as follows:
Public dbRemote As New Connection
Public rsData As New Recordset
dbRemote.Properties("Data Source").Value = "DSM"
dbRemote.Properties("Initial Catalog").Value = "BCM_DSM"
dbRemote.Properties("User ID").Value = "user"
dbRemote.Properties("Password").Value = "password"
d
Tino Wildenhain <[EMAIL PROTECTED]> writes:
> Alban Hertroys schrieb:
>> Matthew T. O'Connor wrote:
>>
>>> Well, to answer my own question, I hacked the source code of DBMail
>>> and had it set the client encoding to LATIN1 immediately after
>>> database connect, this seems to have fixed the probl
Matthew T. O'Connor wrote:
> The basic setup is that Postfix hands the email to a program called
> dbmail-smtp which parses and insert the message into the database.
> DBMail doesn't know anything about encoding.
That's precisely what SQL_ASCII is for. Why not stay with it?
--
Daniel
Alban Hertroys schrieb:
Matthew T. O'Connor wrote:
Well, to answer my own question, I hacked the source code of DBMail
and had it set the client encoding to LATIN1 immediately after
database connect, this seems to have fixed the problem.
LATIN1 != UTF-8. Your problem isn't solved yet.
We
Matthew T. O'Connor wrote:
Well, to answer my own question, I hacked the source code of DBMail and
had it set the client encoding to LATIN1 immediately after database
connect, this seems to have fixed the problem.
LATIN1 != UTF-8. Your problem isn't solved yet.
You should either tell your cli
Tino Wildenhain wrote:
Tim Allen schrieb:
[snip]
The way to tell PostgreSQL what encoding you want to use is by use of
the client_encoding GUC variable, eg
set client_encoding to 'LATIN1';
If you cant educate your client application to set this option on connect,
you can set this per use
Tim Allen schrieb:
Matthew T. O'Connor wrote:
Well, to answer my own question, I hacked the source code of DBMail
and had it set the client encoding to LATIN1 immediately after
database connect, this seems to have fixed the problem.
Sorry for the noise,
Matt
I've seen this sort of proble
Matthew T. O'Connor wrote:
Well, to answer my own question, I hacked the source code of DBMail and
had it set the client encoding to LATIN1 immediately after database
connect, this seems to have fixed the problem.
Sorry for the noise,
Matt
I've seen this sort of problem asked about in the m
73 matches
Mail list logo
