BDY.RTF
Description: RTF file
help
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
Hello,
which global variable is the path of postgresql binary? such as /usr/local/pgsql/bin
I only find pg_pathbname stand for postgres full pathname.
thank you in advance.
Jinqiang Han
---(end of broadcast)---
TIP 1: subscribe and un
Hello! I am a Technical Recruiter with MIS Consultants in Toronto Canada and I
desperately need to find 2 POSTGRES DBA's for our Toronto client on a 3-4 month
renewable contract, open $$$ based on experience.
How do I go about finding these guys?
Any help is much appreciated, thanks!
Jeff Va
How do I unsubscribe from here?
Thank You,
Anthony
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Hello,
My name is rong xie. I am a Student at
TU-Munich.
I have a question to Postgresql an Linux.
e.g:
for IBM DB2: I can write a test.sql
file.
--test.sql
connect to database1;
set schema xie;
select * from table1;
insert table1 value('rong','xie',22);
select * from table1;
terminate
Hello:
I have problems with a LOCK sentence and ECPG.
Could anybody tell me if I can execute some sentences simila to:
EXEC SQL LOCK TABLE users IN SHARE ROW EXCLUSIVE MODE;
Where is my error?
Thanks
Jhon Orellana
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Hi all
I'm trying to compile an old version of Postgres
and suddenly I've got the folloging error message:
make[2]: Cambiando a directorio
`/home/jmilan/postgres-r/src/backend/port'gcc -I../../include
-I../../backend -O2 -Wall -Wmissing-prototypes
-I.. -c -o dynloader.o dynloader.cg
Hi all,
I'm working on a fairly large patch (cleaning up Karel Zak's
PREPARE/EXECUTE work), and I'm having some problems with bison (I'm
a yacc newbie). In fact, my grammar currently has an obscene
20 shift/reduce and 4 reduce/reduce conflicts!
Would someone to be kind enough to let me know what
I'm trying to compile an old version of Postgres and suddenly I've got
the folloging error message:
This looks to be the working model of postgres-r. Did you get it via CVS
or from
the down load area?
These questions should probably be asked on the pg-replication list
instead of hackes.
Hi Guys,
I'm starting work on ADD COLUMN. I'm going to allow:
* SERIAL, SERIAL8
* DEFAULT
* NOT NULL
etc...
The one big programming difficulty I see is the process of running through
all the existing tuples in the relation the column was added to and
evaluating the default for each row.
I ass
Hello,
I am building an rpm for Mitle SME (a scaled down redhat 7.3) and have all functions
working except:
I need to have the rpm when installed create a database and a user with privilege to
that database.
These are the command functions I need to execute within the rpm...
# service postgres
Hello, I'm having a problem vacuum a table and I didn't see an answer using
the fts engine.
I have two questions:
1) Is this a big problem, can it be fixed, do I have to dump / restore this
table?
2) I found this problem from my nightly cron driven vacuum -a -z. When it
hits this error the enti
Neil Conway <[EMAIL PROTECTED]> writes:
> Unfortunately, bison isn't very
> helpful: it doesn't provide line-numbers when it warns me about
> the # of conflicts.
Run bison with -v switch (thus, "bison -y -d -v gram.y") and look at
the y.output file it produces. More detail than you really wanted
words the least
reserved as possible.)
Also, make sure you've put them in keywords.c as well.
Chris
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Neil Conway
> Sent: Thursday, 11 April 2002 9:29 AM
> To: PostgreSQL Hackers
&
> In fact, my grammar currently has an obscene
> 20 shift/reduce and 4 reduce/reduce conflicts!
A shift/reduce conflict, IIRC, usually indicates a situation where
the grammar is unambiguous but may be inefficient. Eliminating them
is nice, but not critical.
A R/R conflict, in contrast, is a poi
On Wed, 10 Apr 2002, Bear Giles wrote:
> > In fact, my grammar currently has an obscene
> > 20 shift/reduce and 4 reduce/reduce conflicts!
>
> A shift/reduce conflict, IIRC, usually indicates a situation where
> the grammar is unambiguous but may be inefficient. Eliminating them
> is nice, but
1 April 2002 9:29 AM
> To: PostgreSQL Hackers
> Subject: [HACKERS] help with bison
>
>
> Hi all,
>
> I'm working on a fairly large patch (cleaning up Karel Zak's
> PREPARE/EXECUTE work), and I'm having some problems with bison (I'm
> a yacc newbie). In f
On Thu, 11 Apr 2002 10:54:14 +0800
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> wrote:
> Out of interest, since the FE/BE protocol apprently doesn't support prepared
> statements (bound variables), what does this patch actually _do_?
It implements preparable statements, by adding 3 new SQL state
> PREPARE AS ;
> EXECUTE USING ;
> DEALLOCATE ;
>
> I didn't write the original patch -- that was done by Karel Zak.
> But since that was several years ago, I'm working on cleaning it up,
> getting it to apply to current sources (which has taken a while),
> and fixing the remaining issues with i
Bear Giles <[EMAIL PROTECTED]> writes:
> As an aside, is there any reason to treat TEMP and TEMPORARY as two
> separate identifiers?
Yes: if the lexer folds them together then unreserved_keyword can't
regenerate the equivalent name properly. (Possibly this could be fixed
by making the lexer pass
> > As an aside, is there any reason to treat TEMP and TEMPORARY as two
> > separate identifiers?
>
> Yes: if the lexer folds them together then unreserved_keyword can't
> regenerate the equivalent name properly.
But if they're synonyms, is that necessary? I'm not indifferent to the
benefits of
Bear Giles <[EMAIL PROTECTED]> writes:
>> Yes: if the lexer folds them together then unreserved_keyword can't
>> regenerate the equivalent name properly.
> But if they're synonyms, is that necessary?
If I say
create table foo (temp int);
I will be annoyed if the system decides that the c
On Wed, 10 Apr 2002, Neil Conway wrote:
> Hi all,
>
> I'm working on a fairly large patch (cleaning up Karel Zak's
> PREPARE/EXECUTE work), and I'm having some problems with bison (I'm
> a yacc newbie). In fact, my grammar currently has an obscene
> 20 shift/reduce and 4 reduce/reduce conflicts!
Neil,
Will this allow you to pass bytea data as binary data in the parameters
section (ability to bind values to parameters) or will this still
require that the data be passed as a text string that the parser needs
to parse. When passing bytea data that is on the order of Megs in size
(thus
On Wed, 10 Apr 2002 22:36:49 -0700
"Barry Lind" <[EMAIL PROTECTED]> wrote:
> Neil,
>
> Will this allow you to pass bytea data as binary data in the parameters
> section (ability to bind values to parameters) or will this still
> require that the data be passed as a text string that the parser n
> The other day there was a discussion around the fact that X'' will
> get converted into an integer constant...
> ... while SQL99 says that this syntax *should* be used to specify a
> "binary string". It looks like the hex-to-integer magic actually occurs
> in the lexer, and then the integer
On Thu, 11 Apr 2002 15:02:49 +1000 (EST)
"Gavin Sherry" <[EMAIL PROTECTED]> wrote:
> On Wed, 10 Apr 2002, Neil Conway wrote:
>
> > Hi all,
> >
> > I'm working on a fairly large patch (cleaning up Karel Zak's
> > PREPARE/EXECUTE work), and I'm having some problems with bison (I'm
> > a yacc newbi
Neil Conway wrote:
> On Wed, 10 Apr 2002 22:36:49 -0700 "Barry Lind" <[EMAIL PROTECTED]>
> wrote:
>
>> Neil,
>>
>> Will this allow you to pass bytea data as binary data in the
>> parameters section (ability to bind values to parameters) or will
>> this still require that the data be passed
Gavin Sherry <[EMAIL PROTECTED]> writes:
> PrepareStmt: PREPARE name AS prepare_query types_prepare_clause
> prepare_store
> There is a reasonably clear problem here. prepare_query encompasses much
> of the grammar of the parser so it will definately cause shift/reduce and
> reduce/reduce confli
On Thu, 11 Apr 2002, Tom Lane wrote:
> Gavin Sherry <[EMAIL PROTECTED]> writes:
> > PrepareStmt: PREPARE name AS prepare_query types_prepare_clause
> > prepare_store
>
> > There is a reasonably clear problem here. prepare_query encompasses much
> > of the grammar of the parser so it will defina
Joe Conway writes:
> The other day there was a discussion around the fact that X'' will
> get converted into an integer constant, e.g.
> , while SQL99 says that this syntax *should* be used to specify a
> "binary string".
Actually, SQL99 is ambiguous regarding whether it represents a blob o
Thomas Lockhart wrote:
>> The other day there was a discussion around the fact that X''
>> will get converted into an integer constant... ... while SQL99
>> says that this syntax *should* be used to specify a "binary
>> string". It looks like the hex-to-integer magic actually occurs in
>>
The following example worked in previous versions (7.0.2 was the last I
tested), but not in 7.1 any more:
create table parent (
global_id serial
);
create table child (
anything text
) inherits (parent);
create table foreign (
fk_id int4 references parent(global_id) on update cascade on delete
I encountered a problem while implementing new CREATE
CONVERSION. Since converion procs are dynamically invoked while doing
an encoding conversion, it might fail for some reasons:
(1) stale pg_conversion entry. If someone re-register that proc, the
oid might be changed and the reference from
I am trying to find when WAL log files are rotated. The message is:
2002-02-11 21:18:13 DEBUG: recycled transaction log file 0005
and it is printed in MoveOfflineLogs(), and MoveOfflineLogs() is only
called by CreateCheckPoint(), but I can't see where CreateCheckPoint()
is called
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> The one big programming difficulty I see is the process of running through
> all the existing tuples in the relation the column was added to and
> evaluating the default for each row.
Basically you wanna do an "UPDATE tab SET col = ". I'd
su
At 03:48 PM 23/11/2002 -0800, Christopher Kings-Lynne wrote:
I assume that's the correct behaviour? If they specify a default, the
column should be auto-filled with that default, right?
Good question. We might want some input from other DBs; Dec RDB default
existing rows to NULL irrespective o
On Sun, 2002-11-24 at 08:34, Philip Warner wrote:
> At 03:48 PM 23/11/2002 -0800, Christopher Kings-Lynne wrote:
> >I assume that's the correct behaviour? If they specify a default, the
> >column should be auto-filled with that default, right?
>
> Good question. We might want some input from othe
On Sun, 2002-11-24 at 11:14, Hannu Krosing wrote:
> On Sun, 2002-11-24 at 08:34, Philip Warner wrote:
> > At 03:48 PM 23/11/2002 -0800, Christopher Kings-Lynne wrote:
> > >I assume that's the correct behaviour? If they specify a default, the
> > >column should be auto-filled with that default, rig
Philip Warner <[EMAIL PROTECTED]> writes:
> At 03:48 PM 23/11/2002 -0800, Christopher Kings-Lynne wrote:
>> I assume that's the correct behaviour? If they specify a default, the
>> column should be auto-filled with that default, right?
> Good question.
No, it's perfectly clear in the spec:
> "Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> > The one big programming difficulty I see is the process of running
through
> > all the existing tuples in the relation the column was added to and
> > evaluating the default for each row.
>
> Basically you wanna do an "UPDATE tab SET col
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
>> Basically you wanna do an "UPDATE tab SET col = ". I'd
>> suggest letting the existing machinery handle as much of that as
>> possible.
> Using SPI calls?
I wouldn't use SPI; it introduces way too many variables --- besides
which, you alre
Folks,
Someone contacted me in IRC about a bug in PL/PgSQL. I've confirmed that
the example SQL they sent me causes a segfault on my machine (CVS HEAD),
but I've so far not had a lot of success tracking down the exact cause
of the problem.
Backtrace:
#0 0x403ed17a in compatible_tupdesc (td1=0x8
Hi there,
attached archive contains simple parser demonstrating our
problem. untar it, make, make test
Good test:
echo -n 12 34.1234 ... | ./parser
INTEGER:'12'
CHAR: ' '
VERSION:'34.1234'
CHAR: ' '
DOT:'.'
DOT:'.'
DOT:'.'
Wrong:
echo -n 12 34.1234. ... | ./parser
On Wednesday 02 July 2003 01:20, Craig Jensen wrote:
> I need to have the rpm when installed create a database and a user with
> privilege to that database. These are the command functions I need to
> execute within the rpm...
> # service postgresql start
> # su postgres
> # createdb account
> # p
"Matthew T. O'Connor" <[EMAIL PROTECTED]> writes:
> cms_beau=# vacuum hits; (It works without the analyze phase of backup.)
> VACUUM
> cms_beau=# VACUUM verbose analyze hits;
> NOTICE: --Relation hits--
> NOTICE: Pages 8389: Changed 0, reaped 2, Empty 0, New 0; Tup 834575: Vac 0,
> Keep/VTL 4/4
Neil Conway wrote:
> Hi all,
>
> I'm working on implementing unique hash indexes. I've got most of the
> code finished, but I'm stumped on how to implement the remainder. Since
> I'm still a newbie to the Postgres code, so any pointers or help would
> be much appreciated.
>
> I've been able to b
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I encountered a problem while implementing new CREATE
> CONVERSION. Since converion procs are dynamically invoked while doing
> an encoding conversion, it might fail for some reasons:
> (1) stale pg_conversion entry. If someone re-register that proc, the
Tom Lane dijo:
> Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> > I encountered a problem while implementing new CREATE
> > CONVERSION. Since converion procs are dynamically invoked while doing
> > an encoding conversion, it might fail for some reasons:
>
> > (2) buggy conversion proc is defined by
En Sat, 31 Aug 2002 23:27:08 -0400 (EDT)
Bruce Momjian <[EMAIL PROTECTED]> escribió:
> I am trying to find when WAL log files are rotated. The message is:
>
> 2002-02-11 21:18:13 DEBUG: recycled transaction log file 0005
>
> and it is printed in MoveOfflineLogs(), and MoveOffline
It is called by a special child process of the postmaster after a
signal. Search for PMSIGNAL_DO_CHECKPOINT in xlog.c and in postmaster.c.
The checkpoint process gets started out of sigusr1_handler().
On Sat, 2002-08-31 at 23:27, Bruce Momjian wrote:
> I am trying to find when WAL log files are
Thanks, got it.
---
J. R. Nield wrote:
> It is called by a special child process of the postmaster after a
> signal. Search for PMSIGNAL_DO_CHECKPOINT in xlog.c and in postmaster.c.
> The checkpoint process gets started out
Neil Conway <[EMAIL PROTECTED]> writes:
> Someone contacted me in IRC about a bug in PL/PgSQL. I've confirmed that
> the example SQL they sent me causes a segfault on my machine (CVS HEAD),
> but I've so far not had a lot of success tracking down the exact cause
> of the problem.
The core dump app
On Fri, 2003-01-10 at 20:28, Tom Lane wrote:
> The core dump appears to occur when the SELECT INTO fails to retrieve
> a row, leaving "finalrec" undefined.
Thanks very much for your help, Tom.
> Clearly, RETURN NEXT with an undefined record variable shouldn't dump
> core, but what should it do? R
Neil Conway <[EMAIL PROTECTED]> writes:
> On Fri, 2003-01-10 at 20:28, Tom Lane wrote:
>> Clearly, RETURN NEXT with an undefined record variable shouldn't dump
>> core, but what should it do? Raise an error, or perhaps be a no-op?
> I'd vote for making it a no-op. Raising an error is too severe fo
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
> Neil Conway <[EMAIL PROTECTED]> writes:
> > On Fri, 2003-01-10 at 20:28, Tom Lane wrote:
> >> Clearly, RETURN NEXT with an undefined record variable shouldn't dump
> >> core, but what should it do? Raise an error, or perhaps be a
"Mike Mascari" <[EMAIL PROTECTED]> writes:
>> Does Oracle's PL/SQL have a concept of record variables? If so, what
>> do they do in this situation?
> In Oracle 8, a row of NULLs:
> 1 CREATE OR REPLACE FUNCTION foo(t IN NUMBER)
> 2 RETURN NUMBER
> 3 IS
> 4 emp_rec employees%ROWTYPE;
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
> "Mike Mascari" <[EMAIL PROTECTED]> writes:
> >> Does Oracle's PL/SQL have a concept of record variables? If so, what
> >> do they do in this situation?
>
> > In Oracle 8, a row of NULLs:
>
> > 1 CREATE OR REPLACE FUNCTION fo
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
> "Mike Mascari" <[EMAIL PROTECTED]> writes:
> > From: "Tom Lane" <[EMAIL PROTECTED]>
> >> That's a rowtype variable, though, not a record variable. I believe our
> >> code will work the same as Oracle for that case.
>
> > 4 TY
On Sat, 11 Jan 2003, Tom Lane wrote:
> "Mike Mascari" <[EMAIL PROTECTED]> writes:
> > From: "Tom Lane" <[EMAIL PROTECTED]>
> >> That's a rowtype variable, though, not a record variable. I believe our
> >> code will work the same as Oracle for that case.
>
> > 4 TYPE EmpRec IS RECORD (
> > 5
Dear Sir,
I want to know the compilaiton and execution of my
code. Suppose if i add a test printf statement in the
src/backend/tcop/postgres.c and after compilation and
execution i should get that statement every time i give
a query to psql.
After running make I even added t
Sorry,
forgot to attach archive :)
Oleg
On Tue, 1 Jul 2003, Oleg Bartunov wrote:
> Hi there,
>
> attached archive contains simple parser demonstrating our
> problem. untar it, make, make test
>
> Good test:
> echo -n 12 34.1234 ... | ./parser
> INTEGER:'12'
> CHAR: ' '
> VERSIO
Oleg Bartunov kirjutas T, 01.07.2003 kell 15:49:
> Hi there,
>
> attached archive contains simple parser demonstrating our
> problem. untar it, make, make test
>
> Good test:
> echo -n 12 34.1234 ... | ./parser
> INTEGER:'12'
> CHAR: ' '
> VERSION:'34.1234'
> CHAR: ' '
> DOT:
On Wed, 1 Jul 2003, Hannu Krosing wrote:
> Oleg Bartunov kirjutas T, 01.07.2003 kell 15:49:
> > Hi there,
> >
> > attached archive contains simple parser demonstrating our
> > problem. untar it, make, make test
> >
> > Good test:
> > echo -n 12 34.1234 ... | ./parser
> > INTEGER:'12'
> > C
Oleg Bartunov kirjutas K, 02.07.2003 kell 11:39:
> > > The problem is recognizing VERSION
> > > (from gram.y)
> > >
> > > version:
> > > INTEGER DOT INTEGER{ $$ = strconcat($1, $3, $2); }
> > > | version DOT INTEGER { $$ = strconcat($1, $3, $2); }
> >
> > removing the line abo
Ooops, sorry, error in this example:
> The following example worked in previous versions (7.0.2 was the last I
> tested), but not in 7.1 any more:
>
> create table parent (
> global_id serial
> );
>
> create table child (
> anything text
> ) inherits (parent);
>
> create table foreign (
> fk_id in
From: [EMAIL PROTECTED] (Bogdan)
Newsgroups: comp.databases.postgresql.questions
Subject: help with I/O statistics in 7.3.1
NNTP-Posting-Host: 12.98.224.90
Message-ID: <[EMAIL PROTECTED]>
I can't make configuration to get "filesystem blocks in/out"
to show valid data.
Im only getting "0/0" all th
Why don't you use elog(LOG, instead of printf ?
--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so
is my test: %s", string);
>
> Chris
>
> - Original Message -
> From: "Srikanth M" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 28, 2003 3:08 PM
> Subject: [HACKERS] Help needed in testing my code.
>
>
> > Dear Sir,
>
Dear Sir
I am new to postgres and dont know the excat procedure of
testing my code, okay i will use elog, but please tell me the procedure
of testing that.
for example,pls tell what should i do after i add code, what make files
should i run and where should i place the new executables.
> "Srikanth" == Srikanth M writes:
Srikanth> Dear Sir I am new to postgres and dont know the excat
Srikanth> procedure of testing my code, okay i will use elog, but
Srikanth> please tell me the procedure of testing that.
Srikanth
As you're a big fan of stealing code, why don't
On Wed, May 28, 2003 at 12:59:56PM +0200, Sailesh Krishnamurthy wrote:
> elog(NOTICE should send NOTICE messages to the psql client (I think !)
> while elog(LOG while only send it to the logfile you might have
> specified while starting the postmaster
Whether a given elog level is sent to the po
Hi,
This is a much better way than printf:
elog(NOTICE, "this is my test: %s", string);
Chris
- Original Message -
From: "Srikanth M" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, May 28, 2003 3:08 PM
Subject: [HACKERS] Help needed
On Wed, 20 Jun 2001, Mike Haberman wrote:
> hello all,
>
> I am using an xml -> sql generator where foreign key are specified
> after the columns are. The sql is written as the xml file is being
> parsed so, the foreign key stuff must be written after the fact.
>
> The problem I need to solve
Matthew <[EMAIL PROTECTED]> writes:
> NOTICE: RegisterSharedInvalid: SI buffer overflow
> NOTICE: InvalidateSharedInvalid: cache state reset
These are normal; at most they suggest that you've got another backend
sitting around doing nothing (but in an open transaction) while VACUUM
runs.
I think
Hi all,
I did an initial patch for ALTER TABLE / SET NULL that should just say 'not
implemented' when someone tries it, but I get this:
template1=# alter table test alter column a set null;
ERROR: parser: parse error at or near "null"
template1=# alter table test alter column a set null_p;
ERRO
You'll need to make a unique index/unique constraint on the fields
of child you wish to constrain. The unique constraint check wasn't
checked in 7.0, and also unique constraints are not inherited so
it has to be on the actual table you want to reference.
Stephan Szabo
[EMAIL PROTECTED]
On Wed,
Bogdan <[EMAIL PROTECTED]> writes:
> I can't make configuration to get "filesystem blocks in/out"
> to show valid data.
> Im only getting "0/0" all the time.
> Is that functionality available in postgres 7.3.1 ???
That is just printing what getrusage() tells it. Complain to your OS
authors.
Tom Lane wrote:
>
> Bogdan <[EMAIL PROTECTED]> writes:
> > I can't make configuration to get "filesystem blocks in/out"
> > to show valid data.
> > Im only getting "0/0" all the time.
> > Is that functionality available in postgres 7.3.1 ???
>
> That is just printing what getrusage() tells it. C
hi all,
tried this on pgsql-admin & darwin-kernel lists, and unfortunately, not a
'nibble' ...
can ne1 here spare a moment?
thanks!
richard
-- Forwarded Message --
hi all,
i've successfully built postgreSQL 7.3.2-STABLE on Mac OSX 10.2.4.
much trouble launching it led me to
my cgi program is
test.cgi:###require
"./connectdb.pl";&connectdatabase();$query="select count(*) from
messages";$sth=$dbh->prepare($query);$sth->execute();$count=$sth->fetchrow_array();print
"Content-type: text/html\n\n";print
<<"TAG"; The count is
$count. TAGexit
0;#
82 matches
Mail list logo