## Igor Korot (ikoro...@gmail.com):
> Another question - do I have to do "DECLARE CURSOR..." or I can just write
> a normal SELECT query?
> For this I followed and example on the libpg page...
Yes. In fact, "libpq Example Program 3" on
https://www.postgresql.org/docs/current/static/libpq-example.
Hi,
I'm trying to retrieve an information about the table. Query is below:
SELECT cols.column_name, cols.data_type,
cols.character_maximum_length, cols.character_octet_length,
cols.numeric_precision, cols.numeric_precision_radix,
cols.numeric_scale, cols,column_default, cols.is_nullable,
table_con
Hi, Tom,
On Sat, May 6, 2017 at 8:22 PM, Tom Lane wrote:
> Igor Korot writes:
>> I tried to implement the code found in
>> https://www.postgresql.org/docs/current/static/libpq-example.html.
>> ...
>> I am getting an error:
>> [quote]
>> Non-constant-expression cannot be narrowed from type 'size_
Igor Korot writes:
> I tried to implement the code found in
> https://www.postgresql.org/docs/current/static/libpq-example.html.
> ...
> I am getting an error:
> [quote]
> Non-constant-expression cannot be narrowed from type 'size_t' (aka
> 'unsigned long') to 'int' in initializer list
> [/quote]
Hi, ALL,
I tried to implement the code found in
https://www.postgresql.org/docs/current/static/libpq-example.html.
On Windows with MSVC 2010 and Liniux with gcc-5.4 it compiled fine.
However on OSX 10.8 with:
[code]
Igors-MacBook-Air:dbhandler igorkorot$ gcc --version
Configured with:
--prefix=/
Hi all
This DbUnit extension for PHPUnit is driving me insane. On my
deathbed, the days of my life I have wasted debugging this testing
framework will haunt me.
Basic things like serial IDs fields, boolean values and timestamps
seem to require omission or unholy workarounds in order to get tests
Hi, Christoph,
On May 6, 2017 2:24 PM, "Christoph Moench-Tegeder"
wrote:
## Igor Korot (ikoro...@gmail.com):
> std::string query1 = "DECLARE alltables CURSOR SELECT
> table_schema, table_name FROM information_schema.tables WHERE
> table_type = 'BASE TABLE' OR table_type = 'VIEW' OR table_
## Igor Korot (ikoro...@gmail.com):
> std::string query1 = "DECLARE alltables CURSOR SELECT
> table_schema, table_name FROM information_schema.tables WHERE
> table_type = 'BASE TABLE' OR table_type = 'VIEW' OR table_type =
> 'LOCAL TEMPORARY';";
> [quote]
> RROR: syntax error at or near "SEL
Hi, ALL,
I am trying to execute following piece of code:
[code]
std::string query1 = "DECLARE alltables CURSOR SELECT
table_schema, table_name FROM information_schema.tables WHERE
table_type = 'BASE TABLE' OR table_type = 'VIEW' OR table_type =
'LOCAL TEMPORARY';";
res = PQexec( m_db, quer
