[GENERAL] It's a test
test
[GENERAL] backup and restore
Hi all. I have a backup of my database created with pg_dump, pg_dump -o mydb > mydb.pg_dump Use -o option so there are many objetcs. I have restore dabase with cat mydb | psql mydb When enter in mydb all appear correct, but when I try to get a object the following error apper: ErrorFastPath call returned ERROR: Relation 66016 does not exist where 66016 is the oid of my object. How can I restory my database? Thanks in advance Gabi -- Gabriel López Millán Facultad de Informática -Universidad de Murcia 30001 Murcia - España (Spain) Telf: +34-968-364644 E-mail: [EMAIL PROTECTED]
[GENERAL] The type conversion CAST does not work ??
The type conversion CAST does not work ? I would like to convert date in string and the reverse! Have I an obsolete version of PostGres ?? Thank Jeremy Ergisi - PARIS - FRANCE ___ Do You Yahoo!? -- Pour dialoguer en direct avec vos amis, Yahoo! Messenger : http://fr.messenger.yahoo.com
[GENERAL] converting .xls to delimited file
Is there any way to convert an Excel file (".xls")
to a delimited file? Maybe using sed?
Bill
[GENERAL] What's it? "LockRelease:"
Hi All! Sorry for my english. I use 6.5.2 and C interface. When program has been run i've recieved the message: NOTICE: LockRelease: locktable lookup failed, no lock /*The part of code:*/ PQexec(conn,"declare grh1 cursor for select x1 from test where x1='RRR'"); res10=PQexec(conn,"fetch all in grh1"); PQexec(conn,"close grh1"); /*end_of_part*/ The program runs well without this part. Thanks in advance Vitaliy
[GENERAL] Re: trouble with db-restore
Tried this morning to recreate the problem, but could not (as of v 7.0.2). Perhaps it was 7.0.1? Sorry for not reporting earlier. I'll keep my eye out for this issue in the future. --rob - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "rob" <[EMAIL PROTECTED]> Cc: "Heiko Irrgang" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 09, 2001 11:43 PM Subject: Re: trouble with db-restore > "rob" <[EMAIL PROTECTED]> writes: > > I have seen that before on my own system. Same PG version for dump/restore. > > Wasn't a big deal for me to redo the views since I had so few (i.e. 1) I > > never reported it, but it happened more than once. > > You should have reported it :-( ... as I said, I hadn't heard about this > failure mode before. I assume that the dump script shows the views as > CREATE TABLE not CREATE VIEW? I'd ask you to send me the dump script, > but it's unlikely to tell me much if the error is upstream. Can you > provide a script for creating a view that pg_dump fails to dump > correctly? > > regards, tom lane >
[GENERAL] Re: converting .xls to delimited file
Try saving it as a .CSV file and then you can choose the delimiter you
want.
William Staniewicz wrote:
> Is there any way to convert an Excel file (".xls")
> to a delimited file? Maybe using sed?
>
> Bill
Re: [GENERAL] xml middleware
I was even thinking more along the lines of a java program that acts as an interface where it receives a query from the user, sends it to postgreql via jdbc, receives the result set, translates it into XML and returns it to the user. Performance would be the isue, but something like that would be best suited for internet applications and the performance is not as big of an issue. Plus, if you plan on using XML, you are expecting to take performance hits anyway. Adam Lang Systems Engineer Rutgers Casualty Insurance Company http://www.rutgersinsurance.com - Original Message - From: "Joseph Shraibman" <[EMAIL PROTECTED]> To: "Adam Lang" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, January 09, 2001 8:55 PM Subject: Re: [GENERAL] xml middleware > According to the the tuning document released by GreatBridge, postgres > is relational as well as object oriented. Since it is object-oriented > methinks it shouldn't be a problem to translate a DTD to a database def, > but trying to figure out the postgres backed code gives me a headache. > > Basically what is needed: > > 1) A parser to create a database schema from an XML DTD. > 2) A parser to translate SELECT /root/element1 FROM table WHERE > /root/element1@param1 = "foo"; into a database query. Could be tricky > because (I think) element1 has to be stored in an array field because > there might be more than one of them, and I'm not sure how to do a > select on an array element. I really don't know how the > object-oriented-ness of postgress works, the only docs only seem to > cover the relational paradigm. > > > Adam Lang wrote: > > > > Not that I know of, but a couple people have been toying with the idea of > > starting something like that... I think we are mostly all talk right now. :) > > > > Adam Lang > > Systems Engineer > > Rutgers Casualty Insurance Company > > http://www.rutgersinsurance.com > > - Original Message - > > From: "Peter Cheng" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Tuesday, January 09, 2001 4:01 AM > > Subject: [GENERAL] xml middleware > > > > > Hi, > > > > > > Does Postgres provide xml middleware? > > > If so, would anyone tell me where I can get it, > > > thanks. > > > > > > - Peter > > > > > > > > > ©_¼¯¹q¤l«H½c¡E·¾³q¤ß¥@¬É http://mail.kimo.com.tw > > > < ºô ¸ô ¥Í ¬¡¡EºÉ ¦b ©_ ¼¯ > http://www.kimo.com.tw > > -- > Joseph Shraibman > [EMAIL PROTECTED] > Increase signal to noise ratio. http://www.targabot.com
Re: [GENERAL] Re: COPY error: pqReadData() -- backend closed thechannel unexpectedly
>> general opinion on the Cobalt mailing lists is that upgrading Postgre is >> a very delicate task. [SNIP] > >Check, at least not without practicing on a spare machine first ;-). > >One thing to think about is that there's no fundamental reason why you'd >have to update the version of Postgres used by the OS. You could >install 7.0.* alongside 6.5, use 7.0 for your own purposes and leave the >OS untouched. Yes, I do this myself with perl and python. And if I had a spare and local Cobalt RaQ3, I'd try it with postgre. But again, I won't try this with our public web server. When it comes to installing software on various unix flavors, I am able to compile from source. If program does not work right away I normally can beat it into submission. Even if I was an order of magnitude more skilled at installs, I don't think I would attempt this particular installation. lee.
RE: [GENERAL] converting .xls to delimited file
Excel can do this for you, if you use File -> Save As...
You will find various file types available. The list will vary according to
the completeness of your Excel installation. I believe that at minimum you
should have "tab delimited text" available, and probably csv as well (don't
use csv, it's evil). If I'm wrong, you'll need to get the MS Office CD and
reinstall Excel with more options checked...
If you want to import the result into Postgres, beware of CR characters, and
leading/trailing spaces in your fields. Excel will tolerate those spaces in
non text-type fields, but Postgres will not.
> -Original Message-
> From: William Staniewicz [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 10, 2001 10:23 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [GENERAL] converting .xls to delimited file
>
> Is there any way to convert an Excel file (".xls")
> to a delimited file? Maybe using sed?
>
> Bill
[GENERAL] variable name RESULT in PLPGSQL does not work (PG7.1)
Hello everybody, I converted some existing plpgsql-scripts from 7.0.3 to 7.1 (CVS from 2001-01-09) and had problems with a variable RESULT in my script. E.g.: drop function bla(integer); create function bla(integer) returns integer as ' declare RESULT integer; begin RESULT:=$1; return RESULT; end;' language 'plpgsql'; will result in: test=> SELECT bla(4); NOTICE: plpgsql: ERROR during compile of bla near line 2 ERROR: parse error at or near "RESULT" whereas bla will work if I rename RESULT to RESLT. I did not find any documentation about a special variable-name, but a quick grep through the *.c-files did show some results in src/backend/nodes, RESULT seems to be part of executor-"plans". Maybe this behaviour should be documented :-). Best Regards Mirko
