G'day Tom,
On 03/05/2012, at 11:57 AM, Tom Lane wrote:
Ben Madin li...@remoteinformation.com.au writes:
SQLSTATE[XX000]: Internal error: 7 ERROR: could not open file
base/102979/430122_fsm: Invalid argument
[ scratches head ... ] AFAICS the only documented reason for open() to
fail
On 3 May 2012, at 24:00, Tom Lane wrote:
Andy Chambers achamb...@mcna.net writes:
So ideally, I'd like to be able to do
insert into foo (a,b,foo_date)
select a,b,now() from foo old where
returning oid, old.oid
...but this doesn't work. It seems you only have access to the table
Hi,
since I got no answer so far I searched through the docu again. I searched for
GC as well as Garbage, and all garbage refers to is with regard to vacuuming a
database. But my question refers to wether or not memory management is with
garbage collection supported or not. When I try to link
On Thu, May 03, 2012 at 02:46:16PM +0800, Ben Madin wrote:
(PS How did you come to deciding that it was EINVAL - is that 'Error INVALid
argument'?)
It's one of the standard error codes, see for example
http://www.jbox.dk/sanos/source/include/errno.h.html
Tom is right, it's not clear how this
On Thu, May 03, 2012 at 09:08:53AM +0200, Alexander Reichstadt wrote:
Hi,
since I got no answer so far I searched through the docu again. I searched
for GC as well as Garbage, and all garbage refers to is with regard to
vacuuming a database. But my question refers to wether or not memory
Maybe I should clarify what I mean.
I have a db (postgresql 8.4.1 with a postGIS spatial extension) with about
200+ tables in it. Some of them is supposed to be updated using an
application what requres that some of the columns are in uppercase (a
leftover from Oracle I suppose) but the main
On 05/03/12 12:08 AM, Alexander Reichstadt wrote:
since I got no answer so far I searched through the docu again. I searched for
GC as well as Garbage, and all garbage refers to is with regard to vacuuming a
database. But my question refers to wether or not memory management is with
garbage
Hi,
since I got no answer so far I searched through the docu again. I searched for
GC as well as Garbage, and all garbage refers to is with regard to vacuuming a
database. But my question refers to wether or not memory management is with
garbage collection supported or not. When I try to link
Thanks, that's answering my question. In Objective-C as well as many other
languages there is the feature to turn on Garbage Collection. It's a separate
thread that scans memory for strong pointers, their source and origin and
vacuums memory so to not have any leaks. Anything unreferenced and
Hello
2012/5/3 Chrishelring christianhelr...@gmail.com:
Maybe I should clarify what I mean.
I have a db (postgresql 8.4.1 with a postGIS spatial extension) with about
200+ tables in it. Some of them is supposed to be updated using an
application what requres that some of the columns are in
What if you created separate tables with the fields in uppercase, either
with different names or better yet the same names and a different schema?
It seems you could put triggers on those tables, and have your trigger
translate the field names and make the updates to the real tables instead.
On 05/03/12 12:50 AM, Ken Tanzer wrote:
What if you created separate tables with the fields in uppercase,
either with different names or better yet the same names and a
different schema? It seems you could put triggers on those tables,
and have your trigger translate the field names and make
On Thu, May 3, 2012 at 9:39 AM, Alexander Reichstadt l...@mac.com wrote:
Thanks, that's answering my question. In Objective-C as well as many other
languages there is the feature to turn on Garbage Collection. It's a
separate thread that scans memory for strong pointers, their source and
On Thu, May 03, 2012 at 09:39:29AM +0200, Alexander Reichstadt wrote:
Thanks, that's answering my question. In Objective-C as well as many other
languages there is the feature to turn on Garbage Collection. It's a separate
thread that scans memory for strong pointers, their source and origin
On Thu, May 3, 2012 at 8:56 AM, Magnus Hagander mag...@hagander.net wrote:
On Thu, May 3, 2012 at 9:39 AM, Alexander Reichstadt l...@mac.com wrote:
Thanks, that's answering my question. In Objective-C as well as many other
languages there is the feature to turn on Garbage Collection. It's a
On 3 May 2012 09:39, Alexander Reichstadt l...@mac.com wrote:
Thanks, that's answering my question. In Objective-C as well as many other
I notice that you're talking about pqlib instead of libpq. Perhaps
pqlib is an Obj-C wrapper around libpq that most of us just don't know
about? Obj-C is not a
(Sorry, I meant libpq). Actually it's finalize in Objective-C as well. PGSQLKit
is the ObjC wrapper framework for libpq. I was confused by what I had learnt
about GC, being it can't mix with non-GC. What the docu didn't mention in the
places I read --or at least not so that it stuck-- was that
Hmm.. Haden´t thought about making a view. It should work because the
application that uses the data is read-only (yet!).
I´ll give that a try. Thanks!
Christian
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Uppercase-to-lowercase-trigger-tp5680384p5682880.html
Sent
Thanks, I went into that function, added log statements everywhere and
figured which check it's failing on:
!heap_attisnull(func_tuple, Anum_pg_proc_proconfig)
and it's because my real function had this at the end:
SET search_path FROM CURRENT;
which I never imagined would make any
Hi there! I'm interested to get the physical locations of tables, views,
functions, data/content available in the tables of PostgreSQL in Linux OS. I've
a scenario that PostgreSQL could be installed in SD-Card facility and
Hard-Disk. If I've tables, views, functions, data in SD, I want to get
On Thu, May 3, 2012 at 6:52 PM, Siva Palanisamy siv...@hcl.com wrote:
Hi there! I'm interested to get the physical locations of tables, views,
functions, data/content available in the tables of PostgreSQL in Linux OS.
I've a scenario that PostgreSQL could be installed in SD-Card facility and
Hi,
We have a situation where HIPAA data that needs to be encrypted.
Since we have lots of users, and a number of users who access the data
of different people, we cannot simply encrypt the disk and call it
good - it's not fine-grained enough.
So far, we've been encrypting each row, and that
Ben Madin li...@remoteinformation.com.au writes:
On 03/05/2012, at 11:57 AM, Tom Lane wrote:
So this is smelling like a kernel or filesystem bug. I wonder exactly
which OS X update you're running, and what sort of filesystem the
database is stored on.
[ it's an up-to-date, pretty vanilla
On Wed, May 02, 2012 at 12:31:02PM -0400, Bruce Momjian wrote:
I assume there are no current users of the BSDi, BSD/OS port that are
going to be upgrading to Postgres 9.2. Therefore, I propose removal of
that port in Postgres 9.2. Any objections?
Port removed for Postgres 9.2.
--
Bruce
Hi Bruce,
Thanks. I tried. It works.
Regards.
Grace
At 2012-05-03 07:14:21,Bruce Momjian br...@momjian.us wrote:
On Wed, May 02, 2012 at 11:03:47AM -0700, leaf_yxj wrote:
Hi Andreas,
Thanks a lot.
I tried those following , they work.
1) insert into test values (
Evan Martin postgre...@realityexists.net writes:
Thanks, I went into that function, added log statements everywhere and
figured which check it's failing on:
!heap_attisnull(func_tuple, Anum_pg_proc_proconfig)
and it's because my real function had this at the end:
SET search_path FROM
Hi Super Guys,
Thanks. I learned a lot. It's very good for me to know that.
Regards.
Grace
At 2012-05-03 07:15:29,Bruce Momjian br...@momjian.us wrote:
On Wed, May 02, 2012 at 04:03:01PM -0700, Adrian Klaver wrote:
On 05/02/2012 11:42 AM, Bruce Momjian wrote:
On Wed, Mar 28, 2012 at
Hi,
I'm trying to make a periodic (daily) incremental backup using rsync but
noticing a message that postgres startup process is waiting on so and so
XLOG file indefinitely.
I intend to schedule a cron job to periodically execute this rsync backup
process by : a) stop postgres server on backup
On Thu, May 03, 2012 at 08:33:06AM +0200, Alexander Reichstadt wrote:
Hi,
since I got no answer so far I searched through the docu again. I
searched for GC as well as Garbage, and all garbage refers to is with
regard to vacuuming a database. But my question refers to wether or
not memory
Chrishelring wrote:
Hmm.. Haden´t thought about making a view. It should work because the
application that uses the data is read-only (yet!).
I´ll give that a try. Thanks!
Well a view is a much more natural solution than the other proposal, about
constantly doing data definition / changing
v8.3.4 on linux
After this..
alter table fred alter column wilma set default 'dino';
...it appeared that a user that had insert,delete,update privs lost them.
I regranded and things went back to normal.
Is it correct for those privs to be dropped in this case? If so, why (just
curious).
On Thu, May 3, 2012 at 11:49 AM, Samba saas...@gmail.com wrote:
Hi,
Please advise me if what i'm doing is makes sense and is an accepted
mechanism for taking backups or if there is any other procedure that i can
emplpoy to avoid unnecessarily archiving gigabytes of WAL logs which may be
On Thu, May 3, 2012 at 11:14 AM, Gauthier, Dave dave.gauth...@intel.com wrote:
v8.3.4 on linux
After this..
alter table fred alter column wilma set default 'dino';
...it appeared that a user that had insert,delete,update privs lost them.
I regranded and things went back to normal.
Is it
Hi,
I have a huge Postgres database on my C drive, I am continuously collecting
the data, so unfortunately, the drive is getting full and I wanted to move
it to a map network drive I got. I followed the instruction in the link
below:
http://kb.vircom.com/kbase/default.asp?id=1512Lang=1SID=
1 -
On 05/03/12 11:55 AM, EllyR wrote:
But after doing all the things mentioned in the link, when I want to start
the postgres again as a service, it can not be started, it seems it does not
recognize the map network drive , would you please let me know if I am in
the right track or I need to do
On Thu, May 3, 2012 at 8:55 PM, EllyR ela_ma...@yahoo.com wrote:
Hi,
I have a huge Postgres database on my C drive, I am continuously collecting
the data, so unfortunately, the drive is getting full and I wanted to move
it to a map network drive I got. I followed the instruction in the link
On Fri, May 4, 2012 at 4:55 AM, EllyR ela_ma...@yahoo.com wrote:
I have a huge Postgres database on my C drive, I am continuously collecting
the data, so unfortunately, the drive is getting full and I wanted to move
it to a map network drive I got.
Are you able to install Postgres on a remote
Hi,
I need to trim whitespace off of a whole column and replace the existing
values with the trimmed ones.
This isn't working
update mytable set id = trim(id);
I'm not sure of the correct syntax. Help appreciated.
Mike
signature.asc
Description: Digital signature
Michael --
Hi,
I need to trim whitespace off of a whole column and replace the existing
values with the trimmed ones.
This isn't working
update mytable set id = trim(id);
I'm not sure of the correct syntax. Help appreciated.
Mike
The trim function needs to be told what sort of trim to do
On 05/03/2012 06:55 PM, Greg Williamson wrote:
Michael --
Hi,
I need to trim whitespace off of a whole column and replace the existing
values with the trimmed ones.
This isn't working
update mytable set id = trim(id);
I'm not sure of the correct syntax. Help appreciated.
Mike
The trim
On 05/03/2012 06:01 PM, Michael P. Soulier wrote:
Hi,
I need to trim whitespace off of a whole column and replace the existing
values with the trimmed ones.
This isn't working
update mytable set id = trim(id);
I'm not sure of the correct syntax. Help appreciated.
Works here:
test= SELECT
Of course, it seems silly now to not have included SET search_path FROM
current in my post, but I had no idea what was and wasn't critical -
that was the whole problem. Wisdom begins with knowing the right
questions to ask! Yes, I was looking at the same function - even checked
SVN logs to
On 03/05/12 Adrian Klaver said:
Works here:
test= SELECT version();
version
---
PostgreSQL 9.0.7 on i686-pc-linux-gnu, compiled by GCC gcc (SUSE
Linux) 4.6.2, 32-bit
On 03/05/12 Michael P. Soulier said:
still, in my app I see a lot of trailing whitespace after reading from the
db...
[root@vmbg-msoulier3 eventviewer]# PYTHONPATH=.. python manage.py shell
Python 2.6.6 (r266:84292, Dec 7 2011, 20:38:36)
[GCC 4.4.6 20110731 (Red Hat 4.4.6-3)] on linux2
Type
Yes you are right, I have read that it is not that reliable, but I have to do
something for that, what would be your suggestion for this case? Thanks.
--
View this message in context:
Thanks for answering,
I have the latest Postgres on my machine, do you know where can I find the
instruction for map network drive? or do you think it won't work at all on
network drive?
--
View this message in context:
On 03/05/12 Michael P. Soulier said:
lots and lots of whitespace. I think it's in the db.
Ah, they're not varchars, they're character columns. That explains it...
signature.asc
Description: Digital signature
On 05/03/12 5:15 PM, EllyR wrote:
I have the latest Postgres on my machine, do you know where can I find the
instruction for map network drive? or do you think it won't work at all on
network drive?
database servers should not be run in SMB/CIFS network shares. The
shares just aren't
On May 3, 2012, at 20:20, EllyR ela_ma...@yahoo.com wrote:
Yes you are right, I have read that it is not that reliable, but I have to do
something for that, what would be your suggestion for this case? Thanks.
Simplest option: install a new local hard drive and configure a tablespace to
use
49 matches
Mail list logo