is, where in the world is the pgdump for 8.2 -
I can't find it.
pg_dump, pg_dumpall are all in /usr/bin but where are the 8.2 ones ?
TIA,
Q
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
this is due to that thing.
I tried to re index them but is not working. Any ideas ?
Thanks
Q
Ps.
I tried to start the server in stand alone and reindex all (used the -P
command to disable the indexed but it didn't work) any ideas ?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You must have missed one, because:
root=# \set tv1 '\'testval\''
root=# insert into test values(:tv1);
INSERT 0 1
root=#
Ilja Golshtein wrote:
Hello!
Is there any way to have psql variable in apostrophes?
The idea is to do something like this
an effort.
regards
Q Beukes
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)
iQEVAwUBRNM+lLEDZDQ16UzTAQIBIggAv3XxXa2HZ4ZU0i0Zu738r4567cgk5trr
/ZGLCdXOSY2wvOtSDtsAVD/rMZXwPEsPfy4M2u0inllr0Uq2uQ1pA4/+fohtqPq5
XPCv5G3wLFcOJR7NpjKAjRC5sl+1/xesskPf174W64RC+iZJJr/Y5GSFffUvkcQY
hTpEC
on dataprocessor_path (cost=0.00..6900.17 rows=284617
width=92)
(1 row)
Please try running 'analyze' on the tables first and then rerun these
queries as 'explain analyze' instead so you can see the difference
between what the planner expects compared to what it actually gets.
--
Seeya...Q
provide the actual schema of tables and rules that
are involved in the query in question.
Q [EMAIL PROTECTED] wrote on 07/19/06 4:37 am:
On 19/07/2006, at 4:24 AM, Christian Rengstl wrote:
now finally after a long time i have the query plan for the whole
filled table. I hope somebody can
cause this huge
performance problem?
That is hard to say unless you post the rule and table schema you are
currently using.
Q [EMAIL PROTECTED] wrote on 07/19/06 11:54 am:
On 19/07/2006, at 6:32 PM, Christian Rengstl wrote:
The analyze is from the exact query and i dropped the indexes
the inheritance that doesn't cause this huge
performance problem?
When you say now everything finished within 20 minutes, what did
you actually do to achieve this?
--
Seeya...Q
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
_ / Quinton Dolan
when reading and transferring 2 million lines?
--
Seeya...Q
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
_ / Quinton Dolan - [EMAIL PROTECTED]
__ __/ / / __/ / /
/__ / _// /Gold Coast, QLD, Australia
) AS w1 JOIN worker AS w2 ON (w1.name = w2.name AND w1.startdate = w2.startdate);Obviously you would use a real primary key instead of 'name' for the join constraint but you get the idea -- Seeya...Q
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hey,
What ways are there to limit the sizes of a database?
Thx
Q Beukes
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iQEVAwUBRF8oErEDZDQ16UzTAQJbsAf+L8+RijP
Hi,
we plan to make available our database from the internet (direct tcp/ip
based connections). We want to make it as secure as possible. There are a
few users who could access the database, but we want to block any other
users to access.
Our plans are:
- using encripted (ssl) connections -
Hi.
I would like to implement simple users/user groups
administration from MS Access. I have already set user groups and permissions to
different objects inside the database. Now, I would like to enable creating new
users and putting them in previosly pre-defined groups, through Access
Hello.
Till now I've been working with Postgres only
through pgAdminIII. Postgres is installed on WIndows XP.
Now I need to use pg_dumpall. I have found folder
with different Postgres aplications, placed inC:\Program
Files\PostgreSQL\8.0\bin.
When I double-click on any of them, I am
Hi.
I know that superusers are allowed to do everything
on the database, but I consider this as dangerous. I want to have some
user group with rights of creating new users and giving them some
authorizations, but without such wide power as superusers have. So,
I wasthinking about two
Thanks, Neil.
Hubert Fröhlich wrote:
Those days, we had PostgreSQL 7.1 and 7.2, and we had to be careful
oids approaching 2^32 (2.14 billion)
Now, we have 8.0. What does the situation look like?
With the default settings, there is exactly the same risk of OID
wraparound as in earlier releases.
Stephane Bortzmeyer wrote:
On Wed, Apr 27, 2005 at 10:26:30AM -0400,
Tom Lane [EMAIL PROTECTED] wrote
a message of 9 lines which said:
If that's what you want, declare it as UNIQUE not PRIMARY KEY.
As shown by Patrick TJ McPhee, it does not work:
tests= create table x (
tests(name TEXT
Hi list,
some time ago, there was a discussion about oid wraparound. See
http://archives.postgresql.org/pgsql-general/2002-10/msg00561.php .
Those days, we had PostgreSQL 7.1 and 7.2, and we had to be careful
oids approaching 2^32 (2.14 billion)
Now, we have 8.0. What does the situation look
On Tue, 2005-04-26 at 13:58 -0400, Ying Lu wrote:
select * from A left join B using (id) where A.type='apple' and
A.isExport=true;
id is the primary key for both table A B. If index (type, isExport)
has been created for table A. In the above query, will this index works?
simplest is
On Mon, 2005-04-25 at 03:38 +0530, Rajiv Verma wrote:
I'm accessing postgres database through tomcat 4.3.1.
I'm able to execute the select and update query through my application
but Insert query is giving following SQLException :
Connection is closed. Operation is not permitted.
looks like
On Sun, 2005-04-24 at 09:49 -0700, Rich Shepard wrote:
I'm converting mysql tables to postgres. One of the tables has this:
PRIMARY KEY (org_id, contact_id),
KEY contact (contact_id, org_id)
Is there really a difference in the two indices if the sequence of fields
is reversed?
David Wheeler wrote:
[...]
Well, I didn't have an unconditional update rule, so I added one without
removing the other two:
CREATE RULE nothing_one AS
ON INSERT TO one DO INSTEAD NOTHING;
And it worked! Now I can have an insert do an INSERT or UPDATE on
another table magically.
But my question
Hello:
It is possible to display error messages from PostgreSQL in other languages rather
than English ?, if it is possible, how can
achieve that. I love this RDBMS but this seems to be a problem for us in using it
with our customers. Any help or answer will
be aprecciated.
Thank yo in
On Tue, 12 Dec 2000 12:04:46 +0100, Roger Wernersson wrote:
I can't BEGIN - SELECT FOR UPDATE - INSERT or UPDATE - COMMIT as someone
might insert after my SELECT and before my INSERT.
correct me if i'm wrong, but a select for update locks the table for
an insert or an update until the end
Hi:
Wonder if any of you know how to setup a postgreSQL server as a windows 2000 service
or have a URL or document on how to do it.
Thank you
---
Luis Magaña
Gnovus Networks Software
www.gnovus.com
Tel. +52 (7) 4422425
[EMAIL PROTECTED]
when i did what's described below, i had no problems at all with
PL/Perl (and, in fact, am using it for a couple of triggers that
are lightly used in a production environment)
http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/pl/plperl/README?rev=1.2content-type=text/x-cvsweb-
markup
you can
According to my copy of SQL For Smarties by Joe Celko (2nd ed, p. 411):
The UNION removes all duplicate rows from the results and does
not care from which table the duplicate rows came. We could
use this feature to write a query to remove duplicates from a
table:
(TABLE tableA)
in effect, this turns the filesystem into a "poor-mans" balanced tree.
the rdbms gives you a "rich-mans" balanced tree, but along with the
overhead of the rdbms.
cheers
--e--
On Thu, 21 Sep 2000 15:20:39 +0300, Alessio Bragadini wrote:
Neil Conway wrote:
a BLOB. Conversely, Unix
statement you quote from the docs (which is not
entirely clear to me without context) seems to refer to
the fact that a sequence will never return the same number
twice when nextval('seq_name') is called.
HTH
--e--
On Wed, 20 Sep 2000 23:13:23 -0700, K Parker wrote:
Edward Q. Bridges'
On Wed, 20 Sep 2000 21:24:17 -0400, Neil Conway wrote:
I believe he is using straight Pg - the perl interface to Postgres.
AFAIK, that's independant of DBI::Pg, which is the Postgres
driver for DBI.
ahhh! "i see" said the blind man :)
I agree with you, however: I've found DBD::Pg quite
On Wed, 20 Sep 2000 17:54:40 -0400, Joe Kislo wrote:
you should not use the OID value for application level work. for one thing,
it's not portable, and if you rebuild the database it'll change. you should
consider it a strictly internal value.
Hmm, I think you missed what my
in other words your perl script should "use DBI;" and
not mention DBD::Pg at all.
try this:
use DBI;
$user = '';
$pass = '';
$dburl = ''; # should be: dbi:Pg:dbname=[your database name]
$db = DBI-connect($dburl, $user, $pass, {AutoCommit=0} )
or die "Can't connect to db";
commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test5=# select '01-10-2000'::date;
?column?
01-10-2000
(1 row)
test5=# select '13-10-2000'::date;
?column?
13-10-2000
(1 row
==
+ as postgres super user:
createlang plperl [database]
NOTES ON USAGE
==
+ Use q[], qq[], and qw[] instead of single quotes in
function definitions.
+ When using escape sequences, you must backslash your
backslashes, e.g
34 matches
Mail list logo
