unity for their work.
--
mvg,
Wim Bertels
--
ROMEO: Courage, man; the hurt cannot be much.
MERCUTIO: No, 'tis not so deep as a well, nor so wide
as a church-door; but 'tis enough, 'twill serve.
--
Sent via pgsql-general mailing list (pgs
write the proposal.
Also no garanties, since the the project needs to be approved,
it's a new program, so predicting the approval chances is hard, but i
think it's an opportunity.
mvg,
Wim
--
--
Wim Bertels
Lector
Katholieke Hogeschool Leuven
Departement Gezondsheidszorg en Technolog
ppose
(views are readonly at this point, rules..)
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Wim>> I have a postgres db version 8.2.15 (Yes, I know it's rather old version).
Wim>> After correcting some disk and file system problems the postgres table
seems to be corrupt, returning:
Wim>>
Wim>> ERROR: xlog flush request B67/44479CB8 is not satisfied --- flus
database?
How difficult would it be to extract data directly from the files containing
the data?
(FYI: the fields used in the most important table are: bigint, character
varying(32), character(1), integer, smallint, text)
Regards,
Wim Goedertier
in the
generated tex code s\textwidth\20cm for example, makes every box 20cm at
maximum. (maybe to be put in the docu somewhere as a comment on
textwidth). This all depends on the page format, unfortunately (for now?
in latex) the nice (p)aragraph formatting doesn't fully extend inside a
tabl
On vr, 2012-02-10 at 19:25 -0500, Bruce Momjian wrote:
> On Mon, Dec 12, 2011 at 07:15:12PM +0100, Wim Bertels wrote:
> > Hallo,
> >
> > psql latex output format needs to differentiate between a newline and a
> > tabularnewline.
> >
> > the problem arises
| TABLE(out_field1 integer,
: out_field2 character varying,
: out_del boolean)
out_description | This function deletes a record
: given the following ..
..
: .. foreign_key_violation.
mvg,
Wim
On ma, 2011-11-28 at 13:00 +0100, Szymon Guz wrote:
>
>
> On 28 November 2011 12:55, Wim Bertels
> wrote:
> Hallo,
>
> if u compare the 2 queries, then they should be equivalent:
>
> -- normal
> -- EXPLAIN AN
/8.4/static/using-explain.html
Suggestions, comments are always welcome.
mvg,
Wim Bertels
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-iterations
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hy?
within one psql script u can have several consecutive output files,
maybe even with different layouts,
this is not possible with the logfile option
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.or
function.
Comments?
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, 2011-06-22 at 09:02 -0500, Merlin Moncure wrote:
> On Wed, Jun 22, 2011 at 5:40 AM, Wim Bertels wrote:
> > Hallo,
> >
> > does anyone have know of a free CRUD generator
> > for generating plpgsql functions for doing CRUD operations on all the
> > tables of
-td3372030.html
http://myleshenderson.com/index.php/2007/11/16/postgresql-insert-function-generator
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
error
details as given by libpg-exec as well.
Eg adding SEVERITY, MESSAGE_HINT, STATEMENT_POSITION, ..
where we now only have SQLSTATE and SQLERRM
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
oesnt get written to the file1 (of \o file1)
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Thu, 2011-04-14 at 16:53 -0400, Tom Lane wrote:
> Wim Bertels writes:
> > is there a function one could use to filter out the specific tokes?
>
> In 8.4 and up, pg_get_keywords() might help.
indeed something i could use as reference
i'm actually looking for a wa
| type
Insert keyword
intokeyword
my_tableidentifier
values keyword
..
'hi there' literal
or in another way with similar functionality?
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
On Fri, 2011-02-04 at 03:23 -0800, Bosco Rama wrote:
> Wim Bertels wrote:
> > On Wed, 2011-02-02 at 12:49 -0800, Bosco Rama wrote:
> >> Wim Bertels wrote:
> >> >
> >> > --user2
> >> > SET SESSION AUTHORIZATION user2;
> >> > \pset
On Wed, 2011-02-02 at 12:49 -0800, Bosco Rama wrote:
> Wim Bertels wrote:
> >
> > --user2
> > SET SESSION AUTHORIZATION user2;
> > \pset format latex
> > \echo ECHO queries
> > \o report/test_user2.tex
> > \i structure/test_user2.sql
> > &
,
is using redirection.
starting for example
> psql -L out.txt # only txt markup
or
> psql > out.txt
But then if have to postprocess the out.txt file, dividing it into
several different files, and the format/markup doenst work so nice any
more.
Suggestions?
tnx,
Wim
--
Sent via pg
her way,
ie that forward engineer from a database to a user interface (web or
program),
maybe using the stored procedures available on the database (eg in the
same naked objects work)
so: exisiting db (possible + stored procedures) >> user interface (eg
crud or other)
mvg,
Wim
--
Sent via
good developing tool
though.
Any suggestions with regard to good gplike erd/sql developing tools for
postgresql?
No mails about proprietary or closed source tools plz.
mvg,
Wim
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
t;[EMAIL PROTECTED]> wrote:
>
> does psql have write access to the folder?
>
> M-
>
> - Original Message -
> *From:* Wim Chalmet <[EMAIL PROTECTED]>
> *To:* pgsql-general@postgresql.org
> *Sent:* Tuesday, December 04, 2007 10:27 AM
> *Subject:* [GENERAL] Va
Hi,
Sorry for my basic question here, but I can't figure things out. I am
running postgres in a windows environment. I would like to redirect the
output from a "vacuum full analyze verbose;" to a text file. How do I do
this?
I have tried this (the file "run_vacuum.sql" just contains this one line
Hallo,
version 7.4.7
i first grant a group some privileges,
then i take those privileges away from a user in this group,
somehow this doens't work (no errors, but the rights aren't revoked)
eg:
GRANT ALL ON TABLE test TO GROUP groep;
--the user jimmy is part of groep;
REVOKE ALL ON TABLE test
Hi,
does anyone know a good opensource tool to do datawarehousing,
(instead of having to manage an mssql server and so on,
so just sticking to postgres or another good os-db.)
it is client and serverside.
tnx,
---(end of broadcast)---
TIP 2: D
Onyx schreef:
When i look at pgadmin:
an anoying feature: it closes when u do something illegal, instead of
saying: u don't have the rights to do this.
Which version of PgAdmin were you using? III? Or II? In my findings, I
have had similiar problems to what you have been experiencing
Dear friends,
i've been using postgresql quiet some time now,
but i don't find any really good clients for "dummies" to this database.
When i look at pgadmin:
an anoying feature: it closes when u do something illegal, instead of
saying: u don't have the rights to do this.
When i look at phpgpadm
o help you. And
remember: in a open source community, you'll never be alone ;-)
Cheers!
Wim
Amy Young wrote:
Bret,
Thanks for voicing your opinion. I'll second it as loudly as I can.
I work for a small 5 member team in a major hospitality corporation.
Our team has a mish mash of re
ying something like:
NOTICE: Rel pg_class: TID 294/3: InsertTransactionInProgress 20065 - can't
shrink relation
NOTICE: Rel pg_class: TID 294/4: InsertTransactionInProgress 20065 - can't
shrink relation
NOTICE: Index pg_class_relname_index: NUMBER OF INDEX' TUPLES (1615) IS NOT
THE SAME AS HEAP' (1587)
NOTICE: Index pg_class_oid_index: NUMBER OF INDEX' TUPLES (1615) IS NOT THE
SAME AS HEAP' (1587)
VACUUM
But it works in 7.0
Cheers Wim.
Dit you do an initdb as postgres?
i.e. you have a: /usr/local/pgsql/data dir?
Cheers Wim.
- Oorspronkelijk bericht -
Van: Greg Brzezinski <[EMAIL PROTECTED]>
Aan: <[EMAIL PROTECTED]>
Verzonden: Saturday, March 18, 2000 4:53 PM
Onderwerp: [GENERAL] Problem with beta2
e:
\connect foodb
begin;
alter user hr270 nocreateuser;
REVOKE all on foo from pn407;
REVOKE all on bar from pn407;
another 1000 of revokes
.
.
REVOKE all on foo2 from pn407;
end;
And while doing that I perform a vacuum.
vacuumdb foodb
Please tell me I'm doing something I really shouldn't be doing.
Cheers Wim.
something here and should I never use vacuum in a script
invoked by users?
Thanks Wim.
> Bruce Momjian wrote:
>
> > > > > > > Anyone seen this message or know what it means?
> > > > > > >
> > > > > > > NOTICE: Index pg_pro
Hi Steve,
Have you checked for inserts in the message field larger then 8k?
Cheers Wim.
Steve Wolfe wrote:
> Grr
>
> Although I'm no longer getting lock releases on this table, a daily
> vaccum analyze still shows:
>
> NOTICE: Rel reef: Uninitialized page 492
t uses an inefficient
storage format and no integrity checks.
You would in this case use the database server always just to service 1
client program.
Regards
Wim
; > implementation-dependent.
> >
> > I see no way that allowing the transaction to commit after an overflow
> > can be called consistent with the spec.
>
> Of course it can not commit this single statement that was in error.
> All he wants is to commit all other statements, before and after the
> error statement inside this same transaction.
>
Isn't the intention of a transaction that it is atomic, i.e. either all
statements pass or none of them? (see section 5.4 in the standard).
Wim
Karl Eichwalder wrote:
>
> Wim Ceulemans <[EMAIL PROTECTED]> writes:
>
> | I can't seem to install the latest postgresql opn Suse linux 6.3 (kernel
> | 2.2.13, glibc 2.1.2). I always get the following message when I run
> | ./configure :
> |
> | che
Sorry Ross,
I replied to early, the second example covers it.Oops
Wim.
"Ross J. Reedstrom" wrote:
> On Mon, Nov 22, 1999 at 02:45:04PM +0100, Wim Aarts wrote:
> >
> > Now I use php3 to read the text from the database then I append some
> > text to it and fi
more text' WHERE word_id = 1;
Resulting in:
test=> SELECT * FROM test_text;
word_id|words
---+---
1|some text some more text
Hope this explains my question.
Thanks.
"Ross J. Reedstrom" wrote:
> On Mon, Nov 22, 1999 at 02:45:04PM +0100, Wim Aarts wrote
Now I use php3 to read the text from the database then I append some
text to it and finaly I do an update on the text field.
Is it possible to use an SQL statement to do this directly in the
database?
Thanks Wim.
I use: Posgresql 6.5.3 Linux 5.2 PHP3
begin:vcard
n:Aarts;Wim
tel;cell:06
user www.
To connect to the database use the form:
psql -h hostnameORipaddress -u dbname
Cheers Wim.
"Sean W. Ellis" wrote:
> wim wrote:
> >
> > Hi Sean,
> >
> > I'm approaching my database over the internet as well. I wondered what you
> > use to
Thanks Aaron,
That is exactly what I wanted. Much more simple then what I was thinking.
On 10-Aug-99 Aaron Seigo wrote:
> hi wim..
>
>>select * from company where created
>>is between (lastpaid + 14 days) and (created + 28 days);
>
> assuming that lastpaid and creat
7;t figure out the syntax that will let me add days to a date. I checked
the archives and the Postgresql doc's, but nothing.
Ideas?
Thanks,
Wim Kerkhoff.
>Can some experts , users or gurus provide me some insight or
>guide me to some pointers where impartial comparative analysis of
>RDBMS has been done.
Look at http://www.mysql.com/crash-me-choose.htmy for a comparison between
databases.
Wim Ceulemans - [EMAIL PROTECTED]
Nice
and after you've done:
reset QUERY_LIMIT;
and in 6.5 I think there is even a better way?
Regards
Wim Ceulemans - [EMAIL PROTECTED]
Nice Software Solutions - http://www.nice.be
Eglegemweg 3, 2811 Hombeek - Belgium
Tel +32(0)15 412953 - Fax +32(0)15 412954
Why not use Java in stead of SWIG - TCL/TK - PHP? Or is java not free in
your opinion?
Regards
Wim Ceulemans - [EMAIL PROTECTED]
Nice Software Solutions - http://www.nice.be
Eglegemweg 3, 2811 Hombeek - Belgium
Tel +32(0)15 412953 - Fax +32(0)15 412954
>
>I've been working on a
int,link1 int);
create table test2 (id2 int, field2 varchar(5));
where link1 is a foreign key of test1 that should be linked to id2 of test2
Now when I execute the following query:
select id1,field2,link1 from test1,test2 where test1.link1=test2.id2
union
select id1,NULL,link1 from test1;
I
not quite the same because it also finds for example 'tempest',
whereas the like search does not find it. So is there a postgreSQL operator
that does the same as the like %% search but case insensitive?
Regards
Wim Ceulemans
Nice Software Solutions
Eglegemweg 3, 2811 Hombeek - Belgium
ate comprehensive comparisan at:
http://www.tcx.se/crash-me-choose.htmy
Sorry to redirect you to the mySQL site, postgreSQL is better but they have
a good comparisan
Regards
Wim
er tst1003;' in postgresql. But I the same error pops up if I type \dt or
\di
Do you have any other suggestions?
-Original Message-
From: Vadim Mikheev <[EMAIL PROTECTED]>
To: Wim Ceulemans <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Frida
to another computer. Is this in fact the way to copy databases?
After copying everything works except for example \dt , \di which gives the
following
error:
ERROR: cache lookup for userid 1003 failed
What does this mean?
Regards
Wim Ceulemans
Nice Software Solutions
-Original Message-
From: Andrew Gibson <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, July 29, 1998 1:59 PM
Subject: [GENERAL] Mac Connectivity
>Hi,
>
>Has anyone achieved Macintosh connectivity to PostgreSQL?
Yes, but with the postgreSQL JDBC driver. Yo
54 matches
Mail list logo
