Title: RE: [GENERAL] Move cursor
does i hope that CURSOR will be fully implemented soon ?
(or maybe you know an alternative for my problem ? :) )
-Message d'origine-
De : Michael Fuhr [mailto:[EMAIL PROTECTED]]
Envoyé : mardi 8 mars 2005 18:29
À : Tom Lane
Cc : FERREIRA William
Adam Tomjack wrote:
For various reasons, I can't actually delete records from my database.
Instead, I have a boolean 'active' field for each table. I need to
implement something like cascading delete, but instead of deleting, I
need to set active=false.
I've googled and haven't found a
On Tue, 2005-03-08 at 16:30 -0600, Guy Rouillier wrote:
We use a dynamic statement in a pgsql stored function to insert rows
into a table determined at run time. After much debugging, I've
discovered that a null incoming argument will cause the dynamic
statement to evaluate to null. The
On Tue, 8 Mar 2005, Scott Marlowe wrote:
On Tue, 2005-03-08 at 09:06, Shelby Cain wrote:
--- Howard Cole [EMAIL PROTECTED] wrote:
Although not appropriate for a speed comparison, you
might want to note
that the use of Mysql versions 4.0 upward now
require commercial license
for clients, which are
Net Virtual Mailing Lists wrote:
All I did was added an extra column to my table (I called it
batch_process). Then in
the trigger do something like (in whichever function you are calling):
IF NEW.batch_update IS NOT NULL AND NEW.batch_update = ''t'' THEN
NEW.batch_process := NULL;
RETURN
On Tue, Mar 08, 2005 at 04:30:54PM -0600, Guy Rouillier wrote:
This is such a common usage pattern that I'm pretty sure I'm missing
something basic. Pgsql provides quote_literal to aid with inserting a
literal string into a dynamically prepared statement. My opinion is
that quote_literal
Marco Colombo wrote:
If want to develop a commercial application that:
- runs under Linux - I can;
- uses HTTP as protocol, and connects to a GPL-ed web server - I can;
- uses MySQL as a database backend - I can't, unless I rewrite the
client library, or buy a commercial licence from them. Why?
Hi,
I'm trying to figure out how to do this from the documentation, but I
can't figure it out. :-(
Here is what I'm trying to do:
CREATE TABLE MyTable
(
ID bigserial unique,
MyData char(255),
PRIMARY KEY (ID)
);
CREATE TABLE Archive_MyTable
(
ID
Gordan Bobic wrote:
Hi,
I'm trying to figure out how to do this from the documentation, but I
can't figure it out. :-(
Here is what I'm trying to do:
CREATE TABLE MyTable
(
IDbigserial unique,
MyDatachar(255),
PRIMARY KEY (ID)
);
CREATE TABLE Archive_MyTable
(
ID
Hi all,
I am running Postgres on a machine with
4G of memory.
When I run
dbvlm= SELECT u.email, g.email FROM dom_user u,
dom_member m, dom_group g
andlm- WHERE u.userid=m.userid and
m.groupid=g.groupid and g.iso_language='de' and
dbvlm- m.type='n' limit 1000;
ERROR: out of memory
DETAIL:
# [EMAIL PROTECTED] / 2005-03-01 17:41:46 +0100:
There are 5 vaccinations in a given vaccination schedule.
Patient had 3 shots.
I want the view to show me that shot 4 and 5 are missing
without having to enter the cardinality of the vaccination in
the original data.
I
Pruteanu Dragos wrote:
Hi all,
I am running Postgres on a machine with
4G of memory.
When I run
dbvlm= SELECT u.email, g.email FROM dom_user u,
shared_buffers = 20
sort_mem = 819200
vacuum_mem = 819200
What process led you to choose these values? Do you
Hi,
it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work together?
Here is my error message:
Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres
Okay, I'll split them with you. I remember the Groton Database Corp. of
Groton Connecticut, whose marketing people didn't like the sound of
*Groton*, and renamed the company Interbase and the product InterBase (note
caps). Ashton Tate came along years later and bought the company to
increase
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Are you using the latest selinux_policy_targeted package? I mean, is your
system up2date?
Regards,
On Wed, 9 Mar 2005, Ulrich Wisser wrote:
Hi,
it seems selinix doesn't like postgres. Can I uninstall selinux from fedora
savely? OR is there any
Sorry,
of course I forgot to mention my installed version. Please find them below:
postgresql-jdbc-7.4.7-3.FC3.1
postgresql-odbc-7.3-8.FC3.1
postgresql-test-7.4.7-3.FC3.1
postgresql-devel-7.4.7-3.FC3.1
postgresql-contrib-7.4.7-3.FC3.1
postgresql-python-7.4.7-3.FC3.1
postgresql-7.4.7-3.FC3.1
On Wed, 09 Mar 2005 14:38:06 +0100, Ulrich Wisser
[EMAIL PROTECTED] wrote:
Sorry,
of course I forgot to mention my installed version. Please find them below:
postgresql-jdbc-7.4.7-3.FC3.1
postgresql-odbc-7.3-8.FC3.1
postgresql-test-7.4.7-3.FC3.1
postgresql-devel-7.4.7-3.FC3.1
On Tue, 2005-03-08 at 21:24, Tope Akinniyi wrote:
Hi,
I am wondering at this display of extreme Linux mentality being
displayed by the 'top bras' of the PostgreSQL community. And I ask,
are we encouraging Windows use of PostgreSQL at all?
Take a look at tools being rolled out at
Richard Huxton wrote:
Gordan Bobic wrote:
Hi,
I'm trying to figure out how to do this from the documentation, but I
can't figure it out. :-(
Here is what I'm trying to do:
CREATE TABLE MyTable
(
IDbigserial unique,
MyDatachar(255),
PRIMARY KEY (ID)
);
CREATE TABLE
I just installed postgresql on a new gentoo server using emerge and I would
like to add the citext module for a case insensitive text type. Emerge does
not have a citext option in postgresql or package.
Does anyone know how to get the citext into postgresql on gentoo and will
this break the next
Ulrich Wisser wrote:
Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres name=PG_VERSION dev=dm-1
ino=1255016 scontext=user_u:system_r:postgresql_t
tcontext=root:object_r:var_lib_t tclass=file
Try running 'restorecon -n -R -v
Ulrich Wisser [EMAIL PROTECTED] writes:
it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work together?
They should work together as long as you have the latest PG RPMs (which
it seems you do) and a reasonably recent
DELETE FROM Temp1 WHERE Test = 'test3';
ERROR: syntax error at or near $2 at character 44
QUERY: INSERT INTO Temp2 (ID, test) VALUES ( $1 $2 )
CONTEXT: PL/pgSQL function temp1_trigger_delete line 2 at SQL statement
LINE 1: INSERT INTO Temp2 (ID, test) VALUES ( $1 $2 )
Csaba Nagy wrote:
DELETE FROM Temp1 WHERE Test = 'test3';
ERROR: syntax error at or near $2 at character 44
QUERY: INSERT INTO Temp2 (ID, test) VALUES ( $1 $2 )
CONTEXT: PL/pgSQL function temp1_trigger_delete line 2 at SQL statement
LINE 1: INSERT INTO Temp2 (ID, test) VALUES ( $1 $2 )
This simple function return setof table DatiRegione
CREATE OR REPLACE FUNCTION public._stato_dati_regione_rt(text)
RETURNS SETOF DatiRegione AS
'
SELECT DISTINCT ON (Codice_regione) dr.* FROM DatiRegione
'
LANGUAGE 'sql' VOLATILE STRICT;
When I perform query on this setof, pgsql not
Tom Lane wrote:
Tope Akinniyi [EMAIL PROTECTED] writes:
I am not holding anybody responsible, but I think we need to do a massive re-orientation of the community not to carry the Linux-Windows game too far.
This is a troll, isn't it?
My thinking as well, unfortunately, has hooked some folks...
--
--- Uwe C. Schroeder [EMAIL PROTECTED] wrote:
The problem is, that it's a question of
perception. Most windows fans don't
see that their OS is pretty instable.
That may have been true in 1995. However, in this day
and age most Windows fans don't see that their OS as
unstable because it
Title: iterate over refcursor
hi
does
the table partitionning exists under PostgreSQL ? or maybe an alternative exists
?
Oracle
implements this system : it allows to spread rows on differents partitions
depending on an attribute.
For
example, my application store xml documents in
unsuscribe
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
On Wed, 2005-03-09 at 10:31, FERREIRA William (COFRAMI) wrote:
hi
does the table partitionning exists under PostgreSQL ? or maybe an
alternative exists ?
Oracle implements this system : it allows to spread rows on differents
partitions depending on an attribute.
For example, my
Please post to the list too when replying...
On Wed, 2005-03-09 at 17:29, Mican Bican wrote:
Thank you for your answer. The reason of so long transactions is that
I first Insert a row than get the last ID (primary key) and select it
for update from the database and wait for user to commit it..
Personally, I find the anti-windows bias that has been shown in this
thread by some developers to be disappointing. Maybe it sucks to program
in, and maybe it's not as stable as unix (though I don't put much water
in that argument anymore), but the fact is there's still a LOT of places
that are
Tablespaces are the closest thing. They were introduced in 8.0:
http://www.postgresql.org/docs/8.0/static/sql-createtablespace.html
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
Shelby Cain wrote:
--- Uwe C. Schroeder [EMAIL PROTECTED] wrote:
The problem is, that it's a question of
perception. Most windows fans don't
see that their OS is pretty instable.
That may have been true in 1995. However, in this day
and age most Windows fans don't see that
Hi, I'm new at pg.
I'll be using tmp tables in others rdbms. An user can create your own
tmp tables (grant temporary tables) but can't drop it (I don't want to
grant drop privileges).
Other way it's using on commit; but I can't make this work.
Example:
CREATE TEMPORARY TABLE tmp ON COMMIT DROP
On Wed, Mar 09, 2005 at 04:49:28PM +0100, Alessandro Vincelli wrote:
This simple function return setof table DatiRegione
CREATE OR REPLACE FUNCTION public._stato_dati_regione_rt(text)
RETURNS SETOF DatiRegione AS
'
SELECT DISTINCT ON (Codice_regione) dr.* FROM DatiRegione
'
Whoops, posted to the wrong mailing list... but it might fit anyway.
---(end of broadcast)---
TIP 8: explain analyze is your friend
hello to all
I have the following problem, when making massive
update of a table, I received the message
segmentation fault without no other data of the
error in log.
Some idea of because it gives east message?
I am using
gentoo
postgres 7.4.6
dual processor HP proliant
5 gigabyte of
On Wed, 9 Mar 2005 11:02:10 -0600, Jim C. Nasby [EMAIL PROTECTED] wrote:
... but the fact is there's still a LOT of places
that are windows shops and a LOT of people who use windows more heavily
than *nix. More important, the egotism of If you want to use PostgreSQL
you better run it on what we
Ho ho, flame on! :)
My completely annecodal experience with devs which prefer windows over
posix is that the former prods things until they seem to work and accepts
unexplained behavior far more readily than the latter. Do I *really* want
that kind of mentality in my database devs?
Anyway, I
On Wed, 9 Mar 2005 14:28:55 -0300 (ART), marcelo Cortez
[EMAIL PROTECTED] wrote:
hello to all
I have the following problem, when making massive
update of a table, I received the message
segmentation fault without no other data of the
error in log.
Some idea of because it gives east
Sim Zacks wrote:
I just installed postgresql on a new gentoo server using emerge and I
would like to add the citext module for a case insensitive text type.
Emerge does not have a citext option in postgresql or package. Does
anyone know how to get the citext into postgresql on gentoo and will
I don't think so, if you consider a troll to be someone who doesn't care
about the topic, but rather wishes to stir up newbies and flamers. A
search of the archives shows the sender has a history of asking valid
questions and offering advice on-topic.
That said, the result is the same.
Cheers,
Le mercredi 09 mars 2005 à 09:47 -0800, Ben a écrit :
Ho ho, flame on! :)
Hear hear!!! This man is a troll if ever we have seen one.
Personally, I find the anti-windows bias that has been shown in this
thread by some developers to be disappointing. Maybe it sucks to program
in, and maybe
I thank you all for throwing light on the question I
asked.
I was exchanging mails with one of the developers on
PgFoundry. He made a comment and said
'Is anybody using PostgreSQL on Windows?'.
I began to wonder, was the Windows version a toy?
I head a software development outfit in Nigeria
Sim Zacks wrote:
I just installed postgresql on a new gentoo server using emerge and I would
like to add the citext module for a case insensitive text type. Emerge does
not have a citext option in postgresql or package.
No, because it's not part of the postgres tarball. But the Gentoo
ebuilds
On Wed, 9 Mar 2005, tony wrote:
Le mercredi 09 mars 2005 à 09:47 -0800, Ben a écrit :
Ho ho, flame on! :)
Hear hear!!! This man is a troll if ever we have seen one.
Who? Jim Nasby? He's made several helpful posts to this list in my
memory, and I'm sure an archive search would turn up a
tony wrote:
Excuse me dear sir. There seems to be about 97% of the world that runs
Windows that does not give you permission to be rude to a tiny minority
who just happen to have written an insanely great database that runs
quite nicely on their hobby OSs as well as the crap you call home. If
you
Tom Lane wrote:
One problem is that selinux-policy-targeted updates don't necessarily
propagate to the security labels of the individual files.
Sounds like it might be a good idea to add a trigger to the PostgreSQL
RPM to run restorecon when the SELinux policy is updated.
--
Scott Marlowe [EMAIL PROTECTED] writes:
With the advent of very large raid arrays with very fast caching
controllers, this methodology is becoming less and less necessary.
I think the evidence is to the contrary. Witness the rather dramatic surge in
inquiries about this on this list. A year
Ragnar Hafstað wrote:
On Tue, 2005-03-08 at 16:30 -0600, Guy Rouillier wrote:
We use a dynamic statement in a pgsql stored function to insert rows
into a table determined at run time. After much debugging, I've
discovered that a null incoming argument will cause the dynamic
statement to
Scott Marlowe wrote:
On Wed, 2005-03-09 at 10:31, FERREIRA William (COFRAMI) wrote:
hi
does the table partitionning exists under PostgreSQL ? or maybe an
alternative exists ?
Oracle implements this system : it allows to spread rows on differents
partitions depending on an attribute.
For
On Wed, 2005-03-09 at 13:07, Greg Stark wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
With the advent of very large raid arrays with very fast caching
controllers, this methodology is becoming less and less necessary.
I think the evidence is to the contrary. Witness the rather dramatic
Lonni , folks
You're doing this from within psql or elsewhere?
from putty terminal from windows statiom
What logging level
default i' guest
are you using? How 'massive' is this update?
full , the update statement not have filter clause.
kind of parameters
the update statement
From your postgresql.conf it look like you're running with a default
config, which is very likely unsuitable for the dataset and/or usage
patterns that you have. Granted that should not cause a seg fault,
but who knows what kind of weirdness is going on behind the scenes.
I didn't see any info
On Wed, 9 Mar 2005 16:26:53 -0300 (ART), marcelo Cortez
[EMAIL PROTECTED] wrote:
Lonni , folks
You're doing this from within psql or elsewhere?
from putty terminal from windows statiom
That doesn't really answer the question. How are you interfacing with
the database? Are you using a
Lonni , folks
configuration data: sorry for long response ;)
Linux sume 2.6.9-gentoo-r1 #1 SMP Mon Feb 21 10:46:46
Local time zone
must
be set--see zic i686 Intel(R) Xeon(TM) CPU 2.80GHz
GenuineIntel
GNU/Linux
postgres:
PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by
GCC gcc (GCC) 3.3.4
On Wed, 2005-03-09 at 13:21, Joshua D. Drake wrote:
Scott Marlowe wrote:
On Wed, 2005-03-09 at 10:31, FERREIRA William (COFRAMI) wrote:
hi
does the table partitionning exists under PostgreSQL ? or maybe an
alternative exists ?
Oracle implements this system : it allows to spread
Joshua,
Very well put !
Cheers,
Aly.
Joshua D. Drake wrote:
Shelby Cain wrote:
--- Uwe C. Schroeder [EMAIL PROTECTED] wrote:
The problem is, that it's a question of
perception. Most windows fans don't
see that their OS is pretty instable.
That may have
[EMAIL PROTECTED] (Tope Akinniyi) writes:
I am wondering at this display of extreme Linux mentality being
displayed by the 'top bras' of the PostgreSQL community. And I ask,
are we encouraging Windows use of PostgreSQL at all?
Take a look at tools being rolled out at PgFoundry on daily
I thank you all for throwing light on the question I asked.
[missed it earlier, not been reading that lists mail]
I was exchanging mails with one of the developers on
PgFoundry. He made a comment and said
'Is anybody using PostgreSQL on Windows?'.
Yes. I know of several fairly large
Lonni , folks
Full meaning all the rows are being updated? What
kind of data is
this that you're updating?
the fts engine using one tsvector field indexing with
gist index
the statement is something like this
update from veryLargeTable
set field = to_tsvector( coleace(field1) );
any
The only additional thing I would add to this if it hasn't been mentioned
already is that 2000 had/has some major security issues and even though 2003 is
more secure out of the box from what I've experienced so far, I would **never**
trust a windows box to anything other than my LAN using private
Quoting Joshua D. Drake [EMAIL PROTECTED]:
Shelby Cain wrote:
--- Uwe C. Schroeder [EMAIL PROTECTED] wrote:
The problem is, that it's a question of
perception. Most windows fans don't
see that their OS is pretty instable.
That may have been true in
Scott Marlowe [EMAIL PROTECTED] writes:
Actually, I think it is the more common scenario of migrating off of
oracle or db2 and onto postgresql, and bringing along the experience
gained there over the years that has caused this refrain to sprout up
more and more often. With a database sitting
On Wed, 2005-03-09 at 14:47, Greg Stark wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
Actually, I think it is the more common scenario of migrating off of
oracle or db2 and onto postgresql, and bringing along the experience
gained there over the years that has caused this refrain to
Quoting Joshua D. Drake [EMAIL PROTECTED]:
The only additional thing I would add to this if it hasn't been mentioned
already is that 2000 had/has some major security issues and even though 2003
is
more secure out of the box from what I've experienced so far, I would
**never**
trust a
The beauty of an open source, BSD-licensed project like PostgreSQL is
the entire Who cares? possibility list.
If you have a Windows shop and you have Windows trained personnel, then
you can use PostgreSQL.
If you have a Linux shop and Linux trained personnel, then you can use
PostgreSQL.
If you
Hi,
It would appear the bittorrent tracker is down or broken. I can't
download anything from postgresql (but I can from other torrents), and I
can't seed either.
--
David Mitchell
Software Engineer
Telogis
NOTICE:
This message (including any attachments) contains CONFIDENTIAL
INFORMATION
Not sure what I need to start on the server, so David will have to check
it over ... the only thing that is in the auto-start script on the srever
itself, though, I've just restarted, so try now and let me know if that
was the only thing I needed ot hit ...
On Thu, 10 Mar 2005, David Mitchell
Scott Marlowe [EMAIL PROTECTED] writes:
Wait, I'm not sure I understand your point here yet. Are you saying
something along the lines of that with a 1TB storage array, and putting
all the data in one big partitions, the DBAs had problems, but when they
partitioned it down to say 10 100G
Scott Marlowe [EMAIL PROTECTED] writes:
Yes, it is a way. It's just a less necessary one than it once was, with
hardware now able to provide the same performance increase with little
or no work on the users part. We've got to weigh the increased
complexity it would take to implement it in
Yes, that fixed it.
Marc G. Fournier wrote:
Not sure what I need to start on the server, so David will have to check
it over ... the only thing that is in the auto-start script on the
srever itself, though, I've just restarted, so try now and let me know
if that was the only thing I needed ot
Jim C. Nasby wrote:
Personally, I find the anti-windows bias that has been shown in this
thread by some developers to be disappointing. Maybe it sucks to program
in, and maybe it's not as stable as unix (though I don't put much water
in that argument anymore), but the fact is there's still a LOT
Net Virtual Mailing Lists wrote:
All I did was added an extra column to my table (I called it
batch_process). Then in
the trigger do something like (in whichever function you are calling):
IF NEW.batch_update IS NOT NULL AND NEW.batch_update = ''t'' THEN
NEW.batch_process := NULL;
[Here's my third attempt to post this. Sorry if it's a dup. (trip?)]
If you're willing to modify your triggers you can gain per-session
control over any and all triggers and functions.
For example, suppose I have a trigger that logs certain events, but I
also want to be able to turn off
It took me a while, but I finally figured out that the citext module did
not require a recompile, it just required all the compile information,
specifically the config.status file, which wasn't there.
After I extracted the sources and ran ./configure for postgresql, the
contrib module compiled
Hi Tom,
sudo /sbin/restorecon -R /var/lib/pgsql
worked like a charm!
Thank you very much!
Ulrich
--
Ulrich Wisser
RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
Lonni J Friedman wrote:
selinux-policy-targeted-1.17.30-2.85
up2date insists that these packages are all up to date.
And you're certain that you're using the targetted policy and not strict?
To be frank, I am not. I have not the slightest idea what all that
selinux is about (beside security in
79 matches
Mail list logo