Do keep in mind that querying across databases generally garners really poor
performance, and can bring
your application to its knees with astonishing speed.
From: pgsql-admin-ow...@postgresql.org [pgsql-admin-ow...@postgresql.org] on
behalf of Albe
Bhanu Murthy wrote:
> Using Oracle Heterogeneous Services (Oracle HS) I have configured/created a
> DB link from Postgres 9.3
> database into Oracle 11gR3 database (with postgres DB user credentials).
>
> SQL> create public database link pg_link connect to "postgres" identified by
> "blahblah"
Dev Kumkar wrote:
> I am using postgres 9.2 and when executing function dblink facing a fatal
> error while trying to
> execute dblink_connect as follows:
>
> SELECT * FROM dblink_connect('host=127.0.0.1 port=5432 dbname=postgres
> password=test')
>
> ERROR: could not establish connecti
On Tue, Mar 6, 2012 at 7:22 AM, Piyush Lenka wrote:
> Hi,
>
> I m trying to take backup of data of a particular table using pg_dump.
> I used double quotes for table name but output is :
> pg_dump : no tables were found.
>
> Command used :
> -h localhost -p 5432 -U postgres -W -F p -a -t '"TestTa
Viktor Bojovi* wrote:
> i don't know why it doesn't use index scan.
Because it thinks your query will return 81226 rows. We need more
information to make many suggestions beyond "make sure the table has
been analyzed".
http://wiki.postgresql.org/wiki/SlowQueryQuestions
Also, it's not consi
use hstore functions on it
> (http://www.postgresql.org/docs/9.0/static/hstore.html)
>
> The other one uses arrays to store column names, old values, new
> values, still more parseable
>
> --
> Jaime Casanova www.2ndQuadrant.com
> Professional PostgreSQL: Soporte 24x7 y capacitación
>
> --
> Sent via pgsql-admin mailing list (pgsql-ad...@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
As I read it, it doesn't matter what the value was originally, it's
what's in postgresql.conf _now_ that matters.
This is a resource allocation: I suspect there's no limit on how much of
your (often precious) memory you wish to set aside for this.
On 04/13/2010 07:01 AM, Satish Burnwal (sburnwal)
show shared_buffers;
or
show all; (for all parameters)
You can also check for postgresql.conf file in your database folder.
-Original Message-
From: Satish Burnwal (sburnwal)
To: pgsql-ad...@postgresql.org
Subject: [ADMIN] Getting the initdb parameter values
Date: Tue, 13 Apr 2010 17
What you have mentioned is already there in postgresql.conf file. I want to
know whats the max value allowed ? Doc seems to be saying that max allowed
value is determined during initdb. How to get this max allowed value ?
On Fri, 2010-03-05 at 09:20 +0100, Iñigo Martinez Lasala wrote:
> For example, if you use functions or sentences that make use of
> timestamp, random, etc it won't be possible to use pg_pool since each
> node will have a different value.
> If not, it could probably work for you.
FWIW, timestamps
On Thu, Aug 21, 2008 at 3:05 AM, Shashwat_Nigam
<[EMAIL PROTECTED]> wrote:
> Dear Vishal
>
> Thanks for the help but by doing this an error is generated at the time when
> the user is trying to log in with the following message:
>
> "
>
> Access to database denied
>
> The server doesn't grant acce
On 10/4/07, yogesh <[EMAIL PROTECTED]> wrote:
> Hello Friends,
>
> I have a Problem in Accessing Arrays in the Postgres.
> The Description of my problem is given
> here:---
> I have two array of numeric types. One That stores the IDs and Other
> Store their va
What's in your server?
Osmar Della Paschoa Jr
Software Engineer
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get
Hi skarthi,
On Wed, 2007-04-11 at 16:29 -0700, Karthikeyan Sundaram wrote:
> The reason why I am asking is, we are building an interface layer
> where all our users will have a view. They shouldn't know anything
> about how and where the data is stored in the table. They can be seen
> only by
Regards
skarthi> Date: Wed, 11 Apr 2007 19:00:23 -0400> From: [EMAIL PROTECTED]>
Subject: Re: [ADMIN] [SQL] Urgent help in bit_string data type> To: [EMAIL
PROTECTED]> CC: pgsql-admin@postgresql.org; pgsql-sql@postgresql.org> > Hi
skarthi,> > On Wed, 2007-04-11 at 15
Hi skarthi,
On Wed, 2007-04-11 at 15:01 -0700, Karthikeyan Sundaram wrote:
> create table test_a (b bit(3));
>
> create view test_vw (b1, b2, b3)
> as select
> to_number(substring(b,1,1)::int,'9') as b1,
> to_number(substring(b,2,1)::int,'9') as b2,
> to_number(substring(b,3,1)::int,'9') as b3 f
; Date: Wed, 11 Apr 2007 17:44:01 -0400> From: [EMAIL PROTECTED]> Subject: Re:
> [ADMIN] [SQL] Urgent help in bit_string data type> To: [EMAIL PROTECTED]> CC:
> pgsql-admin@postgresql.org; pgsql-sql@postgresql.org> > Hi skarthi,> > On
> Wed, 2007-04-11 at 13:30 -
On Sun, 8 Apr 2007, Karthikeyan Sundaram wrote:
>
> Hi team,
>
> I have a requirement like this.
> create table valid_lovs (code_id int not null,lov_value int not null
> ,description varchar(256),status bit(1) not null default '1',constraint
> lov_pk primary key (code_id,lov_value));
> I n
Karthikeyan Sundaram <[EMAIL PROTECTED]> writes:
> I am getting an error message
> ERROR: function substr(bit, integer, integer) does not existHINT: No func=
> tion matches the given name and argument types. You may need to add explici=
> t type casts.CONTEXT: SQL function "week_func"
I think
On Tue, Mar 20, 2007 at 09:06:25PM +0100, Claus Guttesen wrote:
> >DBD::Pg::st execute failed: ERROR: invalid byte sequence for encoding
> >"UTF8": 0x92
> >[for Statement "INSERT INTO longdescs (bug_id, who, bug_when, thetext,
> >isprivate)
>
> Try to modify client_encoding in postgresql.conf to
(3,4);
create or replace rule test_rule_upd as on update to test_vw
do instead
update test_tbl set a=new.a, b=new.b, c=new.c where a=new.a;
update test_vw set c='good' where a=1;
select * from test_vw;
regards
skarthi
From: "Karthikeyan Sundaram" <[EMAIL
"hubert depesz lubaczewski" <[EMAIL PROTECTED]> writes:
> On 3/19/07, Tom Lane <[EMAIL PROTECTED]> wrote:
>>> ERROR: WITH CHECK OPTION is not implemented
>> It seems perfectly clear to me ...
> errors is clear, but maybe the information about check option should
> be removed from docs to 8.2?
The
Ezequias R. da Rocha wrote:
Ok I will use only on error ok ?
-l 0
:)
In the normal case, yes, that is what I'd use (0 is the default in fact,
so you can omit the option altogether).
Regard,s Dave
---(end of broadcast)---
TIP 2: Don't 'kill
Ok I will use only on error ok ?
-l 0
:)
Thank you
Dave Page escreveu:
Ezequias Rodrigues da Rocha wrote:
Hi list,
I would like to know if I set the debug mode to 2 (-l 2) in the
pgAgent connection string it could spend much cpu processing.
I have other things running in the server and
"Karthikeyan Sundaram" <[EMAIL PROTECTED]> writes:
>Thanks for your reply. No, I recently installed (fresh installation)
> from scratch.
Well, your pg_dump seems to be finding an older version of libpq.so from
somewhere. Check for a pre-existing postgresql package.
Hi Joshua,
Thanks for your reply. No, I recently installed (fresh installation)
from scratch.
Regards
skarthi
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: Karthikeyan Sundaram <[EMAIL PROTECTED]>
CC: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org
Subjec
Ezequias Rodrigues da Rocha wrote:
This is delphi. I don't intent you understand but the sql actions are quite
simple (I am reading a list of numbers).
Well, let's see - the last Pascal I did was in 1986 I think...
If not dm.database1.InTransaction then
dm.database1.StartTra
Ok you teach me. Thank you and sorry. :(
I just want to know why is it occuring. I am pretty sad.
Ezequias
2007/2/12, Reinoud van Leeuwen <[EMAIL PROTECTED]>:
On Mon, Feb 12, 2007 at 03:08:27PM -0300, Ezequias Rodrigues da Rocha
wrote:
> I mean really deadlock. Other transactions can't access
On Mon, Feb 12, 2007 at 03:08:27PM -0300, Ezequias Rodrigues da Rocha wrote:
> I mean really deadlock. Other transactions can't access the database until
> the main transaction is complete.
What you describe sounds like a blocking lock: one transaction uses a
resource and another has to wait unt
This is delphi. I don't intent you understand but the sql actions are quite
simple (I am reading a list of numbers).
If not dm.database1.InTransaction then
dm.database1.StartTransaction;
For i:= 0 to memo1.Lines.Count - 1 do
Begin
// Catching ID
On Mon, 2007-02-12 at 12:08, Ezequias Rodrigues da Rocha wrote:
> I mean really deadlock. Other transactions can't access the database
> until the main transaction is complete. A question:
>
> PostgreSQL doesn't permit multiple transactions concurrently ?
Again, that's not a deadlock. A deadlock
Ezequias Rodrigues da Rocha wrote:
2007/2/12, Richard Huxton :
Ezequias Rodrigues da Rocha wrote:
> I mean really deadlock. Other transactions can't access the database
until
> the main transaction is complete. A question:
>
> PostgreSQL doesn't permit multiple transactions concurrently ?
PG h
2007/2/12, Richard Huxton :
Ezequias Rodrigues da Rocha wrote:
> I mean really deadlock. Other transactions can't access the database
until
> the main transaction is complete. A question:
>
> PostgreSQL doesn't permit multiple transactions concurrently ?
PG has quite good concurrency behaviour.
Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> schrieb:
> I mean really deadlock. Other transactions can't access the database until the
> main transaction is complete. A question:
That's not true.
>
> PostgreSQL doesn't permit multiple transactions concurrently ?
Why not? Show us a complete
Ezequias Rodrigues da Rocha wrote:
I mean really deadlock. Other transactions can't access the database until
the main transaction is complete. A question:
PostgreSQL doesn't permit multiple transactions concurrently ?
PG has quite good concurrency behaviour. And "can't access the database"
i
I mean really deadlock. Other transactions can't access the database until
the main transaction is complete. A question:
PostgreSQL doesn't permit multiple transactions concurrently ?
Ezequias
2007/2/12, Scott Marlowe <[EMAIL PROTECTED]>:
On Mon, 2007-02-12 at 11:43, Ezequias Rodrigues da Roc
On Mon, 2007-02-12 at 11:43, Ezequias Rodrigues da Rocha wrote:
> Hi list,
>
> I am curious becouse I am seen my postgresql locking the transactions
> when i load a huge (in some case not to huge) numbers of records
> 70,000 records.
>
> Could someone help me with it ?
Are sure that what you're
"Karthikeyan Sundaram" <[EMAIL PROTECTED]> writes:
> podcast=> \d channel
> psql: symbol lookup error: psql: undefined symbol: PQescapeStringConn
It looks like your psql has linked to an obsolete version of libpq.so,
though it's not real clear why the thing would have started at all if
that were t
Moving to -general (and please start a new thread instead of hijacking
an existing one).
On Thu, Nov 02, 2006 at 01:14:22PM -0500, louis gonzales wrote:
> Hello all,
> Is there an existing mechanism is postgresql that can automatically
> increment/decrement on a daily basis w/out user interaction
> I kown I can use pg_dump to perform that "back up" but I wanted to
> test performences.
pg_dump does the same.. if you same custom it makes binary (WITH BINARY)
but with compression.
Performance?
1. TOP: inserte into select
2. TOP: copy / pg_restore with uncompressed binary
3. TOP: copy /
On Tue, Aug 30, 2005 at 01:59:04PM -0400, Postgres Admin wrote:
> ERROR: set-valued function called in context that cannot accept a set
> CONTEXT: PL/pgSQL function "article_sample" line 10 at return next
You don't show what you did to get this error, but I'd guess yo
I have data in one table called articles and I would like to make a
function in which takes certain data from it and display the results.
Example:
CREATE TABLE articles (
article_id serial,
title varchar(200),
posted timestamp,
article_subject varchar(200),
article_body text,
allow_comments boole
On Tue, Aug 30, 2005 at 12:15:54PM -0400, Postgres Admin wrote:
>
> Can I do something like this:
It's good that you gave an example, but it would also be good to
give a summary of what you're trying to do and what trouble you're
having so people don't have to guess.
On Sun, Aug 21, 2005 at 06:35:22AM +0100, Aldor wrote:
> if you want to insert biiig data volumes try either using COPY instead
> of INSERT - it will run much much faster
And if for some reason you have to stick with inserts, group them into
transactions; it will perform much better than individu
ueryCopyEnd = "\\.\n";
pg_query($thisDBConn,$queryCopyStart);
pg_put_line($thisDBConn,implode("",$queryCopyData));
pg_put_line($thisDBConn,$queryCopyEnd);
pg_end_copy($thisDBConn);
}
be aware with the "max_stack_depth" value in postgresql.conf, ma
On Sat, Aug 20, 2005 at 01:17:55PM -0400, Postgres Admin wrote:
> I don't have any idea how to insert the type of data into PostgreSQL.
> Basically, it's encrypted data in which I would like that keep raw format.
If the data is binary then you could store it in a BYTEA column.
this guy is still polluting this list:
-- Forwarded Message --
Subject: RE: [SQL] two sums in one query
Date: Friday 08 Jul 2005 11:33 am
From: AntiSpam UOL <[EMAIL PROTECTED]>
To: lawgon <[EMAIL PROTECTED]>
http://antispam.uol.com.br";
style=
Hi,
I have the wonderful job of re-synch'ing all the schemas out there not
conforming to the master. I've looked everywhere for something that
will help doing this. I'm specifically looking for a way to do a sumcheck
or something similar on tables and/or schema as a whole to be able to
do a table
|-Original Message-
|From: Goulet, Dick [mailto:[EMAIL PROTECTED]
|Sent: Montag, 07. März 2005 16:33
|To: John DeSoi; Stef
|Cc: pgsql-ADMIN@postgresql.org; pgsql-sql@postgresql.org
|Subject: Re: [SQL] [ADMIN] Postgres schema comparison.
|
|
| My favorite for this task is WinSql available
Jim Buttafuoco mentioned :
=> I use dblink to attach to both databases and query pg_namespace, pg_class,
pg_attribute ... to get the diffs. See
=> attached as an example. look for the dblink_connect lines to specify your
database. You will need to install
=> contrib/dblink. I used this with 7
-ADMIN@postgresql.org; pgsql-sql@postgresql.org
Subject: Re: [ADMIN] Postgres schema comparison.
On Mar 7, 2005, at 4:33 AM, Stef wrote:
> I have the wonderful job of re-synch'ing all the schemas out there
not
> conforming to the master. I've looked everywhere for something that
&
tested yet with
8.0.X.
You can adjust the output to fit your needs.
Jim
-- Original Message ---
From: Stef <[EMAIL PROTECTED]>
To: Tom Lane <[EMAIL PROTECTED]>
Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org
Sent: Mon, 7 Mar 2005 17:31:55 +0200
Subject: Re:
On Mar 7, 2005, at 10:09 AM, Stef wrote:
Is it possible to somehow pass the output of : "\d [TABLE NAME]"
to this function? If not, what would return me consistent text
that will describe the columns, indexes and primary keys of a table?
I'm not sure you can use \d directly, but if you startup psql
Tom Lane mentioned :
=> > The problem I have with this, is that I have to run the command per table,
=>
=> Why?
=>
=> If the problem is varying order of table declarations, try 8.0's
=> pg_dump.
Yes, this will solve the global schema check, but I will still need to split
it into "per table" dump
Markus Schaber mentioned :
=> Some weeks ago, I posted here a script that uses psql to create split
=> dumps. Maybe you can reuse some of its logics to create per-table
=> md5sums for all tables in a database automatically.
Thanks, but I've got something very similar to this already. I almost
tho
John DeSoi mentioned :
=> Develop a function that builds a string describing the tables/schemas
=> you want to compare. Then have your function return the md5 sum of the
=> string as the result. This will give you a 32 character value you can
=> use to determine if there is a mismatch.
OK, this
Stef <[EMAIL PROTECTED]> writes:
> Markus Schaber mentioned :
> => But maybe a pg_dump --schema-only on all the databases, and then
> => manually diffing the files may already fulfil your needs.
> I've tested something similar, that seems to work ok for me for now :
> pg_dump -s -t [TABLE] [DBNAME
[EMAIL PROTECTED] mentioned :
=> Are you just synching the schemas, or do you also need to synch the data?
Schemas now, data later.
To do the data part, I'm thinking of using slony, because it seems to be able to
do pretty much everything I need from that side. But, unfortunately I can't
even st
<[EMAIL PROTECTED]> To: Stef <[EMAIL
PROTECTED]>
Sent by: cc:
pgsql-ADMIN@postgresq
Hi, Stef,
Stef schrieb:
> The problem I have with this, is that I have to run the command per table,
> and seeing that I have over 500 tables in each database, this takes quite a
> long time.
Some weeks ago, I posted here a script that uses psql to create split
dumps. Maybe you can reuse some o
Markus Schaber mentioned :
=> There are (at least) two independently developed pgdiff applications,
=> they can be found at:
=>
=> http://pgdiff.sourceforge.net/
=>
=> http://gborg.postgresql.org/project/pgdiff/projdisplay.php
Thanks a lot!
=> I did not try the first one, but the latter one wor
On Mar 7, 2005, at 4:33 AM, Stef wrote:
I have the wonderful job of re-synch'ing all the schemas out there not
conforming to the master. I've looked everywhere for something that
will help doing this. I'm specifically looking for a way to do a
sumcheck
or something similar on tables and/or schema
Tom Lane wrote:
"Dario V. Fassi" <[EMAIL PROTECTED]> writes:
SQL_ASCII is not an encoding (it's more like the absence of knowledge
about an encoding). What is the data actually stored as?
Yes you are right , the original data come from a DB2 with Code
Tom Lane wrote:
"Dario V. Fassi" <[EMAIL PROTECTED]> writes:
A simple question, we need to migrate many (>20) postgres databases from
SQL_ASCII encoding to UNICODE encoding, over a 7.3.6 server.
SQL_ASCII is not an encoding (it's more like the absence of knowledge
about
Dario V. Fassi wrote:
> Yes you are right , the original data come from a DB2 with CodePage
> IBM-850 and was inserted without complains in a Postgres 7.3.6 with
> SQL_ASCII.
If you have a program named "recode" installed you could try using that
to recode the dump file to a supported encoding.
"Dario V. Fassi" <[EMAIL PROTECTED]> writes:
>> SQL_ASCII is not an encoding (it's more like the absence of knowledge
>> about an encoding). What is the data actually stored as?
> Yes you are right , the original data come from a DB2 with CodePage
> IBM-850 and was inserted without complains i
Daniel Struck wrote:
If you decrypt the data on the database, the sysadmin can see it.
Hm, you are right. If one does decrypt the data on the database you have to sent
the password to postgresql and so a administrator of the database could easily grasb
the password.
So the only way to go, wo
Sorry, wrong question.
-Original Message-
From: Jie Liang
Sent: Wednesday, May 19, 2004 10:20 AM
To: Tom Lane
Cc: postgres-list; [EMAIL PROTECTED]
Subject: [ADMIN] rules
According to the document of rule:
CREATE RULE rulename AS ON delete TO mytablename DO
(
delete from aaa where id
Thank you, Tom.
Jie
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 12, 2004 4:06 PM
To: Jie Liang
Cc: Christian Kratzer; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [ADMIN] [SQL] \set
"Jie Liang" <[EMAIL PROTECTED]> writes:
&g
"Jie Liang" <[EMAIL PROTECTED]> writes:
> You will see AAA associate with 'whatever', it's an internal variable,
> but how could I use it in my SQL query?
regression=# \set AAA 'whatever'
regression=# select :AAA;
ERROR: column "whatever" does not exist
regression=# \set AAA '\'whatever\''
regres
> The postmaster logs to a separate log file, but at the moment
> it's impossible to tell which sql comes from which connection.
> Is there an easy way to accomplish this?
>
The PID of the connected process is prepended to every log statement.
You can make use of this to know which sql comes from
Dear Ganesan,
pgautodoc (for dot output) + dot (from graphviz.org , creates
postscript) +
epssplit ( splits the postscript into multipage so that one can create
poster size
diagrams) works well for me.
I have 45 tables in the database though.
Regds
mallah.
Chris Travers wrote:
There is a fre
If you define the field as CHAR, 1000 bytes will be consumed.
If you define the field as VARCHAR, on sufficient bytes to store the contents will be used.
Marc
--Original Message Text---
From: Ganesan Kanavathy
Date: Mon, 8 Dec 2003 20:56:06 +0800
Clean Clean DocumentEmail MicrosoftI
: Ganesan Kanavathy
[mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003
6:26 PM
To: [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [ADMIN] Field Size
Can anyone tell me, what harm would setting a field size to 1000 characters do to the size?
By
increasing the size, will the database require
On Mon, Dec 08, 2003 at 18:36:57 +0530,
Somasekhar Bangalore <[EMAIL PROTECTED]> wrote:
> There is no harm in having a field size of 1000 character provided u use the proper
> datatype. Don't user char(1000). Try using varchar(1000).
And if the 1000 limit is just a large number you picked rathe
pgAdmin is installed
on linux redhat 8.
Regards,
Ganesan
-Original Message-
From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ganesan Kanavathy
Sent: Sunday, November 02, 2003 17:03
To: [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: [ADMIN] pgAdmin
How
[EMAIL PROTECTED] a écrit :
Hey,
create or replace function sample(varchar,int) returns varchar as'
declare
data alias for $1;
size alias for $2;
begin
return substr(data,(length(data)-size)+1,length(data));
end;
' language 'plpgsql';
WARNING: pl
[EMAIL PROTECTED] writes:
> CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
> BEGIN
> RETURN $1 + 1;
> END;
> ' LANGUAGE 'plpgsql';
> The expected ouput of the above function should be 11 when we pass the 10 t=
> o it but it returns 1.
Works fine for me:
regression=# CR
On Thu, 21 Aug 2003, Anagha Joshi wrote:
> Hi all,
> I'm using PG - 7.2.4 on Solaries.
> I'm using "libpq++" library as client implementation is coded in "C++".
>
> I'm doing the following :
> 1.Making the connection to database by creating new object of
> "PgDatabase" i.e.
> data = new PgDat
On Mon, 11 Aug 2003, Jie Liang wrote:
> 1. No doc said % should escape by %%, and
> select replace('whatever%20sites','%20','%%20') won't work also.
> 2. v7.3.2 haven't resolved this problem yet, I am not sure the later version.
I seem to get the expected results on my 7.3.4 system.
--
Raymond Chui <[EMAIL PROTECTED]> writes:
> drop table whitepage;
> delete from state where state_code = 'GU';
> ERROR: Relation "whitepage" does not exist
> Why I got this error message??!!
I could not duplicate this error. What PG version are you running?
regards, to
On Wed, 13 Aug 2003, Raymond Chui wrote:
>
> Here are the simple things I did
>
> create table state (
> state_code char(2) not null,
> state varchar(15) not null,
> primary key (state_code)
> );
>
> create table whitepage (
> user_id char(8) not null,
> email varchar(50),
> tele
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 20 June 2003 01:27, Anagha Joshi wrote:
> Yes...I'm aware of that and have tried also by maintaining extra table.
> But how to to the following:
> 1.If insertion takes place, I want to return to the client the
> values (with field names o
CTED]
Sent: Thursday, June 19, 2003 7:26 PM
To: Anagha Joshi; [EMAIL PROTECTED]
Subject: Re: [ADMIN] Latest transcation
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 18 June 2003 22:16, Anagha Joshi wrote:
> Is there any way to know programatically which is the latest
> insert/
threads, you can use shared
variables and semaphores. With processes, you can use some form of IPC or
shared memory.
If you decide to go at an application layer, it is beyond the scope of the
ADMIN list, and better suited for a discussion with your peers in that
language and environment.
If you
Info contains the details like time of insertion of a row and data in
that row.
I think this sufficely explains what I want.
-Anagha
-Original Message-
From: Bruno Wolff III [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 4:00 PM
To: Anagha Joshi
Cc: [EMAIL PROTECTED]
Subject:
On Tue, Jun 17, 2003 at 01:37:37PM -0700, Jonathan Gardner wrote:
> Why in the world would you want to? Think about this for a moment:
> The script runs in under a second - why would it want to sit around
> and wait for a notification?
No, my script runs hours, days, month ...
cu
--
-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 17 June 2003 05:13, Anagha Joshi wrote:
> Hi All,
> I'm new to Postgres. I'm using Postgres-7.2.4
> Can anybody guide me in detail how 'NOTIFY-LISTEN' can be implemented
> progmatically bet'n frontend and backend?
>
Might want to move this
On Tue, 2003-05-27 at 10:30, Jodi Kanter wrote:
> I also need a Perl programming book to use as a reference but also as a
> means to learning the product. I am a DBA but fairly new to coding in
> Perl.
> Does anyone have a recommendation?
> Thanks
> Jodi
>
You might want to give "PostgreSQL" by K
Marcelo Pereira Tada <[EMAIL PROTECTED]> writes:
>> NOTICE: Child itemid in update-chain marked as unused - can't continue repair_frag
>> ERROR: No one parent tuple was found
Try updating to 7.2.4; that should fix this.
regards, tom lane
---(end
Hi shreedhar :
--- shreedhar <[EMAIL PROTECTED]> wrote:
> Can any body tell that how sub queries and joins
> differs funcationally.
> Because sub queries taking lot of time than joins.
>
The following could be the probable reasons:
a) Your are using correlated queries - Correlated
queries
On Wed, 2002-08-14 at 13:09, Raymond Chui wrote:
> Let say I have a table has column1 and column2 and I made a trigger for
> after INSERT OR UPDATE for each row to execute procedure my_function.
>
> What I want is the trigger execute my_function only when column1 is
> insert or
> update, but not
PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Subject: Re: [ADMIN] [SQL] Urgent - SQL Unique constraint error (long)
On Mon, 19 Aug 2002, Darrin Domoney wrote:
> Thanks for the response but the answer is no. Owing to the
> ongoing issue with inherited tables in 7.x I have opted
At 04:28 AM 7/31/02 , Elielson Fontanezi wrote:
>I'm interested in programming a first prototype to demonstrate 3-tier
>programming using PostGRE database.
We're using FreeBSD/Apache for web servers, Macromedia JRun for the servlet
container and PostgreSQL for the back-end database.
We've just
On Mon, Jul 01, 2002 at 02:29:27PM +0300, Oleg Bartunov wrote:
>
> I tried 1.2.4 but didn't found how to configure tora to work
> with postgresql.
Tora is very nice. I'm using 1.3.5 with PG 7.2 (Debian). I had to compile
the PostgreSQL Qt 3 module for it to work.
-Roberto
--
+| http://fs
On Monday 01 July 2002 15:00, Oleg Bartunov wrote:
> On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote:
> > On Monday 01 July 2002 13:29, you wrote:
> > > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote:
> > > > Take a look at TOra - Toolkit For Oracle:
> > > > http://www.globecom.se/tora/
> > > >
> >
On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote:
> On Monday 01 July 2002 13:29, you wrote:
> > On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote:
> > > Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/
> > >
> > > It has excellent PostgreSQL support.
> >
> > I tried 1.2.4 but d
On Monday 01 July 2002 13:29, you wrote:
> On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote:
> > Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/
> >
> > It has excellent PostgreSQL support.
>
> I tried 1.2.4 but didn't found how to configure tora to work
> with postgresql.
I
On Mon, 1 Jul 2002, Andreas Joseph Krogh wrote:
>
> Take a look at TOra - Toolkit For Oracle: http://www.globecom.se/tora/
>
> It has excellent PostgreSQL support.
I tried 1.2.4 but didn't found how to configure tora to work
with postgresql.
>
>
Regards,
Oleg
On Friday 28 June 2002 17:30, Josh Berkus wrote:
> David,
>
> > As for what I first said in this mail, I'll launch the development of
> > a Kde
> > application (I think called KPostgreSQL...), which will have to fit
> > the
> > following :
>
> Listen, the PGAdminII "team" (i.e. David Page) is plan
1 - 100 of 134 matches
Mail list logo
