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
Hallo,
is there a reason why
the grant syntax for views isn't included in the documentation?
(eg REFERENCES doesnt make sense for a view)
cf
http://www.postgresql.org/docs/9.2/static/sql-grant.html
or
\h grant in psql
GRANT INSERT ON view_x TO user_y;
works this for scripting reasons i suppose
(
> > > > the problem arises when u have a field value that contains a newline
> > > > character, when this field is not the first column, then all the data
> > > > after this newline comes in the first column..
> > > >
> > > > u can try this out, writing a function or table,
> > > > and then add 'e
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
Hallo,
psql latex output format needs to differentiate between a newline and a
tabularnewline.
the problem arises when u have a field value that contains a newline
character, when this field is not the first column, then all the data
after this newline comes in the first column..
u can try this
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
Gc,
For passwords the use of
http://www.postgresql.org/docs/8.4/interactive/pgcrypto.html
is advised.
But what about GPU cracking?
Is crypt-bf/8 strong enough?
cf bcrypt in php:
http://stackoverflow.com/questions/6791126/how-is-bcrypt-more-future-proof-than-increasing-the-number-of-sha-iteratio
Hallo,
psql feature request
i would be nice if
/o file_with_less.txt
for redirecting output to a file
could contain the same info as the logfile
psql -a -L file_with_more.txt
(and -eE if u need it)
option -a echo's all, but this info doesn't get written to
/o file_with_less.txt
why?
within on
Hallo,
good reasons to use prep statements
seem
- performance
- some sql injection defence
but when i look at plpgsql
http://www.postgresql.org/docs/8.4/interactive/plpgsql-implementation.html
i see that sql statements are translated into prep statements,
and live (the plan) as long the db conne
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
Hallo,
does anyone have know of a free CRUD generator
for generating plpgsql functions for doing CRUD operations on all the
tables of a database or schema or just one table or..
cf
http://postgresql.1045698.n5.nabble.com/CRUD-functions-similar-to-SQL-stored-procedurs-for-postgresql-tables-td33720
Hallo,
Using libpqexec many error details can retrieved:
http://www.postgresql.org/docs/8.4/interactive/libpq-exec.html
(such as PG_DIAG_SEVERITY, PG_DIAG_MESSAGE_HINT,
PG_DIAG_STATEMENT_POSITION.. as on the site above)
eg:
http://pgsql.privatepaste.com/656698b511
but when u try to trap/catch all
Hallo,
i have a possible feature request.
It is not possible to get the sql statement itself and the output of the
statement in a user-friendly way to an output file (option \o psql),
this is only possible outside of psql, when calling this function with
an option -L (psql -L log.txt).
The nice t
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
Hallo,
according to
http://www.postgresql.org/docs/8.4/interactive/sql-syntax-lexical.htm
A token can be a key word, an identifier, a quoted identifier, a literal
(or constant), or a special character symbol.
I suppose these different tokens are used by the internal parser?
So my questions is,
is
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
> > &
Hallo,
goal:
to write the input and query results to different files in 1 script
context example:
1 sql script demo.sql
"
--init messaging
\set client_min_messages warning
\set log_error_verbosity terse
--user1
SET SESSION AUTHORIZATION user1;
\pset format html
\o report/test_user1.html
\i stru
Hallo,
there exist many framework that 'backward' engineer from a programming
language to database to make the data persistent.
so: code >> db (generated)
eg. hibernate, turbogears many others
My question is, from db point of view, do we have such frameworks that
work the other way,
ie that f
Hallo,
i have tested some tools,
but none of them have the all the functionality i'm looking for:
(erd/sql(/db))
- forward engineer SQL (to db (and uncluttered erd))
- backward engineer SQL (to sql and uncluttered erd)
- compare
- autocompletion when writing code
(erd)
- full postgresql suppo
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
26 matches
Mail list logo