Hi all,
I need a tool which allows me to do a task before every SELECT on a
table. Specifically,the behavior I would get with a BEFORE SELECT
trigger.
Please advice me on this.
Regards,
Atri
--
Regards,
Atri
l'apprenant
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
I get Godaddy's page saying it's free
--- ---
Eduardo Morras emorr...@yahoo.es
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, Apr 18, 2013 at 10:31 AM, Eduardo Morras emorr...@yahoo.es wrote:
I get Godaddy's page saying it's free
Really?
Whois shows it expires Oct 21 - and surely it will be renewed by then.
and godaddy says it's registered (though no details).
Any chance you just spelled it wrong?
--
On Thu, Apr 18, 2013 at 6:33 PM, Magnus Hagander mag...@hagander.net wrote:
On Thu, Apr 18, 2013 at 10:31 AM, Eduardo Morras emorr...@yahoo.es wrote:
I get Godaddy's page saying it's free
Really?
Whois shows it expires Oct 21 - and surely it will be renewed by then.
and godaddy says it's
On Thu, Apr 18, 2013 at 10:37 AM, Eduardo Morras emorr...@yahoo.es wrote:
On Thu, 18 Apr 2013 10:33:20 +0200
Magnus Hagander mag...@hagander.net wrote:
On Thu, Apr 18, 2013 at 10:31 AM, Eduardo Morras emorr...@yahoo.es wrote:
I get Godaddy's page saying it's free
Really?
Whois shows
On Thu, 18 Apr 2013 18:40:40 +1000
Chris Angelico ros...@gmail.com wrote:
On Thu, Apr 18, 2013 at 6:33 PM, Magnus Hagander mag...@hagander.net wrote:
On Thu, Apr 18, 2013 at 10:31 AM, Eduardo Morras emorr...@yahoo.es wrote:
I get Godaddy's page saying it's free
Really?
Whois
On Thu, Apr 18, 2013 at 8:32 PM, Eduardo Morrás emorr...@yahoo.es wrote:
On Thu, 18 Apr 2013 18:40:40 +1000
Chris Angelico ros...@gmail.com wrote:
Works for me. Do a name lookup - what IP address do you get? I get:
postgresql.org. 17973 IN A 217.196.149.50
On Thu, 18 Apr 2013 20:35:37 +1000
Chris Angelico ros...@gmail.com wrote:
That one's clearly fine. What about www.postgresql.org? It's possible
you have a poisoned cache for just that one record.
ChrisA
I have clean all (dns, web cache, etc) and get:
camibar% nslookup www.postgresql.org
Eduardo Morras wrote:
In 87.238.57.232 (Sweeden) 98.129.198.126(San Antonio,TX) and
217.196.149.50(Saltzburg) i get lighttpd default page.
Perhaps a miss configuration on my ISPs dns.
These IP addresses look fine, but it's not unexpected that using them
directly in the browser's
Hi Atri
Maybe you could think different and, instead of do a before select trigger,
you can:
- create a store procedure with result is a recordset
- create a view
If you can't... could you please explain us a bit more about the requirements
about this before action?
Good luck
Regards
El
On Thu, Apr 18, 2013 at 5:35 PM, Alfonso Afonso aafon...@gmail.com wrote:
Hi Atri
Maybe you could think different and, instead of do a before select trigger,
you can:
- create a store procedure with result is a recordset
- create a view
If you can't... could you please explain us a bit
On 04/18/2013 05:12 AM, Atri Sharma wrote:
On Thu, Apr 18, 2013 at 5:35 PM, Alfonso Afonso aafon...@gmail.com wrote:
Hi Atri
Maybe you could think different and, instead of do a before select trigger,
you can:
- create a store procedure with result is a recordset
- create a view
If you
Hi John,
On 17 Apr 2013, at 11:30 AM, John R Pierce wrote:
on AIX, I build mine to run in /opt/$MYGROUP/pgsql/9.2 and I just tar it up
and distribute it as a tarball to my operations people. I'd previously asked
them if they wanted it as a system package, and their response was 'why
How about a RULE:
http://www.postgresql.org/docs/9.2/interactive/sql-createrule.html
Rules can be tricky, so I would at least skim through:
http://www.postgresql.org/docs/9.2/interactive/rules.html
Thanks.
It looks like that it is another way to create a view, which is
probably not I
On 04/18/2013 07:02 AM, Atri Sharma wrote:
How about a RULE:
http://www.postgresql.org/docs/9.2/interactive/sql-createrule.html
Rules can be tricky, so I would at least skim through:
http://www.postgresql.org/docs/9.2/interactive/rules.html
Thanks.
It looks like that it is another way to
So what would you run the SELECT against, another view or table?
No, what I meant was:
SELECT on main table: fires a rule which updates a view V1
Now, essentially, view V1 has the data I was trying to acquire
originally through BEFORE INSERT trigger.
When I need the data, I can query view
On 04/18/2013 07:19 AM, Atri Sharma wrote:
So what would you run the SELECT against, another view or table?
No, what I meant was:
SELECT on main table: fires a rule which updates a view V1
Now, essentially, view V1 has the data I was trying to acquire
originally through BEFORE INSERT
On Thu, Apr 18, 2013 at 11:02 AM, Atri Sharma atri.j...@gmail.com wrote:
[...]
One way I was thinking of was creating an updatable view, which is
initialized to NULL. As SELECT queries take place, I can update the
view to include the new rows.
Why you just create your track function and a
Why you just create your track function and a view to call it?
Example:
BEGIN;
CREATE TABLE foo (id SERIAL PRIMARY KEY, data TEXT);
CREATE TABLE foo_track(tracktime TIMESTAMP DEFAULT now(), foo_row foo);
INSERT INTO foo (data) SELECT 'Some Data'||id FROM generate_series(1,10) AS
id;
Hi,
I am using Postgres DB with stand by database, configured with streaming in
synchronized mode (each commit on primary DB waits for commit on secondary DB).
Sometimes we suffer from network issues and as consequences, secondary machine
is not available.
In these situations, our application
Hi
Sincerely, if you are missing tcp packets you first should recheck the
environment because this issue is not acceptable in any cases, but less if we
are talking about HA databases.
If you are cofiguring this with remote machines or similar, try to use async
and pgwall recovery system.
If
Not really sure of your exact situation, if your network is really flaky
you really need to fix that and if your trying to do streaming over a
WAN, you might be better off doing log shipping instead.
But what we do here with one live and one hot-standby via streaming is
synchronous_commit =
Hello list,
I received the following error while backing up my database:
pg_dump: Dumping the contents of table
summary_show_unique_personas_2012_10_15 failed: PQgetCopyData() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY
On 04/18/2013 01:08 PM, Eduardo Morras wrote:
On Thu, 18 Apr 2013 20:35:37 +1000
Chris Angelico ros...@gmail.com wrote:
That one's clearly fine. What about www.postgresql.org? It's possible
you have a poisoned cache for just that one record.
ChrisA
I have clean all (dns, web cache, etc)
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes:
I received the following error while backing up my database:
pg_dump: Dumping the contents of table
summary_show_unique_personas_2012_10_15 failed: PQgetCopyData() failed.
pg_dump: Error message from server: pg_dump: The
I'd say you either have overloaded application (try increasing timeout),
too small pool (increase pool) or connection leaks (find and fix).
18 квіт. 2013 23:45, itishree sukla itishree.su...@gmail.com напис.
Dear All,
Can any one please help me to fix this issue, i am getting this error from
Le 2013-04-18 à 16:02, Tom Lane a écrit :
=?iso-8859-1?Q?Fran=E7ois_Beausoleil?= franc...@teksol.info writes:
I received the following error while backing up my database:
pg_dump: Dumping the contents of table
summary_show_unique_personas_2012_10_15 failed: PQgetCopyData() failed.
Hello,
I tried the following scenario on PostgreSQL 9.4.2 on Linux:
1) Connect to a remote postgres database and run a long running query
e.g. psql -h vm5 -p 57001 warehouse -c 'select x.a from
generate_series(1, 1) as x(a);'
2) Suspend the client process by pressing CTRL-Z
3) In
28 matches
Mail list logo