[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 followi

[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, Y

[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

[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 I

[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

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 u

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'

[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