On Mon, Oct 16, 2000 at 11:22:40PM -0400, Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes:
> > I want to store some binary data in Postgres. The data is an
> > MD5 checksum of the user's password, in binary. It will be
> > exactly 16 bytes (since it is a one-way hash).
>
> > Can I store
What's the trick to getting it to compile?
I'm on Linux 6.2, using JDBC2.
Thanks
Rick
Neil Conway <[EMAIL PROTECTED]> writes:
> I want to store some binary data in Postgres. The data is an
> MD5 checksum of the user's password, in binary. It will be
> exactly 16 bytes (since it is a one-way hash).
> Can I store this safely in a CHAR column?
No. CHAR and friends assume there are
I want to store some binary data in Postgres. The data is an
MD5 checksum of the user's password, in binary. It will be
exactly 16 bytes (since it is a one-way hash).
Can I store this safely in a CHAR column? Can the data be
treated normally (i.e. compare a binary checksum of the
password the use
Edmar Wiggers wrote:
>
> I too am interested in full text indexing under PostgreSQL.
As I have described it, does it sound like something you would use? It
is designed more like a search engine. It will do a full text / boolean
search with phrase ranking in about 10~40 ms depending on the number
"Edmar Wiggers" <[EMAIL PROTECTED]> writes:
> Moreover, I have run into the same problem as you (in a different project
> though): how do you return more than 1 value from a C function?
In current releases, a C function cannot return a set; the expression
evaluator has a hard-wired notion that on
I too am interested in full text indexing under PostgreSQL.
Moreover, I have run into the same problem as you (in a different project
though): how do you return more than 1 value from a C function? I'd like to
return "rows", but, if at all possible, NOT to create a table. How about a
cursor? Perh
Gilles DAROLD <[EMAIL PROTECTED]> writes:
I have take a look to the source code concerning PL/Perl, it seems that 2
>variables
have a bad call : errgv and na.
If you replace them by their normal call (in 5.6.0) PL_errgv and PL_na you will
>get
success to compile the lib
* Roderick A. Anderson <[EMAIL PROTECTED]> [001016 12:32] wrote:
> On Mon, 16 Oct 2000, Alfred Perlstein wrote:
>
> > huh? How are you copying to an unmounted partition?
>
> Sorry I left that step out of the description. I usually mount it to some
> dumy point long enough to copy the files the
On Mon, 16 Oct 2000, Alfred Perlstein wrote:
> huh? How are you copying to an unmounted partition?
Sorry I left that step out of the description. I usually mount it to some
dumy point long enough to copy the files then unmount it and mount it to
the database directory.
Rod
--
Roderick A. An
That's the title of an interesting article on 9i in eWeek magazine.
Quote: "After the smoke clears and the mirrors are taken away,
Oracle9i might just be a marketing ploy based on a single, untested
technology."
http://www.zdnet.com/eweek/stories/general/0,11011,2639156,00.html
--
--
Thanks! That worked perfectly!!
-Original Message-
From: Peter Eisentraut <[EMAIL PROTECTED]>
To: Darrin Ladd <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Monday, October 16, 2000 1:41 PM
Subject: Re: [GENERAL] dump vs dumpall
>Darrin Ladd writes:
>
>> I am in t
On Mon, 16 Oct 2000, Peter Eisentraut wrote:
> Darrin Ladd writes:
>
> > I am in the process of moving my postgres dbs from an Alpha to a Pentium box
> > and I can't seem to get pg_dumpall to work. I have password authentication
> > enabled and am using the -u option on pg_dumpall, but it never
* Roderick A. Anderson <[EMAIL PROTECTED]> [001016 11:38] wrote:
> Typically when I want to place a database on a different partition I
> create it then copy all the stuff from the new databases directory(s) to
> the new partition followed by a mount. I check things out and then
> unmount the par
Darrin Ladd writes:
> I am in the process of moving my postgres dbs from an Alpha to a Pentium box
> and I can't seem to get pg_dumpall to work. I have password authentication
> enabled and am using the -u option on pg_dumpall, but it never actually asks
> me for a userid or password, it just wr
Typically when I want to place a database on a different partition I
create it then copy all the stuff from the new databases directory(s) to
the new partition followed by a mount. I check things out and then
unmount the partition remove all the stuff in the database directories,
remount, and the
Bruce Momjian wrote:
> Can you send me a patch?
>
> > Hi,
> >
> > I have take a look to the source code concerning PL/Perl, it seems that 2 variables
> > have a bad call : errgv and na.
> >
> > If you replace them by their normal call (in 5.6.0) PL_errgv and PL_na you will get
> > success to comp
Bruce Momjian wrote:
>
> I think the problem is using kaffe. I downloaded the jdbc binary from
> Peter's web site at:
>
> http://www.retep.org.uk
>
> and that worked with kaffe. Seems kaffe can not handle dependencies
> properly.
>
Well, yeah. "make jdbc2" won't work with kaffe, sin
I need help creating a new database.
It should be something like this:
Table1 Table2
-- --
t1_ID (int) t2_ID (int)
data1 (text)data1 (text)
data2 (text)
I think the problem is using kaffe. I downloaded the jdbc binary from
Peter's web site at:
http://www.retep.org.uk
and that worked with kaffe. Seems kaffe can not handle dependencies
properly.
> When attempting to build JDBC 7.0 driver with "make jdbc2 jar", the following
> e
Peter, where are we on this?
[ Charset ISO-8859-1 unsupported, converting... ]
> Ok, I've added it to the list of things to check, and commit if not already
> done etc...
>
> Peter
>
> --
> Peter T Mount [EMAIL PROTECTED], [EMAIL PROTECTED]
> Homepage: http://www.retep.org.uk Contact details:
On Mon, 16 Oct 2000, Tom Lane wrote:
> Karl DeBisschop <[EMAIL PROTECTED]> writes:
> > If it's of any use, I have attached the debug output - I don't see
> > where the problem is occurring, but I don't pretend to fully understand
> > the output, other than the exit is status 25.
>
> Signal 25?
Karl DeBisschop <[EMAIL PROTECTED]> writes:
> If it's of any use, I have attached the debug output - I don't see
> where the problem is occurring, but I don't pretend to fully understand
> the output, other than the exit is status 25.
Signal 25?? What is that on your machine? (see /usr/includ
Howdy,
I am in the process of moving my postgres dbs from an Alpha to a Pentium box
and I can't seem to get pg_dumpall to work. I have password authentication
enabled and am using the -u option on pg_dumpall, but it never actually asks
me for a userid or password, it just writes out that the pas
Can you send me a patch?
> Hi,
>
> I have take a look to the source code concerning PL/Perl, it seems that 2 variables
> have a bad call : errgv and na.
>
> If you replace them by their normal call (in 5.6.0) PL_errgv and PL_na you will get
> success to compile the lib plperl.so.
>
> Also in
We had a production DBMS die in a failrly dramitica way this morning. I
suspect the cause may have been interactions between lock and pg_dump,
but I'm a long way off from being able to say that with any certainty
at all. In the end, I moved the data directroy off to the side and
restored all
On Mon, Oct 16, 2000 at 12:18:15PM -0400, Bruce Momjian wrote:
> > > Let me ask. Could people who need to be up all the time dump their
> > > data, install PostgreSQL on another machine, load that in, then quickly
> > > copy the new version to the live machine and restart. Seems like
> > > downt
Hi,
why I can't use tabb variable in INSERT ?
The error message I get is:
ERROR: parser: parse error at or near "$1"
DECLARE
ids1 INTEGER;ids2 INTEGER;
tab TEXT;tabbTEXT;
...
tab := TG_RELNAME;
tabb :=
> On Mon, Oct 16, 2000 at 12:00:59PM -0400, Bruce Momjian wrote:
> > > > Migration tools might ease the pain, sure (though I'd still recommend
> > > > doing a full backup before a major version upgrade, just on safety
> > > > grounds; so the savings afforded by a tool might not be all that much).
On Mon, Oct 16, 2000 at 12:00:59PM -0400, Bruce Momjian wrote:
> > > Migration tools might ease the pain, sure (though I'd still recommend
> > > doing a full backup before a major version upgrade, just on safety
> > > grounds; so the savings afforded by a tool might not be all that much).
> >
> >
Added to TODO:
* Allow COPY to specify column names
> Yes, I have same problem. This functionality is "almost" standard,
> and
> found on other RDBMS. How do new features get added to the todo list's.
> Where can I view the current todo list?
>
> Fredrick
>
> Matthew Kennedy wrote:
> Tom Lane wrote:
>
> > Migration tools might ease the pain, sure (though I'd still recommend
> > doing a full backup before a major version upgrade, just on safety
> > grounds; so the savings afforded by a tool might not be all that much).
>
> What is needed, IMHO, is a replacement to the pg_u
Thanks to everyone who responded. I created a table
with int4 fields; and they appear as long integers in
MS Access.
After a review of the data fields, I've decided I
don't need int8 fields. Last night I dumped the
schema of the database, changed int8 fields to int4;
and moved the data to new t
33 matches
Mail list logo
