same reasons as Tom), but with the addition of the mention of
the server - "... read from or written to a file directly by the
server".
--
Peter Headland
Architect
Actuate Corporation
-Original Message-
From: Bruce Momjian [mailto:br...@momjian.us]
Sent: Monday, February 22
ow that I have grasped the behavior, I'm more than happy to edit the COPY doc
page, if people think that would be helpful/worthwhile.
--
Peter Headland
Architect
Actuate Corporation
-Original Message-
From: Adrian Klaver [mailto:akla...@comcast.net]
Sent: Thursday, September 10,
syntax extension to COPY (which I think is the most desirable
implementation), this would have no adverse effect on any other
capability. It also seems sufficiently isolated from sensitive/complex
areas of the code that it might make a suitable first project for
someone who is interested in becoming a c
yntax) to specify
encoding explicitly and handle UTF lead bytes - would that be of
interest?
--
Peter Headland
Architect
Actuate Corporation
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, September 10, 2009 10:38
To: Peter Headland
Cc: pgsql-general@postgresql
enhancements planned in this area, I might be interested in improving
this command to allow specifying the encoding and to have it do obvious
stuff like recognize UTF lead bytes automatically. At the very least,
the documentation needs some work to explain these subtleties.
--
Peter Headl
The documentation of the COPY command does not state what character
set(s) are recognized or written. I need to import and export UTF-8
data; how can I do that?
--
Peter Headland
Architect
Actuate Corporation
ctids into an array variable that I then
use in the DELETE (actually an UPDATE in my case, but that's beside the
point). I know this question would be better on new users, but since we
already have all the context established, I'd be grateful to know how to
get the ctids into an arra
from del where ctid = any(array(select ctid from del limit 10))
If so, am I correct to think that adding FOR UPDATE to create the version below
would eliminate the hazard?
delete from del where ctid = any(array(select ctid from del limit 10 for
update))
--
Peter Headland
Architect
Ac
If I do the following in a pl/pgsql function, will an update lock be
held until the end of the transaction?
PERFORM c FROM t FOR UPDATE;
--
Peter Headland
Architect
Actuate Corporation
