Re: [BUGS] Fwd: Bug#380047: libpq-dev: no declaration for pg_encoding_to_char

2006-07-30 Thread Martin Pitt
Hi Alvaro,

Alvaro Herrera [2006-07-29 21:41 -0400]:
> The correct solution seems to be that the libpq-dev package must include
> mb/pg_wchar.h.  

Many thanks for your explanations. This is trivial to do.

> > [1] http://bugs.debian.org/18858
> 
> I find this one more closely related to the topic at hand:
> 
> http://bugs.debian.org/318858

Erm, yes, yay for my typos. :/ 
/me looks on the floor for a dropped '3'.

Have a nice Sunday,

Martin

-- 
Martin Pitt  http://www.piware.de
Ubuntu Developer   http://www.ubuntulinux.org
Debian Developerhttp://www.debian.org


signature.asc
Description: Digital signature


[BUGS] BUG #2556: ODBC driver version 2.00 doesn't publish functions correctly

2006-07-30 Thread Jon Watte

The following bug has been logged online:

Bug reference:  2556
Logged by:  Jon Watte
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 7.3
Operating system:   Linux 2.4
Description:ODBC driver version 2.00 doesn't publish functions
correctly
Details: 

Define a function using pgAdmin III. Let's say we call it "next_id()" and
it's defined as "select max(id)+1 as next from sometable;".

In Data Sources view in Visual Studio 2005, "configure dataset" on a dataset
that connects to this database.

Notice that the function doesn't show up under "functions" but it does show
up under "stored procedures".

Check the stored procedure checkbox for the "next_id" function, to include
it in your data set view.

You will get an error from visual studio saying that the "next_id" stored
procedure wasn't actually found.

It seems to me as if the ODBC driver has some confusion as to whether it's a
function or a stored procedure, and this confusion means that Visual Studio
can't use it.

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org


[BUGS] BUG #2555: runtime error 80040e21

2006-07-30 Thread Jonas Bruhn

The following bug has been logged online:

Bug reference:  2555
Logged by:  Jonas Bruhn
Email address:  [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system:   Windows 2000 Pro
Description:runtime error 80040e21
Details: 

I'm using VB6, and trying to update a table. It is all happening on my home
pc with IIS running too. I can download the table to a datagrid, bit I can't
type any text i a textbox and update it whith out the error occuring. Here
is the code and some remarks afterwards:

Private Sub command2_click()

Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset

Set cn = New ADODB.Connection

cn.Open "Provider=PostgreSQL.1;Password=***;User ID=postgres;Data
Source=localhost;Location=***" ';Extended Properties="""

Set rs = New ADODB.Recordset
rs.CursorLocation = adUseClient
rs.Open "select tilbudspris, materialer from efterkalk", cn,
adOpenKeyset, adLockOptimistic

rs.AddNew
debug here ---  rs("tilbudspris").Value = Text1.Text
rs("materialer").Value = Text2.Text
rs.Update

Set rs.ActiveConnection = Nothing
Set rs = Nothing
cn.Close
Set cn = Nothing

End Sub

Remarks:
The columns in the table is set to text.
I've tried to write rs!tilbudspris and rs!materialer.
I've tried to trim(text1.text)
I've tried adopenstatic
I've tried rs.movefirst

I can't recognise where the problem should be, if it isn't a bug.

Best regards

Jonas Bruhn

---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq