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 defaults to connecting to the local machine unless you tell it
otherwise, so this
[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 to
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 constant
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 event?
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 create a
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
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
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 no
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 defaults to
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 defaults to
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
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
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=
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 be a
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
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
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
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
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;
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 truly
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
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 to be
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
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
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.).
I
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 pgloader
Hi,
When I do a search such as:
EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
QUERY PLAN
---
Seq Scan on itemsbyauthor
LARC/J.L.Shipman/jshipman wrote:
EXPLAIN ANALYZE SELECT * FROM itemsbyauthor;
QUERY PLAN
---
Seq Scan on itemsbyauthor
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
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 could
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 for SQL code?
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
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, trying to
[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 of index
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 pgsql-general@postgresql.org
Sent: Monday, March 10, 2008
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 something
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 from
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
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
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
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 message)
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 description (T
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.
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:
66 matches
Mail list logo
