ata so you might want to make
sure that data really got modified.
--
Joachim Wieland [EMAIL PROTECTED]
GPG key available
---(end of broadcast)-
w arguments". Why? Can I 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
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 yo
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
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 re
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 FUNCT
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, rel
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
he switch / case construct so you'll have to
use IF ... ELSIF.
Joachim
--
Joachim Wieland [EMAIL PROTECTED]
C/ Usandizaga 12 1°B ICQ: 37225940
20002 Donostia / San Sebastian (Spain)
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
f a SERIAL column
This should 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 PROTECTE
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 a
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
> >conffil
o you don't
even take a look at the conf file but look for the problem elsewhere...
Joachim
--
Joachim Wieland [EMAIL PROTECTED]
C/ Usandizaga 12 1°B ICQ: 37225940
20002 Donostia / San Se
ften you want to execute 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 PR
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 y
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 wr
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
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 get
20 matches
Mail list logo
