Am 19.Dez. 2013 um 09:41 schrieb Andreas Kretschmer :
> hello all,
>
> don't ask why, but a customer created tables with foreign key constraints but
> with inconsistent data.
>
> Because of this he disabled all triggers (alter table foo disable trigger
> all).
> So far, so bad ...
> (he can't
Am 13.09.2013 um 18:47 schrieb David Noel :
>> ...have you used the "for update" clause in your select statements?
>
> Hi Ralf, thanks for the reply. I was unaware of the "for update"
> construct. Thank you!
>
>> My understanding is, that "for update" does what you need.
>
[...]
> My question
Hi David,
have you used the "for update" clause in your select statements? With this
clause "select" locks the selected row(s) in a table for modifications and
other "select for updates".
My understanding is, that "for update" does what you need. You can execute your
select and update statement
Hi Jürgen,
am 31.10.2012 um 15:24 schrieb Jürgen Fuchsberger
:
> The replica is backed up once a week using rsync, a full backup runs about 10
> hours, so I also keep at least 24h of WAL files to make sure I have a
> consistent backup.
>
> The backup process also runs fine without errors, on
Am 08.10.2012 um 02:08 schrieb Yvon Thoraval :
> 2012/10/7 Scott Marlowe
> 'd have posted more, but
>
> 1: I know just enough about MacOS to be dangerous and
> 2: MacOS is known for changing how shared memory works from one minor
> patch to another so..
> 3: Any page on making work will be depe
Hello,
am 01.06.2012 um 17:28 schrieb Bryan Montgomery:
> So we've been reviewing our processes and working on improving them. One area
> we've been lacking is a procedure to version control our database functions,
> table changes, static data etc.
we use a very basic system since a few years,
rates a proper xml version of the query results.
Ralf
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Ralf Schuchardt
> Sent: 23 July 2010 01:37 PM
> To: Machiel Richards
> Cc: pgsql-general@postgresql.org
> Subject: R
Hi,
Am 23.07.2010 um 10:32 schrieb Machiel Richards:
>As I am fairly new to postgresql I am trying to find some more info
> regarding options to dump specific data to files.
> However, even though I can get the sql query,etc... how will I use this
> to dump the data into the rele
run a dump-all without problems and there are rows created after the
death the postmaster.
Thanks.
Ralf Schuchardt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
could include the old values of columns which could change in the
where clause of your update statement. For example:
UPDATE mytable SET col1 = 'newValue'
WHERE col1 = 'oldValue1' AND col2 = 'oldValue2';
This way, whenever a row has changed (col1 or col2 have di
On Sun, 16 Jan 2005 01:13:58 -0500
Ken Tozier <[EMAIL PROTECTED]> wrote:
> Anybody using PostgreSQL with WebObjects on OS X 10.3.x? I'm having
> trouble setting it up and could use some pointers from anyone who has
> successfully gotten the two working together.
I've done this a numerous times.
11 matches
Mail list logo