hi all ,
i want to retrieve records from my java program
i am getting these exceptions
pls help me
No class found for refcursor
at org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1C
onnection.java:693)
at org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(Ab
Dick Davies <[EMAIL PROTECTED]> writes:
> I notice pg_dump does'nt have a '-P' flag to provide a password,
~/.pgpass is the preferred solution.
http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html
regards, tom lane
---(end of broadcast)-
On Thu, 2005-02-10 at 14:32, Joel Fradkin wrote:
> I tried changing the directory in postgres.conf, but it is looking for a
> PG_VERSION?
> Do I need to do a dbinti or something?
> I only want my data to be in the pgdata drive I want the rest in
> /var/lib/pgsql/data
> I actually want my wal in /wa
I notice pg_dump does'nt have a '-P' flag to provide a password, so I assume
you generally use it to pull data through a socket.
I need to run it remotely (to dump a live db and clone its structure to a test
db for unit testing), has anyone got a way to do this?
I've tried 'echo pass | pg_dump -h
* Tom Lane <[EMAIL PROTECTED]> [0231 20:31]:
> Dick Davies <[EMAIL PROTECTED]> writes:
> > I'm probably missing something obvious, but how do I revoke the 'create
> > database'
> > privilege for a user?
>
> See ALTER USER.
Thanks Tom. As usual I found it 15 seconds after posting :)
--
'Power c
Dick Davies <[EMAIL PROTECTED]> writes:
> I'm probably missing something obvious, but how do I revoke the 'create
> database'
> privilege for a user?
See ALTER USER.
regards, tom lane
---(end of broadcast)---
TIP 6: Have yo
I tried changing the directory in postgres.conf, but it is looking for a
PG_VERSION?
Do I need to do a dbinti or something?
I only want my data to be in the pgdata drive I want the rest in
/var/lib/pgsql/data
I actually want my wal in /wal (a different drive as well).
I have the instructions
0) ba
I'm probably missing something obvious, but how do I revoke the 'create
database'
privilege for a user?
--
'Oh, wait you're serious. Let me laugh even harder.'
-- Bender
Rasputin :: Jack of All Trades - Master of Nuns
---(end of broadcast)---
Pascal Van Puymbroeck wrote:
> I'm not sure if this is the best method but I use the:
>
> pgsql -d dbase -U ppk -f e:\\Test.imp < passwd.txt
>
> Where passwd.txt holds the password for the user specified.
Also see .pgpass in the libpq manual section. It allows you to store
passwords in a file f
Adam Witney wrote:
> On 10/2/05 5:45 pm, "Bruce Momjian" wrote:
>
> > Adam Witney wrote:
> >>
> >> Something strange has just appeared in my database, can anyone explain this
> >> duplication of columns:
> >>
> >> test=# \d plate_reporter
> >> Table "plate_
I'm not sure if this is the best method but I use the:
pgsql -d dbase -U ppk -f e:\\Test.imp < passwd.txt
Where passwd.txt holds the password for the user specified.
Hope this helps you out.
Pascal Van Puymbroeck
ZENON productions bvba
---(end of broadcast)--
On 10/2/05 5:45 pm, "Bruce Momjian" wrote:
> Adam Witney wrote:
>>
>> Something strange has just appeared in my database, can anyone explain this
>> duplication of columns:
>>
>> test=# \d plate_reporter
>> Table "plate_reporter"
>> Column | Ty
Adam Witney wrote:
>
> Something strange has just appeared in my database, can anyone explain this
> duplication of columns:
>
> test=# \d plate_reporter
> Table "plate_reporter"
> Column | Type | Modifiers
> ---
Something strange has just appeared in my database, can anyone explain this
duplication of columns:
test=# \d plate_reporter
Table "plate_reporter"
Column | Type | Modifiers
---+-+
Title: Check user
Hello there,
Im using PostgreSQL 7.2.1 and I have a user who connects remotely to a database. This connection is almost permanent but sometimes is lost. I want to know where I can check in Postgres i.e.(log file) that the connection from the current user is lost so I make
15 matches
Mail list logo
