"Martin A. Marques" <[EMAIL PROTECTED]> writes:
> Has somebody made a script to start and stop the postmaster on Solaris? I'm
> having a hard time trying to do the stop part of the script, I just can't
> find an elegant way to kill the process and eliminate the socket lock that's
> left in /tmp
Joseph Shraibman <[EMAIL PROTECTED]> writes:
> Could someone please tell me what is going wrong?
> query: VACUUM ANALYZE
> NOTICE: FlushRelationBuffers(message, 15): block 0 is referenced
> (private 0, global 2)
> FATAL 1: VACUUM (vc_repair_frag): FlushRelationBuffers returned -2
This is prob
Has somebody made a script to start and stop the postmaster on Solaris? I'm
having a hard time trying to do the stop part of the script, I just can't
find an elegant way to kill the process and eliminate the socket lock that's
left in /tmp.
bye,
--
"And I'm happy, because you make me feel go
Fabrice Pollet <[EMAIL PROTECTED]> writes:
> ERROR: INSERT has more expressions than target columns
> I get this message when I insert in table inventaire.
What version are you running? I don't see a problem with 7.0.2:
play=> insert into inventaire (catgorie) values ('informatique');
ERROR:
Could someone please tell me what is going wrong?
query: VACUUM ANALYZE
ProcessUtility: VACUUM ANALYZE
DEBUG: --Relation pg_type--
DEBUG: Pages 2: Changed 0, reaped 1, Empty 0, New 0; Tup 134: Vac 0,
Keep/VTL 0/0, Crash 0, UnUsed 1, MinLen 105,
MaxLen 109; Re-using: Free/Avail. Space 1220
Peter Mount wrote:
>
> On Mon, 16 Oct 2000, 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.
On Mon, 16 Oct 2000, Bruce Momjian wrote:
> Peter, where are we on this?
Did it some time ago. I've just retrieved the email from my laptop
and checked it against cvs, and it's in there.
Peter
> [ Charset ISO-8859-1 unsupported, converting... ]
> > Ok, I've added it to the list of things to ch
On Tue, 17 Oct 2000, Rick Roberts wrote:
> What's the trick to getting it to compile?
> I'm on Linux 6.2, using JDBC2.
It depends on the version of the driver.
In most 6.5 & 7.0 you type:
make jdbc2
In 7.1, you have 3 options. The easiest is:
make
while:
make jdbc2
On Mon, 16 Oct 2000, 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.
Yes, kaffe cannot handle compiling tw
Thanks! 2>&1 was already used in same script. pgwrap is an OpenBSD thing
that sets pg environment for root user (I know a *little* bit about my
system).
Frank
At 12:49 PM 10/17/00 -0400, you wrote:
>Frank Bax <[EMAIL PROTECTED]> writes:
>> Thanks. When I remove -S then the command never comp
Frank Bax <[EMAIL PROTECTED]> writes:
> Thanks. When I remove -S then the command never completes?
Oh, OK. It wasn't clear what context you were starting the postmaster
in. Evidently it's from a script that has other things to do. You
need to put an ampersand "&" at the end of the command lin
On Tue, 17 Oct 2000, Matthew Kennedy wrote:
> A little redefinition of my question is in order. If I try doing this:
>
> create table things (name varchar(20), state(2));
> create table states (abbreviation varchar(2));
> alter table things
> add foreign key (state)
> references st
On Tue, 17 Oct 2000, Matthew Kennedy wrote:
> [EMAIL PROTECTED] wrote:
> > On Tue, 17 Oct 2000, Matthew Kennedy wrote:
> > > Is it possible to perform an alter table with add foreign key constraint
> > > in PostgreSQL? We are trying to support multiple DBMS in our project by
> > > keeping to a c
Thanks. When I remove -S then the command never completes?
How do I redirect stderr?
At 11:49 AM 10/17/00 -0400, you wrote:
>Frank Bax <[EMAIL PROTECTED]> writes:
>> I've got the following line in /etc/rc.local on my OpenBSD 2.6 system:
>> /usr/local/bin/pgwrap -o /var/pgsql/log postmaster -i -
Victor Ivanov <[EMAIL PROTECTED]> writes:
> I'm using PostgreSQL 7.0.2 and I'm trying to create my own types with
> input and output functions in C. Everything works fine, but when the input
> is invalid and the function returns NULL, the backend crashes with SIGSEGV.
You can't return an SQL NULL
create table inventaire (
id serial primary key,
catégorie text
constraint catégorie check (catégorie='informatique' or
catégorie='bureautique' or catégorie='technique' or catégorie='contrat'),
n°_contrat text,
n°_facture text,
n°_commande text,
nie text,
n°_barre int,
n°_série text,
ref_fabriqua
> 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 o
Frank Bax <[EMAIL PROTECTED]> writes:
> I've got the following line in /etc/rc.local on my OpenBSD 2.6 system:
> /usr/local/bin/pgwrap -o /var/pgsql/log postmaster -i -S -o -F >>
> /var/pgsql/postmaster.log
> Postgres starts ok, and /var/pgsql/postmaster.log gets created, but it
> stays at size=0
Rick Roberts writes:
> What's the trick to getting it to compile?
> I'm on Linux 6.2, using JDBC2.
cat src/interfaces/jdbc/README
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
[EMAIL PROTECTED] wrote:
> On Tue, 17 Oct 2000, Matthew Kennedy wrote:
> > Is it possible to perform an alter table with add foreign key constraint
> > in PostgreSQL? We are trying to support multiple DBMS in our project by
> > keeping to a common, compatible denominator. Oracle, supports such a
>
AGRE Enterprises <[EMAIL PROTECTED]> writes:
> I have a Plpsgsql function that I have been using in 6.5.1 and it works fine.
> The same function on 7.0.2 gives me an error. I have looked in the doc and haven't
> seen any change in syntax but maybe Im blind.
> The error is
> ERROR: parser: parse
Hello all,
I posted this query a while ago, but I might have missed the response, so here
goes again.
Is there any good documentation on the PL/PGSQL language? Like the complete
grammar and syntax? I have read the user's and programmer's manuals and all
they include is a few examples (hardly eno
On Tue, 17 Oct 2000, Tom Lane wrote:
> Gilles DAROLD <[EMAIL PROTECTED]> writes:
> >> The problem is this will break on older copies of Perl.
>
> > This problem is solved by perl itself !
>
> Yeah, it is: there is a module called Devel::PPPort that isolates
> user C code from the incompatibilit
I assume redhat does... I believe I patched it with an RPM from them.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "luc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; "pgsql-general" <[EMAIL PROTECTED]>
S
www.php.net will have a lot more info on that. If you installed via rpm,
you can rpm the additional patches. If you compiled and installed, the only
way I know off hand is to recompile php with "--with pgsql" and "--with
imap" parameters (check the syntax). php.net would have more info. They
h
For the most part, everyone's answers are accurate. The interface and
database you design needs to be tighter to prevent that.
One topic that no one mentioned is database security. For the user that the
php script runs under, start by restricting it acces to what it doesn't
need. If they are o
I'm using postgres through JDBC as the backend for my research so I have a
great interest in having a better driver. I'll pitch in.
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
27 matches
Mail list logo
