SQL-2011 and PostgreSQL specifics
keywords. May works with any other databases too. It shares the same
code with pgBadger, so any improvement made in the parser is reversed to
pgBadger. Tool created by Gilles Darold.
pgFormatter can work as a console program or as a CGI. It will
automatically detect his env
t, any idea?
>
>
> Best guess it is stored in a table in the schema.
As Adrian says, there's no equivalent with PostgreSQL. You will need to
use custom variable in postgresql.conf or a table to store your global
information.
Best regards,
--
Gilles Darold
Consultant PostgreSQL
http://dalibo.com - http://dalibo.org
On 22/05/2015 06:09, Adrian Klaver wrote:
> On 05/21/2015 09:04 PM, Alvaro Herrera wrote:
>> Adrian Klaver wrote:
>>
>>> SELECT
>>> extract (
>>> YEAR
>>> FROM
>>> school_day ) AS YEAR,
>>
>>> Reformatting courtesy of pgFormatter(http://sqlformat.darold.net/).
>>
>> FWIW
ded to decide me: no more Java !
Regards
Gilles Darold
Alex Knight wrote:
> Daniel, thank you kindly for your input.
>
> However, mod_perl is absolutely slower than most any j2ee application.
> If all you are doing is keeping a session variable to count number of hits
> on a web
statistics, I've planed it
to the end of the year :-)
Regards,
Gilles Darold
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Hi,
Extraction of large amount of data is not realistic especially with
CGI, then DBI/DBD::Pg always return all data received from a query
so if you don't want to tired your machine, the better way is to use
cursor in a transaction (or query) or the LIMIT+OFFSET keywords.
Regards
G
Hi,
Another point regarding /contrib or other directory like /tools is to
centralize tools for Pg. Also I can't be sure to always have an URL.
This one is dependant on the company I'm working now.
Life is moving.
Regards
Bruce Momjian wrote:
> [ Charset US-ASCII unsupported, converting... ]
>
Add on on ora2pg.
Table grant extraction is done. It is based on group/users grants.
Oracle has ROLES that I understand as groups and users associated to
these roles. So I create a group for each role and alter it by adding the
users.
And then set grants to each tables.
Let me now if I have to
Hi,
As I previous searched a tool to convert Oracle database to PostgreSQL
and really found nothing, there's now a piece of perl code I've written
that
can become a great tool to do this job.
It currently extract the database schema table definition of an Oracle
database
and output a sql script
Hi,
What package do you have downloaded ? You need the full install not just
the base package.
Regards,
Gilles
Al wrote:
> I am running OpenLinux 2.3 (Caldera) out of the box. Trying to install
> PostGreSQL I seem to be unable to get past the 'make' process. Errors I
> get at the end of the
Hi,
I widly use DBI/DBD::Pg and doesn't notice any problem. Perhaps because
there's no error or they are well handled :-)). I'm interested to know more
about this problem because I have many script to review in that case.
Could you please send more explanation of the problem and some source code
Peter Eisentraut wrote:
> This could be a name mangling problem. Maybe the linker needs to be
> invoked specially when building C++ libraries. Maybe the C++ compiler
> driver needs to be invoked directly. This could especially be a problem
> if you're using the GNU compiler with system librari
Gilles DAROLD wrote:
> Hi,
>
> I am currently testing beta6 on AIX 4.3.3 on a RS6000 H80 with 4 cpu and 4
> Go RAM
> I use :
>
> ./configure
> --with-CC=/usr/local/bin/gcc
> --with-includes=/usr/local/include
> --with-libraries=/usr/local/li
Hi,
It works for me with 5.6.0 !
Hans-Jürgen Schönig wrote:
> Hans-Jürgen Schönig schrieb:
>
>> Does anyone know why
>> perl Makefile.pl
>> doesn't produce a useful Makefile with RedHat 7.0 (Perl 5.6) and
>> PostgreSQL 7.0.3?
>>
>> Hans
>
>
> After some hard hours of debugging and testi
ters (such as quotation marks) contained
within the string and adding the required type of outer quotation
marks.
$sql = $dbh->quote($string);
Regards
Gilles DAROLD
Oleg Lebedev wrote:
> Hello,
> I am using postgresql to store data passed from a web page. A user may
> e
m you probably do not have open source.
I don't think PostgreSQL can handle this syntax but it will be a great
feature to uniformize my perl source code :-) even if it does nothing.
Regards
Gilles DAROLD
Steven Saner wrote:
> I am trying to get Visio (5.5 Enterprise) on Win98/NT to talk wi
Hi,
Just try it and you will trust it ! Personnaly I use it for a long time...
but don't trust me I'm a persistance mistake, perhaps one day I will
write a pool of mistake :-)
Regards
Gilles DAROLD
August Zajonc wrote:
> Apache is multi-process. What are you talking about? If I
Hi,
With Apache/mod_perl it is very simple to enable DB connection
persistance.
in your perl script :
use vars qw($dbh);
$dbh ||= DBI::connect($datasrc, $dbuser, $dbpwd);
That create a persistance connection to your DB and you do not have to
care
about a pool of connection. Double pipe do all
Hi,
Do you use the file GNUmakefile and ppport.h I recently send to the list ?
What is your version of Perl ?
Could you send me output of your build ?
Regards,
Gilles DAROLD
Larry Rosenman wrote:
> Broke my build on UnixWare 7.1.1... May be perl version confusion...
>
> See m
patch < ppport.patch
rm ppport.patch
Thanks to Kenneth Albanowski for his PPPort.pm usefull package and to Tom Lane
for his ligth.
Note: the attachment is a tar of all modified and added files in the source tree.
Regards,
Gilles DAROLD
ppport-change.tar.gz
Hi,
I've got this very bad message with Apache 1.3.6 running mod_perl and
postgresql
6.3.2 with a site hosted by an ISP. They just allocate a max of 10 Mo of memory
for
each user.
For me this was a message coming from server resources. Not enougth memory.
At home with the same configuration I ne
rrgv and PL_na you will get
> > success to compile the lib plperl.so.
> >
This patch (simple diff) applies to postgresql-7.0.2.
See attachment...
Regards
Gilles DAROLD
328c328
< if (SvTRUE(GvSV(PL_errgv)))
---
> if (SvTRUE(GvSV(errgv)))
334c334
<
#x27;t remember exactly what it does with search (AND/OR) but this depend
on what you want
as result, so hack it.
Of course it's Perl... Search is very fast !
And in any way you can easily hack it to match your needs.
Let me know if your are interested I will post it to the list.
Regards,
Tom Lane wrote:
> "Edward Q. Bridges" <[EMAIL PROTECTED]> writes:
> > since there is no email address for a maintainer on that, i post it here
> > for review, comment, and (hopefully) integration with the source tree.
>
> Mark Hollomon <[EMAIL PROTECTED]> is the originator of plperl. Please
> ge
Hi,
I have take a look to the source code concerning PL/Perl, it seems that 2 variables
have a bad call : errgv and na.
If you replace them by their normal call (in 5.6.0) PL_errgv and PL_na you will get
success to compile the lib plperl.so.
Also in Perl documentation you will find the answer f
Take a look at the sql COPY command (\h COPY) it will do it as you want
!
[EMAIL PROTECTED] wrote:
>
> How should I go about importing the contents of an Excel spreadsheet
> into a Postgres database table?
>
> I was considering a comma separated file, but am not sure how to
> import this into
Hi,
> How can I retrieve the "names" of all the tables in my database ?
Not sure what you are using but if you use DBI perl interface you can
use
this two functions :
$sth = $dbh->table_info;
@names = $dbh->tables;
They works well with DBD::Pg.
In psql simply type \d. this is certainly n
jprem wrote:
> hello ,
>postgreqsl 6.5.3 does not support nested transactions.
> so i don't think it will be suitable for e-com application.isn't it ?
> does postgreqsl 7.0 support nested transacions ? is postgresql 7.0 a
> stable version ?
Hi,
I have around 4000 online shop runnin
Hi,
I have seen DBengine on Freshmeat few weeks ago, perhaps this this what
you
are looking for...
Regards,
Gilles
"Jeffrey A. Rhines" wrote:
> It seems i remember seeing somewhere that someone had developed a
> generic web front-end to Postgres. Was this a dream, or has someone
> else seen
h belong to the
University of California
what programmers can do to protect their works ?
Apology my poor understanding but it smell something wrong for me. Is
PostgreSQL Inc. have
the same need than Landmark/Great Bridge concerning this licence migration
?
Regards,
Gilles DAROLD
Hi,
I want to find information into your search engine for postgresql
mailing
list but I can't find any answer to my search.
Typing SELECT or CURSOR or any other words in pgsql-general or pgsql-sql
give me no output. Perhaps you have an indexation problem ?
Regards
Hi,
For case insensitive you must use the regexp search as follow :
SELECT title, firstname, lastname, description FROM stuff
WHERE title *~ '.*.*' AND firtsname *~ '.*.*';
>
> P.S.: as far as I know there is no locale for windows-1251 and,
> unfortunately, I can't store data in koi8-r w
work
with Apache
take a look at mod_perl :
http://perl.apache.org/
and DBI-DBD at
http://theory.uwinnipeg.ca/CPAN/by-name/DBD-Pg.html
Sorry if it don't help you.
Gilles Darold
handle is used by two processes at the same time. Each
child must have it's own unique connection handle.
Gilles DAROLD
perhaps France is not in the
world :-) Here I
can not find any offer with PostgreSQL and WWW services really cost a
lot : $70-90/month
for a normal little housed domaine name with 10Mo !
Thanks again,
Regards,
Gilles Darold
difficult because I use
Perl/DBI but I really don't
want to. I want PostgreSQL because I need PostgreSQL as a professional
solution.
Also, I'm a free developper. I do it by myself on my sleep time as most
part of you,
so I need cheapest services :-)))...
Thanks a lot,
Gilles Darold
Hi stuart,
It means that (as I know) you don't need C++ compiler to compile and run
PostgreSQL
on your machine. But you will not be able to link C++ application with
PostgreSQL.
Why? This is because you will not have Libpq++ compiled. Ok, I promise you to
be
more efficient next time :-)))
Regar
Hi,
Part II (translation) : You need C++ compiler installed on you Linux box.
See your log :
> checking for c++... no
> checking for g++... no
This is the reason.
Regard,
Gilles.
Jonathan Scott wrote:
> Hello fellow PostgreSQL users.:)
>
> I am having trouble with the configure file for vers
Bonjour Sandrine,
Ton probleme semble venir du fait que tu n'a pas installer le compilateur
C++ sur ta machine.
Ca n'a rien a voir avec le path, mais il est preferable aussi que tu renomme
le repertoire
/usr/src/pgsql/postgresql-6.4.2 en /usr/src/pgsql car la plupart des path
par defaut pointent
Hi,
You can use the lo_open() - lo_read() - lo_write() - lo_seek() C like functions
that allow to read, write and more directly into your blobs and so display data
on the fly...
This is already in the documentation - PostgreSQL Programmer's Guide - Chapter
15. Large Objects.
Martin Wong wrote:
Hi Tim,
Perhaps it's usefull for VxWorks or PostgreSQL to have such a port, but I
think
that a better way is to use Linux Real Time. You will have less port
problems and
probably no lost of time.
Ok, this is my point of view!
Tim Wadsworth wrote:
> Hello,
>
> I was wondering how easy or other
Hi,
You just have to use the read() function directly into your image field.
I think
there is an example into the documentation, perhaps the programmers
guide ?
If not I can send you a perl script which is doing this kind of stuff!
Regards,
Bernie wrote:
> Now that I've stored several jpg's in
Hello,
I have a little problem with connecting a Java standalone application
and Postgresql 6.3.2. In fact it doesn't connect.
Before sending you the error output, is anybody can tell me if I have
to declare a user/password in the h_dba_conf if I want this to work?
I ask this because I can't t
43 matches
Mail list logo
