Hi,
I'm getting an exception when I'm trying to load a
jar file in Windows XP.
The command I'm using is:
statement.executeUpdate("SELECT
sqlj.install_jar('file:///"+jarLocation+"','"+transformName+"',false)");
where jarLcation is:
C:/temp/transform.jar
The error is:
java.sql.SQ
In article <[EMAIL PROTECTED]>,
Terry Lee Tucker <[EMAIL PROTECTED]> wrote:
% elements of 50 thousand records on 8 structurally identical databases. We
% threw together the script and decided to just delete the record and re-insert
% it with the data that was brought into sync. Now the question:
Dear Sir, We are using postgres 8.0.3, on windows xp and we don't have latest database backup. Database shows tables but missing all the procedures written in and shows following error. Also we are using front end PgAdminIII for creating procedures etc. Error is: invalid page header in blo
Trent Shipley wrote:
On Tuesday 2006-06-13 09:26, David Fetter wrote:
On Tue, Jun 13, 2006 at 09:18:17AM -0600, Scott Ribe wrote:
To hold it up as any kind of paradigm is really misinformed.
SQL had something that relational algebra/relational calculus did not
have, which is that somebody with
1. Section 23.3.2 (Making a Base backup) of the 8.1.0 doc says:
"Also, some versions of GNU tar consider it an error if a file is changed
while tar is copying it. There does not seem to be any very convenient way
to distinguish this error from other types of errors, other than manual
inspection of
Bruce Momjian writes:
> Should pg_dumpall be using the "SET default_tablespace = foo" method as
> well?
That would mean changing the semantics of CREATE DATABASE; currently it
copies the default tablespace from the template database, rather than
looking at default_tablespace. I'm unsure if that'
LLC wrote:
Hi List;
I've created a plperlu (perl untrusted) function with the ability to use
dbi. I can use the code listing below to return data if I specify the
query as follows:
select * from sybase_get2() as (f1 varchar(100), f2 varchar(100));
However, I have to specify the column names as
I have added this URL to the TODO list in case people want to move
forward on this.
---
Martijn van Oosterhout wrote:
-- Start of PGP signed section.
> For a while I've been wondering about making a type that was really a
>
On Fri, 2006-06-16 at 12:57, LLC wrote:
> Hi List;
>
> I found documentation that talks about untrusted perl here:
> http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html
>
> However I do not know how to install/use untrusted perl.
>
> Can someone point me in the right direction?
On Fri, Jun 16, 2006 at 11:42:51AM -0500, LLC wrote:
> Hi List;
>
> I have 2 questions...
>
> 1) I want to create a perl function which connects to an external
> non-Postgres database and retrieves data. I wonder is the best way
> to do this to return a set or an array? I assume returning a dat
Hi List;
I've created a plperlu (perl untrusted) function with the ability to use
dbi. I can use the code listing below to return data if I specify the
query as follows:
select * from sybase_get2() as (f1 varchar(100), f2 varchar(100));
However, I have to specify the column names as f1 and f2.
I
LLC wrote:
However I do not know how to install/use untrusted perl.
the easiest way is to use createlang from the command line.
for PLperlu just do the following:
(run the command as the postgres user)
su postgrest
Then:
createlang plperlu yourdatabasename
It's pretty much the same on win
Hi List;
I found documentation that talks about untrusted perl here:
http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html
However I do not know how to install/use untrusted perl.
Can someone point me in the right direction?
Thanks in advance...
In response to snacktime <[EMAIL PROTECTED]>:
> On 6/16/06, Richard Huxton wrote:
>
> > The other option would be to run replication, e.g. slony to migrate from
> > one version to another. I've done it and it works fine, but it will mean
> > slony adding its own tables to each database. I'd stil
On Wed, Jun 14, 2006 at 13:51:50 -0700,
[EMAIL PROTECTED] wrote:
> Starting with this:
>
> create sequence languages_seq increment by 1;
> create table languages (
> id integer primary key default nextval('languages_seq'),
> language_name varchar(100)
> );
> insert into languages (id, langua
On 6/16/06, Richard Huxton wrote:
The other option would be to run replication, e.g. slony to migrate from
one version to another. I've done it and it works fine, but it will mean
slony adding its own tables to each database. I'd still do it one
merchant at a time, but that should reduce your d
Florian G. Pflug wrote:
Chander Ganesan wrote:
Tom Lane wrote:
Chander Ganesan <[EMAIL PROTECTED]> writes:
I'd like to suggest that a feature be added to pg_dumpall to remove
tablespace definitions/creation from the output. While the
inclusion is important for backups - it's equally painfu
Hi List;
I have 2 questions...
1) I want to create a perl function which connects to an external non-Postgres database and retrieves data. I wonder is the best way to do this to return a set or an array? I assume returning a data set is a better way to go, I want to be able to run something lik
On Tue, Jun 13, 2006 at 09:04:15 -0700,
Benjamin Arai <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a database where there are three columns (name,date,data). The
> queries are almost always something like SELECT date,data FROM table WHERE
> name=blah AND date > 1/1/2005 AND date < 1/1/2006;. I
Should pg_dumpall be using the "SET default_tablespace = foo" method as
well?
---
Florian G. Pflug wrote:
> Chander Ganesan wrote:
> > Tom Lane wrote:
> >> Chander Ganesan <[EMAIL PROTECTED]> writes:
> >>
> >>> I'd like to
Doc patch applied. I must have missed the second attachment.
---
Tom Lane wrote:
> "Magnus Hagander" <[EMAIL PROTECTED]> writes:
> > Actually, the docs *were* submitted. See
> > http://archives.postgresql.org/pgsql-patches/2
On fös, 2006-06-16 at 11:39 +0530, surabhi.ahuja wrote:
[in response to Jim advising not to set random_page_cost=1]
> in that case, should i set
> enable_seqscan parameter to off at the time of starting postmaster?
that is unlikely to be a good stategy.
> because i have seen that even thou the
In response to "Nitin Verma" <[EMAIL PROTECTED]>:
> $ ls -al pgsqldb/pg_xlog
> total 32816
> drwx--2 nitinverma root 4096 Jun 16 19:53 .
> drwx--6 nitinverma root 4096 Jun 16 19:33 ..
> -rw---1 nitinverma root 16777216 Jun 16 20:08 0001
> -rw
$ ls -al pgsqldb/pg_xlog
total 32816
drwx--2 nitinverma root 4096 Jun 16 19:53 .
drwx--6 nitinverma root 4096 Jun 16 19:33 ..
-rw---1 nitinverma root 16777216 Jun 16 20:08 0001
-rw---1 nitinverma root 16777216 Jun 16 19:45
Thanx so much which would really help
-Original Message-
From: Richard Huxton [mailto:[EMAIL PROTECTED]
Sent: Friday, June 16, 2006 6:29 PM
To: Nitin Verma
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] VACUUMing sometimes increasing database size /
sometimes
Nitin Verma wrote:
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> Actually, the docs *were* submitted. See
> http://archives.postgresql.org/pgsql-patches/2005-12/msg00375.php.
> Applied per
> http://archives.postgresql.org/pgsql-patches/2006-03/msg00080.php, I
> think it's just the docs that were missed.
Ah. I had
On Wed, 2006-06-14 at 18:34 -0400, Chris Browne wrote:
> kleptog@svana.org (Martijn van Oosterhout) writes:
>
> > On Tue, Jun 13, 2006 at 05:23:56PM -0400, Christopher Browne wrote:
> >> > [3]
> >> > http://www.intelligententerprise.com/010327/celko_online.jhtml;jsessionid=NDIHEWXGL4TNKQSNDBNSKHS
> > > 8.2 will have direct LDAP authentication without PAM.
> >
> > That code's going to go away real soon if some
> documentation doesn't
> > show up. I can't believe Bruce was sloppy enough to accept
> a feature
> > patch with zero documentation.
>
> ?? I thought I had sent in the docs for
> > 8.2 will have direct LDAP authentication without PAM.
>
> That code's going to go away real soon if some documentation
> doesn't show up. I can't believe Bruce was sloppy enough to
> accept a feature patch with zero documentation.
?? I thought I had sent in the docs for that. Will dig thro
"Magnus Hagander" <[EMAIL PROTECTED]> writes:
> 8.2 will have direct LDAP authentication without PAM.
That code's going to go away real soon if some documentation doesn't
show up. I can't believe Bruce was sloppy enough to accept a feature
patch with zero documentation.
r
Chander Ganesan wrote:
Tom Lane wrote:
Chander Ganesan <[EMAIL PROTECTED]> writes:
I'd like to suggest that a feature be added to pg_dumpall to remove
tablespace definitions/creation from the output. While the inclusion
is important for backups - it's equally painful when attempting to
mig
Nitin Verma wrote:
if your application depends on things that changed between 7.3 and 8.1. >>
Postgres tends to become more strict with every release, so
there are things you got away with in 7.3 which now cause an error
message.
Do we have change lists where I can see all the changes between
Kenneth Downs wrote:
AFAIK it has always been the case that you should expect to have to dump
out your databases and reload them for version upgrades.
Is anybody over at the dev team considering what an onerous burden this
is? Is anyone considering doing away with it?
Far from trivial. You
>> if your application depends on things that changed between 7.3 and 8.1. >>
Postgres tends to become more strict with every release, so
>> there are things you got away with in 7.3 which now cause an error
>> message.
Do we have change lists where I can see all the changes between 7.3 and 8.1,
m
On Thu, 15 Jun 2006, snacktime wrote:
Anyone have any tips for minimizing downtime when upgrading? So far
we have done upgrades during scheduled downtimes. Now we are getting
to the point where the time required for a standard dump/restore is
just too long. What have others done when downtime
Douglas McNaught wrote:
"Nitin Verma" <[EMAIL PROTECTED]> writes:
Will 7.3.2 Dump made up of copies using pg_dump import without any migration
to 8.0+? What I need isn't a once process and will go as a automated script,
in a way that user will not even get to know (if he isn't reading that logs
"Nitin Verma" <[EMAIL PROTECTED]> writes:
> Will 7.3.2 Dump made up of copies using pg_dump import without any migration
> to 8.0+? What I need isn't a once process and will go as a automated script,
> in a way that user will not even get to know (if he isn't reading that logs)
> Database version
snacktime wrote:
Anyone have any tips for minimizing downtime when upgrading? So far
we have done upgrades during scheduled downtimes. Now we are getting
to the point where the time required for a standard dump/restore is
just too long. What have others done when downtime is critical? The
on
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
DataIntellectSent: 15 June 2006 20:56To:
pgsql-general@postgresql.orgSubject: Re: [GENERAL] postgres
password
You cannot use the postgres account without some tweaks, Sorry I don't
remember where I foun
You cannot use the postgres account without some tweaks, Sorry I
don't remember where I found this info - somewhere in the pgadmin
install docs.
However this works:
Create a new superuser with a password, add connectivity to the pg_hba.conf file if needed and pgadmin should work fine
/Kevi
Doc section 4.1.2.1 says that in future, backslashes will be treated as
ordinary string characters. It says to use the "E" string prefix to
ensure that backslashes are permanently treated as escape characters.
Question: Aside from "dollar quoting" (Section 4.1.2.2), is there any
way NOW to force
Alban Hertroys wrote:
Hi all,
We're using some 3rd party product that uses inheritence, and the
following query is rather slow on PostgreSQL 7.4.7 (debian stable). Any
suggestions how to speed it up?
We really need this solved. Isn't anybody able to shed some light on
this? Is it possible t
> Hi
>
> I have started to use ldap for user authentication on my systems.
>
> 1 is it possible to get postgres to authenticate against ldap
Yes. With current releases you can do this with PAM, assuming you're on
a platform that can do PAM. If your platform can't do PAM (for example,
Windows), y
Will 7.3.2 Dump made up of copies using pg_dump import without any migration
to 8.0+? What I need isn't a once process and will go as a automated script,
in a way that user will not even get to know (if he isn't reading that logs)
Database version changed. Considering that even a remote problem
snacktime wrote:
Anyone have any tips for minimizing downtime when upgrading? So far
we have done upgrades during scheduled downtimes. Now we are getting
to the point where the time required for a standard dump/restore is
just too long. What have others done when downtime is critical? The
onl
Jasbinder Bali wrote:
well, i start it from anywhere, it would close abnormally..
And you don't get an error message in the terminal? Not even "process
exited on signal XXX"?
SELinux is interfering? like how?
It sets policies for what applications can access what files/other
resources. I
46 matches
Mail list logo
