st regards
Hans
ence
> implementation of this to compare against.
>
"dsn" is only relevant when the scheme is ODBC.
In a situation where an application (like Drupal) get connect string (URI)
it should be able to find the right driver to use. In case with of ODBC, a
dsn (Data Source Name) is needed.
./hans
2017-07-05 16:29 GMT+02:00 Thomas Kellerer :
> Hans Schou schrieb am 05.07.2017 um 14:27:
> > The dburl (or dburi) has become common to use by many systems
> > connecting to a database. The feature is that one can pass all
> > parameters in a string, which has similar p
2017-07-05 15:15 GMT+02:00 Albe Laurenz :
>
> Unless I misunderstand, this has been in PostgreSQL since 9.2:
>
Sorry! I did not read the *new* manual.
(OK, 9.2 is not that new)
It is even mentioned in the man page.
Then I have a new proposal. Write a note about in
psql --help
./hans
tabase: dbname
I have attached an example of how it could be implemented. It uses libpcre
RegEx to pass the dburl.
best regards
Hans
diff -Naur /home/hsc/tmp/postgresql-10beta1/src/bin/psql/dburl.c ./dburl.c
--- /home/hsc/tmp/postgresql-10beta1/src/bin/psql/dburl.c 1970-01-01
01:00:00.0
BTW, nowhere in the current documentation is mentioned the requirement of the
VC++ runtime library installation.
Thanks in advance
Hans Buschmann
NSERT INTO mail(pid,subject,body) VALUES( (SELECT pid FROM person WHERE
name='Joe') , 'B', 'Guten tag welt!');
INSERT INTO attachment(mid,content) VALUES( (SELECT mid FROM mail WHERE
subject='A'), 'blah blah');
best regards/hans
Thanks, this is most helpful. I originally found that query somewhere on the
internet and used it as-is.
If I drop the restriction on table name I get a list that also includes
indexes, constraints, etc. Is there a way to restrict the returned set to
tables only?
Hans Guijt
From: Melvin
...and I forgot to add: for the rest the database is behaving fine; everything
else works without performance issues, even when we stepped up the amount of
data somewhat. It's just this one query that is somehow very slow.
Hans Guijt
From: pgsql-general-ow...@postgresql.org
[mailto:
text)"
" SubPlan 1"
"-> Aggregate (cost=9.49..9.50 rows=1 width=4)"
" -> Index Scan using pg_index_indrelid_index on pg_index
(cost=0.27..9.48 rows=2 width=4)"
"Index Cond: (indrelid = cl.reltoastrelid)"
" SubPlan 2"
"-> Aggregate (cost=9.49..9.50 rows=1 width=4)"
" -> Index Scan using pg_index_indrelid_index on pg_index pg_index_1
(cost=0.27..9.48 rows=2 width=4)"
"Index Cond: (indrelid = c.oid)"
Is there a way to improve execution time of what should be a fairly trivial
query? What am I doing wrong?
Hans Guijt
is, but I don't see the need
for a WAL archive in sync mode. Can you please explain that? Thanks
Original-Nachricht
> Datum: Fri, 6 Apr 2012 17:54:54 -0400
> Von: Michael Nolan
> An: hans wulf
> CC: pgsql-general@postgresql.org
> Betreff: Re: [GENERAL] 9.1.3 S
I am wondering how the catchup mode of a hot synchron slave server works on
9.1.3 if there is no WAL archive.
Can the slave only request WALs that are still in the xlog directory of the
master server? Or does the master regenerate some kind of fake log for the
catchup mode? E.g. in case of a sl
I'm trying to set up a replication server that shall handle synchronized
commits. I stopped my master database, copied all the files to the slave, added
a recovery.conf, started the master with synchronized_commit = on and then
started the slave.
I would prusume because the slave is nearly up t
IN
SELECT *
FROM pg_tables
WHERE tableowner = current_user
LOOP
EXECUTE 'GRANT ' || privilegio || ' ON ' || db.schemaname || '.' ||
db.tablename || ' TO ' || usuario;
END LOOP;
RETURN 0;
END;
$$ LANGUAGE plpgsql;
COMME
de la línea de comandos.
Bye
Hans
Hans Poo, Welinux S.A.
Bombero Ossa #1010, oficina 800,
+56-2-3729770, Movil: +56-9-3199305
Santiago, Chile
- Mensaje original -
De: ego...@adgsystems.com.do
Para: pgsql-general@postgresql.org
Enviados: Jueves, 19 de Mayo 2011 16:45:01
Asunto: [GE
y};
unless ($aref) {
$aref = [];
$tuplas{$key} = $aref;
}
push @$aref, $constName;
}
}
Bye
Hans
Hans Poo, Welinux S.A.
Bombero Ossa #1010, oficina 526,
+56-2-3729770, Movil: +56-9-3199305
Santiago, Chile
--
Sent via pgsql-general mailing list (pgsql-general@post
$constraintName) = /ALTER TABLE
ONLY (\w+)\s+ADD CONSTRAINT (\w+) (FOREIGN KEY|UNIQUE)\s*\((\w+)\)/) {
my $key = "$lastSchema.$table,$constraintType.$constraintName";
my $aref = $tuplas{$key};
unless ($aref) {
$aref = [];
$tuplas{$key} = $aref;
}
pu
re is the database name or user to use, if it work with dumps
i need to give the dump files and the database type...
Hans
- "Randal L. Schwartz" escribió:
> >>>>> "hans" == hans writes:
>
> hans> Actually just compare tables and fields, for m
Hi,
I was looking for a simple diff program to compare two schemas, i found two
scripts out there but one compared everything and was too much for me, the
other was a ruby script i wasn't able to run, so i wrote a little perl script
that do the trick:
http://www.welinux.cl/hans/dbdi
the US one (around 5.4%
here usually).
you can also get "bock bier" (as we call it in austria), however.
it is in the area of 12% :).
THIS is beer *g*. you need just the fingers of one hand to count if you
had more than enough *g*.
i can send you a bottle, if you want.
hans
When reading the documentation (Section 32.6.3. Different types of host
variables) I find description only for basic date types. It is not
described, how I can retrieve, for example, a big integer, byte varying,
bit varying, or text data type in embedded SQL.
Is this not possible, or is it only no
thanks,
hans
Oleg Bartunov wrote:
Hi there,
this is an announcement of our new contribution module for PostgreSQL
- Plantuner - enable planner hints
(http://www.sai.msu.su/~megera/wiki/plantuner).
Example:
=# LOAD 'plantuner';
=# create table test(id int);
=# create index id_i
.
Many thanks,
hans
Dave Page wrote:
The PGDay.EU 2009 conference in Paris will include a series of
lightning talks on Saturday the 7th November.
This is your chance for five minutes of fame and glory, presenting any
PostgreSQL-related topic you like!
Interested, but not sure what you
> > > > We're using a statement like this to dump between 500K and >5
> > > > million rows.
> > > >
> > > > COPY(SELECT SomeID FROM SomeTable WHERE SomeColumn > '0')
> > > > TO '/dev/shm/SomeFile.csv'
> > > >
> > > > Upon first run, this operation can take several minutes. Upon
> > > > second ru
> > We're using a statement like this to dump between 500K and >5 million
> > rows.
>
> > COPY(SELECT SomeID FROM SomeTable WHERE SomeColumn > '0')
> > TO '/dev/shm/SomeFile.csv'
>
> > Upon first run, this operation can take several minutes. Upon second
> > run, it will be complete in generall
> > We're using a statement like this to dump between 500K and >5
> > million rows.
> >
> > COPY(SELECT SomeID FROM SomeTable WHERE SomeColumn > '0')
> > TO '/dev/shm/SomeFile.csv'
> >
> > Upon first run, this operation can take several minutes. Upon
> > second run, it will be complete in ge
Hello,
We're using a statement like this to dump between 500K and >5 million rows.
COPY(SELECT SomeID FROM SomeTable WHERE SomeColumn > '0')
TO '/dev/shm/SomeFile.csv'
Upon first run, this operation can take several minutes. Upon second run,
it will be complete in generally well under a minut
o it with a function, but it fails. The script is at
the end of the mail.
Description of percent encoding:
http://en.wikipedia.org/wiki/Percent-encoding
/hans
---
drop function percent2bin(text);
create function percent2bin(text) returns
I suggest to explicitly invite the Russian folks too.
Oleg showed strong interest in a global certification thing.
we can contribute some material and so on if needed. it is currently
in german but it should not be a big problem.
many thanks,
hans
On Jan 30, 2008
Hi *,
we are using PostgreSQL for data in different
languages like English, German and French.
The encoding and locale parameters on our OS (UTF-8
and en_US.UTF-8) had problems e.g. with german umlaut.
After some tries we found encoding and locale
parameters (LATIN1 and de_DE.iso88591)
ernal?
Best regards,
Hans
Tom Lane wrote:
Peter Eisentraut <[EMAIL PROTECTED]> writes:
I'm not convinced that PLs are more tied to the core than say OpenFTS,
and if we can't maintain that kind of thing externally, then this whole
extension thing sounds like a
o Informix.
> Go SF 49ers!
What's that?
> Go Rhein Fire!
And that?
> Use Debian GNU/Linux!
I Use Gentoo and SuSE.
> Use PostgreSQL!
Yes, when Embedded SQL works again :-)
--
With kind regards | Mit freundlichen Gruessen
Hans-Michael Stahl
Condat AG
Alt-Moabit 91d | 10559 Berlin
ays
related to calls of malloc/free/realloc issued by libpq.
--
With kind regards | Mit freundlichen Gruessen
Hans-Michael Stahl
Condat AG
Alt-Moabit 91d | 10559 Berlin | Germany | Old Europe
tel: +49.30.3949-1155 | fax: +49.30.3949-2221155
http://www.condat.de/
---(e
t
declared?
--
With kind regards | Mit freundlichen Gruessen
Hans-Michael Stahl
Condat AG
Alt-Moabit 91d | 10559 Berlin | Germany | Old Europe
tel: +49.30.3949-1155 | fax: +49.30.3949-2221155
http://www.condat.de/
---(end of broadcast)---
TIP 8: exp
Is there a way to access the execution plan of a query using the DBI
interface?
Since EXPLAIN seems to write to STDERR, there is no way to use
prepare->execute->fetch ...
Does anybody know, what to do best - I don't want to use a system call
from inside Perl.
Hans-Jürgen Schönig schrieb:
Does anyone know why
perl Makefile.pl
doesn't produce a useful Makefile with RedHat 7.0 (Perl 5.6) and
PostgreSQL 7.0.3?
Hans
After some hard hours of debugging and testing I finally found out
that it seems to work with Perl 5.005 but NOT with Per
Does anyone know why
perl Makefile.pl
doesn't produce a useful Makefile with RedHat 7.0 (Perl 5.6) and
PostgreSQL 7.0.3?
Hans
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
I am busy writing a table editor in Perl, using the module Pg.pm as
interface to Postgresql. When opening a table in that editor I would like
to find out how the tables in the database are defined.
So far I have considered doing a pg_dump to a file and then examine the
content, but it is so u
x27;;
I get the following error:
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Recognized languages are sql, C, internal, and created
procedural languages.
According to my docs "plpgsql" should be ok.
Hans
t; best of luck,
> --
> -Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
> "I have the heart of a child; I keep it in a jar on my desk."
Kernel >= 2.4 can manage large files. As far as I have tried this it works
perfectly well.
Hans
StartTransactionCommand
query: END
ProcessUtility: END
CommitTransactionCommand
Thanks for help.
OTTO WÖHR GmbH Tel: 07044 46-0
Hans Reichenecker Tel: 07044 46193
Leiter DVO
Ölgrabenstraße 14 Fax: 07044 46266
71292 Friolzheim http:www.woehr.de
winmail.dat
41 matches
Mail list logo