By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,374 Members | 2,014 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,374 IT Pros & Developers. It's quick & easy.

Base type OIDs

P: n/a
I'm trying to properly tag the types of the parameters I'm passing
into PQexecParams, as it seems to be the right thing to do, and it's
not that big a deal given my existing code base. Unfortunately I'm
running into a problem figuring out what I should be using for the
tag numbers.

I originally thought that the enum in include/ecpgtype.h was the
place to go, but no joy there -- those numbers weren't right. (Or at
least they threw errors) So instead I tried
src/include/catalog/pg_type.h for the type numbers. (Which seemed a
better bet, as the docs for PQftype say to reference this file)
Unfortunately this isn't working either. I'm trying to use these base
type numbers:

text data: 1043
numbers: 1700
dates: 1082

which correspond to the VARCHAROID, NUMERICOID, and DATEOID
constants. It *seems* right, but when I do I get back the error:

DB error is: ERROR: unsupported format code: 1043

I'm at a bit of a loss right now. What *should* I be using here? (Or
is there something simple that I'm missing?)
--
Dan

--------------------------------------it's like this-------------------
Dan Sugalski even samurai
da*@sidhe.org have teddy bears and even
teddy bears get drunk

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Dan Sugalski <da*@sidhe.org> writes:
DB error is: ERROR: unsupported format code: 1043


You're putting it in the format parameter, not the datatype parameter
....

regards, tom lane

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

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 23 '05 #2

P: n/a
At 3:41 PM -0400 10/26/04, Tom Lane wrote:
Dan Sugalski <da*@sidhe.org> writes:
DB error is: ERROR: unsupported format code: 1043


You're putting it in the format parameter, not the datatype parameter


D'oh! Darned reused array pointers...

Thanks.
--
Dan

--------------------------------------it's like this-------------------
Dan Sugalski even samurai
da*@sidhe.org have teddy bears and even
teddy bears get drunk

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.