I'm not sure this is the right place to enquire...
I'm trying to connect to a postgres datanbase with Java.
import java.sql.*;
public static void main(String[] args) {
// TODO code application logic here
try{
System.out.println("Starting...");
Class.fo
Dave Coventry wrote:
I'm not sure this is the right place to enquire...
I'm trying to connect to a postgres datanbase with Java.
does that sample code hang? do you get an error?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
htt
donniehan wrote:
> Dear Tom,
>
> I'm sorry to bother you. i really care about this behavior, but i couldn't
> find the discussions you mentioned in pgsql-hackers archives.
> Would you please tell me more about the discussions(about date? the related
> issue?), so that i can search it and find it
Dave,
It looks like the postgresql.jar archive is not in your CLASSPATH.
[]s, Fernando Lozano
> I'm not sure this is the right place to enquire...
>
> I'm trying to connect to a postgres datanbase with Java.
>
> import java.sql.*;
>
> public static void main(String[] args) {
> //
Sure the url looks bad.
Shoudl be something like:
http://jdbc.postgresql.org/dbname
Anyway you cen find more help about jdbc connectivity to postgres here:
http://jdbc.postgresql.org/
Dave Coventry ha scritto:
> I'm not sure this is the right place to enquire...
>
> I'm trying to connect to a
Alvaro Herrera writes:
> donniehan wrote:
>> I'm sorry to bother you. i really care about this behavior, but i couldn't
>> find the discussions you mentioned in pgsql-hackers archives.
>> Would you please tell me more about the discussions(about date? the related
>> issue?), so that i can search
On Sat, Dec 19, 2009 at 7:16 PM, Christophe Pettus wrote:
>
>> I understand that it is not possible to read previous rows without
>> creating hack using triggers.
>
> As noted above, that's not correct. You cannot access new values of a
> particular row within a single UPDATE statement, but you d
On Dec 24, 2009, at 12:53 PM, Adrian Klaver wrote:
On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote:
This is sort of a PostgreSQL question/sort of a general SQL question,
so I apologize if this isn't the best place to ask. At any rate, I
know in PostgreSQL you can issue a command
Hi,is there away to check with DB Link if one record exists/not exists in a
remote database?
Something like...
SELECT item_id FROM TABLE A WHERE NOT EXISTS (SELECT 1 FROM TABLE B WHERE
A.item_id=B.item_id)
Where Table A is on a Local machine and Table B is on a remote machine.
Thanks for any hel
I've some tables that are just cache.
I'd like to just dump the table schema without dumping the table
contend.
I think I could do it in 2 steps but I'd like to avoid it.
Is there a way?
thanks
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
--
Sent via pgsql-general mailing list (pgs
On 28/12/2009 18:41, Ivan Sergio Borgonovo wrote:
> I'd like to just dump the table schema without dumping the table
> contend.
pg_dump -s -t
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
2009/12/29 Israel Brewster :
>
> On Dec 24, 2009, at 12:53 PM, Adrian Klaver wrote:
>
>> On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote:
>>>
>>> This is sort of a PostgreSQL question/sort of a general SQL question,
>>> so I apologize if this isn't the best place to ask. At any rate,
On Mon, 28 Dec 2009 19:39:36 +
Raymond O'Donnell wrote:
> On 28/12/2009 18:41, Ivan Sergio Borgonovo wrote:
>
> > I'd like to just dump the table schema without dumping the table
> > contend.
> pg_dump -s -t
My fault. I was not clear enough.
I'd like to make a "mostly" full backup, exclu
On 28/12/2009 20:20, Ivan Sergio Borgonovo wrote:
> On Mon, 28 Dec 2009 19:39:36 +
> Raymond O'Donnell wrote:
>
>> On 28/12/2009 18:41, Ivan Sergio Borgonovo wrote:
>>
>>> I'd like to just dump the table schema without dumping the table
>>> contend.
>
>> pg_dump -s -t
>
> My fault. I was
Hi:
I cannot dump any database from my server. When I try to do it i
receive this error
pg_dump: The command was: SELECT tableoid, oid, nspname, (select usename
from pg_user where nspowner = usesysid) as usename, nspacl FROM pg_namespace
I checked the pg_user database and I found this:
Hi:
I cannot dump any database from my server. When I try to do it i
receive this error
pg_dump: The command was: SELECT tableoid, oid, nspname, (select usename
from pg_user where nspowner = usesysid) as usename, nspacl FROM pg_namespace
I checked the pg_user database and I found this:
Ivano Luberti wrote:
Sure the url looks bad.
Shoudl be something like:
http://jdbc.postgresql.org/dbname
say huh?
http://jdbc.postgresql.org/documentation/84/load.html
http://jdbc.postgresql.org/documentation/84/connect.html
says what he's doing is fine.
--
Sent via pgsql-general mailin
Hi:
I cannot dump any database from my server. When I try to do it i
receive this error
pg_dump: The command was: SELECT tableoid, oid, nspname, (select usename
from pg_user where nspowner = usesysid) as usename, nspacl FROM pg_namespace
I checked the pg_user database and I found this:
=?ISO-8859-1?Q?Gast=F3n_Quiroga?= writes:
> I checked the pg_user database and I found this:
> postgres=# select * from pg_user;
> usename| usesysid | usecreatedb | usesuper | usecatupd |
> passwd | valuntil | useconfig
> ---+--+-+--+
Thanks for your reply Tom, and sorry for the duplicated e-mails.
It's Postgres version 8.0.8
Thank you
Gastón Quiroga
Allytech S.A.
Tom Lane wrote:
=?ISO-8859-1?Q?Gast=F3n_Quiroga?= writes:
I checked the pg_user database and I found this:
postgres=# select * from pg_use
=?ISO-8859-1?Q?Gast=F3n?= writes:
> It's Postgres version 8.0.8
Well, that's pretty ancient, and I see at least one bug in the release
history that could result in duplicated rows. I'd counsel an update to
8.0.something-recent. You can probably delete the extra row using
a WHERE on ctid.
Is there some way to export the postgresql query parse tree in XML format? I
can not locate the API/Tool etc to do that...
thanks
-Matt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-g
matt writes:
> Is there some way to export the postgresql query parse tree in XML format?
No, and it probably wouldn't be very useful to you if there was, because
we feel free to whack the internal parsetree representation around in
every release.
regards, tom lane
--
S
Oh sorry, cut and paste mistake
By the way using that syntax he is using he is assuming the server is
running on localhost and the port is the default one
John R Pierce ha scritto:
> Ivano Luberti wrote:
>> Sure the url looks bad.
>> Shoudl be something like:
>>
>> http://jdbc.postgresql.org/dbnam
On Dec 27, 2009, at 6:59 PM, donniehan wrote:
> Hi Tom,
>
> Thanks for your information. One more question, if i wanna get the accurate
> information about grantor(Sometimes the application just needs the
> information), what can i do?
> Apparently i cannot get from the acls, so where can i g
On Monday 28 December 2009 12:13:46 pm Greenhorn wrote:
> 2009/12/29 Israel Brewster :
> > On Dec 24, 2009, at 12:53 PM, Adrian Klaver wrote:
> >> On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote:
> >>> This is sort of a PostgreSQL question/sort of a general SQL question,
> >>> so I ap
On Mon, Dec 28, 2009 at 6:34 PM, Adrian Klaver wrote:
> On Monday 28 December 2009 12:13:46 pm Greenhorn wrote:
>> 2009/12/29 Israel Brewster :
>> > On Dec 24, 2009, at 12:53 PM, Adrian Klaver wrote:
>> >> On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote:
>> >>> This is sort of a Post
Trying to install postgis on LINUX machine, need to find the geos-
config file, as seems it is no where to be found after download of
postgis in the ./configure step, is there anyone that can give me a
clue on how to find this file? Ultimate goal is to get postgis working
so we can use geom data ty
Nick,
You'll find GEOS questions get answered better on the GEOS mailing
list (http://lists.osgeo.org/mailman/listinfo/geos-devel), BUT:
If ./configure is not finding g++ then odds are, you don't have it
installed (type g++ on the commandline, see what happens). Use your
package manager to do a se
On 12/28/2009 08:24 PM, Nick wrote:
Trying to install postgis on LINUX machine, need to find the geos-
config file, as seems it is no where to be found after download of
postgis in the ./configure step, is there anyone that can give me a
clue on how to find this file? Ultimate goal is to get post
On Mon, 2009-12-28 at 18:24 -0800, Nick wrote:
> Trying to install postgis on LINUX machine,
Which Linux? Many distros have PostGIS and related stuff in their
repositories. You don't need to compile them.
> need to find the geos-config file, as seems it is no where to be found
> after download of
On Dec 28, 7:20 pm, a...@squeakycode.net (Andy Colson) wrote:
> On 12/28/2009 08:24 PM, Nick wrote:
>
>
>
> > Trying to install postgis on LINUX machine, need to find the geos-
> > config file, as seems it is no where to be found after download of
> > postgis in the ./configure step, is there anyon
Nick writes:
> 'g++' or g++ says -bash g++: command not found
So you haven't got it installed.
> distro is red hat
"Red Hat" is pretty darn nonspecific, but on recent Fedora g++ is
part of the gcc-c++ package.
regards, tom lane
--
Sent via pgsql-general mailing list (
Nick wrote:
'g++' or g++ says -bash g++: command not found
distro is red hat
Assuming thats RHEL5,
yum install gcc-c++
if its RHEL4 or earlier, use up2date instead. either of these will
require a RHN subscription to be activated.
if it is in fact, centos 3,4,5,
yum install g
35 matches
Mail list logo
