am Tue, dem 16.10.2007, um 21:55:38 -0700 mailte Bret Schuhmacher folgendes:
> Does the PG/Tcl interface allow expect scripts? I want to create a stored
> procedure that ssh's to another server and runs a Perl script. Expect could
> do
> it, but can I load the expect module from pgtcl?
I think
> I prefer the manual. I would think the list would be pretty long and
> deal with lots of internals terms.
Also the manual has more "reference" character; as we saw with GUC in
this discussion it is still possible to find a CORRECT definition of
them.
Harald
--
GHUM Harald Massa
persuadere e
Tom Lane wrote:
Jorge Godoy <[EMAIL PROTECTED]> writes:
Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu:
The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to skip those rows entirely. Of
course you could argue I suppose that it oug
Tom Lane wrote:
> Steve Crawford <[EMAIL PROTECTED]> writes:
> > My vote is to add "Appendix I. Abbreviations".
>
> It seems more like FAQ material than something for the manual.
I prefer the manual. I would think the list would be pretty long and
deal with lots of internals terms.
--
Bruce
Steve Crawford <[EMAIL PROTECTED]> writes:
> My vote is to add "Appendix I. Abbreviations".
It seems more like FAQ material than something for the manual.
regards, tom lane
---(end of broadcast)---
TIP 4: Have you searched o
Jorge Godoy <[EMAIL PROTECTED]> writes:
> Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu:
>> The row is pretty useless without a rowid in this context -- it seems
>> like the best thing to do would be to skip those rows entirely. Of
>> course you could argue I suppose that it ought to thr
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Steve Crawford wrote:
>> Raymond O'Donnell wrote:
On 18/10/2007 22:26, Laurent ROCHE wrote:
No idea what GUC is, though !
>>
>> It's Global User Configuration. But the confusion does point out the
>> need for a reference.
> I think it is Gran
Steve Crawford wrote:
> Raymond O'Donnell wrote:
> > On 18/10/2007 22:26, Laurent ROCHE wrote:
> >
> >> No idea what GUC is, though !
> >
> > Grand Unified Contraption? ;-)
> >
> > Ray (who's just been reading Jules Verne).
>
> It's Global User Configuration. But the confusion does point out th
Raymond O'Donnell wrote:
> On 18/10/2007 22:26, Laurent ROCHE wrote:
>
>> No idea what GUC is, though !
>
> Grand Unified Contraption? ;-)
>
> Ray (who's just been reading Jules Verne).
It's Global User Configuration. But the confusion does point out the
need for a reference.
-Steve
---
Alvaro Herrera wrote:
> Steve Crawford wrote:
>> Is there a comprehensive (or semi-comprehensive) on-line list of
>> commonly used PG-related abbreviations used in PostgreSQL documentation,
>> mail-lists, etc.? If there is not, would such a list make a reasonable
>> one-page addition to the PG manu
Em Thursday 18 October 2007 14:57:27 brian escreveu:
> Ken Johansson wrote:
> > Hello,
> >
> > Sorry everyone for the stupid rant. Wont happen again. And thanks for
> > offer assistance. I seem to have it running and once i have a valid
> > question ill post it.
> >
> > Sorry again..
> >
> > Ken
Em Thursday 18 October 2007 16:37:59 Joe Conway escreveu:
> Tom Lane wrote:
> > so it's trying to pstrdup a null result from SPI_getvalue.
> >
> > Obviously it shouldn't crash, but I'm not sure what it *should* do in
> > this case. Joe?
>
> The row is pretty useless without a rowid in this context
Jeff Lanzarotta wrote:
Sam Mason <[EMAIL PROTECTED]> wrote: On Tue, Oct 16, 2007 at 07:46:34AM -0700,
Jeff Lanzarotta wrote:
Hello,
I have a table that looks something like this:
SKU Dept Col1 Col2 Col3
--- -- --- --- --
1112 3
Laurent ROCHE <[EMAIL PROTECTED]> writes:
> Not good because in that case pg_dump will generate code that can not run in
> 8.1 ... like :
>
> ALTER SEQUENCE ... OWNED BY
Dumps produced by version X of pg_dump have never been guaranteed to
load into earlier versions.
-Doug
--
On Thu, Oct 11, 2007 at 12:03:47PM -0400, Tom Lane wrote:
> > If in the meantime another writer changed the data we
> > originally read we would detect that by xmin having changed
> > hence no row to be updated. So, yes, there is a *tiny*
> > failure condition:
>
> Hmm. I think the failure condi
Laurent ROCHE wrote:
> Hi,
>
> So nobody can help me to write the SELECT that will return the SEQUENCE
> names, and their linked columns and their linked tables ?
> Are the system tables documented somewhere ?
Of course -- in the "internals" section. You need pg_class where
relkind = 's', pg_de
On 18/10/2007 22:26, Laurent ROCHE wrote:
No idea what GUC is, though !
Grand Unified Contraption? ;-)
Ray (who's just been reading Jules Verne).
---
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
[EMAIL PROTECTED]
On 18-Oct-07, at 3:15 PM, Brian Wipf wrote:
The offset is the last 6 hex digits of the checkpoint location
value. The offset contains leading zeros to make it 6 digits if its
actual value is less than 6 digits. Therefore, the digits between
the slash and the last 6 digits are the log segmen
Hi,
So nobody can help me to write the SELECT that will return the SEQUENCE names,
and their linked columns and their linked tables ?
Are the system tables documented somewhere ?
Cheers,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Laurent ROCHE <[EMAIL PROTECTED]>
Yep, having a list would be good !
To answer your question, DDL is not a PG (here is another one) abbreviation but
a database abbreviation.
It stands for Data Definition Language ... and basically that means SQL orders
to manage objects (CREATE, DROP, ALTER) see Wikipedia for more info.
No idea
Not good because in that case pg_dump will generate code that can not run in
8.1 ... like :
ALTER SEQUENCE ... OWNED BY
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Alvaro Herrera <[EMAIL PROTECTED]>
À : Laurent ROCHE <[EMAIL PROTECTED]>
Cc : Andreas Kretsc
On 17-Oct-07, at 12:01 AM, Brian Wipf wrote:
I'm working on a script that takes backups in intervals from our
warm PITR stand by server (both servers running PG 8.2.5). The
documentation advises "running pg_controldata on the standby server
to inspect the control file and determine the curre
On Tuesday 16 October 2007 12:20 pm, ctorres wrote:
> Hi,
>
> I doing a simple insert into a table re Perl/DBI
> "INSERT INTO party (party_id, party_type_id, description, status_id)
>VALUES ($partyId, 'PERSON', 'Initial
> Import','PARTY_ENABLED')
>
> and I'm getting
When I fetch a row it returns a row number.
Is there a method under the fetch command of either not returning the row
number or of ignoring it after it is returned.
begin work;
Declare loop_set Cursor
for Select one, two from loop_import
order by loop_id ;
fetch n
On Oct 18, 2007, at 1:02 PM, Andreas Kretschmer wrote:
Laurent ROCHE <[EMAIL PROTECTED]> schrieb:
Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not
dropped, however
when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too !
I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY
I looked farther up the STDOUT/STDERR of the
psql import using the file from a pg_dumpall
There are tons of errors there besides encoding.
Sample errors:
psql:/tmp/cluster_pg_dumpall.txt:10: ERROR: role "airburst" does
not exist
SET
psql:/tmp/cluster_pg_dumpall.txt:14: ERROR: relat
On Tuesday 16 October 2007, ctorres <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I doing a simple insert into a table re Perl/DBI
> "INSERT INTO party (party_id, party_type_id, description, status_id)
>VALUES ($partyId, 'PERSON', 'Initial
> Import','PARTY_ENABLED')
>
> and
Hi all,
recently our application was locked, and postgres shows several
processes in "LOCK TABLE waiting" state. Even the autovacuum process is
stalled.
The pg_locks table shows the following:
> SELECT pg_class.relname AS table, transaction, pid, mode, granted FROM
pg_locks, pg_class, pg_databas
Does the PG/Tcl interface allow expect scripts? I want to create a
stored procedure that ssh's to another server and runs a Perl script.
Expect could do it, but can I load the expect module from pgtcl?
Thanks,
Bret
Hi,
I doing a simple insert into a table re Perl/DBI
"INSERT INTO party (party_id, party_type_id, description, status_id)
VALUES ($partyId, 'PERSON', 'Initial
Import','PARTY_ENABLED')
and I'm getting a
"ERROR: relations "party" does not exist"
I get the same e
> A case for dynamic
> SQL!http://www.postgresql.org/docs/8.2/static/plpgsql-statements.html#PLPGSQ
> L-STATEMENTS-EXECUTING-DYN
>
> Yours,
> Laurenz Albe
>
> ---(end of broadcast)---
> TIP 5: don't forget to increase your free space map settings
P
Okay, actually the query is something like:
select dept, (col1 + col2) * col3) from table group by dept
So, the output would look something like:
DeptTotal
-- ---
1 26
2 18
3 9
Sam Mason <[EMAIL PROTECTED]> wrote: On Tue, Oct 16, 2007 at 07:46:34AM -0700,
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Laurent ROCHE wrote:
>> Yep, of course but what's the situation for people using 8.1 and
>> pg_dump that does not generate code with SERIAL ?
> They grab 8.2's pg_dump and connect with it to their 8.1 server, to
> generate a dump that does.
Actually, I
I'm preparing to upgrade and am practicing.
I'm using v7.4
I created a blank .7.4 to import a pg_dumpall into. (Also a v8.2 to
upgrade to.)
The encoding was wrong and I have a lot of:
psql:/tmp/cluster_pg_dumpall.txt:4382: ERROR: invalid byte
sequence for encoding "UTF8": 0x91
HINT:
2007/10/18, Bill Moran <[EMAIL PROTECTED]>:
> I don't know of any system that will just hand you those capabilities.
>
> Every multi-master system I've ever heard of requires high-speed links
> between the masters, otherwise the synchronization is far too slow to
> be usable.
I supposed so. Howeve
Lothar Behrens <[EMAIL PROTECTED]> writes:
> When there is a way to optionally add columns to existing tables via
> SQL I have very less development needs to get this working.
Why don't you just issue the ALTER ADD COLUMN and ignore the error
if it's duplicate column?
Or if you don't like that,
Steve Crawford wrote:
> Is there a comprehensive (or semi-comprehensive) on-line list of
> commonly used PG-related abbreviations used in PostgreSQL documentation,
> mail-lists, etc.? If there is not, would such a list make a reasonable
> one-page addition to the PG manual?
I don't think we have o
Is there a comprehensive (or semi-comprehensive) on-line list of
commonly used PG-related abbreviations used in PostgreSQL documentation,
mail-lists, etc.? If there is not, would such a list make a reasonable
one-page addition to the PG manual?
Things like GUC and DDL for example. Couldn't find th
Tom Lane wrote:
so it's trying to pstrdup a null result from SPI_getvalue.
Obviously it shouldn't crash, but I'm not sure what it *should* do in
this case. Joe?
The row is pretty useless without a rowid in this context -- it seems
like the best thing to do would be to skip those rows entirel
On 18 Okt., 19:33, [EMAIL PROTECTED] (brian) wrote:
> Lothar Behrens wrote:
> > On 18 Okt., 18:22, [EMAIL PROTECTED] ("Scott Marlowe") wrote:
>
> >>Normally when you get thundering silence, you've asked a question no
> >>one feels real qualified to answer, and rather than answer it halfway,
> >>the
Laurent ROCHE wrote:
> Yep, of course but what's the situation for people using 8.1 and
> pg_dump that does not generate code with SERIAL ?
They grab 8.2's pg_dump and connect with it to their 8.1 server, to
generate a dump that does.
--
Alvaro Herrerahttp://www.C
I think this is not the way I should go.
My application is a database prototype design tool that also is able to
run the design because the designer it self is a design.
So I did not only need a DDL to create the target application's
database, also I need to feed a model into the system datab
Yep, of course but what's the situation for people using 8.1 and pg_dump that
does not generate code with SERIAL ?
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
De : Andreas Kretschmer <[EMAIL PROTECTED]>
À : pgsql-general@postgresql.org
Envoyé le : Jeudi, 18 Oc
Scott Marlowe wrote:
On 10/18/07, Ken Johansson <[EMAIL PROTECTED]> wrote:
and i though PostgreSQL would be easier to get up and running than SQL
server
I sincerely hope you don't consider that the sole criteria for
choosing databases.
I don't know - it's put me off MS-SQL in a b
On Thu, Oct 18, 2007 at 10:06:00AM -0700, Laurent ROCHE wrote:
> Hi,
>
> I am quite surprised I could not find a way to automatically reset the value
> of a sequence for all my tables.
I never bother resetting sequences. It's not like the numbers mean
anything...
Have a nice day,
--
Martijn va
Laurent ROCHE <[EMAIL PROTECTED]> schrieb:
> Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not dropped, however
> when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too !
> I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY does not exist ! ! !
Read this message: <[EMAIL PROTE
It is not as easy as that :
1/ select table_name from information_schema.tables does not give you the
tables list on the current schema but the list of all objects !
But the following will
SELECT c.relname
FROM pg_namespace AS nc, pg_class AS c
WHERE c.relnamespace = nc.oid
AND c.relkind IN ('
Thank you very much Shane. It fixed my problem, at least now :-).
I installed the pgsql 8.2.5 from source. The user "postgres" has a
shortname of "pgsql".
Another question, what's the purpose/advantage to create a user of
postgres? May I just create the database under my user account?
S
Hi,
You might want to have a look at DdlUtils that does similar things that you
want to do: compare databases schemas using XML files and synchronising the
schemas.
Interesting tool ! !
http://db.apache.org/ddlutils/
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message d'origine
Hi,
I have a problem with pg_dump generating a code with no SERIALs id but with
SEQUENCEs instead: if I write in a SERIAL I want to see a SERIAL, even when I
reload the database.
We had this conversation before on this mailing list and I was told that's
because SERIAL is just a kind of macro ge
On Thursday 18 October 2007, Laurent ROCHE <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am quite surprised I could not find a way to automatically reset the
> value of a sequence for all my tables.
>
> Of course, I can write:
> SELECT setval('serial', max(id)) FROM distributorsBut if I reload data
> into
2007/10/18, Laurent ROCHE <[EMAIL PROTECTED]>:
>
> Hi,
>
> I am quite surprised I could not find a way to automatically reset the value
> of a sequence for all my tables.
>
> Of course, I can write:
> SELECT setval('serial', max(id)) FROM distributors
> But if I reload data into all my tables, it's
Lothar Behrens wrote:
On 18 Okt., 18:22, [EMAIL PROTECTED] ("Scott Marlowe") wrote:
Normally when you get thundering silence, you've asked a question no
one feels real qualified to answer, and rather than answer it halfway,
they just leave it for the next guy to get.
In my opinion the ques
[EMAIL PROTECTED] wrote:
Hi, I am a newbie for pgsql and tried to install it on my MacBookPro
Intel. I got everything correct until creating the user: postgres and
initdb, then the error message showed up for running the db. How to fix
the problem?
LizheXusComputer:/Users/lizhexu pgsql$ /usr/
Hi,
I am quite surprised I could not find a way to automatically reset the value of
a sequence for all my tables.
Of course, I can write:
SELECT setval('serial', max(id)) FROM distributorsBut if I reload data into all
my tables, it's a real pain to have to write something like this for every
s
On 18 Okt., 18:22, [EMAIL PROTECTED] ("Scott Marlowe") wrote:
> On 10/18/07, Lothar Behrens <[EMAIL PROTECTED]> wrote:
>
>
>
> > On 18 Okt., 17:17, [EMAIL PROTECTED] (brian) wrote:
> > > Lothar Behrens wrote:
> > > > Hi,
>
> > > > Several groups I post most of them does not answer.
> > > > Did noon
That's marvelous - thanks.
Bob
- Original Message -
From: "brian" <[EMAIL PROTECTED]>
To:
Sent: Thursday, October 18, 2007 9:45 AM
Subject: Re: [GENERAL] ordering rows
Bob Pawley wrote:
Hi
I have a table 'import' which is an amalgam of two other tables
'loops' and 'devices'.
The
Ken Johansson wrote:
Hello,
Sorry everyone for the stupid rant. Wont happen again. And thanks for
offer assistance. I seem to have it running and once i have a valid
question ill post it.
Sorry again..
Ken
We'll put it down as "thinking out loud" then. It happens. ;-)
brian
---
On 10/18/07, Ken Johansson <[EMAIL PROTECTED]> wrote:
> Hello,
>
> Sorry everyone for the stupid rant. Wont happen again. And thanks for
> offer assistance. I seem to have it running and once i have a valid
> question ill post it.
Don't worry about it. We've all had to cut our teeth sometime.
Bob Pawley wrote:
Hi
I have a table 'import' which is an amalgam of two other tables
'loops' and 'devices'.
The ID column of loops is reflected in the import table. However the
order of rows ends up as, a for instance, 6, 8, 7, 4, 5 3, 2, 1.
These are the IDs from loops?
I need to fetch the
Hello,
Sorry everyone for the stupid rant. Wont happen again. And thanks for
offer assistance. I seem to have it running and once i have a valid
question ill post it.
Sorry again..
Ken
On 18/10/2007, brian <[EMAIL PROTECTED]> wrote:
>
> Ken Johansson wrote:
> > and i though PostgreSQL would
On 10/18/07, Stefan Schwarzer <[EMAIL PROTECTED]> wrote:
> But when re-doing the query now without the JOIN, it works (almost):
>
> SELECT
> *
> FROM
> crosstab(
>'SELECT
> id_country AS id,
> year_start AS year,
> value
> FROM
>
Hi
I have a table 'import' which is an amalgam of two other tables 'loops' and
'devices'.
The ID column of loops is reflected in the import table. However the order of
rows ends up as, a for instance, 6, 8, 7, 4, 5 3, 2, 1.
I need to fetch these rows one at a time, in sequence with the loop ID
I just install it as my own user on my laptop... I usually do something like
./configure --prefix=/Users/myaccount/pgsql
make && make install
then
cd ~/
pgsql/bin/initdb -D /Users/myaccount/pgsql/data
pgsql/bin/pg_ctl _D /Users/myaccount/pgsql/data start
and I'm off to the races ;-)
Good luck!
Hi,
May be a solution will be to make a diff fo the XML file produced by another
tool: DdlUtils (http://db.apache.org/ddlutils/) !
However, DdlUtils won't produce a file with all PG elements (no user types,
views, triggers, ...).
Have fun,
[EMAIL PROTECTED]
The Computing Froggy
- Message
On 10/18/07, Lothar Behrens <[EMAIL PROTECTED]> wrote:
> On 18 Okt., 17:17, [EMAIL PROTECTED] (brian) wrote:
> > Lothar Behrens wrote:
> > > Hi,
> >
> > > Several groups I post most of them does not answer.
> > > Did noone see my postings ?
> >
> > > Please at least give me one answer :-)
> >
> > >
Gotcha!
- Original Message
From: Lothar Behrens <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Thursday, 18 October, 2007 7:40:54 PM
Subject: [GENERAL] Am I overseen ?
Hi,
Several groups I post most of them does not answer.
Did noone see my postings ?
Please at least give
On 10/18/07, Stefan Schwarzer <[EMAIL PROTECTED]> wrote:
> > Could you provide a self-contained test case for this? There's not
> > really enough information here for someone else to duplicate the
> > problem. Also, which PG version are you using?
>
> Wasn't sure what you ment with "a self contai
On 18 Okt., 17:17, [EMAIL PROTECTED] (brian) wrote:
> Lothar Behrens wrote:
> > Hi,
>
> > Several groups I post most of them does not answer.
> > Did noone see my postings ?
>
> > Please at least give me one answer :-)
>
> > Thanks, Lothar
>
> ping
>
> What was your query?
>
I do convert an UML XM
Hi, I am a newbie for pgsql and tried to install it on my MacBookPro
Intel. I got everything correct until creating the user: postgres and
initdb, then the error message showed up for running the db. How to fix
the problem?
LizheXusComputer:/Users/lizhexu pgsql$ /usr/local/pgsql/bin/postgres -
On 10/18/07, Ken Johansson <[EMAIL PROTECTED]> wrote:
> and i though PostgreSQL would be easier to get up and running than SQL
> server
I sincerely hope you don't consider that the sole criteria for
choosing databases.
Personally, I found it quite easy.
apt-get install postgresqlp8.2
Stefan Schwarzer <[EMAIL PROTECTED]> writes:
> Here is a SQL dump for the table. One can just neglect the JOIN with
> the countries table (which just replaces the country id with the
> country name):
> http://geodata.grid.unep.ch/download/sql_agri_area.sql.zip
> But when re-doing the query now
Ken Johansson wrote:
and i though PostgreSQL would be easier to get up and running than SQL
server
Question? Complaint? Thinking out loud? Lyrics to a song? We're all
standing by, Ken!
---(end of broadcast)---
TIP 3: Have you check
and i though PostgreSQL would be easier to get up and running than SQL
server
--
Ken
2007/10/18, Lothar Behrens <[EMAIL PROTECTED]>:
> Hi,
>
> Several groups I post most of them does not answer.
> Did noone see my postings ?
>
> Please at least give me one answer :-)
>
> Thanks, Lothar
>
I see your post
Pavel
---(end of broadcast)-
Could you provide a self-contained test case for this? There's not
really enough information here for someone else to duplicate the
problem. Also, which PG version are you using?
Wasn't sure what you ment with "a self containted test case". Is it
the raw data?
Here is a SQL dump for the ta
Lothar Behrens wrote:
Hi,
Several groups I post most of them does not answer.
Did noone see my postings ?
Please at least give me one answer :-)
Thanks, Lothar
ping
What was your query?
---(end of broadcast)---
TIP 5: don't forget to increa
Hi,
Several groups I post most of them does not answer.
Did noone see my postings ?
Please at least give me one answer :-)
Thanks, Lothar
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.or
Stefan Schwarzer <[EMAIL PROTECTED]> writes:
> I had a couple of problems getting there. But now that I have the
> feeling that this is OK, it tells me this:
> server closed the connection unexpectedly
Could you provide a self-contained test case for this? There's not
really enough information
Hi there,
successfully installed the tablefunc package.
Now, I would like to transform this kind of result based on a normal
SQL:
c_name |year|value
---
Germany | 2001| 123
Germany | 2002| 125
Germany
In response to "Tomi N/A" <[EMAIL PROTECTED]>:
> I am considering pgsql as the RDBMS in a project with the following
> constraints:
> - there's a master and reserve instance of the RDBMS on every remote location
> - there's a master and reserve instance of the RDBMS on a central location
> - the
Ow Mun Heng wrote:
>
> On Wed, 2007-10-17 at 22:47 -0300, Alvaro Herrera wrote:
> > Ow Mun Heng wrote:
> >
> > > Index Cond: ((audit_key_dtime >= $0) AND (audit_key_dtime < $1))
> > >
> > >
> > > Index Cond: ((audit_key_dtime >= '2007-08-08 18:00:00'::timestamp without
> > > time zone)
> > >
I am considering pgsql as the RDBMS in a project with the following constraints:
- there's a master and reserve instance of the RDBMS on every remote location
- there's a master and reserve instance of the RDBMS on a central location
- the connections are DSL connections and therefore unreliable
-
Richard Huxton wrote:
jehan.procaccia wrote:
my postgresql installation from redhat package:
$ rpm -q postgresql
postgresql-7.4.17-1.RHEL4.1
is located in /var partition, unfortunalty it is nearly full
$ df -H .
Filesystem Size Used Avail Use% Mounted on
/dev/sda12 11
Em Thursday 18 October 2007 01:44:33 Bret Schuhmacher escreveu:
>
> Thanks for the reply, Tom. I was thinking I could have my remote
> process send a message back to PG via XMLBlaster, too. XMLBlaster is
> a MOM-like message-queuing app that guarantees delivery to
> subscribers. (www.xmlblaster.o
[EMAIL PROTECTED] a écrit :
Hi list!
I am using DBLink on a Win32 system running PostgreSQL 8.2 to query a table on
another similar system (Win32 / PostgreSQL 8.2).
If I query the server with dblink('hostaddr=ip_address ...', ...), it works
fine, but if I try to use the hostname instead
(dbli
86 matches
Mail list logo
