Hi,
short summary of the problem follows :)
I'm writing an on delete rule for a view and I need to set the status
message (DELETE XXX) for
number of deleted tuples. Is it possible?
A brief, working use case follows:
I have a view restricting the access to a table, as the following:
create
On Fri, 2008-01-25 at 11:34 +1100, Phillip Smith wrote:
We have a center in Europe who has just started to use PostgreSQL and was
asking me if there are any Symantec product or other products that backup
this type of database.
It doesn't appear to.
The design of the PITR system allows a
is it posible to transfer data from postgres of one computer to the postgres in
another computer. In SQL server this is easily done by the export utility of
the sql server.
-
Never miss a thing. Make Yahoo your homepage.
Check out the docs for pg_dump utility.
http://www.postgresql.org/docs/8.3/static/app-pgdump.html
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of User Map
Sent: Friday, January 25, 2008 10:18 AM
To: pgsql
Subject: [GENERAL] exporting postgre data
is it posible to
Wes [EMAIL PROTECTED] writes:
I guess I should also turn off fsync for the duration.
It shouldn't make a big difference. fsync only happens at the end of a
transaction or at a checkpoint.
Since you're concerned with very long operations the slowdown at the end of
the transaction won't make a
Tim Rupp [EMAIL PROTECTED] writes:
where start_time = '2008-01-01'::date AND start_time '2008-01-10'::date
should give the same rows as
where start_time = '2008-01-01'::date AND end_time = '2008-01-09'::date
I think you'll need to do the same thing to the constraints as well. You'll
Bill,
pgadmin3 provides the same: just dig down to the table, use the backup
link and give the options. It also calls pg_dump just with the right
parameters, you can copy that command for a .cmd for professional
automatic backup.
Best wishes,
Harald
MSSQL has a fancy GUI wizard.
It
Tom Lane wrote:
Steve Clark [EMAIL PROTECTED] writes:
explain shows:
Aggregate (cost=4712921585.30..4712921585.31 rows=1 width=0)
- Seq Scan on t_event_ack_log a (cost=103170.29..4712920878.60
rows=282677 width=0)
Filter: (NOT (subplan))
SubPlan
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
Talk submissions close on February 3rd and thus far we have had over
two dozen submissions and we want more. This is your chance to get that
talk that you keep meaning to give accepted! Some of the current talk
topics include:
* PostgreSQL
On Jan 24, 2008 11:02 PM, brian [EMAIL PROTECTED] wrote:
The client for a web application I'm working on wants certain URLs to
contain the full names of members (SEO-friendly links). Scripts would
search on, say, a member directory entry based on the name of the
member, rather than the row ID.
Ok, that did it. Thank you for the help.
Tomasz Ostrowski wrote:
On Wed, 23 Jan 2008, Tom Hart wrote:
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence
for encoding UTF8: 0xc52f
Try editing your dump-file and change the line which reads SET
client_encoding =
On 25/01/2008 19:54, Geoffrey wrote:
Question is, why does the avlds table not have an entry in the Object
descriptions?
According to \? in psql, \dd shows the comment on the tableso I
suppose if there's no comment, then \dd won't show one.
Comments are created by executing
We've stumbled upon an issue that we don't understand. I'm assuming
that any given table should contain 'Object Descriptions.' For example,
we have two tables as follows:
mwv=# \dd carr;
Object descriptions
Schema | Name | Object | Description
Daniel Verite wrote:
Steve Clark wrote:
any way i have 2 table - A and B.
each table has a key field and if a row is in B it should have a
corresponding row in A - but theres
the problem it doesn't for all the rows in B.
So I want to do something like
delete from B where key not in
Steve Clark wrote:
any way i have 2 table - A and B.
each table has a key field and if a row is in B it should have a
corresponding row in A - but theres
the problem it doesn't for all the rows in B.
So I want to do something like
delete from B where key not in (select key from A
On Fri, 25 Jan 2008 10:02:41 -0500
Bill Moran [EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of User
Map Sent: Friday, January 25, 2008 10:18 AM
To: pgsql
Subject: [GENERAL] exporting postgre data
is it posible to transfer data from
Hello List,
this is a noobie question:
I have had to take over an existing system - it was supposed to have
some contraints that
prevented dangling references - but...
any way i have 2 table - A and B.
each table has a key field and if a row is in B it should have a
corresponding row in A -
On 25/01/2008 16:51, johnf wrote:
The issue I have with pgAdmin3 and backing up a table is with the restore.
The associated sequences are not restored. Granted that might be a different
problem. But from a users perspective I see it as a major problem.
Oh? Works fine for me, on PG 8.2.5 -
On 1/25/08 5:40 AM, Gregory Stark [EMAIL PROTECTED] wrote:
It shouldn't make a big difference. fsync only happens at the end of a
transaction or at a checkpoint.
Since you're concerned with very long operations the slowdown at the end of
the transaction won't make a big difference.
Ok, I
On Friday 25 January 2008 02:56:12 am Gevik Babakhani wrote:
Check out the docs for pg_dump utility.
http://www.postgresql.org/docs/8.3/static/app-pgdump.html
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of User Map
Sent: Friday, January 25, 2008 10:18 AM
To: pgsql
JohnF,
But how do you backup only a single table or transfer only a signle table.
please use pg_dump. You can find excellent documentation at
http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html
please pay special attention to the --table option.
Best wishes,
Harald
--
GHUM
On Friday 25 January 2008 07:21:34 am Harald Armin Massa wrote:
Bill,
pgadmin3 provides the same: just dig down to the table, use the backup
link and give the options. It also calls pg_dump just with the right
parameters, you can copy that command for a .cmd for professional
automatic
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of User Map
Sent: Friday, January 25, 2008 10:18 AM
To: pgsql
Subject: [GENERAL] exporting postgre data
is it posible to transfer data from postgres of one computer to the
postgres in another computer. In SQL server this
Steve Clark [EMAIL PROTECTED] writes:
explain shows:
Aggregate (cost=4712921585.30..4712921585.31 rows=1 width=0)
- Seq Scan on t_event_ack_log a (cost=103170.29..4712920878.60
rows=282677 width=0)
Filter: (NOT (subplan))
SubPlan
- Materialize
Hi Marko,
Actually I have it,
However I was thinking the problem in a wrong way. In my particular case,
the fact of the private key in memory is a good reason for discard the
electronic signature, I mean, in order to have a real protection against the
data modification I need a TSA (time
Tom Lane wrote:
Steve Clark [EMAIL PROTECTED] writes:
Tom Lane wrote:
Also, whatever is the ORDER BY for?
without the order by it wants to do a seq scan of t_unit_event_log.
see below:
explain select count(*) from t_event_ack_log where event_log_no not
in (select event_log_no from
http://people.planetpostgresql.org/xzilla/index.php?/archives/149-out-parameter-sql-plpgsql-examples.html#extended
Is there any difference in terms of performance and returning rows a
bit at a time between myuser2 and myuser3?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
It seems that I recall there is a way to display the actual select
statement that is executed when you execute the \d command.
Anyone?
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin
On Jan 25, 2008 1:34 PM, Geoffrey [EMAIL PROTECTED] wrote:
It seems that I recall there is a way to display the actual select
statement that is executed when you execute the \d command.
psql --help says:
-E display queries that internal commands generate
psql -E
Steve Clark [EMAIL PROTECTED] writes:
Tom Lane wrote:
Also, whatever is the ORDER BY for?
without the order by it wants to do a seq scan of t_unit_event_log.
see below:
explain select count(*) from t_event_ack_log where event_log_no not
in (select event_log_no from t_unit_event_log);
30 matches
Mail list logo