Hi,
As the Subject line says, all I am looking to do is to make the libraries so
I can write some C/C++ postgresql client programs under Cygwin (under Win98)
using the GNU C/C++ compilers. I guess I could use ODBC and MSVC++, but I
just don't want to get stuck in a rut. I do not need to build a
The following function doesn't work when called multiple times:
CREATE FUNCTION foo(INTEGER) RETURN BOOLEAN AS '
DECLARE
y INTEGER;
BEGIN
CREATE TEMP TABLE a (
x INTEGER
);
INSERTINTO a
VALUES(4);
SELECTINTO
> Furthermore, after trying to just index on a 8191-character long substring
> of the resume, I run into the following:
> ERROR: btree: index item size 3948 exceeds maximum 2713
> The only way I could actually get the index created was to substring the
> body of the resumes down to 2k. I also lat
On Tue, 10 Apr 2001, Joe Johnson wrote:
> I have a table with over 1,000,000 records in it containing names and phone
> numbers, and one of the indexes on the table is a unique index on the phone
> number. I am trying to copy about 100,000 more records to the table from a
> text file, but I get
On Tue, 10 Apr 2001, Cefull Lo wrote:
> When I type INSERT INTO friend
> VALUES ('', '', '');
> it returns
> INSERT 19748 1
>
> what means of 19748 and 1?
It's the OID, a unique idenifier for everything in the database.
Read the Momjian book on the website -- it explains this very well.
--
Jo
On Tue, 10 Apr 2001, Poet/Joshua Drake wrote:
> I've been experimenting a bit with Full Text Indexing in PostgreSQL. I
> have found several conflicting sites various places on the net pertaining
> to whether or not PostgreSQL supports FTI, and I was hoping I could find
> an authoritative answer h
No, not yet. Hopefully 7.2. You can perform a pg_dump anytime, though.
> Is there a way to perform a point in time restore with postgresql ?
>
> /Claes
>
>
>
> ---(end of broadcast)---
> TIP 4: Don't 'kill -9' the postmaster
>
--
Bruce M
When I type INSERT INTO friend
VALUES ('', '', '');
it returns
INSERT 19748 1
what means of 19748 and 1?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
On Tue, 10 Apr 2001, Cefull Lo wrote:
> When I type INSERT INTO friend
> VALUES ('', '', '');
> it returns
> INSERT 19748 1
>
> what means of 19748 and 1?
19748 is the OID of that record, and 1 means one record was inserted.
For information on OID's, look in the documentation.
--
Dominic J.
On Tue, Apr 10, 2001 at 09:27:50PM +0200, some SMTP stream spewed forth:
> Is there a way to perform a point in time restore with postgresql ?
>
Nope, not yet anyway, to the best of my knowledge.
dan
> /Claes
>
>
>
> ---(end of broadcast)---
> The reason I need to compile w/ Perl
> support turned on is what I am reading
> in the README.rserv of the ERServer
> available in contrib directory.
> It says that the requirements are:
> - PostgreSQL >= 7.0.X
>A separate Makefile is required for PostgreSQL 7.0.x and earlier
> - Perl5 and t
I have a table with over 1,000,000 records in it containing names and phone
numbers, and one of the indexes on the table is a unique index on the phone
number. I am trying to copy about 100,000 more records to the table from a
text file, but I get an error on copying because of duplicate phone nu
Thought that I share this with the group. Thanks Marco.
The problem was gone once I created a soft link to
JAVA_HOME/lib/tools.jar in the default directory
JAVA_HOME/jre/lib/ext/. I have not set specific CLASSPATH
variable and I could understand the problem better if
I had seen the problem when u
> I have the following table, containing about 57 Rows, but some
> indexes are not used, on 7.1RC4, freshly vacuumed (analyse). It was the
> same at least in 7.1RC1
> CREATE TABLE access_log(
> access_time timestamp NOT NULL DEFAULT NOW(),
> method_num int2NO
David Wall writes:
> Does 7.1 "natively" handle large objects in dumps, restores and vaccums? In
> 7.0.3 there was a contrib for LOs.
Yes.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---(end of broadcast)---
TIP 6:
On Tue, 10 Apr 2001, mazzo wrote:
> First of all, since i'm new to this mailing listHi all..!!
> My first question..
> I have to convert an access 97 database to pgsql...are there any tools to do
> this?? I checked the website but the link for the tools are not working so i
> tried to export
First of all, since i'm new to this mailing listHi all..!!
My first question..
I have to convert an access 97 database to pgsql...are there any tools to do
this?? I checked the website but the link for the tools are not working so i
tried to export the tables from access using the ODBC driver.
On Tue, Apr 10, 2001 at 01:42:13PM -0400, Stan Brown wrote:
> I have been suing PostgreSQL quite happily in projects for
> several years now.
i have the smae porbelm -- you might wnat to solw down wehn you
tyep your email msesaegs.
Suing is quite different from Using.
:)
--
americans should n
On Mon, Apr 09, 2001 at 03:33:19PM -0700, Homayoun Yousefi'zadeh wrote:
>
> I first ran configure with the following options
>
> ./configure --with-perl --with-tcl --enable-odbc --with-java
> --enable-syslog --enable-debug
>
> and then compiled postgresql-7.1rc4 on Redhat 7.0 successfully
>
On Tue, 10 Apr 2001, Stan Brown wrote:
> I have been suing PostgreSQL quite happily in projects for several years
> now.
>
> Now, I am thinking about actually using the computers at home for something
> useful (what a concept :-)).
>
> So, I was wandering if anyone knows wehre I could find a fe
I have been suing PostgreSQL quite happily in projects for several years
now.
Now, I am thinking about actually using the computers at home for something
useful (what a concept :-)).
So, I was wandering if anyone knows wehre I could find a few small
applicationsUsing PostgreSQL as abckaends? I'm
Does 7.1 "natively" handle large objects in dumps, restores and vaccums? In
7.0.3 there was a contrib for LOs.
Thanks,
David
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
"Homayoun Yousefi'zadeh" <[EMAIL PROTECTED]> writes:
> The reason I need to compile w/ Perl
> support turned on is what I am reading
> in the README.rserv of the ERServer
> available in contrib directory.
> It says that the requirements are:
>
> - PostgreSQL >= 7.0.X
>A separate Makefile is
Tony Grant wrote:
> Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
> JDK1.3
>
> I just don't have the patience to figure out what is going wrong here.
>
> /usr/share/ant
>
> Ant install made a /usr/share/java withe the jar files in it.
>
> Java is installed on the
Can someone please point me to a precompiled jdbc driver for 7.1RC4 and
JDK1.3
I just don't have the patience to figure out what is going wrong here.
/usr/share/ant
Ant install made a /usr/share/java withe the jar files in it.
Java is installed on the machine as /usr/java/jdk1.3
[javac]
On 10 Apr 2001, Konstantinos Agouros wrote:
> Hi,
>
> I have a query running for 97hours now and I am wondering if this can be made
> any faster.
> The Query is:
> insert into dailyreport select timestamp(date
>'1-8-2001'),a.category,'Observed',sum(b.count) as count from websensebycat a,
>nets
26 matches
Mail list logo
