[BUGS] tablefunc extension

2013-09-19 Thread Carl Clemens
Hi Folks, The following query appears to be correct but fails to execute. \set VERBOSITY verbose select * from crosstab('select claim_id::bigint, patient_id::integer, code_id::text from diagnosis') as dg_list(claim_id bigint, patient_id integer, code_id text); ERROR: 42601: return and sql tu

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-19 Thread Saravanan Nagarajan
Hi Michael & Team, No anti-virus is running on that machine. I started the DB using Windows service. Its working fine. I am trying to start the DB with different user credentials using command prompt, the DB is not started. I provided full permission for everyone to postgres folder and its sub fol

Re: [BUGS] BUG #8449: ODBC Failure with Access 10

2013-09-19 Thread Michael Paquier
On Thu, Sep 12, 2013 at 10:21 AM, wrote: > Bug reference: 8449 > I'm not able to link in Access to the table "map". I get an ODBC error and > in the table fields are no data, it returns "#Name?". > > Any idea what is wrong ? You should be more precise here: - What is the version of ODBC driv

Re: [BUGS] BUG #8452: COPY command pgadmin

2013-09-19 Thread Michael Paquier
On Sat, Sep 14, 2013 at 4:15 PM, wrote: > in short, for pgadmin... This feature request is related to PGAdmin and not Postgres core. You should send such requests to the PGAdmin mailing lists which are listed here: http://www.pgadmin.org/support/list.php Regards, -- Michael -- Sent via pgsql

Re: [BUGS] Postgis extension bug w/ OpenBSD

2013-09-19 Thread Michael Paquier
On Tue, Sep 17, 2013 at 4:48 PM, Marcelo Bacha wrote: > I have an OpenBSD 5.3 server, with PostgreSQL 9.3.0, which seems to work > fine. I´m trying to install on it, which always worked fine. Postgres is working fine as you mention, and only PostGIS development failed. Based on the information ab

Re: [BUGS] Cant start PostgreSQL Using command prompt

2013-09-19 Thread Michael Paquier
On Tue, Sep 17, 2013 at 1:52 AM, Saravanan Nagarajan wrote: > In pglog_txt, > > LOG: could not bind IPv6 socket: No error > HINT: Is another postmaster already running on port 33307? If not, wait a > few seconds and retry. > LOG: could not bind IPv4 socket: No error > HINT: Is another postmast