after I enter the password I get
pg_restore: creating FUNC PROCEDURAL LANGUAGE plpgsql_call_handler()
pg_restore: [archiver (db)] could not execute query: ERROR: function
"plpgsql_call_handler" already exists with same argument types
pg_restore: *** aborted because of error
however after lookin
I know that
pg_dumpall -g
gives you user/groups only.
Dilipan
Nitin Jawarkar wrote:
hello,
I have create database and run "psql -d databasename -f
filename(.out)" so according to this it restores all data but not
create users, i want to create users so how it can be done plz tell
Here's what I do:
pg_dump testdb > test.psql
dropdb testdb
createdb testdb
psql -f test.psql testdb
But there are 2 things where it won't accept it's own output as input.
# CASE #1
psql:test.psql:18: ERROR: unrecognized configuration parameter
"default_with_oids"
# CASE #2
psql:t
Michael Hipp <[EMAIL PROTECTED]> writes:
> # CASE #1
> psql:test.psql:18: ERROR: unrecognized configuration parameter
> "default_with_oids"
Apparently you're trying to use an 8.0 pg_dump with a 7.4 backend.
> # CASE #2
> psql:test.psql:42: ERROR: invalid input syntax for type t
This is one of the queries that work,and is the first
in a 4 level nested query
where do I find how to interpret explains???
thanks in advance,
Carlos.
mate=# explain analyze select * from vdocinvdpre;
Tom Lane wrote:
Michael Hipp <[EMAIL PROTECTED]> writes:
# CASE #1
psql:test.psql:18: ERROR: unrecognized configuration parameter
"default_with_oids"
Apparently you're trying to use an 8.0 pg_dump with a 7.4 backend.
# CASE #2
psql:test.psql:42: ERROR: invalid input syntax for t
I've looked in the archives searching on oid and 'access' (microsoft)
to see how others have handled migration from data bases in ms-access
to postgresql. MS access has an auto-inc field that is used frequently
as a uniq id. Seems the OID has the same function. Yet, I've seem
parts of messages tha
I'm trying to move data from an Oracle
database into postgresql 7.4.3. I have a program that is extracting
data and writing it to an sql script as a long series of inserts
(20,000 at a time). When I run these scripts using psql, I
occassionally get a problem that is reported as
ERROR: canc
"Paul B. Anderson" <[EMAIL PROTECTED]> writes:
> I'm trying to move data from an Oracle database into postgresql 7.4.3.
> I have a program that is extracting data and writing it to an sql script
> as a long series of inserts (20,000 at a time). When I run these
> scripts using psql, I occassio
On Mon, Nov 08, 2004 at 03:36:26PM -0700, David Bear wrote:
> I've looked in the archives searching on oid and 'access' (microsoft)
> to see how others have handled migration from data bases in ms-access
> to postgresql. MS access has an auto-inc field that is used frequently
> as a uniq id. Seems
I'm getting fairly frustrated here. I'm trying to populate a table
using psql copy command. The file lives in the client machine where
psql is running, not on the back end. I assume from the readings that
I can you the \copy command to get to data in my clients file system.
Yet, its not working.. H
I'm getting fairly frustrated here. I'm trying to populate a table
using psql copy command. The file lives in the client machine where
psql is running, not on the back end. I assume from the readings that
I can you the \copy command to get to data in my clients file system.
Yet, its not working..
Carlos Lopez <[EMAIL PROTECTED]> writes:
> This is one of the queries that work,and is the first
> in a 4 level nested query
Do you really need UNION (as opposed to UNION ALL) in this query?
The EXPLAIN shows that almost half the runtime is going into the
sort/uniq to eliminate duplicates ...
David Bear <[EMAIL PROTECTED]> writes:
> npcenter=> \copy "contactName" from
> "/home/iddwb/data/copp/dev/npcenter/contactName.txt"
> "/home/iddwb/data/copp/dev/npcenter/contactName.txt": No such file or
> directory
> I must be missing something very obvious.. Help...
Use single quotes, or none
14 matches
Mail list logo
