On 11/29/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
Are you sure this isn't just PostgreSQL caching data?
i am not sure. but what bothers me is:
i setup limit of shared memory to 5 buffers - which gives estimate 400 megabytes. how come it ended up using 6GB ?
depesz
On Tue, Nov 29, 2005 at 09:58:49PM -0500, John D. Burger wrote:
> I could use some help with the following:
>
> I have a database of geographic entities with attributes spread across
> several tables. I need to determine which entities are unique with
> respect to some of those attributes. I'm
On Thu, Nov 24, 2005 at 11:47:53AM +0100, A.j. Langereis wrote:
> But how can I do something like this:
>
> select my_pg_func(table2.some_col).col1
> from table2.some_col
Use another set of parentheses around the function call, as at the
end of this example:
CREATE TYPE test_type AS (col1 intege
On Mon, Nov 28, 2005 at 03:39:37PM +0200, Peter Filipov wrote:
> I can't detect whether i passed a NULL to stored procedure
> in plpgsql when it happens that I use composites
This came up a few months ago; see Tom Lane's response to the
following message:
http://archives.postgresql.org/pgsql-sql/
On Tue, Nov 29, 2005 at 04:16:53PM -0500, Tom Lane wrote:
> On a default HPUX build you can look into /usr/local/lib/gcc-lib/ to
> discern what the compiler was actually built on; not sure if the
> equivalent directories are kept in the same place on Solaris.
The equivalent on my box is /usr/local
I could use some help with the following:
I have a database of geographic entities with attributes spread across
several tables. I need to determine which entities are unique with
respect to some of those attributes. I'm using the following query:
select p2.gazPlaceID from
(select p1.feat
I am coming from Oracle & mySQL. In Oracle I can use
spool foo.txt
spool off
After this the file foo.txt shows everything the screen showed.
If I had echo on it will show the command and results. If I turn
on timing it shows there too.
With mySQL similarly I can use tee foo.txt and notee;
Tim Bunce <[EMAIL PROTECTED]> wrote:
> I'll guess that what you're really after is to be able to call begin_work
> again whilst an earlier begin_work is in effect and have the DBI keep a
> counter of how deeply nested the begin_work calls are. Then commit would
> decrement the counter and only comm
I've had a look at the config.log (see below). It seems to be returning yes
to the isinf check despite warnings. So port/isinf.c does not get compiled
on subsequent make.
configure:14213: checking for isinf
configure:14235: gcc -o conftest -O2 -Wall -Wmissing-prototypes
-Wpointer-arith
-Winline -W
Are you sure this isn't just PostgreSQL caching data?
A complete testcase would help, too (ie: whatever you used to generate
the initial data).
On Tue, Nov 29, 2005 at 06:46:06PM +0100, hubert depesz lubaczewski wrote:
> On 11/29/05, hubert depesz lubaczewski <[EMAIL PROTECTED]> wrote:
> >
> > i
You migth also find http://pgfoundry.org/projects/newsysviews/ useful.
On Tue, Nov 29, 2005 at 01:25:37AM -0800, Peter Futaro wrote:
> Dear PSQL,
>
> I need to make a documentation for my database. The documentation I want
> is almost exactly like the result of "\d" command. I want to make
Yes, that's probably true. Depending on your pain you could also fund
development of a feature that would make this easier to deal with.
On Tue, Nov 29, 2005 at 09:43:16AM +0100, Egy?d Csaba wrote:
> Hi Jim,
> so IIUC, I will have to schedule a program on the server which reads all
> user informat
Michael Fuhr <[EMAIL PROTECTED]> writes:
> I wonder if this is a problem with gcc 4 on Solaris. The OP is
> using Solaris 8/gcc 4.0.2 and the previous complaint involved
> Solaris 10/gcc 4.0.0. My Solaris 9/gcc 3.4.2 box builds fine,
> as does the Solaris 10/gcc 3.3.2 box buzzard in the buildfarm
Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:
Summary:
I installed glibc-locale and initdb now works fine.
Interesting. I had just come to the conclusion that you were missing
some files...
>
the other four files all exist and are in
the glibc-common RPM, which means that i
Mark Cave-Ayland wrote:
> We're looking at investing in a new storage system in order to run
> PostgreSQL and the advice we are getting is to move away from our
> current SAN solution to a NAS solution. Can anyone offer any
> advice/experience on using NAS devices to run a PostgreSQL database?
The
On Tue, Nov 29, 2005 at 03:45:00PM -0500, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Obviously isinf() is missing. Is it a documented function on that
> > platform? Is there any indication which library it is in? It's
> > obviously not in libm.
>
> What's even odder is that configure ma
Martijn van Oosterhout writes:
> On Tue, Nov 29, 2005 at 07:53:52PM +, Janet Bagg wrote:
>> I'm getting errors at the make stage for 8.1.0 on Solaris 8 despite
>> configure looking ok.
> Obviously isinf() is missing. Is it a documented function on that
> platform? Is there any indication whic
On Tue, Nov 29, 2005 at 07:53:52PM +, Janet Bagg wrote:
> I'm getting errors at the make stage for 8.1.0 on Solaris 8 despite
> configure looking ok. A similar issue was reported with 8.0.3 on Solaris 10
> but there didn't seem to be a resolution.
> http://archives.postgresql.org/pgsql-admin/20
I'm getting errors at the make stage for 8.1.0 on Solaris 8 despite
configure looking ok. A similar issue was reported with 8.0.3 on Solaris 10
but there didn't seem to be a resolution.
http://archives.postgresql.org/pgsql-admin/2005-09/msg00029.php
make in this instance is gmake.
utils/SUBSYS.o:
On Tue, 2005-11-29 at 18:00 +0200, Sterpu Victor wrote:
> I have the following table
...
> And the sequence for the id column:
> CREATE SEQUENCE cachedgroupmembers_id_seq CACHE 1000;
>
> Now the table is empty and I try to insert a row in this table:
> INSERT INTO cachedgroupmembers(groupid) value
Steve Crawford <[EMAIL PROTECTED]> writes:
> Summary:
> I installed glibc-locale and initdb now works fine.
Interesting. I had just come to the conclusion that you were missing
some files from this part of your strace:
[pid 5240] open("/usr/lib/locale/locale-archive", O_RDONLY|O_LARGEFILE) = -1
I have the following table
Column | Type |Modifiers
+---+-
id | integer | not null default
nextval('cachedgroupmembers_id_seq'::regclass)
groupid
Tom Lane wrote:
Steve Crawford <[EMAIL PROTECTED]> writes:
creating template1 database in /var/lib/pgsql/data/base/1 ... FATAL:
XX000: failed to initialize lc_messages to ""
We've seen this reported occasionally before, but none of the PG
developers have ever been able to reproduce it
On Mon, 2005-11-28 at 18:39, Stock, Stuart wrote:
> FYI in case you still have the problem after using pg_dump from 8.1 (we did)
> you may have an encoding mismatch between your 7.3 and 8.1 databases. Our
> 7.x database was SQL_ASCII while 8.1 defaults to creating databases as
> UTF-8. I had simila
On 11/29/05, hubert depesz lubaczewski <[EMAIL PROTECTED]> wrote:
i think i've encountered a bug in postgresql 8.1.
now i'm nearly positive it's a bug.
i created database in this way:
CREATE DATABASE leak;
\c leak
CREATE TABLE users (id serial PRIMARY KEY, username TEXT NOT NULL DEFAULT '', passwo
hi
i think i've encountered a bug in postgresql 8.1.
yet - i'm not reallty info submitting it to -bugs, as i have no way to successfully redo it again.
basically
i have server, with dual opteron, 4g of memory, 2gb of swap. everything working under centos 4.2.
postgresql 8.1 compiled from sources
I shoul start the sequence with the last number in the higher number in
the table +1.
It works.
Sterpu Victor wrote:
I have the following table
Column | Type |Modifiers
+---+--
Peter Futaro wrote:
I need to make a documentation for my database. The documentation I want is almost exactly like the result
of "\d" command. I want to make the report using a database manager application, and it requires
me to make my own report by typing the SQL command in it. Can you
am 29.11.2005, um 1:25:37 -0800 mailte Peter Futaro folgendes:
> Can you please provide me the command behind "\d" or perhaps tell
> me what attributes do you use to build that "\d" report ?
Start psql with -E. Now you can see the sql-commands for \d and other
commands like this.
HTH, An
Peter Futaro wrote:
> Dear PSQL,
>
> I need to make a documentation for my database. The documentation I want
> is almost exactly like the result of "\d" command. I want to make the
> report using a database manager application, and it requires me to make
> my own report by typing the SQL command
Read the FAQ.
---
Peter Futaro wrote:
> Dear PSQL,
>
> I need to make a documentation for my database. The documentation I want
> is almost exactly like the result of "\d" command. I want to make the report
> using
I downloaded the postgresql-8.1.0 source rpm for Fedora Core 4 from the
rpm repository at postgresql.org.
I installed the rpm with " rpm -i postgresql-8.1.0-2PGDG.src.rpm"
I then attempted to rebuild the packages with
rpmbuild --rebuild --define 'tcl 1' --define 'kerberos 0' --define
'tclde
Dear PSQL,I need to make a documentation for my database. The documentation I want is almost exactly like the result of "\d" command. I want to make the report using a database manager application, and it requires me to make my own report by typing the SQL command in it. Can you please prov
On Tue, November 29, 2005 0:37, Jim C. Nasby said:
> One issue is that pg_toast tables can't vacuum rows until their
> respective rows have been deleted by vacuuming the base table. But it's
> still odd that the count decreases by 4 each time you run it.
So, VACUUM would first vacuum , then
pg_toa
Hello All,
I run Tru64 Unix 5.1B / Alpha OSF1.
I have installed Postgresql 8.0.3 on a cluster.
The following is my pg_hba.conf,
"
hostdcs all 127.0.0.1 255.255.255.255
password
hostdcsconfig all 127.0.0.1 255.255.255.255
password
local all
On Tue, Nov 29, 2005 at 01:03:39PM +0100, Martijn Meijers wrote:
> Dear list members,
>
>
> Let me first introduce myself, I'm Martijn and currently doing my master's
> thesis research at Delft University (The Netherlands). I am working in the
> field of spatial databases and I am going to test,
Tom,
Thanks for the reply...something did in fact remove the
postmaster.pid file! We will have to look into this further to track
down the culprit.
Thank you everyone for your responses!
Tim
On Nov 28, 2005, at 3:36 PM, Tom Lane wrote:
Timothy Perrigo <[EMAIL PROTECTED]> writes:
We ar
On Nov 28, 2005, at 6:14 PM, Michael Glaesemann wrote:
[Reordering top-posted reply]
Conflicts with the ARD-installed server has been an issue for me on
and off in the past, though I haven't been able to connect to the
server using psql without specifying the ard database, user, and
pass
On Nov 29, 2005, at 21:55 , Timothy Perrigo wrote:
We are still able to connect to our database using psql (and via
JDBC). Does this still seem like it could be an ARD conflict?
No. I think ARD is blame-free in this instance. Dunno what the issue
is, though. Sorry.
Michael Glaesemann
gr
(Oops...originally sent this to Jim, instead of the group)
Thanks for the reply...Yes, we do have ARD installed on the machine,
but I believe the postgres instance that we see running (through ps
auxw | grep postgres) is our server instance (pointed at our data
directory), not the ARD insta
Dear list members,
Let me first introduce myself, I'm Martijn and currently doing my master's
thesis research at Delft University (The Netherlands). I am working in the
field of spatial databases and I am going to test, investigate and
implement a data structure which is suitable for on-the-fly g
surabhi.ahuja wrote:
hi
I start postmaster by giving the following command
/usr/bin/pg_ctl -w -l postgreslog -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start
however nothing gets looged in postgrelog.
if i see postgreslog it shows me only this:
LOG: logger shutting down
LOG: l
hi
I start postmaster by giving the following
command
/usr/bin/pg_ctl -w -l postgreslog -D $PGDATA
-p /usr/bin/postmaster -o '-p ${PGPORT}' start
however nothing gets looged in
postgrelog.
if i see postgreslog it shows me only
this:
LOG: logger shutting downLOG:
logger shutting downL
Hi Jim,
so IIUC, I will have to schedule a program on the server which reads all
user information and if a new user is added it modifies the pg_hba.conf and
reloads the server?
thanks,
-- csaba
-Original Message-
From: Jim C. Nasby [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29,
44 matches
Mail list logo
