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
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 );
>
"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_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
> 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
"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
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
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
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
"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_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
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
"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
"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
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
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
>
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
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
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
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
20 matches
Mail list logo
