that data really got modified.
--
Joachim Wieland [EMAIL PROTECTED]
GPG key available
---(end of broadcast)---
TIP 5: don't forget to increase your free
correct the
query to avoid the error message? (sqlca.sqlerrd[2] does contain the #
of elements in spite of error)
The problem is that you are selecting a value but you don't say where ecpg
should store the result. You're missing the INTO :var part.
Joachim
--
Joachim Wieland
On Tue, Jul 25, 2006 at 02:46:02PM -0400, Jasbinder Bali wrote:
Tried writing the follwoing code but doesn't give me any result.
Don't know if i have to do somethin else apart from what i've already done.
There are many ways your program can fail before actually reaching the
select line but you
On July 22, 7:46 pm Jasbinder Bali [EMAIL PROTECTED] wrote:
I have a C program and have some ECPG code in it.
How do i display the data that i retrieve from the postgres database
using a simple select statment or calling a stored procedure.
Is it mandatory to use cursor or there's any other
Luis,
On Tue, Jun 13, 2006 at 01:19:32PM -0500, Luis Alberto Pérez Paz wrote:
The program works fine, actually I can verify that it executes the FUNCTION
'myFunction', however I dont know how can I get the return value of the
FUNCTION 'myFunction' (as you can see in the little example the
Luis,
On Mon, Jun 12, 2006 at 06:24:24PM -0500, Luis Alberto Pérez Paz wrote:
res = PQexecParams ( conn, select myFunction($1,$2,$3) , 3, NULL,
paramValues, paraLenghts, paramFormats, resultFormat);
It's works fine, however I dont know how can I retrieve the result that
return the FUNCTION
On Fri, Jun 02, 2006 at 02:47:22AM -0700, badlydrawnbhoy wrote:
I need to locate all the entries in a table that match , but only after
a number of characters have been ignored. I have a table of email
addresses, and someone else has erroneously entered some addresses
prefixed with 'mailto:',
David,
On Thu, May 25, 2006 at 02:07:27PM -0700, David Wall wrote:
object. Look in template1 and see if you see a table with that OID.
Thanks, but I clearly lack that expertise. How do I find a table with
that OID?
Do a normal select against pg_class. Something like:
select oid, relname
On Fri, May 19, 2006 at 03:58:19PM +0400, Ivan Zolotukhin wrote:
There are no clients connected to the
database except me in that moment since I switched application to
another DB.
Did you check for not yet committed prepared transactions?
Check the pg_prepared_xacts system view.
Joachim
go along with another command like
... ALTER COLUMN DROP SERIAL
which drops the serial and removes the dependencies to get rid of it in a
clean way, right?
Joachim
--
Joachim Wieland [EMAIL PROTECTED]
C/ Usandizaga 12 1°B
On Wed, Feb 08, 2006 at 09:03:54AM -0500, Bruce Momjian wrote:
Joachim Wieland wrote:
On Tue, Feb 07, 2006 at 09:49:02AM -0500, Bruce Momjian wrote:
The correct solution to this is to forbid ALTER COLUMN SET DEFAULT on
a serial column, but we haven't gotten around to enforcing that yet
for the problem elsewhere...
Joachim
--
Joachim Wieland [EMAIL PROTECTED]
C/ Usandizaga 12 1°B ICQ: 37225940
20002 Donostia / San Sebastian (Spain) GPG key available
On Sun, Feb 05, 2006 at 07:59:06PM +0100, Martijn van Oosterhout wrote:
On Sun, Feb 05, 2006 at 07:43:47PM +0100, Joachim Wieland wrote:
I propose to change it on the grounds that:
- other unix daemons reset their values to defaults before reading
conffiles
But the biggest issue
On Sun, Feb 05, 2006 at 02:37:53PM -0500, Tom Lane wrote:
Joachim Wieland [EMAIL PROTECTED] writes:
There's been various discussions in the past about making this behavior
less non-intuitive, but nothing's been settled on ...
So what about deciding now that it should be changed. What
the
same query with different arguments.
You're always welcome to improve the documentation by submitting a
documentation patch that adds more examples ;-)
Joachim
--
Joachim Wieland [EMAIL PROTECTED]
C/ Usandizaga 12 1°B
Hi, I wonder if the following behavior is intentional or not:
template1=# create role r1 nocreatedb createrole;
CREATE ROLE
template1=# set role r1;
SET
template1= create role r2 createdb;
CREATE ROLE
template1= set role r2;
SET
template1= create database d1;
CREATE DATABASE
So in effect, if you
On Wed, Jul 13, 2005 at 11:18:04PM -0500, Bob wrote:
Here is the link in case your fingers are broken and it hurts to type;)
http://www.postgresql.org/docs/8.0/interactive/encryption-options.html
I think the Password Storage Encryption paragraph needs a note similar to
what Stephen Frost wrote
Hi Randall,
On Sun, Oct 31, 2004 at 11:25:46PM -0600, Randall Smith wrote:
1. Set up stored proc on oracle that records a INSERT, UPDATE, DELETE
SQL action taken on a table into a log table.
2. Program reads the log table on oracle and issues the same SQL command
on the postgres db. In the
Hi there,
I want to use the RIPE whois server that uses MySQL by default. However
I'd prefer a PostgreSQL solution. :-)
Does anybody know if there exists a patch to support PostgreSQL?
Thanks,
Joachim
---(end of broadcast)---
TIP 2: you can
19 matches
Mail list logo