I have found that using SPT to send a simple rollback like
SQLEXEC('ROLLBACK')
causes C5 error in VFP.
William Yu [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Andrus wrote:
Can you use Postgres savepoints from VFP ?
sqlexec('ROLLBACK TO mysavepoint') and even
Coming late into the discussion, there is one more note I'd add to this
- if you're on windows and want to be extra secure, also set
wal_sync_method=fsync_writethrough. This will get it through most (I
would say all if I was sure, but I'm not) IDE disks that lie about write
completion.
Hi, pgsql-general.
Tell me please, how to update a set of rows using order-
something like :
update my_table set counter1=nextval('my_seq') order by counter2 ;
--
Regards,
Igor mailto:[EMAIL PROTECTED]
---(end of
On Sun, 2005-10-30 at 23:08 -0500, Tom Lane wrote:
Vlad [EMAIL PROTECTED] writes:
I'm looking for some help in regards to letting Posresql use more
memory.
8.0 can't go past 2Gb of shared memory, and there is really no reason
to try because its performance will get worse not better with
On Mon, Oct 31, 2005 at 12:16:59PM +, Simon Riggs wrote:
8.0 can't go past 2Gb of shared memory, and there is really no reason
to try because its performance will get worse not better with more than
about 5 shared buffers.
Unless you turn off the bgwriter, in which case going
On Mon, 2005-10-31 at 14:14 +0100, Martijn van Oosterhout wrote:
On Mon, Oct 31, 2005 at 12:16:59PM +, Simon Riggs wrote:
8.0 can't go past 2Gb of shared memory, and there is really no reason
to try because its performance will get worse not better with more than
about 5 shared
Jamie Deppeler [EMAIL PROTECTED] writes:
Hi trying to wtite a trigger to update summary fields in a seperate
table to do this i am planning on using trigger. problem i have at
the moment the update trigger doesnt seem to be fireing but the
insert works.
Trigger
CREATE TRIGGER
Anyway, the original writer didn't specify an architechure. If it is a
32bit one it is entirly possible that the memory map simply has no
large contiguous space to map the shared memory.
it's 32bit. The actual problem of giving more buffers to postgresql
was solved with the help of the
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2005-10-31 at 14:14 +0100, Martijn van Oosterhout wrote:
On Mon, Oct 31, 2005 at 12:16:59PM +, Simon Riggs wrote:
I'm not sure we have any good tests of that either way, do we? I'm not
certain why we would trust OS cache any more than we could
On Mon, Oct 31, 2005 at 01:34:12PM +, Simon Riggs wrote:
Secondly, you're assuming that PostgreSQLs caching is at least as
efficient as the OS caching, which is more of an assertion than
anything else.
Do you doubt that? Why would shared_buffers be variable otherwise?
Because the
Martijn van Oosterhout kleptog@svana.org writes:
There have been tests that demonstrate that you can raise the buffers
to a certain point which is optimal and after that it just doesn't
help [1]. They peg optimal size at 5-10% of memory.
[1]
On Mon, Oct 31, 2005 at 09:54:39AM -0500, Tom Lane wrote:
Note however that it's reasonable to think that 8.1 may do better than
8.0 did at performing well with large values of shared_buffers,
primarily because we got rid of the StrategyDirtyBufferList overhead:
Highlights from the license: My thoughts. This is not free, not even as
in beer. Only good for a year. No production use (which is more
restrictive than no commercial use. IANAL) You have to pay when they
release it.
Quotes (with my bolding)
grants to you a no-charge trial license to use
On Saturday 29 October 2005 22:33, Tom Lane wrote:
Steve Crawford [EMAIL PROTECTED] writes:
Is postgresql (or some parts thereof) now using relative pathing
and has that behavior changed?
As of 8.0 we attempt to determine the libdir, sharedir etc as
relative to the location of the
I presume this thread was all brought about by the /. article
http://developers.slashdot.org/article.pl?sid=05/10/31/0659254tid=221tid=1
87
According to the link provided in the /. article
(http://news.zdnet.com/2100-3513_22-5920796.html), Oracle has *proposed* a
free version by year end.
I assume they are probably thinking of a free for non-commercial use,
which is great and all, but I assume that like the majority of folks
here, I am using postgres very much for commercial use, and not just
to run my personal website! So I would say it's not a big deal,
infact it's not even a
--- Joshua D. Drake [EMAIL PROTECTED] wrote:
It is not fully debugged, but this is what I wrote a
few months ago for sh*ts and grins.
/* djenkins, 2005-7-22
Implements poor-man's reverse DNS lookup tool for use
in
Postgresql SQL functions.
CREATE FUNCTION
At 08:24 AM 10/30/2005 -0800, David Fetter wrote:
http://developer.postgresql.org/docs/postgres/plpgsql-control-structure
s.html#PLPGSQL-ERROR-TRAPPING
Erm, doesn't it have the same race conditions?
No, don't believe it does. Have you found some?
Depends on how you do things.
As I
Perhaps I'm the only one to actually have read the article?
Oracle 10g Express Edition HAS been available for free for development
purposes with the previously posted and reviewed limited licenses for quite
some time now.
The news the zdnet.com article is reporting suggests Oracle WILL, by years
Lincoln Yeoh said:
At 07:48 PM 10/30/2005 +, John Sidney-Woollett wrote:
Panic - that's my middle name. ;)
Had I known how to identify the database at fault, and that it would have
had no effect on the other databases, then I would have handled this
episode differently.
Wonder if it would
[EMAIL PROTECTED] wrote on 10/31/2005 12:02:07 PM:
Perhaps I'm the only one to actually have read the article?
Okay, yeah. I went straight for the license. I have now read the article
and agree with you.
---(end of broadcast)---
TIP 5: don't
I have a problem when sorting records with:
SELECT * FROM table WHERE name LIKE 'Ö%'
I am running Postgres 8.02 with a database whose character encoding is
UNICODE.
The SQL Query
SELECT *
FROM member
WHERE name LIKE 'O%'
OR
name like 'Ö%'
ORDER BY name
Hi all,
I'm currently trying to build a defence against SQL INJECTION, after
reading some material on it I arrived to few possible solutions and I
would like to know if anyone can comment anything about them or maybe
add a solution of its own:
1. PachyRand: SQL Randomization for the
Is is
possible to use replace along with regular _expression_ to remove any and all
punctuation from a field?
If so how?
I have tried:
SELECT replace ('Brian\'s Co, INC.', 'Y*([.]',''),SUBSTRING('XY1234Z',
'Y*([0-9]{1,3})');
The second
field substring works with out a problem the
I don't know too much about this solutions, but It always seemed to me
that simple numeric validation plus magic-quotes will work just fine.
Simply validate any numeric input (or you can just quote it with
postgresql, and postgres will do it for you), and auto-escape any
string inputs
Maybe I'm not very creative, but it sure seems to me that if you escape your
strings, make sure your numbers are numbers, and your booleans are actually
booleans, then you're protected
On Mon, 31 Oct 2005, Yonatan Ben-Nes wrote:
Any new ideas or comments will be received gladly.
At 7:54 PM +0200 10/31/05, Yonatan Ben-Nes wrote:
Hi all,
I'm currently trying to build a defence against SQL INJECTION, after
reading some material on it I arrived to few possible solutions and
I would like to know if anyone can comment anything about them or
maybe add a solution of its
On Monday 31 October 2005 08:00, Steve Crawford wrote:
... believe symlinking the executables will work fine though (ie, we
look through the symlink before doing the relative-path
calculation).
Yes, the symlinking did appear to work fine. Thanks for the
confirmation that it is an acceptable
am 31.10.2005, um 13:11:20 -0500 mailte DEV folgendes:
Is is possible to use replace along with regular expression to remove any
and all punctuation from a field?
Which version?
PG 8.1 have a function 'regex_replace'.
HTH, Andreas
--
Andreas Kretschmer(Kontakt: siehe Header)
Heynitz:
On Mon, Oct 31, 2005 at 05:27:15PM -, John Sidney-Woollett wrote:
Wonder if it would be a good idea for the error messages to identify which
databases might have lost data.
However if you have a fair number of databases involved you might get a
fair number of log messages. Still, I
On Mon, 2005-10-31 at 09:35 -0500, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2005-10-31 at 14:14 +0100, Martijn van Oosterhout wrote:
On Mon, Oct 31, 2005 at 12:16:59PM +, Simon Riggs wrote:
I'm not sure we have any good tests of that either way, do we? I'm not
[EMAIL PROTECTED] (Wes Williams) writes:
Perhaps I'm the only one to actually have read the article?
Oracle 10g Express Edition HAS been available for free for development
purposes with the previously posted and reviewed limited licenses for quite
some time now.
The news the zdnet.com
Simon Riggs [EMAIL PROTECTED] writes:
On Mon, 2005-10-31 at 09:35 -0500, Tom Lane wrote:
The real point is that RAM dedicated to shared buffers can't be used for
anything else [1], whereas letting the kernel manage it gives you some
flexibility (for instance, to deal with transient large
[EMAIL PROTECTED] wrote on 10/31/2005 01:14:57 PM:
snip
And I daresay that this _can_ be an attractive thing to businesses,
supposing they offer a production release, gratis.
snip
True, as long as there is no license clause for future revocation of the
free license at the vendor's whim.
Hello all,
I am currently experiencing some strange behaviour when vacuuming an active table.
This table is constantly being updated by one process which gets a new connection every time it updates the table.
There is a second process which is selecting from this table, also aquiring a new
Hi,
Yonatan Ben-Nes wrote:
Hi all,
I'm currently trying to build a defence against SQL INJECTION, after
reading some material on it I arrived to few possible solutions and I
would like to know if anyone can comment anything about them or maybe
add a solution of its own:
[...]
If you're
Precisely the point I was trying to make sure everyone would understand
clearly. Although I don't have a copy of Oracle's suspected new license, if
it is close to the existing license verbiage, even though it is crippled
by having certain hardware and software limits, those limits are per
Hi,
I did a partially successful attempt at creating a partitioned table + two
subpartitions in Pg8.1b inspired by the method used by Bizgres (see
http://www.bizgres.org/assets/docs/html/tblpartn.htm)
I.e:
CREATE TABLE parttest.mastertab
(
id serial not null,
datecol date not null,
Joe Maldonado [EMAIL PROTECTED] writes:
The VACUUM process does not seem to be able to exit, instead it seems to be
stuck in some strange loop for some time.
Is this something to be expected?
That trace looks perfectly normal. Try increasing vacuum_mem if you
want fewer tuple-removal cycles.
Nico Grubert wrote:
Ah, I found it:
lc_collate: [EMAIL PROTECTED]
lc_ctype: [EMAIL PROTECTED]
This is an iso-8859-15 locale, isn't it?
If your database encoding is UNICODE, I believe you'd have more success
using an UTF8 locale, such as de_DE.UTF-8 in your case.
--
Daniel
On Mon, 2005-10-31 at 21:02 +0100, Mikael Carneholm wrote:
So far so good. Now, the part where it fails to be useful (performance wise)
is when you want to make sure a select query only scans the relevant
partition(s), as it's not possible to create a conditional SELECT rule using
an
On Mon, 2005-10-31 at 10:58, Simon Riggs wrote:
On Mon, 2005-10-31 at 15:44 +0100, Martijn van Oosterhout wrote:
On Mon, Oct 31, 2005 at 01:34:12PM +, Simon Riggs wrote:
Secondly, you're assuming that PostgreSQLs caching is at least as
efficient as the OS caching, which is more of
Steve Crawford [EMAIL PROTECTED] writes:
if I try to ensure the C locale I
keep running up against:
FATAL: XX000: failed to initialize lc_messages to
We've seen a few reports of this before, but never been able to identify
the cause. What platform are you running on, exactly? Did you
Can you demonstrate a URL/attack that would constitute an injection
attack that would get around magic-quotes, or provide some links to
such?
Alex
On 10/31/05, MaXX [EMAIL PROTECTED] wrote:
Hi,
Yonatan Ben-Nes wrote:
Hi all,
I'm currently trying to build a defence against SQL INJECTION,
On Mon, 2005-10-31 at 14:50 -0600, Scott Marlowe wrote:
As I understand it, when the last backend referencing a collection of
data stops referencing it, that the buffers holding that data are
released, and if, a second later, another backend wants the data, then
it has to go to the Kernel for
On Mon, Oct 31, 2005 at 02:50:31PM -0600, Scott Marlowe wrote:
Your point was about cache efficiency as an argument for not increasing
shared_buffers. Politely, I don't accept that argument. Clearly, there
are some other considerations (for which I agree completely) but those
don't prevent
Scott Marlowe [EMAIL PROTECTED] writes:
I was mainly wondering if that behaviour had changed, if, when the data
are released, they are still held in shared memory until forced out by
newer / more popular data. Which would make the buffer pool a real
cache.
Huh? It's always done that.
On Mon, 2005-10-31 at 15:44, Simon Riggs wrote:
On Mon, 2005-10-31 at 14:50 -0600, Scott Marlowe wrote:
As I understand it, when the last backend referencing a collection of
data stops referencing it, that the buffers holding that data are
released, and if, a second later, another backend
Try doing a select against mastertab and you will see that it only
selects from the correct partitions. Look at constraint_exclusion
parameter, which needs to be set on for this to work.
Ah - constraint_exclusion is the correct param, not enable_constraint_exclusion
(as stated in
On Mon, 2005-10-31 at 16:12, Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
I was mainly wondering if that behaviour had changed, if, when the data
are released, they are still held in shared memory until forced out by
newer / more popular data. Which would make the buffer pool a
I have a table like so:
id|username|email
with unique indices on username and email. In a
plpgsql function if an insert fails because of a
duplicate on one of those fields, is it possible to
trap the error, figure out which unique fields it
applies to, and raise a custom error message?
Thanks,
On Mon, 2005-10-31 at 14:48 -0800, Chris Travers wrote:
Simon Riggs wrote:
Your point was about cache efficiency as an argument for not increasing
shared_buffers. Politely, I don't accept that argument. Clearly, there
are some other considerations (for which I agree completely) but those
In MySQL, I can insert multiple rows like this:
insert into cars values(5, toyota),(5,ford), etc.
How can I do something similiar in PostgreSQL?
Thanks!
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On Mon, Oct 31, 2005 at 06:06:14PM -0500, blackwater dev wrote:
In MySQL, I can insert multiple rows like this:
insert into cars values(5, toyota),(5,ford), etc.
How can I do something similiar in PostgreSQL?
The similar thing in PostgreSQL is the COPY command (man 8 copy).
HTH :)
On Monday 31 October 2005 13:00, Tom Lane wrote:
Steve Crawford [EMAIL PROTECTED] writes:
if I try to ensure the C locale I
keep running up against:
FATAL: XX000: failed to initialize lc_messages to
We've seen a few reports of this before, but never been able to
identify the cause.
Alex Turner wrote:
Can you demonstrate a URL/attack that would constitute an injection
attack that would get around magic-quotes, or provide some links to
such?
[...]
Just quoting an article in Hackin9 (N°5/2005) I was just reading before
writing my post (page 53, translated from french):
I have this statement in oracle:
CREATE OR REPLACE TRIGGER trig
AFTER INSERT OR UPDATE OR DELETE OF column2 - Here
is the doubt
ON table_product
FOR EACH ROW
BEGIN
...
END
Migrating to PostgreSQL, the conditionals for AFTER UPDATE OF COLUMN2 in
On Mon, 2005-10-31 at 17:13, David Fetter wrote:
On Mon, Oct 31, 2005 at 06:06:14PM -0500, blackwater dev wrote:
In MySQL, I can insert multiple rows like this:
insert into cars values(5, toyota),(5,ford), etc.
How can I do something similiar in PostgreSQL?
The similar thing in
I would need to prepend a couple array items BUT I
NEED them to be positive [1:13] instead of [-4:9] for
instance.
How may I keep prepended array items positive?
__
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
Does PHP support prepared queries with bound parameters for PostgreSQL?
Not only is that foolproof (unless you're calling a function that uses
an argument to build a query string...), you'll get a performance boost
as well since PostgreSQL won't have to reparse and plan every query.
On Mon, Oct
I didn't think query plans were cached between sessions, in which case
prepeared statements aren't worth much for most HTTP based systems
(not counting luckily re-using the same connection using pgpool)...
Please correct me if I'm mistaken - I like being wrong ;)
Alex
On 10/31/05, Jim C. Nasby
go KEY802207 wrote:
Hi, pgsql-general.
Tell me please, how to update a set of rows using order-
something like :
update my_table set counter1=nextval('my_seq') order by counter2 ;
The way this is usually done is to issue a SELECT with an ORDER BY
clause, then update the rows that
On Nov 1, 2005, at 13:40 , Guy Rouillier wrote:
go KEY802207 wrote:
Hi, pgsql-general.
Tell me please, how to update a set of rows using order-
something like :
update my_table set counter1=nextval('my_seq') order by counter2 ;
The way this is usually done is to issue a SELECT with
Hi,
Has anyone installed PostgreSQL 8.1RC on a Cpanel server? I have
root access to my dedicated server and would like to install it,
and then have it available in Cpanel interface to my domains.
Thanks for any tips or pointers.
.ep
__
On Mon, Oct 31, 2005 at 04:37:39PM -0800, Matthew Peter wrote:
I would need to prepend a couple array items BUT I
NEED them to be positive [1:13] instead of [-4:9] for
instance.
How may I keep prepended array items positive?
You could use array-to-array concatenation instead of prepending
I want to use it like this...
UPDATE SET _array = {1,2,3} || _array;
Which if _array had {1} in it, I'd get something like
[-2:1]{1,1,2,3} as the range... I only want it to push
the existing values to the right so I'd have
[1:4]{1,1,2,3}
I don't have a pgsql on this box to show output..
---
On Mon, Oct 31, 2005 at 10:22:14PM -0800, Matthew Peter wrote:
I want to use it like this...
UPDATE SET _array = {1,2,3} || _array;
Which if _array had {1} in it, I'd get something like
[-2:1]{1,1,2,3} as the range...
You have the result backwards: concatenating {1,2,3} and {1} yields
67 matches
Mail list logo