Hello,
The community jabber server is now up. We are using the Wildfire server
from Jive Software, backed to a PostgreSQL database (of course).
Our current enabled features are:
1. Server side storage (for static groups etc..)
-- We currently have a Slaves_to_WWW group for example
2. MUC (
Gregory Stark <[EMAIL PROTECTED]> writes:
> Jim Bryan <[EMAIL PROTECTED]> writes:
>> "/home/jb/Desktop/DateTimeData.txt" for reading:
>> Permission denied
>>
>> -rw-rw-r-- 1 jb jb 83 Aug 25 14:30
>> DateTimeData.txt
> I suspect it doesn't have "x" permission on some parent directory,
Y
Hello,
I have been looking at the migration of Gborg lately. It looks like the
only two active projects on that site are Slony, and pljava. Libpqxx has
recently moved to their own Trac site.
I would like to suggest the following course of action.
1. We set a read only date of 12/31/06
This
Jim Bryan <[EMAIL PROTECTED]> writes:
> "/home/jb/Desktop/DateTimeData.txt" for reading:
> Permission denied
>
> -rw-rw-r-- 1 jb jb 83 Aug 25 14:30
> DateTimeData.txt
I suspect it doesn't have "x" permission on some parent directory, what does
ls -ld /home /hoome/jb /home/jb/Desktop
Michael
Thanks again for your help.
Bob
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Saturday, August 26, 2006 1:36 PM
Subject: Re: [GENERAL] Inserting Data
On Sat, Aug 26, 2006 at 01:22:49PM -0700, Bob Pa
Tom Lane <[EMAIL PROTECTED]> writes:
> If this is a common result from short-lived
> network problems then you have a beef with the TCP stack at one end
> or the other ... TCP is supposed to be more robust than that.
Or a beef with some firewall or router along the way. NAT routers are
particular
On Sat, Aug 26, 2006 at 11:35:56AM -0700, Jim wrote:
> copy tabledaily from '/home/jb/FinalData.txt' with csv;
> ERROR: could not open file "/home/jb/FinalData.txt" for reading: Permission
> denied.
> Yet everything else works, including populating tables with Insert queries.
>
> All the permiss
On Sat, Aug 26, 2006 at 01:22:49PM -0700, Bob Pawley wrote:
> What is the reason for redefining type_ as device_type ???
The function doesn't redefine type_; it selects the value of the
type_ column into a local variable named device_type to avoid
querying library.devices more than once. That loc
Michael
This works perfectly. Thanks very much for your help.
What is the reason for redefining type_ as device_type ???
Bob
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Friday, August 25, 2006 12:31 PM
snacktime <[EMAIL PROTECTED]> writes:
> I have an application that processes credit card transactions,and
> contains a table called authorizations. The authorizations table
> contains information returned by the bank necessary to capture the
> transaction. Nothing should block the application f
On Fri, Aug 25, 2006 at 09:25:34AM -0400, Ed Brown wrote:
> Can someone tell me how the content of the "relacl" column of the
> "pg_class" system table is interpreted? The documentation simply states
> "Access permissions. See the descriptions of GRANT and REVOKE for
> details." Much of the content
On Sat, Aug 26, 2006 at 03:32:37PM -0400, Jasbinder Bali wrote:
> Do we have any concept of shared objects in perl.
> Just wondering, how do we dynamically load something written in perl in
> postgresql.
A PL/Perl function can load external code with "use", "require",
or "do". Since those are pot
I had this problem a few weeks ago.
What I did was isolate it into an
individual row that was causing the problem, then going over the fields one by
one, till I located the free text field that was responsible.
Then I repopulated it with the value in
the latest backup I could find.
I was
I have an application that processes credit card transactions,and
contains a table called authorizations. The authorizations table
contains information returned by the bank necessary to capture the
transaction. Nothing should block the application from inserting new
rows into the authorizations
I've got a problem with
conversion.Database is running on pg8.1.3I've 2 tables, in one there is
mediabinary collumn of bytea type. And during conversion to another table /
conversion only move data from timestamp type to timestamptz but mediabinary in
botha are the same. And during query whic
copy tabledaily from '/home/jb/FinalData.txt' with csv;ERROR: could not open file "/home/jb/FinalData.txt" for reading: Permission denied. Yet everything else works, including populating tables with Insert queries.All the permissions were changed for world access ( perhaps bad idea but out of fr
Hi! - Fedora Core 5, cannot copy text file into a
table called datetime, yet the permissions seem OK:
copy datetime from '/home/jb/Desktop/DateTimeData.txt'
with csv;
ERROR: could not open file
"/home/jb/Desktop/DateTimeData.txt" for reading:
Permission denied
-rw-rw-r-- 1 jb jb 83 Au
Can someone tell me
how the content of the "relacl" column of the "pg_class" system table is
interpreted? The documentation simply states "Access permissions. See the
descriptions of GRANT and REVOKE for details." Much of the content of this
column is obvious from the GRANT description - "r"
Dang. I re-read your post and see that you are not checking for the
correct answer, you simply want to store the responses like a
questionare. Well I still think a different table for each type of
response would be beneficial, obviously, adding a serial field like you
have done and the foreign ke
I agree with Tim, that your option 3 is really not all that hard, and I
suggest would provide you with the best solution. I'm assuming,
however, that your application asks the question and checks the user
supplied answer with the answer in the db (and not Jeopardy style). I
might add a 'join' or
Thanks for your reply Martijn. I do not know for certain that its in pg_dump format, not having dealt with it specificly before. I will examine the files more closely to look for COPY statements. If not in that format, what else could it be that could be shoved right into a postgresql databas
Peter Eisentraut wrote:
> Am Freitag, 25. August 2006 13:51 schrieb Martijn van Oosterhout:
> > It really depends on the format they send you. It's either plain text,
> > in which case the COPY commands will tell you which fields. If it's the
> > custom format you can use tar to extract it IIRC.
>
Hi,
Do we have any concept of shared objects in perl.
Just wondering, how do we dynamically load something written in perl in postgresql.
Thanks,
Jas
On 8/24/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
On Thu, Aug 24, 2006 at 03:46:00PM -0400, Jasbinder Bali wrote:> The way we use ECPG for the d
On 8/26/06, snacktime <[EMAIL PROTECTED]> wrote:
I have an application that processes financial transactions. Each of
these transactions needs to be sent with a sequence number. It starts
at 1 and resets to 1 once it hits 8000. I'm trying to think of the
most elegant solution without having t
Hi all,I just tried to install postgresql 8.1 in windows 2000 professional.After selecting language option, clicking NEXT button gives the message "Failed to create process: 2!" and exits.In postgresql site, its under bug no 1872 and no solutions found.
http://archives.postgresql.org/pgsql-bugs/200
snacktime <[EMAIL PROTECTED]> writes:
> I have an application that processes financial transactions. Each of
> these transactions needs to be sent with a sequence number. It starts
> at 1 and resets to 1 once it hits 8000. I'm trying to think of the
> most elegant solution without having to cr
On fös, 2006-08-25 at 18:34 -0400, Silvela, Jaime (Exchange) wrote:
> This is a question on speeding up some type of queries.
>
> I have a very big table that catalogs measurements of some objects over
> time. Measurements can be of several (~10) types. It keeps the
> observation date in a field,
27 matches
Mail list logo
