Hi all,
What is the best way to disallow updates on a column of a table, or even
on a whole table itself?
I can write a BEFORE UPDATE trigger which compares old.column_name(s) to
new.column_name(s) and raise an exception if these values are different.
Are there better ways?
Certain propert
Quoting Owen Hartnett <[EMAIL PROTECTED]>:
If my perusal of the sql generated by pg_dump is correct, then it
doesn't appear that it's wrapped in a transaction, and thus might be
able to only complete a partial restore?
Or does
psql myDatabase
Try to use pg_restore with the following opti
Hi all,
Is the instruction 'ALTER TABLE x ENABLE/DISABLE TRIGGER y' part of the
current transaction? That is, say that there are two ongoing
transactions, T1 and T2. Is the trigger y still enabled in transaction
T2 if it's disabled in transaction T1?
Thanks in advance. Kind regards,
Peter
Hi all,
I have a problem with foreign keys and data-only (no schema) backup. I
have a simple table node (pseudo-SQL):
node
(
integer node_idNOT NULLPRIMARY KEY;
integer parent_node_id NULL;
)
It contains the following two entries:
node(1, NULL) the rood
node(2,
Thanks. I thought it was a bit counter-intuitive to have a BIGSERIAL
while I will only have a few thousands of entries, which are updated (by
DELETE and INSERT) constantly.
Thanks Scott,
Peter
Scott Marlowe schreef:
On Thu, Aug 21, 2008 at 1:08 PM, Peter Billen <[EMAIL PROTECTED]>
advance,
Peter
ries van Twisk schreef:
On Aug 21, 2008, at 2:23 PM, Peter Billen wrote:
Oops, my example was a bit incorrectly edited.
I wanted to say that the range of a serial datatype goes from 1 to 5
(incluse) and I insert five entries (not 10).
Peter
Peter Billen schreef:
Hi all,
I would
Oops, my example was a bit incorrectly edited.
I wanted to say that the range of a serial datatype goes from 1 to 5
(incluse) and I insert five entries (not 10).
Peter
Peter Billen schreef:
Hi all,
I would like to ask a question about the serial datatype. Say I have a
field of type serial
Hi all,
I would like to ask a question about the serial datatype. Say I have a
field of type serial, and say for the sake of example that the range of
a serial goes from 1 to 5 (inclusive). I insert 10 entries into the
table, so the table is 'full':
INSERT INTO my_table (my_serial) VALUES (D
Dear PostgreSQL users,
I would like to ask a question about outputting data as XML. Say I have two
tables:
team(integer id, text name);
player_of_team(integer id, integer team_id, text name); (team_id is FK to
team.id)
I would like to query both tables to get following example XML output: