[EMAIL PROTECTED] wrote:
...it will be the first time they have seen your name... ...with your first
email have criticised the project...
Check the archives. This poster has been active on the list for awhile.
He has indeed, and even posted a news item, but it will still be the
first time many
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
- -
PostgreSQL New RPM Sets
2005-03-11
Versions: 8.0.1, 7.4.7
Operating Systems:
* Red Hat Enterprise Linux Enterprise Server 2.1
* Red Hat Enterprise Linux Enterprise Server 4
*
Pg8.0.1
backend begin;
backend create table a (i int);
backend insert into a values(1);
1: i (typeid = 23, len = 4, typmod = -1, byval = t)
backend select * from pg_class;
1: relname (typeid = 19, len = 64, typmod = -1, byval = f)
2: relnamespace
Actually I have a strong feeling what really _ought_ to happen here is that
the inherited tables support in postgres, which never really worked anyways,
should be deprecated and eventually removed.
Hopefully not. They are useful for other things, too.
Karsten
--
GPG key ID E4071346 @
I don't know that much about medicine, so this might be a funny
question, but do you really need to know that shots 4 and 5 are
missing,
I want to be able to display shot 4: ... and shot 5: ... in
the application but pull the data from the database, not
calculate it in the
How do you know that PG is in maintainence mode?
I am not sure what PG's maintainence mode is and not aware of any
configuration parameters that could control the IO reponse waiting time.
Postgres just issues the ordinary file system read/write command and wait
for the response.
Regards,
Hi All!
While restoring PG7.23 dump into PG 8.01 database
(pg_restore -Fc -d a3 -v arz3.test.dat) i got error:
pg_restore: ERROR: invalid byte sequence for encoding UNICODE: 0xfc3535
CONTEXT: COPY mytable, line 9, column post3: 55146/23.12.04
pg_restore: [archiver (db)]
go wrote:
Hi All!
While restoring PG7.23 dump into PG 8.01 database
(pg_restore -Fc -d a3 -v arz3.test.dat) i got error:
pg_restore: ERROR: invalid byte sequence for encoding UNICODE: 0xfc3535
CONTEXT: COPY mytable, line 9, column post3: 55146/23.12.04
pg_restore: [archiver
On Mar 11, 2005, at 4:07 AM, Qingqing Zhou wrote:
Pg8.0.1
backend begin;
backend create table a (i int);
backend insert into a values(1);
1: i (typeid = 23, len = 4, typmod = -1, byval = t)
backend select * from pg_class;
1: relname (typeid = 19, len = 64,
why this query needs more time? Its very slow
thx
//QUERY
select
coalesce(personaldetails.masterid::numeric,personaldetails.id) +
(coalesce(personaldetails.id::numeric,0)/100) as sorting,
You can look up our complete schema in our Wiki:
http://salaam.homeunix.com/twiki/bin/view/Gnumed/WebHome
Go to Deverloper Guide - Database Structure.
http://salaam.homeunix.com/twiki/bin/view/Gnumed/DatabaseSchema
is more convenient for you guys.
Karsten
--
GPG key ID E4071346 @
Solution found! Thanks to Kris Jurka's advise I managed to pass this info
using: elog(INFO,... or elog(NOTICE,... . These messages together with
.getWarnings() do the job. :
e.g. message returned by the SQLWarning:
SNOTICEC0M#SUCCESSFUL EXECUTION. NO TUPLES FROM PEER(S):
Any suggestions on how to set up a server -strictly- for data mining?
This means:
- I want queries to run as quickly as possible, and
- I don't care if I lose data if the power goes down.
A solid state disk would obviously speed things up, like the to-disk
sorts that Postgres does when it runs
Title: Convert Cursor to array
Hi,
In a procedure, I put data of Cursor in a two-dimensional array. This allows me to sort rows.
The problem is this method is too slow.
In fact, I translate a pl/sql procedure to a plpgsql.
Under Oracle, we use bulk and I search to use equivalent of
ALÝ ÇELÝK wrote:
why this query needs more time? Its very slow
Difficult to say for sure - could you provide the output of EXPLAIN
ANALYSE rather than just EXPLAIN?
Some other immediate observations:
1. Perhaps don't post to so many mailing lists at once. If you reply to
this, maybe reduce it
* Jim C. Nasby [EMAIL PROTECTED] [0336 21:36]:
With the attitude of Windows can not be made to reliably run a
database, how many developers do you think will be attracted?
People are entitled to an opinion, and in many cases its formed from
experience. I think it's unrealistic to expect a
GIROIRE Nicolas (COFRAMI) wrote:
Hi,
In a procedure, I put data of Cursor in a two-dimensional array. This allows
me to sort rows.
The problem is this method is too slow.
In fact, I translate a pl/sql procedure to a plpgsql.
Under Oracle, we use bulk and I search to use equivalent of this under
Title: RE: [GENERAL] Convert Cursor to array
my sort algorithm is a very particular solution.
In fact, I put record in array to allow me to sort record. I sort them by using one column of my table but the column indx can have duplicate value and it's volontary.
here is the order algorithm
Richard Huxton wrote:
It can also be bad - the more time spent supporting Windows, the less
time is spent working on PostgreSQL itself.
Unless the Windows support attracts more resources. Personally I'd be
surprised if that's not the case.
That's clearly a decision only you can make. Getting
On Fri, Mar 11, 2005 at 06:16:28PM +1100, Russell Smith wrote:
On Fri, 11 Mar 2005 03:39 am, Michael Fuhr wrote:
On Thu, Mar 10, 2005 at 01:31:21AM -0800, Net Virtual Mailing Lists wrote:
Some have suggested that PostgreSQL should use a weaker lock on the
referenced key, but that hasn't
Hi All,
I'd like to ask your opininon about how to handle DST on an 7/24 system.
Where should it be handled: on the server side or on the client side? And
how could I (at all could I???) make it transparent?
Or we must bow to the fact that twice a year there are two unusable hours?
If it cannot
On Thu, Mar 10, 2005 at 13:22:05 +0100,
Karsten Hilbert [EMAIL PROTECTED] wrote:
Also notice that we do have views that display the missing
shots per schedule per patient. I just have not found a way to
join the two views (that is, given and missing) because that
would AFAICT require the
That remains to be seen.
I wouldn't consider it the least bit worthwhile to try to evaluate it
now, as what is happening now is that WinFolk are getting their very
first exposure to the software.
It would seem surprising for new developers to emerge from the
Windows(tm) population before at
Quoth [EMAIL PROTECTED] (Jim C. Nasby):
With the attitude of Windows can not be made to reliably run a
database, how many developers do you think will be attracted?
That remains to be seen.
I wouldn't consider it the least bit worthwhile to try to evaluate it
now, as what is happening now is
An idea I like, because I have entrenched windows clients also, is to run
things that run best under Linux on VMWare (vmware.com) and to run good
Windows things (like desktop apps) under Windows. Linux can be either the
host or guest OS under VMWare, so the options of which OS is truly in
control
Richard Huxton wrote:
2. This response is alarming: Tom Lane wrote in digest V1.5092:
We are supporting Windows as a Postgres platform for the benefit of
developers who want to do testing on their laptops (and for reasons
best known to themselves feel a need to run Windows on their
Hi,
I'm trying to use an SSL-enabled (OpenSSL 0.9.7d) Postgres 7.3.9 as database
backend to Samba 3.0.11. On startup Samba opens a connection, and passes it to
every fork()ed process. On some scenarios (consistenly, when somebody tries to
log into a workstation after reboot), Samba spits:
An idea I like, because I have entrenched windows clients
also, is to run things that run best under Linux on VMWare
(vmware.com) and to run good Windows things (like desktop
apps) under Windows. Linux can be either the host or guest
OS under VMWare, so the options of which OS is truly
Alejandro D. Burne wrote:
Hi, I'm new at pg.
I'll be using tmp tables in others rdbms. An user can create your own
tmp tables (grant temporary tables) but can't drop it (I don't want to
grant drop privileges).
Other way it's using on commit; but I can't make this work.
Example:
CREATE
Thanks Magnus,
Just the information I need. Is this the case if Linux is the host (and
running PostgreSQL) and Windows is the guest running under VMWare? I care
about the data in the Linux realm. I could give a rip if a PowerPoint
presentation gets hosed. On the other hand, if it lost one of
Le vendredi 11 mars 2005 à 10:10 -0500, [EMAIL PROTECTED] a
écrit :
An idea I like, because I have entrenched windows clients also, is to run
things that run best under Linux on VMWare (vmware.com) and to run good
Windows things (like desktop apps) under Windows. Linux can be either the
host
On Fri, Mar 11, 2005 at 15:25:28 +0100,
Együd Csaba [EMAIL PROTECTED] wrote:
Hi All,
I'd like to ask your opininon about how to handle DST on an 7/24 system.
My advice would be to use GMT and not have to worry about DST while
collecting data. When displaying data you might convert the
Le vendredi 11 mars 2005 à 16:51 +0100, Magnus Hagander a écrit :
Do *not* do this with a production database.
Vmware does *not* correctly handle fsync()s (or O_SYNC or any of those)
thruogh to disk. If your host PC crashes, your database will almost
certainly be corrupted. fsync() on the
On Fri, Mar 11, 2005 at 03:25:28PM +0100, Együd Csaba wrote:
Hi All,
I'd like to ask your opininon about how to handle DST on an 7/24 system.
Where should it be handled: on the server side or on the client side? And
how could I (at all could I???) make it transparent?
Or we must bow to the
Hi,
I'm new to Postgres and plpgsql so my sincerest apologies if the answer to
my problem is common :-)
I want to add entries to a table. The table has 2 fields, FieldID which is
the primary key and FieldValue which is a unique field.
I can add to FieldValue just fine when the unique constraint
Thanks Magnus,
Just the information I need. Is this the case if Linux is
the host (and running PostgreSQL) and Windows is the guest
running under VMWare? I care about the data in the Linux
realm. I could give a rip if a PowerPoint presentation gets
hosed. On the other hand, if it
Because I was just burned by this, I'd like to remind OS X users that
OS 10.3 (Panther) may be a less desirable platform than 10.2 for
running PostgreSQL and other applications that benefit from customizing
SYSV shared memory settings.
The problem is that in 10.3, there unbelievably seems to
subscribe-digest pgsql-general
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Do *not* do this with a production database.
Vmware does *not* correctly handle fsync()s (or O_SYNC or any of
those) thruogh to disk. If your host PC crashes, your database will
almost certainly be corrupted. fsync() on the client just
puts it in
the RAM cache on the host. Not
Le vendredi 11 mars 2005 à 17:41 +0100, Magnus Hagander a écrit :
Do *not* do this with a production database.
Vmware does *not* correctly handle fsync()s (or O_SYNC or any of
those) thruogh to disk. If your host PC crashes, your database will
almost certainly be corrupted.
http://linux.slashdot.org/article.pl?
sid=05/03/11/130217tid=143tid=163tid=223tid=1
Tony
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
I have recently migrated from MS Access to PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet = aGroupPathStmt.executeQuery(
SELECT \groupID\,\fullpath\ FROM \groups\ WHERE
\fullpath\ Like ' +
aPath + ');
where aPath was equal to 'folder\another
--- William Shatner [EMAIL PROTECTED] wrote:
I have recently migrated from MS Access to
PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet =
aGroupPathStmt.executeQuery(
SELECT \groupID\,\fullpath\ FROM
\groups\ WHERE
\fullpath\ Like ' +
aPath
But no Windows support yet. Needs future hardware: new Intel hardware for
better support of virtualization. VMWare is drooling over the upcoming
Intel support also.
Rick
Fernando Schapachnik [EMAIL PROTECTED] writes:
And the server log says:
[24129] LOG: SSL error: decryption failed or bad record mac
[24129] LOG: pq_recvbuf: recv() failed: Connection reset by peer
I think you need to find some SSL hackers; this is below libpq's level too.
On Fri, Mar 11, 2005 at 05:19:35PM +, William Shatner wrote:
I have recently migrated from MS Access to PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet = aGroupPathStmt.executeQuery(
SELECT \groupID\,\fullpath\ FROM \groups\ WHERE
\fullpath\ Like ' +
[EMAIL PROTECTED] (Egyd Csaba) wrote:
I'd like to ask your opininon about how to handle DST on an 7/24 system.
Where should it be handled: on the server side or on the client side? And
how could I (at all could I???) make it transparent?
Don't use DST.
Use GMT/UTC.
That makes the issue go
On Tue, Feb 15, 2005 at 02:00:20PM -0500, Christopher Browne wrote:
As has been noted by others, this is an artifact of the JDBC driver
holding onto a stored query plan. And it's somewhat worth noting that
this is not unique to Slony-I...
(Yes, I'm behind on reading mail lists.)
Actually, I
On Friday 11 March 2005 6:25 am, Egyd Csaba wrote:
Hi All,
I'd like to ask your opininon about how to handle DST on an 7/24
system. Where should it be handled: on the server side or on the
client side? And how could I (at all could I???) make it
transparent?
Or we must bow to the fact that
On Fri, Mar 11, 2005 at 04:21:49PM +, ILove TheSpam wrote:
My problem is that I want to:
a) Be able to detect when an error occurs and be able to read that error
b) Find out the FieldID for the row which already has the value in it. So
if I try to enter 'blah' into FieldValue and it's
On Fri, Mar 11, 2005 at 03:25:28PM +0100, Egy?d Csaba wrote:
Hi All,
I'd like to ask your opininon about how to handle DST on an 7/24 system.
Where should it be handled: on the server side or on the client side? And
how could I (at all could I???) make it transparent?
As others have
Hello,
I am trying build and install 8.0 on RedHat 9.0 the
configure runs with out a problem and when I type make I get:
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wendif-labels -fno-strict-aliasing zic.o ialloc.o scheck.o localtime.o
-L../../src/port
DEV [EMAIL PROTECTED] writes:
zic.o(.text+0x3c40): undefined reference to `__ctype_b'
zic.o(.text+0x3c5b): undefined reference to `__ctype_tolower'
Apparently your /usr/include/ctype.h file doesn't agree with your libc.
Some googling on __ctype_tolower suggests that there were changes in
that
Not exactly...
Here is a scenario I ran in to with collecting bandwidth usage and
displaying it back in graph form to customers.
You can store the timestamps in GMT, but the customer wants to see when
spikes happen in his localtime, which most likely has DST. So twice a
year, you are either
On Fri, 2005-03-11 at 13:47, Mike Benoit wrote:
Not exactly...
Here is a scenario I ran in to with collecting bandwidth usage and
displaying it back in graph form to customers.
You can store the timestamps in GMT, but the customer wants to see when
spikes happen in his localtime, which
On Tue, Mar 01, 2005 at 11:41:11AM +0100, Martijn van Oosterhout wrote:
I'm impressed by Slony and I could probably make it do what I want with
enough trickery. But again the need to be able to connect from any
server to any other. To put it in Slony terms, the origin never needs
to move. If
On 2005-03-11, Mike Benoit [EMAIL PROTECTED] wrote:
Here is a scenario I ran in to with collecting bandwidth usage and
displaying it back in graph form to customers.
You can store the timestamps in GMT, but the customer wants to see when
spikes happen in his localtime, which most likely has
Hello.
The PG mailing lists web page contains artifacts of a jobs list but no
such list appeared in the dropdown of available lists.
I am referring to;
http://www.postgresql.org/community/lists/subscribe
Is there such a resource and if so, could someone direct me to it?
Thanks.
--
Instead of spikes or dips, with your method customers will just be
confused as to why the labels skip an hour, or have two of the same
hour. It would make for a more accurate graph though, your right.
6 of 1, half a dozen of another I guess.
On Fri, 2005-03-11 at 23:33 +, Andrew - Supernews
Hi Shelby,
I don't think the problem isn't with the backslashes. They are escaped and
seem to be working fine e.g. to insert a backslash in Access I had to use
one escape character ('\\') whereas in PostgreSQL four backslashes ('')
are required. The line that inserts the % is as follows...
I have applied your patch with minor modifications. Applied version
attached.
I think the pages message:
INFO: free space map: 44 relations, 28 pages stored; 704 total pages
used
DETAIL: FSM size: 1000 relations + 2 pages = 182 kB shared memory.
should remain
Check out CREATE RULE command,
Regards,
Qingqing
Doug Bloebaum [EMAIL PROTECTED] дÈëÓʼþ
news:[EMAIL PROTECTED]
[ Sorry if this appears twice on the list: sent it via a non-subscribed
email the first time around. Of course, while waiting for it to appear I
figured out a workaround; see the
Hi all,
I am back to trying to get the forum software called 'Ikonboard'
working under postgres (it's advertised as being supported but the
developers confirmed their pgSQL person left a while back).
At the moment I am (well, the program is) getting trying to perform
this query:
SELECT *
63 matches
Mail list logo