> [EMAIL PROTECTED] wrote:
> I am having a stored function in plperlU which is called from
> php script then. It select data from a table, export them to
> a file and zips the file. The problem is that it should store
> this file into temporary table. Then it should return some
> identificator
On Sun, Mar 09, 2008 at 11:40:47AM -0500, Justin wrote:
> I got the aggregate function for weighted average done. I finely left
> alone for more than 10 minutes to actual get it written. It takes 2
> value input Weight and the Value. it will sum the weighted entries to
> create the constan
Hi Guys,
We have a system with a multithreaded daemon running on Linux using
PostgreSQL 8.2.4 Embedded SQL in C. Most of the threads are doing database
access and they have each their own conection which is opened when the
thread is created (as one of the first things within the thread).
Hi guys, i just wondering, i there a way to make PostgreSQL database like M$
Access. That have only single or several files without installing it.??
Thanks for your attention.
Regards..
Christian
Hello,
On Sun, 9 Mar 2008 11:59:49 -0700 Josh Berkus wrote:
> > > I have no problem with having a policy or following a policy. My
> > > problem is: Where is it? When was the last time someone's blog was
> > > booted from planetpostgresql? Is it documented, i.e. an "open &
> > > discussed" e
Magnus Hagander wrote:
> On Mon, Mar 10, 2008 at 01:43:03PM +0700, Christian Teguh wrote:
>> Hi guys, i just wondering, i there a way to make PostgreSQL database like M$
>> Access. That have only single or several files without installing it.??
>> Thanks for your attention.
>
> No.
> Unless you cr
On Mon, Mar 10, 2008 at 01:43:03PM +0700, Christian Teguh wrote:
> Hi guys, i just wondering, i there a way to make PostgreSQL database like M$
> Access. That have only single or several files without installing it.??
> Thanks for your attention.
No.
Unless you create a file and mount a loopback f
gargoyle47 wrote:
I installed PostgreSQL on my Windows XP Home PC (at home) but when I
look under the Control Panel, User accounts, the special postgres user
name is not listed.
However, using "net user postgres" shows the following:-
User namepostgres
Full Name
shiguoying wrote:
Hello everybody work for postgre: I have a problem for i/o error when
i using java programming.it happend when I disconnect database.but
,i'm not sure its database'bug or my programming'bug.I follow a text
in attachment. I hope your help! thanks ! eagle shi from china
The erro
Hello everybody work for postgre:
I have a problem for i/o error when i using java programming.it happend
when I disconnect database.but ,i'm not sure its database'bug or my
programming'bug.I follow a text in attachment.
I hope your help!
thanks !
On Mon, 10 Mar 2008 07:43:03 +0100, Christian Teguh
<[EMAIL PROTECTED]> wrote:
Hi guys, i just wondering, i there a way to make PostgreSQL database
like M$
Access. That have only single or several files without installing it.??
Thanks for your attention.
Regards..
Christian
No, thereis n
On Mon, Mar 10, 2008 at 06:55:48AM +, Raymond O'Donnell wrote:
> On 09/03/2008 22:33, Reid Thompson wrote:
> >On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
> >>On 09/03/2008 15:34, Reid Thompson wrote:
> >>
> >>>you'll also probably have to add the parameter -h 127.0.0.1
> >>psql
On Mon, 2008-03-10 at 06:55 +, Raymond O'Donnell wrote:
> On 09/03/2008 22:33, Reid Thompson wrote:
> > On Sun, 2008-03-09 at 19:41 +, Raymond O'Donnell wrote:
> >> On 09/03/2008 15:34, Reid Thompson wrote:
> >>
> >>> you'll also probably have to add the parameter -h 127.0.0.1
> >> psql def
Richard Huxton wrote:
gargoyle47 wrote:
I installed PostgreSQL on my Windows XP Home PC (at home) but when I
look under the Control Panel, User accounts, the special postgres user
name is not listed.
However, using "net user postgres" shows the following:-
User namepostgres
Mitchell D. Russell escribió:
> I did a PG_dump of the database tonight, and went to restore it to my newly
> created database (WIN2152 encoding), which worked fine, but when I go to
> retrieve the data via my code (.NET c#), I get errors like :
>
> character 0x8f of encoding "WIN1252" has no equ
On 10/03/2008 11:38, Reid Thompson wrote:
Cool. I'll have to check the pg_hba.conf on my windows system and see
what it has in it. My windows box is running either 8.0.x or 8.1.x.
Has this setting always been this way for the windows installer?
As far as I can remember, it has - and I think
I'm currently using Postgre 8.2. Are there something wrong with that
version?
Below is the DDL for my table:
CREATE TABLE absensi (
id_absensi integer NOT NULL,
id_user integer,
tanggal date,
keterangan character varying,
id_tipe_absensi integer
);
ALTER TABLE ONLY absensi
AD
Hi,
I seem to have a problem on one of my databases,
When I log into pgsql I see this:
ERROR: Invalid page header in block 3 of pg_statistic_relid_att_index
Welcome to psql 7.3.4, the PostgreSQL interactive terminal.
When I try to run any command (eg vacuum) I get this message:
dbname=> vac
Achmad Nizar Hidayanto wrote:
> The two records are identical. But if i display the ctid, the two
> records differ as they
> have different ctid (suppose i display the ctid in the first column):
> R1: , 1001, 1, 02-25-2008, Present, 1
> R2: , 1001, 1, 02-25-2008, Present, 1
This would b
Hi
today I had a problem with postgresql.conf file, i remove it from my local
home, any of you know if there is some security copy of it somewhere or if
there is some how to recover it? the guy who did the configuration is not
working at my office any more and i don't know is he changed some dir
Pau Marc Munoz Torres wrote:
Hi
today I had a problem with postgresql.conf file, i remove it from my local
home, any of you know if there is some security copy of it somewhere or if
there is some how to recover it? the guy who did the configuration is not
working at my office any more and i do
Hi
today I had a problem with postgresql.conf file, i remove it from my local
home, any of you know if there is some security copy of it somewhere or if
there is some how to recover it? the guy who did the configuration is not
working at my office any more and i don't know is he changed some dir
Pau Marc Munoz Torres wrote:
Hi
today I had a problem with postgresql.conf file, i remove it from my local
home, any of you know if there is some security copy of it somewhere or if
there is some how to recover it? the guy who did the configuration is not
working at my office any more and i do
On Mon, 10 Mar 2008, shiguoying wrote:
I have a problem for i/o error when i using java programming.it happend
when I disconnect database.but ,i'm not sure its database'bug or my
programming'bug.I follow a text in attachment.
Well, if you disconnected the database, there's no bug there; these
i wish that could work but need to keep track of the individual weights
as its a percentage of the total amount of the weight.
I would never have thought the performance of the Array would suck this
bad.
Martijn van Oosterhout wrote:
On Sun, Mar 09, 2008 at 11:40:47AM -0500, Justin wrote:
[EMAIL PROTECTED] ("Christian Teguh") writes:
> Hi guys, i just wondering, i there a way to make PostgreSQL database
> like M$ Access. That have only single or several files without
> installing it.?? Thanks for your attention.
No, there isn't, just as there isn't a "make it faster" flag.
If you
Ok
it's works !!
thanks
2008/3/10, Craig Ringer <[EMAIL PROTECTED]>:
>
> Pau Marc Munoz Torres wrote:
>
> > Thanks Craig
> >
> > just one more question, most of the variables at
> > /home/postgresql/data/postgresql.conf file are commented (the directory
> > /home/postgresql/data is where i fou
Is the %r option of the restore_command available in PG 8.2.4? If not, is
there any other way to know how many archive files need to be kept on the
standby server when in recovery mode?
Thanks,
Steve
Hi,
On Mon, 2008-03-10 at 13:10 +0800, longlong wrote:
> i want some advice about ideas for gsoc. i don't konw if it is
> appropriate that i send a email here, so if you feel uncomfortable,
> please accept my apology.
Use pgsql-hackers list. Development discussions are done on that list.
Regards
Hi! When it comes to programming SQL, my newbie approach is to write my
code in a file test.sql, which I test from within psql by using
my_db=> \i /some/path/test.sql
...and (once I'm satisfied with the code) copy and paste it to a different
file that has the SQL I've written so far for the pr
Pau Marc Munoz Torres wrote:
Thanks Craig
just one more question, most of the variables at
/home/postgresql/data/postgresql.conf file are commented (the directory
/home/postgresql/data is where i found PG_VERSION file), should i it be
commented in my postgresql.conf file?
Yes, that's normal.
Hi,
Le samedi 01 mars 2008, Simon Riggs a écrit :
> On Tue, 2008-02-26 at 13:08 +0100, Dimitri Fontaine wrote:
> > I'd like to have some feedback about the new version, in term of bugs
> > encountered and performance limitations (is pgloader up to what you would
> > expect a multi-threaded loader
Well, after some testing, it appears as though the %r option is not
supported on 8.2.4.
It also looks as though pg_controldata may have the answer I want, but what
is the best programmatic way to determine the earliest archive file that I
need to keep?
Thanks,
Steve
On Mon, Mar 10, 2008 at 11:32
Kynn Jones wrote:
Hi! When it comes to programming SQL, my newbie approach is to write my
code in a file test.sql, which I test from within psql by using
my_db=> \i /some/path/test.sql
...and (once I'm satisfied with the code) copy and paste it to a different
file that has the SQL I've writt
longlong escribió:
> 3.sometimes, i want to copy data from one database to another. i think using
> COPY will simple the code. i want the content from COPY TO not store in the
> file, but in the memory, and i can COPY FROM the memory(i don't kown COPY
> with STDIN and STDOUT can do this or not.).
On Mon, 2008-03-10 at 17:18 +0100, Dimitri Fontaine wrote:
> Le samedi 01 mars 2008, Simon Riggs a écrit :
> > On Tue, 2008-02-26 at 13:08 +0100, Dimitri Fontaine wrote:
> > > I'd like to have some feedback about the new version, in term of bugs
> > > encountered and performance limitations (is pg
Hi,
When I do a search such as:
EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
QUERY PLAN
---
Seq Scan on itemsbyauthor (c
LARC/J.L.Shipman/jshipman wrote:
EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
QUERY PLAN
---
Seq Scan on itemsbyauthor (cost=0.0
On Monday 10 March 2008, LARC/J.L.Shipman/jshipman
<[EMAIL PROTECTED]> wrote:
> Hi,
> When I do a search such as:
>
> EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
> QUERY PLAN
> ---
On Mar 10, 2008, at 4:50 PM, Kynn Jones wrote:
Hi! When it comes to programming SQL, my newbie approach is to
write my code in a file test.sql, which I test from within psql by
using
my_db=> \i /some/path/test.sql
...and (once I'm satisfied with the code) copy and paste it to a
differ
On Mar 10, 2008, at 6:33 PM, LARC/J.L.Shipman/jshipman wrote:
Hi,
When I do a search such as:
EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
QUERY PLAN
--
Le lundi 10 mars 2008, Simon Riggs a écrit :
> Not sure when or why I would want an rrqueue_size larger than
> copy_every, and less sounds very strange. Can we get away with it being
> the same thing in all cases?
In fact, that's just that you asked for a reader which reads one line at a
time and
I need to get a list of roles granted select on a table from a remote
database. Ideally, each grantee would be represented as VARCHAR and not
an ACLITEM.
If the remote database is on the same server, it works but fails on the
different server. It looks like the datatype aclitem[] is linked to
A couple of email pointers:
* Please don't use language like "the Array would suck this bad" in
lists. I swear like a sailor in person, but it reads *very* badly in
email. There are a lot of people on this list who might take offense,
since it is their hard work that means that arrays work at
On Mon, Mar 10, 2008 at 11:00 AM, Justin <[EMAIL PROTECTED]> wrote:
>
> That comment was not meant to be an insult or disparaging in any way what
> so ever. If it was taken as such then i'm sorry.
I am sure it would have been fine in person, I just think over email
it sounded abrasive.
But coul
In article <[EMAIL PROTECTED]>,
Alban Hertroys <[EMAIL PROTECTED]> writes:
>> I'm thinking of something like the trick of surrounding C code with
>> pairs of #if 0 and #endif, which effectively comments out code,
>> even when it contains /* C-style comments */.
>>
>> Is there some similar trick f
I am trying to reindex some indexes through a batch script. for
example
Database : hermes
Schema : sc1
Indexes : ind1
when i use reindexdb with the following switches
./reindexdb --index=ind1 hermes
i get the below error message
reindexdb: reindexing of index "ind1" in database "hermes" fa
Hi! I want to set up a trigger (somehow) that, whenever someone connects
database my_db, will fire and thereby run a stored PLPERL procedure
perl_setup() in the new connection's environment. (BTW, this procedure adds
useful definitions, mostly subs, to Perl's main package. This needs to be
done
Hello All,
I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
version 8.2.3. I think that TCP connections are enabled correctly in
the server's pg_hba.conf and I can successfully connect from the client
using pgsql. However, trying to use pg_connect() w/ a call like:
John Cartwright <[EMAIL PROTECTED]> writes:
> I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
> version 8.2.3. I think that TCP connections are enabled correctly in
> the server's pg_hba.conf and I can successfully connect from the client
> using pgsql. However, tryin
[EMAIL PROTECTED] writes:
> I am trying to reindex some indexes through a batch script. for
> example
> Database : hermes
> Schema : sc1
> Indexes : ind1
> when i use reindexdb with the following switches
> ./reindexdb --index=ind1 hermes
> i get the below error message
> reindexdb: reindexing
"Roberts, Jon" <[EMAIL PROTECTED]> writes:
> If the remote database is on the same server, it works but fails on the
> different server. It looks like the datatype aclitem[] is linked to
> roles which seems weird to me.
Why would you find that weird? aclitem exists to store references to
roles.
In a recent post I mentioned that I had a PLPERL procedure that
...adds useful definitions, mostly subs, to Perl's main package.
I thought this claim needs further clarification, since the docs for PLPERL
include a warning that may give readers the impression that defining Perl
functions within
Thanks for your reply, Tom. Not sure exactly what you mean - this is a
php script executed via apache. php scripts w/in the same directory that
don't make database connections seem to work OK.
Your suggestion is a good one though - it may be an SELinux
configuration. I'll try to pursue that
/*
* Inside SQL statement place Obligatory top post Comment here
*/
Bedankt
Martin-
- Original Message -
Wrom: MKHJYFMYXOEAIJJPHSCRTNHGSWZIDREXCAXZOWCONEUQZAAFXISHJE
To: "Kynn Jones" <[EMAIL PROTECTED]>
Cc: "pgsql-general General"
Sent: Monday, March 10, 2008 12:55 PM
Subject: Re: [GEN
On Mon, 10 Mar 2008, Tom Lane wrote:
I don't know much about how to fix it, other than the extremely
brute-force tool of "setenforce 0". On current Fedora it looks like the
way is probably "setsebool -P allow_user_postgresql_connect 1", but I'm
not sure if RHEL5 uses that approach or somethin
On Mon, Mar 10, 2008 at 1:14 PM, John Cartwright
<[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server
> version 8.2.3. I think that TCP connections are enabled correctly in
> the server's pg_hba.conf and I can successfully connect
Yes, the command-line client works fine that way.
Turns out the problem was SELinux permissions that had to be
specifically enabled.
Thanks for the suggestions and the help.
-- john
Scott Marlowe wrote:
On Mon, Mar 10, 2008 at 1:14 PM, John Cartwright
<[EMAIL PROTECTED]> wrote:
Hello A
On Mar 10, 2008, at 9:07 PM, Kynn Jones wrote:
So I tried to find some system table that would get modified
whenever a new connection was made, but I was unsuccessful. The
closest I found was the VIEW pg_activity, and the crucial
information I need from this view comes from procedures like
Anyone know of any MOLAP/MDDB/MDX Business Intelligence reporting solutions
tahat work on top of PostgreSQL ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Kevin Kempter wrote:
Anyone know of any MOLAP/MDDB/MDX Business Intelligence reporting solutions
tahat work on top of PostgreSQL ?
I haven't used it myself, but you could check out Mondrian:
http://sourceforge.net/projects/mondrian/
HTH
Joe
--
Sent via pgsql-general mailing list (pgsql-g
Hello,
I'm using the libpq interface to PostgreSQL (8.3.0) in one of our apps, and
I'm having a sporadic issue with receiving the error message:
--snip--
message contents do not agree with length in message type "T" server sent
data ("D" message) without prior row description ("T" messa
Hi All,
I wonder if you can help me out.
I already installed PostgreSQL 8.2.3 without error.
postgresql-8.2.3-1PGDG.x86_64.rpm
postgresql-libs-8.2.3-1PGDG.x86_64.rpm
postgresql-server-8.2.3-1PGDG.x86_64.rpm
"Mike" <[EMAIL PROTECTED]> writes:
> I'm using the libpq interface to PostgreSQL (8.3.0) in one of our apps, and
> I'm having a sporadic issue with receiving the error message:
> message contents do not agree with length in message type "T" server sent
> data ("D" message) without prior row descrip
On Mon, 10 Mar 2008, longlong wrote:
1.release8.2 make COPY TO can copy the output of an arbitrary SELECT
statement. so i think maybe COPY FROM can get data from output and 'insert
into' some column that designated. the format of the command will be
discussed.
This would be a nice feature. Ri
Hi,
On Mon, 2008-03-10 at 16:35 -1000, Tri Quach wrote:
> I already installed PostgreSQL 8.2.3 without error.
Which distro/arch is this? Probably you installed a package set which is
not built for you distro.
Use 8.2.6 packages for your distro:
http://www.postgresql.org/ftp/binary/v8.2.6/linux/
your words are a great encouragement to me!
i am embarrassed by my English and i will improve it.
maybe i missed something that makes you a little misunderstand in point 3.
what i want is data-copys between databases automatically processed by
program. and databases may be not in the same host. i
67 matches
Mail list logo
