Re: [GENERAL] initdb doesn't work with cygwin 1.3.1?

On Mon, May 21, 2001 at 01:50:45PM +0200, Iwan van der Kleyn wrote: > Hi there, > > PostgreSQL 7.1 now is part of the Cygwin "Unix on Win32" Toolkit. A terrific > development, because it takes away lots of fuss trying to get Postgres to > work on Win2000. > > However, when running "initdb" the s

Re: [GENERAL] perl vs php for postgresql

On Tue, 22 May 2001, John wrote: > It seems that I having problems locating the DBM:Pg module. I even followed > the instructions on compiling postgresql to support it. My perl scripts > don't seem to know about a Pg module and I have not had any luck finding > answers. Is is easier to use php w

[GENERAL] Stubborn Multibyte

I am working for a company in Japan. I have two RedHat 6.1J machines that I want Postgres on. On one of them, I installed postgresql 7.0.2 RPMs off of a CD I received, and everything works fine. The second (same OS), has given me nothing but trouble. I installed the RPMs, and then when I tried

[GENERAL] pg_dump fails, data integrity imperfect

At some point between april 13 and now a single row in my 'orders' table became compromised and caused the failure of pg_dump upon which I had been depending for a backup, sort of. I say sort of because I allowed each days dump to overwrite the previous and as such cannot point to a specific day a

Re: [GENERAL] Autocommit off in psql??

On Tue, May 22, 2001 at 08:18:31PM -0400, Paul Tomblin wrote: > Quoting Neil Conway ([EMAIL PROTECTED]): > > Yes, just start an explicit transaction with "BEGIN" -- this disables > > autocommit (so when you want to commit your transaction, you'll need > > to do "COMMIT" by hand). > > That brings

Re: [GENERAL] Postgresql - multibyte

I have no problems with exactly the same configuration as you said. Can you make distclean and try again? -- Tatsuo Ishii > hello, > > I have a problem during compilation of Postgresql 7.1 > I configure it with --enable-multibyte=LATIN2 --enable-odbc --enable-locale > Everything goes OK. > Then

Re: [GENERAL] Autocommit off in psql??

Quoting Neil Conway ([EMAIL PROTECTED]): > Yes, just start an explicit transaction with "BEGIN" -- this disables > autocommit (so when you want to commit your transaction, you'll need > to do "COMMIT" by hand). That brings to mind a couple of questions I had: Can I just open a transaction, delet

Re: [GENERAL] I want more Money (the data type, of course! :-))

Use numeric with appropriate precision information. On Sat, 19 May 2001, Carlos Moreno wrote: > > No, it's not spam! :-) > > I'm just wondering if there is a data type like Money, but with > a (much much much) higher range -- checking the documentation, > it would look like PG uses an int

[GENERAL] Cant get Perl Module loaded

I have installed perl and postgres, followed the instructions on how to install the perl modules and tried to run a simple cgi script to connect to postgress, get some data and display it. I keep getting a message in the error log that says perl can't find the DBM:Pg module or maybe I misspelled

[GENERAL] NOTIFY/LISTEN Using Embedded SQL (ecpg)

[cross posted from comp.databases.postgresql.general] I seem to have painted myself into a corner, technologically speaking. I am implementing a database using embedded SQL, and PostgreSQL 6.5.3 as the backend. The problem is that I would like to use the NOTIFY feature, but the only way I've foun

[GENERAL] Re: Why can't I do this (setup question)

Karl DeBisschop wrote: > Paul Tomblin wrote: >> >> Quoting Tom Lane ([EMAIL PROTECTED]): >> > Paul Tomblin <[EMAIL PROTECTED]> writes: >> > > I've got PostgreSQL 7.1 installed from rpms on a RedHat 6.2 system. >> > > I want the data directory on a separate partition, so I shut down, >> > > tar

[GENERAL] Re: perl vs php for postgresql

On Tue, 22 May 2001 02:48:58 GMT, John <[EMAIL PROTECTED]> wrote: >It seems that I having problems locating the DBM:Pg module. I even followed >the instructions on compiling postgresql to support it. My perl scripts >don't seem to know about a Pg module and I have not had any luck finding >answer

[GENERAL] Re: I want more Money (the data type, of course! :-))

Carlos Moreno wrote: > > No, it's not spam! :-) > > I'm just wondering if there is a data type like Money, but with > a (much much much) higher range -- checking the documentation, > it would look like PG uses an int (32bits) to store the amount > of cents -- but -21 million to +21 million is

[GENERAL] Re: PostgresSQL 7.1 and ODBC/MSAccess

I am having a related problem with the 7.1 ODBC driver. Records which I write using JDBC are fine which I use pgaccess to view them. However, if I use ODBC and Access and do a link table, the data appears a jiberish. "Lieven Van Acker" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]

[GENERAL] Autocommit off in psql??

Hi! Is there a way of turning autocommit of in psql ? It would be nice for people used to Oracle's SQL*Plus. No fatal error has occurred yet, but some minor problems could have been avoided if rollback was possible when the fingers on the keyboard are faster than the brain :) Björn --

[GENERAL] Re: perl vs php for postgresql

In article , "John" <[EMAIL PROTECTED]> wrote: > It seems that I having problems locating the DBM:Pg module. I even > followed the instructions on compiling postgresql to support it. My > perl scripts don't seem to know about a Pg module and I have not had any > luc

[GENERAL] I want more Money (the data type, of course! :-))

No, it's not spam! :-) I'm just wondering if there is a data type like Money, but with a (much much much) higher range -- checking the documentation, it would look like PG uses an int (32bits) to store the amount of cents -- but -21 million to +21 million is insufficient for accounting of

[GENERAL] production java/postgresql

I'm interested in finding companies that use java and postgres in a production environment. If anyone knows of any url's I could visit or has experience with this in their own company, I'd love to hear about it. Thanks ---(end of broadcast)--- T

[GENERAL] Incrementing a date type.

I have an event that is three days long. In a table I want to be able to enter Friday date and have Saturdays and Sundays fill in automatically. It also has to check for the month/# of days in... Example input : Friday=6-1-2001 autoadd: Saturday=6-2-2001 autoadd: Sunday=6-3-2001 Example 2 input:

Re: [GENERAL] debian packages for Postgresql 7.1 or higher ?

On Wed, 16 May 2001, Alex wrote: > Are there any debian packages for Postgresql 7.1 or higher for Potato? > I've tried to get the src-deb from unstable (7.1.1) but it won't compile > under potato, not unless I upgrade the perl packages as well, which is not > my idea. http://people.debian.org/~e

[GENERAL] postgreSQL 7.0.3 + kdevelop 1.4.1

Hi all! I have some troubles trying to configure kdevelop 1.4.1 to use the postgreSQL 7.0.3 C++ library. Configuration -- menu Project>Options Compiler Options additional options: -I/usr/include/pgsql/ Linker Options additional libraries: -lpq++ -L/usr/lib/

[GENERAL] Re: production java/postgresql

Dennis Muhlestein wrote: > I'm interested in finding companies that use java and postgres in a > production environment. If anyone knows of any url's I could visit or has > experience with this in their own company, I'd love to hear about it. www.linux.org.ru FreeBSD, PostgreSQL, Java Info and

[GENERAL] Re: Which Front End for Postgresql

Al Frick wrote: > Which software should I use for a front end for Postgresql? I know I > need an admistrator package for the databases, don't I? > > What about which software to write the enduser routines? The input > screens, etc? > > come to think of it, what software should I use for repor

[GENERAL] Vacuum Failed - backend closed the channel unexpectedly

Running Linux 2.2.14 postgresql 7.0.3 I am trying to run a vacuum and I get the following output vacuum; NOTICE: FlushRelationBuffers(menudt, 6): block 3 is referenced (private 0, global 2) FATAL 1: VACUUM (vc_vacheap): FlushRelationBuffers returned -2 pqReadData() -- backend closed the channel

Re: [GENERAL] ER diagram generator

> http://techdocs.postgresql.org/oresources.php#erdtools Thanks a bunch, I should have been able to find that found that on my own :/ > If you come across any more, can you let us know so we can add it to the > list? I did find http://gasql.sourceforge.net/ - it looks real nice, only I haven

[GENERAL] Postgresql - multibyte

hello, I have a problem during compilation of Postgresql 7.1 I configure it with --enable-multibyte=LATIN2 --enable-odbc --enable-locale Everything goes OK. Then I type gmake, and after a while of compilation I get an error message like: gmake[4]: Entering directory `/export/home/root/instalacje

[GENERAL] Warnings on pg_dump

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I switched to PGSQL 7.1.1 on Linux recently and since then I am getting following warnings when doing pg_dump: - ---8<--- ld01ad06:~$ pg_dump -u -t cpranges spam Username: borelupo Password: WARNING: owner of type 'pg_inherits' appear

[GENERAL] Re: ZeroFill(.../pg_xlog/xlogtemp.20148) failed: No such file or directory

I found the answer to this: the partition had filled up, and so the problem was lack of disk space. Could we have a more helpful error message? I was just looking in the wrong direction because of the contents of the message. *** postgresql-7.1.1.orig/src/backend/access/transam/xlog.c Tue M

[GENERAL] ZeroFill(.../pg_xlog/xlogtemp.20148) failed: No such file or directory

I got this error while trying to restore a full dump: psql:/home/olly/db.out:93439: FATAL 2: copy: line 37292, ZeroFill(/var/lib/postgres/data/pg_xlog/xlogtemp.20148) failed: No such file or directory psql:/home/olly/db.out:93439: PQendcopy: resetting connection psql:/home/olly/db.out:157137:

[GENERAL] psql.exe runtime error

I work on Windows 2000. I start psql.exe on a console. The PostgreSQL Interactive Terminal seems to run well. But each time I execute a commande like \d or \l or anything else, I quit psql and I get the following error : the "0x77fc9e82" instruction uses "0x" memory address. the memory can