I have a recover situation related to:
Oct 13 23:04:58 66-162-145-116 postgres[16955]: [1-1] LOG: database
system was shut down at 2007-10-13 23:04:54 PDT
Oct 13 23:04:58 66-162-145-116 postgres[16955]: [2-1] LOG: checkpoint
record is at F0/E21C
Oct 13 23:04:58 66-162-145-116 postgres[169
On Sun, Oct 14, 2007 at 12:01:45AM -0600, Cesar Alvarez wrote:
> Hello
> im working in a proyect in ORACLE 10g and one of the things i like is
> using the INSERT RETURNING with the parameters, im not sure that i read
> about postgres 8.2 suporting this feature... if its true where can i
> read m
Hello
im working in a proyect in ORACLE 10g and one of the things i like is
using the INSERT RETURNING with the parameters, im not sure that i read
about postgres 8.2 suporting this feature... if its true where can i
read more about it.
regards Cesar Alvarez.
begin:vcard
fn:Cesar Alvarez
n:;Ce
I was wondering whether there could be an atomic commit;begin command
for postgresql, in order to open up a transaction at the beginning of
a unit of work in a client session, so that client applications don't
have to duplicate work with having optimistic locking and version id
fields in their tabl
2007-10-13_15:22:34-0400 Gregory Stark <[EMAIL PROTECTED]>:
> "Ron Peterson" <[EMAIL PROTECTED]> writes:
>
> > My first thought was to just do something like:
> >
> > CREATE TYPE __full_key AS ( n bytea, e bytea, d bytea );
> >
> > CREATE OR REPLACE FUNCTION
> > generate_rsa_key( )
> > RETURNS
>
http://www.postgresql.org/docs/8.3/static/libpq-envars.html
use environment variables
PGHOST is the host for Postgres
PGHOSTADDR is the Numeric Host Address for Postgres
PGPORT is the port for the PostgresServer to listen on
PGDATABASE is the default Database Name
PGUSER is the default Username t
"Ron Peterson" <[EMAIL PROTECTED]> writes:
> My first thought was to just do something like:
>
> CREATE TYPE __full_key AS ( n bytea, e bytea, d bytea );
>
> CREATE OR REPLACE FUNCTION
> generate_rsa_key( )
> RETURNS
> __full_key
Oh, incidentally you probably don't want to name your type star
"Ron Peterson" <[EMAIL PROTECTED]> writes:
> Am I making this way too complicated? Do I only have to return a C
> string representation of three bytea values as a tuple?
No, if you want to define a composite type and return it then you're on the
right track to be using heap_form_tuple. And usin
2007-10-13_14:15:06-0400 yrp001:
> select * from generate_rsa_key();
Am I making this way too complicated? Do I only have to return a C
string representation of three bytea values as a tuple?
(I still think a bona-fide user-defined type in C is probably better.)
--
Ron Peterson
https://www.ye
2007-10-13_13:44:33-0400 Gregory Stark <[EMAIL PROTECTED]>:
> "Ron Peterson" <[EMAIL PROTECTED]> writes:
>
> > I think I can get where I want to go without completely figuring that out
> > right now though...
>
> What are you trying to do?
I've implemented the RSA PKCS #1 v2.1 public key cryptog
"Ron Peterson" <[EMAIL PROTECTED]> writes:
> I think I can get where I want to go without completely figuring that out
> right now though...
What are you trying to do?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
---(end of broadcast)--
2007-10-13_11:12:05-0400 Gregory Stark <[EMAIL PROTECTED]>:
> "Ron Peterson" <[EMAIL PROTECTED]> writes:
>
> > 2007-10-13_08:50:56-0400 Ron Peterson <[EMAIL PROTECTED]>:
> >> 2007-10-13_01:22:06-0400 Gregory Stark <[EMAIL PROTECTED]>:
> >
> >> > And normally you would define your own datatype and
On Sat, Oct 13, 2007 at 11:23:41AM -0600, Cesar Alvarez wrote:
> Good day everyone
>
> I got a question, what are the differences of SQL_ASCII and UTF8, witch
> one should i use??
Well, SQL_ASCII means basically that what you put in you get out, but
the DB is going treat it as ASCII, umlauts/etc
Good day everyone
I got a question, what are the differences of SQL_ASCII and UTF8, witch
one should i use??
regards Cesar Alvarez.
begin:vcard
fn:Cesar Alvarez
n:;Cesar Alvarez
title:Web Development Asesor and Software Enginner
version:2.1
end:vcard
---(end of broad
"Ron Peterson" <[EMAIL PROTECTED]> writes:
> 2007-10-13_08:50:56-0400 Ron Peterson <[EMAIL PROTECTED]>:
>> 2007-10-13_01:22:06-0400 Gregory Stark <[EMAIL PROTECTED]>:
>
>> > And normally you would define your own datatype and not use bytea.
>>
>> Actually, I already have my data in a structure mu
> can I define connection-global variables within a ODBC connection ?
Temp table, containing only 1 row, one column per variable. If you so wish,
wrap it up in stored procedures for creating, setting, and accessing.
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 722-0567 voice
2007-10-13_08:50:56-0400 Ron Peterson <[EMAIL PROTECTED]>:
> 2007-10-13_01:22:06-0400 Gregory Stark <[EMAIL PROTECTED]>:
> > And normally you would define your own datatype and not use bytea.
>
> Actually, I already have my data in a structure much like varlena.
Pght, I misunderstood what you we
"brien colwell" <[EMAIL PROTECTED]> writes:
> Is there documentation for the contrib / fuzzystr module? I haven't been
> able to find it ...
Should be a couple of README files whereever your contrib documentation
is installed ...
$ ls contrib/fuzzystrmatch
CVS/ fuzzystrma
2007-10-13_01:22:06-0400 Gregory Stark <[EMAIL PROTECTED]>:
> "Ron Peterson" <[EMAIL PROTECTED]> writes:
>
> > Is this a legitimate/blessed way to go about it?
> >
> > aval = (bytea *)palloc( len + VARHDRSZ );
> > VARATT_SIZEP(aval) = len + VARHDRSZ;
> > memcpy( VARDATA(aval), myrawdata, len );
>
On 10/12/07, Guy Rouillier <[EMAIL PROTECTED]> wrote:
> I've had several occasions when a user-defined variable would have come
> in handy. What is the scope of user_vars as you've defined them above?
> Are they unique to a connection? A user_id? Or defined globally?
> Ideally, they would be
20 matches
Mail list logo
