Gregory Youngblood wrote:
On Mon, 2005-10-17 at 12:05 -0700, Chris Travers wrote:
5) Independant patent license firms. I guess it is a possibility, but in the
end, companies that mostly manufacture lawsuits usually go broke. Why would
you sue a non-profit if you were mostly trying
Andrew Sullivan wrote:
On Sat, Oct 15, 2005 at 06:04:54PM -0700, Chris Travers wrote:
Out of curiosity, what is wrong with requiring client SSL certs to
access the system and only issuing them to the PGPool system (or using a
different CA if you need to issue client certs to the end users
Andrew Sullivan wrote:
On Tue, Oct 18, 2005 at 01:19:53PM -0700, Chris Travers wrote:
Ok. but it is still a lazy approach and indicates that Oracle has not
singled us out for special treatment. Again, this was not the case with
MySQL as of 2000 at the latest.
I may be more paranoid
campaign on the part of Oracle directed
specifically at us and not tied to any specific project (fairly likely).
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
Jan Wieck wrote:
On 10/17/2005 10:16 AM, Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What is bad about leaving pg_catalog all lower case and expect
everyone to query the catalog quoted?
The fact that it will break every nontrivial client currently in
existence. Those quotes
Tom Lane wrote:
Chris Travers [EMAIL PROTECTED] writes:
I make the following assumptions:
1) All backend references to identifiers are treated as quoted by the
backend as mentioned in a previous thread.
2) Same with official clients like psql.
3) We don't guarantee complete
will be worried if and when Oracle demonstrates any intelligent
competitive strategy against us. A poorly orchestrated and hasty FUD
campaign does not qualify.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast
target. This is a very interesting move
by Oracle... It will be interesting to see where it goes
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send
you rather deal with the likes of Larry Ellison and his
peons or the likes of you, Josh (both of them), etc?
I think Oracle will start marketing PostgreSQL sometime after IBM jumps
on ship. But don't expect either soon.
Best Wishes,
Chris Travers
Metatron Technology Consulting
inverse strategy of subsidizing the
high-end with the commodity market is ultimately more effective).
Maybe when Bizgres MPP comes out things will change ;-)
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 3: Have you checked our extensive
) NEVER EVER guess as to what the user really meant when the exact
instructions are ambiguous.
If we didn't make these assumptions, we would be using MySQL :-)
Best Wishes,
Chris Travers
Metatron Technology COnsulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x
, if these are the only objections you have :-)
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
---(end of broadcast)---
TIP 1
into FOSS. Third, they may be after
personnel (i.e the buyout may be really a hiring bonus).
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
Jan Wieck wrote:
On 10/13/2005 2:40 PM, Tom Lane wrote:
Chris Travers [EMAIL PROTECTED] writes:
So basically, the problem is that any fix for case folding would
touch a fair bit of code and possibly cause other problems.
However, I haven't seen anyone worry about performance issues
.
Autocommit is a bad example. A better option is the GUC variable that
allows you to go back to the way we used to do things and allow NULL =
NULL to return TRUE instead of NULL. In both these cases, the
difference is a semantic change in what a given SQL statement means.
Best Wishes,
Chris
Martijn van Oosterhout wrote:
On Sat, Oct 15, 2005 at 05:46:03PM -0700, Chris Travers wrote:
This is largely what I have been suggesting. However, you still have
two (small) problems that could be solved fairly easily I think. Take
Tom's example:
SELECT MAX(relpages) FROM pg_class
a larger number of smaller
users so they technically have better market share numbers *and* they
have better plublicity.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
think they do own that one
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
am willing to do this work if people decide
that they are going to go ahead and try to get this in the next release.
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
are not
guaranteed to be backwards compatible and have been changed in the past?
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
to allow connecting from another host,
and then issue the change, but then this isn't really the same
objection, is it).
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
.
Best Wishes,
Chris Travers
Metatron Technoloy Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
performance any day
if it was user error and could be fixed with the help of the people on
the PERFORM list. If we didn't believe that, we would all be using
MySQL, right?
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast
is pretty
mazy...
Again, this is likely doable. There are hidden fields that I suppose
could be extended in a view to reference unique rows (maybe ctid since
the whole thing is expanded in a single SQL statement, but I haven't
tried it).
Best Wishes,
Chris Travers
Metatron Technology
Scott Marlowe wrote:
On Thu, 2005-10-13 at 13:09, Chris Travers wrote:
The problem, as explained to me when I floated this idea, is that the
CATALOGS are all in lower case, and many references to them are behind
the case folding mechanism (i.e. they get accessed by their lower case
names
of a useful piece of a solution.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Tom Lane wrote:
Chris Travers [EMAIL PROTECTED] writes:
So basically, the problem is that any fix for case folding would touch a
fair bit of code and possibly cause other problems. However, I haven't
seen anyone worry about performance issues in such a fix, just that it
might be a fair
Ok. here are some indepth thoughts after reviewing as many prior threads
as I could find on the archives.
Tom Lane wrote:
Chris Travers [EMAIL PROTECTED] writes:
Tom Lane wrote:
Since the end reward for all this work would be having to read CATALOGS
WRITTEN IN ALL UPPER CASE, none
Martijn van Oosterhout wrote:
On Thu, Oct 13, 2005 at 12:21:14PM -0700, Chris Travers wrote:
Since the end reward for all this work would be having to read CATALOGS
WRITTEN IN ALL UPPER CASE, none of the key developers seem very
interested ...
I think you're slightly missing
for
development, it should be adequate.
Hope this helps,
Chris Travers
Metatron Technology COnsulting
I would like to know the limitations of PostgreSQL.
Also, I would like to know, whether there is any limitations for the
number of records or the size of the tables or database in PostgreSQL?
Thanks
Scott Marlowe wrote:
On Wed, 2005-10-12 at 16:16, Chris Travers wrote:
Denis G Dudhia wrote:
Hello There...
I am new to PostgreSQL.
I usually check out negative sides of any software or system, before
implementing it or using it.
Compared to MySQL, I can't think of any
turn of data
verification and then insert dates like Feb 31, 2005? (Strict mode can
be enabled/disabled per connection/session)
snip
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 2: Don't 'kill -9
are running an production database on Windows 98 you have
bigger problems than support from Microsoft
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
to. denied columns
could be filled in with NULLs or or something else. Denied rows
could simply be omitted. As for updating and inserting, you can do your
own permission schemes here too with triggers checking them and
providing the needed logic.
Best Wishes,
Chris Travers
Metatron
Tom Lane wrote:
Justin R. Smith [EMAIL PROTECTED] writes:
I've solved the problem.
I was accessing Postgres over an ssh connection and had enabled X
forwarding in the sshd server (not the default configuration). For
reasons that pass understanding, psql attempts to establish an
) in
the data from the Fn key sequences that is causing Readline to crash.
In that case it would be a readline bug not something correctable in
psql I'm afraid.
Best Wishes,
Chris Travers
Metatron Technology Consultingp
-Doug
---(end of broadcast
column || ',' ||'value'
Delete would require some regular expressions-- check the manual on these.
Or you could write a Perl function.
However, this strikes me as quite denormalized
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast
getting at...
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
don't care
which RDBMS you use, management of 1000 identical tables is going to be
a real pain and I think that everyone here will probably suggest that it
is not exactly a sane thing to do.
Best Wishes,
Chris Travers
Metatron Technology COnsulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
is that you wait until 8.1 is released as some of the
issues involved in application porting will be resolved (LEAST and
GREATEST, for example).
Any feedback on the guide would be appreciated.
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email
to rewrite a whole lot.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
, and then rebuild dependant views. Again the
fact that it is not commonly done indicates simply that there is no need.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
William Yu wrote:
Chris Travers wrote:
1) Efficiency of network throughput
2) Tolerance to attempts at repeat transactions before replication
(emptying an account multiple times)
3) Availability of a transaction.
We ended up having to give up #1. It's possible to have our
;
' LANGUAGE PLPGSQL;
You might have to extend this to track and maintain rules for inserting
and updating on the view.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 6: explain analyze is your friend
and forth. The trick I used here
was for each master to use a different SERIAL field as its primary key
so there are no duplicates. Another option is to have a compound
primary key which is a serial and a server-hash (this would scale to a
larger number of masters).
Best Wishes,
Chris Travers
William Yu wrote:
Chris Travers wrote:
Why not have the people who have rights to review this all write to
the master database and have that replicated back? It seems like
latency is not really an issue. Replication here is only going to
complicate
What master database? Having
William Yu wrote:
Chris Travers wrote:
I guess I am thinking along different lines than you. I was thinking
that the simplest solution would be to have master/slave replication
for *approved* transactions only and no replication for initial
commits prior to approval. This makes
,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 6: explain analyze is your friend
Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
did it in under 10 minutes. A token set of
16 characters, and a fixed length of 8 charachters just isnt a very big
search space.
This is why I suggested a variable-length random string function. But
this not as trivial to impliment.
Best Wishes,
Chris Travers
,
Chris Travers
Metatron Technology Consulting
--
Mike Nolan
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
it to use.
You can then create another function like this:
CREATE FUNCTION random_string(int) returns varchar AS '
SELECT random_string($1, );
' LANGUAGE SQL;
This becomes much harder when working with Unicode, I think
Best Wishes,
Chris Travers
Metatron Technology Consulting
Fernando
FOR IN EXECUTE ''SELECT '' || tname || ''AS table_name, count(*)
from '' ||tname;
LOOP
RETURN NEXT;
END LOOP;
END LOOP;
END;
' LANGUAGE PLPGSQL;
Not saying this will work but it might be a good start.
Best Wishes,
Chris Travers
Metatron Technology Consulting
by the user. This makes it easier to
manage permissions. Of course you cannot use connection pooling in this
case without a partial rewrite of your app...
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 6
can use a
trigger to insert into a message queue and use NOTIFY to let a listening
process know that some action needs to be taken.
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version
,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
---(end of broadcast)---
TIP 6: explain analyze is your friend
Christopher Kings-Lynne wrote:
PDF not found?
Argh Ok. Fixed.
It is about 12 pages. Table of contents entries are clickable. I am
not familiar enough with Docbook so I just wrote it in LaTeX (sources
available upon request).
Direct link is
To anyone who tried before, the link is fixed.
http://www.metatrontech.com/wpapers/mysql2postgresql.pdf
Chris Travers wrote:
Hi;
I have just posted a MySQL to PostgreSQL migration guide at
http://www.metatrontech.com/wpapers and it is free for pretty much
any use (I do have a somewhat
mode debuts in 5.x, it is unlikely
that this will be enabled by
default as MySQL will be largely required to be backwards compatible.
Hope this helps.
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
changed. I am also considering creating a set of wrapper functions
which will provide compatibility with many of the non-standard functions
in MySQL.
Any feedback, etc. is appreciated.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast
?
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
this helps,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
---(end of broadcast)---
TIP 1: if posting/reading through Usenet
them as well.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
unique identifier
along with a globally unique location identifieer. Sort of like we have
with IP addresses, MAC addresses, telephone numbers, etc...
Best Wishes,
Chris Travers
Metatron Technology Consulting
Ben wrote:
Yes, this is the problem with GUIDs... you can calculate them by mashing
*
collisions. Similarly, if we want a guaranteed uniqueness to a GUID we
have to have some sort of unique string to the GUID prepended to it (not
merely used in a hash).
So you could use the Mac address of the machine, I guess, if you wanted
to
Best Wishes,
Chris Travers
Metatron Technology
a monolithic
dump/restore?
I seem to remember encountering an issue some time ago with pg_dump
dumping tables in an order that prevented them from being reloaded.
The solution was to specify the order of the tables in the commandline.
Hope this helps.
Chris Travers
Metatron Technology Consulting
for at least tables and data definitions. Triggers,
functions, etc. would be more difficult. But I think it is reasonable
to expect that functions might have to be manually ported in most
circumstances.
Best Wishes,
Chris Travers
Chris
---(end of broadcast
never been pleasent. These are however caveats and are not
insurmountable.
However, I would choose Firebird anyday for larger Windows
installations, and it is quite a bit better than MySQL...
Best Wishes,
Chris Travers
Metatron Technology Consulting
Tony Caduto wrote:
Hi,
We have a big project
.: No
Ok, how about a better way to do this?
select * from mytable where lower(mycol) LIKE lower(% || lower(X) || %);
Does this work? It seems that this may be the best way to handle this
sort of thing.
Best Wishes,
Chris Travers
Metatron Technology Consulting
ERROR: invalid regular expression
,
Chris Travers
Metatron Technology Consulting
--
/A computer is like an airconditioner. When windows open, it stops
working ! /
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steven Verhoeven, ICT Support Engineer
Department
, but not PostgreSQL crashing.
As I said, the core team takes the security of your data very
seriously. Note that this does not mean that it will nto be supported,
but just that people don't think you should consider doing this.
I hope this response is helpful.
Best Wishes,
Chris Travers
Metatron Technology
it on their development efforts. But YMMV.
And again, this is not the reason for the dearth of tools, but something
to think about when deploying a solution.
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla
information_schema.tables where table_name = $1). the structure of the
information schema is defined in the SQL standards and will be stable
between versions.
Best Wishes,
Chris Travers
Metatron Technology COnsulting
Thanks in advance
Kind Regards,
Shaun Clements
---(end
connections to use. One
you need to scale, you will probably have to go to Linux, BSD, etc.
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere
in their right mind wants to ask the courts whether a work which
might or might not be (f. ex. links to a GPL'd library) is a derivative
work.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 7: don't forget
, but I don't think we are that invulnerable.
Maybe we should set the default authentication to only use TRUST on
local sockets only. At least as of 7.4, the default was to trust
network ports.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast
Tom Lane wrote:
Chris Travers [EMAIL PROTECTED] writes:
Maybe we should set the default authentication to only use TRUST on
local sockets only. At least as of 7.4, the default was to trust
network ports.
Perhaps you should check your facts before posting.
Ok. Pardon me. I misread
to research this too.
Should I be testing on 8 or the 7 version?
8. Has better cache management, meaning will likely perform better.
Hope this helps. It is not a typical question on the list, but if you
start running into issues, this is a good list to ask question on :-)
Best Wishes,
Chris
for something like PostgreSQL... There are a few caveats for
other software but this becomes a bit off-topic. For example, some
games won;t work because they require access to a framebuffer device
which FreeBSD doesn't have.
Best Wishes,
Chris Travers
Metatron Technology Consulting
-Original
://www.metatrontech.com/sql-ledger-wiki/
The site will not be branded with my company information except in a
contributed by bit, and in the domain name.
Do people think that this would be helpful?
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers
) Push security enforcement back as far as possible. Let the database
server maintain its security. If it can be exploted, you are toast anyway.
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla
support, but it doesn't look like it has been maintained in a
while.
Best Wishes,
Chris Travers
Metatron Technology Consulting
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
including DoS, etc. than
IPSec is, and having a good set of security barriers is critical when
you are looking at business data. The SSL issue could be used as well,
but I don't really know what sorts of options are available on Windows
for SSL-based VPN's.
Best Wishes,
Chris Travers
Metatron
Just a little on the history of the tools might be helpful. I think
that these environments are easy to criticize by people who are not
really aware of what the tools are really good for.
PHP:
This is worth noting in the context of this thread though fairly
off-topic for the list.
PHP was
? Could this be leading to a
system hang (say when swap space is being called back into memory)?
Best Wishes,
Chris Travers
Metatron Technology Consulting
begin:vcard
fn:Chris Travers
n:Travers;Chris
email;internet:[EMAIL PROTECTED]
x-mozilla-html:FALSE
version:2.1
end:vcard
than a set of
supported technologies. PostgreSQL handles OLAP *much* better than
MySQL which doesn't even support views
If you can tell us more about what you need, maybe we can help.
Best Wishes,
Chris Travers
Metatron Technology Consulting
Jason Monserrate wrote:
I'm a student currently
This has been recently covered in a discussion both on this list and on
Hackers. It is not easy to do, apparently, but it is on the radar.
Check the archives.
Best Wishes,
Chris Travers
On Tuesday 02 March 2004 09:53, you wrote:
Are there any plans for PostGreSQL to support something like
/iCalendar)?
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
, be nice to avoid
worrying about SMTP and IMAP servers as well, though.
One thing I noticed about DBMAIL was that it didn't seem to have many docs
on their site. Maybe I will have to download it and play with it though.
See how easy it would be to extend.
Best Wishes,
Chris Travers
before considering it infinite.
Best Wishes,
Chris Travers
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Eric B.Ridge [EMAIL PROTECTED]
Cc: Chris Travers [EMAIL PROTECTED]; Jan Wieck
[EMAIL PROTECTED]; NTPT [EMAIL PROTECTED]; Mike Mascari
[EMAIL PROTECTED]; PostgreSQL-general
but this other server got the support last week.
So we only need one subscription. Again, RHEL's licenses are not
licenses but rather service contracts.
Best Wishes,
Chris Travers
IANAL, but I have checked with them in the past over this issue.
- Original Message -
From: Bruce Momjian
vs. SCO, and SCO vs. Novell) are worth
following, but I am not worried yet.
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
.
The list could also serve as a place for consultants to go if they want
competitive information relating to other products.
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
.sp_log_error(r_return_cd,r_return_type,r_return_msg);
END;
Ok. I understand. This is extremely useful. I agree that this should be
done. Is it on the ToDo?
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 9: the planner will ignore your
the operation/transaction rather than truncate your
data in a NUMERIC column.
So what is the alternative? I am working on some documentation but my work
is slowed by my laptop being in the shop. Perhaps we could have a technical
education category in Techdocs?
Best Wishes,
Chris Travers
using MD5 to hide the details of the MAC and
IPV4 address from the outside world, and it is not strictly necessary for
the purposes of this discussion.
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 9: the planner will ignore your desire
.
2: Have multiple accounts for different roles and store these in the LDAP
user profiles. This creates a large number of headaches (are the role
fields properly secured, for example).
3: Finally you could have a user profiles table which contained the allowed
accounts to use.
Best Wishes,
Chris
the pending commit become
'committed' when transaction xid is commited. Again this is just off the
top of my head.
Also an 2PC framework if added into the protocol would allow for true nested
transactions via DBLink.
Best Wishes,
Chris Travers
---(end of broadcast
this is an issue, I usually create
functions to do this so that my information does not get out of sync.
However, I can imagine this being a concern, security wise.
Best Wishes,
Chris Travers
---(end of broadcast)---
TIP 9: the planner will ignore your
Wishes,
Chris Travers
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
401 - 500 of 552 matches
Mail list logo