On 7 Sep 2003 at 10:42, Alex wrote:
> Hi,
> the postgres configuration file is somewhat confusing to me and I could
> not find a good tutorial on how to configure the db.
>
> I have a single and dual processor machine, 1GB of memory.
> The database is a couple of GB, about 10Million records.
> T
Hello,
I think that there is a bug in plPGSQL - or maybe I don't know something
about this language. Try to create this function
Ok., this is the function created in plPGSQL:
CREATE FUNCTION "public"."test" (text, text) RETURNS text AS'
BEGIN
IF $1 THEN
RETURN $1;
ELSE
RETURN $2;
E
On 7 Sep 2003, Alex Martinoff wrote:
> Using the org.postgresql.Driver JDBC driver is it possible to connect
> to Postgres using a unix domain socket instead of a TCP socket (so you
> don't have to start the postmaster with -i)? Using a TCP socket
> instead of a unix socket seems to slow down re
On 07/09/2003 11:59 Dr. Azmir wrote:
Hi there I'm Dr. Azmir from Kuala Lumpur.
I'm using RH 9.0 with postgresql intalled in it.
My problem is I can't createuser and createdb with it.
The error message "psql: FATAL: user "name" does not exist
createdb: database creatio
Hi all,
I'm using
solaris 8
gcc 3.0.1
postgres 7.3.4
psycopg 1.1.2
apache 1.3.19
python 2.1.1
mod_python 2.7.8 compiled with DSO
Compilation and tests run good for all tools.
When I connect from a standalone python session (either a program or a
CGI) everything works fine.
But when I use either
Hi everyone.
I need to create a C function that returns a row, and the type of this row must be the same of a type that I've created using CREATE TYPE.
I've seen the function:
TupleDesc TypeGetTupleDesc(Oid typeoid, List *colaliases)
but I don't understand two things:
1)I just know the name
On Sat, 6 Sep 2003, Don V. Soledad wrote:
> good day!
>
> is there a way to retrieve a user's decrypted password, just like when i
> issued a "SELECT * FROM pg_shadow;" in the earlier version of postgresql?
Sure, here's the simple method:
1: Generate a list of all possible passwords.
2: Gene
Franco Bruno Borghesi <[EMAIL PROTECTED]> writes:
> 1)I just know the name of the type, not its oid... woud it be ok if I
> execute a SELECT on pg_type asking for typname to find the oid of the
> type I want to return? or is there any function like
> RelationNameGetTupleDesc (maybe TypeNameGetTuple
> This is a psql artifact, not a feature supported by the backend.
> If you want to do likewise, emulate the code in src/bin/psql/large_obj.c.
Thanks, it seems that since I also want to allow non-superusers as well to
'trigger' an automagically created comment on a large object 'upload', it was
On Mon, Sep 08, 2003 at 08:53:26 -0600,
"scott.marlowe" <[EMAIL PROTECTED]> wrote:
> 3: Compare your infinite number of md5 sigs to the one stored for the
> user. When they match, you've got the original password, or at least a
> password that will work just like the original.
It is probably
On Fri, 5 Sep 2003, Relaxin wrote:
> How do we get someone from PG to respond to the questions in the ODBC
> newsgroup?
> Is the someone we can email directly?
I believe your question was already answered. The issue is that in ODBC
you can set it to use a cursor / fetch with a checkbox, or you
On Sun, 7 Sep 2003, Azkia H.Syed wrote:
> Scenario: I want to modify the PostgreSQL source code to customize per customer
> requirements, add new features and then package PostgreSQL with my own developed
> application. Then I want to sell/lease that sw/hw package to customer. I will only
> sel
On Mon, 8 Sep 2003, Bruno Wolff III wrote:
> On Mon, Sep 08, 2003 at 08:53:26 -0600,
> "scott.marlowe" <[EMAIL PROTECTED]> wrote:
> > 3: Compare your infinite number of md5 sigs to the one stored for the
> > user. When they match, you've got the original password, or at least a
> > password
On Sun, 2003-09-07 at 08:04, Holger Marzen wrote:
> Hi all,
>
> the docs are not clear for me. If I want (in version 7.1.x, 7.2.x) to
> help the analyzer AND free unused space do I have to do a
>
> vacuum
> vacuum analyze
>
> or is a
>
> vacuum analyze
vacuum analyze = vacuum + analyze
FYI, I
"scott.marlowe" <[EMAIL PROTECTED]> writes:
> On Mon, 8 Sep 2003, Bruno Wolff III wrote:
>
> > It is probably worth trying to spend some time trying to find a finite
> > set of passwords that are guarenteed to be generators for all possible
> > MD5 hashes (or at least those than can possibly occu
On 8 Sep 2003, Matthew T. O'Connor wrote:
> On Sun, 2003-09-07 at 08:04, Holger Marzen wrote:
> > Hi all,
> >
> > the docs are not clear for me. If I want (in version 7.1.x, 7.2.x) to
> > help the analyzer AND free unused space do I have to do a
> >
> > vacuum
> > vacuum analyze
> >
> > or is a
On Mon, 2003-09-08 at 11:32, Doug McNaught wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
>
> > On Mon, 8 Sep 2003, Bruno Wolff III wrote:
> >
> > > It is probably worth trying to spend some time trying to find a finite
> > > set of passwords that are guarenteed to be generators for all pos
yes, parseTypeString() seems to be the way.
I've found parseTypeString() in plpgsql.so... would it be ok to call dlopen('plpgsql.so', ...) from my C code to access this function or is there some other method I sould use?
thanks tom.
On Mon, 2003-09-08 at 12:02, Tom Lane wrote:
Franco Bruno
Franco Bruno Borghesi <[EMAIL PROTECTED]> writes:
> I've found parseTypeString() in plpgsql.so... would it be ok to call
> dlopen('plpgsql.so', ...) from my C code to access this function
Why would you need to do that!??! It's in the main executable.
regards, tom lane
--
That "_by whatever means_" seems to include "network link", and that
doesn't sound right.
Ah, but in order to use it over the network link you need to be
running their server software, on the one side, and their client
access software, on the other. Both sides are linked to
Tom Lane <[EMAIL PROTECTED]> writes:
> Yeah, but I think he's complaining about the 10sec delta for the
> aggregate on top of the 71sec to read the 8 million rows. That
> seems high to me too. On a 10-mil-row test table, I get
...
> in other words 26sec to do the aggregate on top of 163sec to r
On Mon, 8 Sep 2003, Ron Johnson wrote:
> On Mon, 2003-09-08 at 11:32, Doug McNaught wrote:
> > "scott.marlowe" <[EMAIL PROTECTED]> writes:
> >
> > > On Mon, 8 Sep 2003, Bruno Wolff III wrote:
> > >
> > > > It is probably worth trying to spend some time trying to find a finite
> > > > set of pass
On Monday 08 September 2003 19:30, Kaarel wrote:
>> Your client software has to link in software belonging to MySQL AB,
>> and that's where they are now "biting" people on this.
>>
>> This is one of the reasons why the PHP people removed bundled MySQL
>> support in version 5 back in June.
>
>
> W
On Monday 08 September 2003 09:32, Marek Lewczuk wrote:
> Hello,
> I think that there is a bug in plPGSQL - or maybe I don't know something
> about this language. Try to create this function
[snip]
> And when i execute: SELECT test(NULL, 'buuu'); -> it returns me NULL
> value, when it should return
Marek Lewczuk wrote:
Hello,
I think that there is a bug in plPGSQL - or maybe I don't know something
about this language. Try to create this function
Ok., this is the function created in plPGSQL:
CREATE FUNCTION "public"."test" (text, text) RETURNS text AS'
BEGIN
IF $1 THEN
RETURN $1;
ELSE
"Marek Lewczuk" <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION "public"."test" (text, text) RETURNS text AS'
> BEGIN
> IF $1 THEN
> RETURN $1;
> ELSE
> RETURN $2;
> END IF;
> END;
> 'LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
If there's a bug here at all, it's
26 matches
Mail list logo
