Re: [HACKERS] Array types

On Wed, Apr 8, 2009 at 4:11 PM, John Lister wrote: Cheers for the pointers. Am i right in thinking that if i get an array of arrays, the nested arrays are sent in wire format as well - it seems to be from the docs. No, you can't easily get an array of arrays in Postgres. You ca

Re: [HACKERS] Array types

.. On Wed, Apr 8, 2009 at 10:48 AM, John Lister wrote: Following this up, is there any docs on the binary wire format for arrays? Thanks Does java wrap libpq? If so, your best bet is probably going to be to go the libpqtypes route. If you want help doing that, you are more than welcome to

Re: [HACKERS] Array types

value? This seems to be what the lbound value is for... or is this a addition to deal with nulls eg, {null, null, null, 4} would have a lbound of 3 (or both) Thanks - Original Message - From: "Andrew Chernow" To: "John Lister" Cc: Sent: Wednesday, Ap

Re: [HACKERS] Array types

Following this up, is there any docs on the binary wire format for arrays? Thanks - Original Message - From: John Lister To: pgsql-hackers@postgresql.org Sent: Tuesday, April 07, 2009 7:54 PM Subject: [HACKERS] Array types Hi, using v8.3.5 and a number of client libraries

Re: [HACKERS] Array types

brilliant i'll give it a go... Now to sort out java :) James Pye wrote: On Apr 7, 2009, at 12:54 PM, John Lister wrote: Cheers, nice to know it is possible... Now to see if i can get java/python to do the same :) or to use a modified libpq somehow... http://python.projects.postgresq

Re: [HACKERS] Array types

Cheers, nice to know it is possible... Now to see if i can get java/python to do the same :) or to use a modified libpq somehow... Merlin Moncure wrote: On Tue, Apr 7, 2009 at 3:35 PM, John Lister wrote: Does libpqtypes pass the array "over the wire" as an array? Ideally i&#x

Re: [HACKERS] Array types

Does libpqtypes pass the array "over the wire" as an array? Ideally i'd like to do this with jdbc, but might give me a pointer... Thanks - Original Message - From: "Andrew Chernow" To: "John Lister" Cc: Sent: Tuesday, April 07, 2009 8:15 PM

Re: [HACKERS] Array types

This is something the client code would request (or not). It would not be sensible to try to force it from the server side, since if the client doesn't request it it's likely that the client wouldn't understand the data format. Cheers for the quick reply, any chance of a pointer to the protocol

[HACKERS] Array types

Hi, using v8.3.5 and a number of client libraries (java, python, pgadmin) and playing about with arrays. They all return arrays as text, is it possible to configure postgresql to return an array in native form (does postgresql support such a thing)? This is using both the simple and extended qu

Re: [HACKERS] Database corruption help

Cheers, i'll give it ago. I'm probably going to do a full restore over the weekend while i can shut things down without too many complaints... I can save any of the files if you are interested in them later on... JOHN Tom Lane wrote: John Lister writes: Any help would be appr

Re: [HACKERS] Database corruption help

learned about the -P option to the server which may have helped here). The corruption in pg_class manifested itself as multiple rows (for this and another table) with the same OIDs So not sure at what point what if anything got corrupted and what my subsequent actions did to compound this.. T

[HACKERS] Database corruption help

Originally in psql-admin, but copied here at the request of Tom to.. Story so far, transaction log archiving went wrong causing the transaction log disk to fill up. Foolishly i deleted the unarchived transaction logs (early monday morning) which required a pg_resetxlog to get the db up and run