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 * F
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
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 D
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...
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
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.
--
-
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
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. I
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, wh
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 compr
"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
t
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 -Wl,-rpath,/usr/local/pg
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 menti
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 Friday 11 March 2005 6:25 am, 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 fac
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,
[EMAIL PROTECTED] (Együd 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 g
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
> \"fullpa
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.
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
--- 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 '"
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\a
http://linux.slashdot.org/article.pl?
sid=05/03/11/130217&tid=143&tid=163&tid=223&tid=1
Tony
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that y
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 co
> > 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
subscribe-digest pgsql-general
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
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 be
> 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, i
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 h
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 t
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 t
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 time
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
> ho
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 m
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:
> CR
> 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 tru
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:
SELE
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
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
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
[ 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 "Late breaking update" at the end. ]
In the spirit of "tell us what you're trying to do..."
I'd like to mimic a su
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 lea
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
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 b
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 h
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 re
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 :
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
pos
* 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
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 t
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 this
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 ou
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):
mobileb#Ftestmy
> 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 @
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,
floor(coalesce(personaldetails.masterid::numeric,personaldet
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, t
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: [archi
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)]
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,
Qingqin
> 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 a
> 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 @ wwwkey
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
-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
* Fedora
[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 pe
64 matches
Mail list logo
