Probably in this particular case, you will want to dig into more underneath
design in order to get the best performance.
Doing a lazy view with that query, you can use the top n of it and get less
callers if you need to (or more if you want to expand the feature).
Hope it helps,
--
--
Emanuel Calvo
Twitter: 3manuek
LinkedIn: http://ar.linkedin.com/in/ecbcbcb/
give
you the list of supported casts.
Did you try the cast operand?
postgres=# select '1235'::int , 823::text, (now()::date)::text;
int4 | text |now
--+--+
1235 | 823 | 2014-11-02
(1 row)
--
--
Emanuel Calvo http://www.2ndQuadrant.
icates
that (-1 all distinct, 1 none distintct). That's what you are asking about?
--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
El 28/10/14 a las 15:37, Joe Van Dyk escibió:
> On Mon, Oct 27, 2014 at 6:22 AM, Emanuel Calvo <
> emanuel.ca...@2ndquadrant.com> wrote:
>
>>
>> El 23/10/14 a las 17:40, Joe Van Dyk escibió:
>>> Hi,
>>&
e that your
data is safe.
The OOM killer doesn't respect what it kills, so this certain things can
happen without
a proper kernel configuration.
--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgs
dby queries when a conflict occurs on a
wal-records-about-to-be-applied.
Source:
http://www.postgresql.org/docs/9.3/static/runtime-config-replication.html
--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via p
-config.html
"They cannot be changed once recovery has begun"
--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
://www.depesz.com/2012/06/09/how-much-ram-is-postgresql-using/
Try to filter those which are quite old if you don't want to mess up
with configuration variables like max_fsm_pages, etc.
- --
- --
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA512
El 08/10/14 a las 17:24, Israel Brewster escibió:
> On Oct 8, 2014, at 9:30 AM, Emanuel Calvo
> wrote:
>
>
>
> El 08/10/14 a las 14:01, Israel Brewster escibió:
>>>> I am currently doing periodic syncs of one of
d easily be over a minute of sync time in another two
> years. I would really rather not have to wait several minutes every
> time I want to update my development data.
Which is the entire size of your production cluster?
- --
- --
Emanuel Calvo http://www.2ndQuadrant.com/
Postg
tion. The replica is using less
> than 1% processor on average.
So, it looks like that writes aren't the issue. You'll need to check the
IO rate on your machine.
I'll recommend that you share the output of the sysstat commands. Also,
check the RSS of each
process with the command:
p
9800
>
> The important point is the difference in the filtering rate.
>
> In this case, departments table is higher filtering rate,
>
> so taking departments table as driving table will be able to cut the
> computational cost, I think.
>
>
>
> I tried
ound handling for pg_multixact/members (Álvaro Herrera)
- Truncate pg_multixact during checkpoints, not during VACUUM (Álvaro
Herrera)
--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
into our json fields - can this be
> done ? I guess we could have a separate json field and bytea field for the
> markdown file but this might be difficult when it comes to our REST
> response - anyone do something like this ?
>
>
> --
> Sent via pgsql-general mail
hink this would be easier to implement but not as useful as
> for the ranges.
>
>
I guess you should write down a feature request on the hackers list.
tsrange should be included also on that request.
I tested on the beta version and it does not work either.
--
--
Emanuel Calvo http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
ng to have to specify all the columns in the group by
> clause?
>
Yes, except those that are inside the aggregate.
http://www.postgresql.org/docs/9.3/static/queries-table-expressions.html
Section 7.2.3
> I originally had the query without the group by, but I had
> duplicate rows, so
2012/7/11 Tom Lane :
> Emanuel Calvo writes:
>> Executed the following statement:
>> ...
>> ERROR: insert or update on table "veraz" violates foreign key
>> constraint "veraz_dni_fkey"
>> DETAIL: Key (dni)=(21530976) is not presen
quot; violates foreign key
constraint "veraz_dni_fkey"
DETAIL: Key (dni)=(21349995) is not present in table "persona".
The script is in github at:
https://github.com/3manuek/Random-database-for-Postgres
I tried with other versions >9.0 and is the same failure.
--
--
Emanuel Calvo
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
>
> Please keep in mind, that the Call for Speakers is open until December 20th.
> Only a few days left.
> Now it's a good time to submit your proposal ;-)
>
Did someone applied?
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgsql-general
2011/11/10 Tom Lane :
> Emanuel Calvo writes:
>> postgres=# explain (buffers true, costs true, analyze true ) (select i
>> from random_values) UNION ALL (SELECT NULL LIMIT 0);
>>
01 rows=1 width=0) (actual
time=0.007..0.007 rows=0 loops=1)
-> Result (cost=0.00..0.01 rows=1 width=0) (never executed)
Total runtime: 15680.066 ms
(9 rows)
Time: 15681.999 ms
10 seconds to UNION *nothing*? Is an expected behavior?
--
--
E
2011/6/22 Jaime Casanova :
> On Wed, Jun 22, 2011 at 3:28 AM, Emanuel Calvo wrote:
>> I'm still finding pg_create_restore_point in 9.1a2 documentation:
>> http://www.postgresql.org/docs/9.1/static/functions-admin.html
>>
>> But I've compiled that version
orrect but in other releases it displays all
the functions (as \d displays
all the relations in this one).
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ing beta download. I need to update my CVS
version. at least I will apply these lines manually to test now.
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ght be worth to
> add libselinux version check in the configure phase.
> --
So it could be added into the configure the check and I think
a patch in the doc could complete this issue. That's rigth?
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgsql-gen
1 of rows & 100 of c_id's.
>
>
> Please let me know if it is possible or any information is required.
>
Something like this?
http://wiki.postgresql.org/wiki/Pivot_query
--
--
Emanuel Calvo
Helpame.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.1beta1/contrib/sepgsql# dpkg -l | grep seli
ii libselinux12.0.55-0ubuntu4
SELinux policy enforcement, run-time librari
ii libselinux1-dev 2.0.55-0ubuntu4
SELinux policy enforcement, development file
--
--
Emanuel Calvo
2010/11/27 Lew :
> Emanuel Calvo Franco wrote:
>>
>> I'm having this 'issue':
>>
>> coches=# select array_agg(patente order by fecha desc) from
>> dia4.infraccion limit 6
71}
(1 row)
I now why it happens an how avoid it, but it's ok? Must work like this?
--
Emanuel Calvo Franco
DBA | www.emanuelcalvofranco.com.ar
Curso a distancia Nivel 1 Admin Postgres:
http://www.postgresql-es.org/node/525
--
Sent via pgsql-general mailing
gres
- redundance or good backups.
You can not spare RAM or CORES. What will tell you, the exact amount
of each other,
is 'how' the application will use the base.
If you share more details, maybe we could help a little more.
--
Emanuel Calvo Franco
DBA | www.
s?
>
> The worry part is how this happened?!
>
Do you have fsync turned off?
--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar
Join: http://www.thevenusproject.com/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To ma
use E'string'.
In that case the ' will be include into the string, so it will be not more
1 char lenght.
Or something like this:
select ('(' || quote_literal('b') || ',0)')::y
> shs-dev=# select ('("b,",0)'::y).c;
> ERROR: value
some
enhacements (cosmetic at all) here:
http://desarrollos.siu.edu.ar/trac/postgresql/attachment/wiki/Desarrollos/pgstat
--
Emanuel Calvo Franco
DBA at: www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgr
es=# COPY tabla_2 FROM '/tmp/returnes.csv' DELIMITER '|';
COPY 19780
postgres=# SELECT * from tabla_2 limit 1;
entero
----
13
(1 row)
Obviusly, you can automatize these steps in a shell script.
Hope you enjoy it.
--
Emanuel Calvo Franco
DBA
2009/10/8 Leonardo M. :
> On jue, 2009-10-08 at 17:01 -0300, Emanuel Calvo Franco wrote:
>> > select
>> > *
>> > from my_table
>> > where
>> > cast(rtf_field as varchar) like '%condition%'
>> >
>> > This works ok
Dollar quoting is more clean to put strings inside than ' '. ~~ is
like operator.
And :: operand is more clean to the syntax of the query.
Don't think so? :)
--
Emanuel Calvo Franco
DBA at: www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
h function.
The option
--with-wal-segsize=SEGSIZE
set WAL segment size in MB [16]
when you compile postgresql allow you to change the size of these files (but you
can't do it only restarting :S )
--
Emanuel Calvo Franco
DB
7;0.06');
Without hashtext:
CREATE INDEX xx ON table (substring(citext_col,1,4));
explain select * from pp where substring(i,1,4) = '0.06';
The entire field to search:
CREATE INDEX xx ON table (hashtext(citext_col));
explain select * from pp where hashtext(i) = hashtext('all the
2009/9/2 Devrim GÜNDÜZ :
> Hi,
>
> On Wed, 2009-09-02 at 13:47 -0300, Emanuel Calvo Franco wrote:
>> > I released initial version of my PostgreSQL 8.4 live CD, which i
>> > based on CentOS 5.3. It includes the PostgreSQL related packages
>> > that I build on h
get work 8.4:libsdl-perl,
libperl-dev, python-all-dev (for perl and python). For 8.3 i didn't
need it (seems).
But in my case i use 2.5. Hope it helps :S
--
Emanuel Calvo Franco
DBA at: www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-genera
e for pgadmin
- has several docs in html format, in a /var/www and when the livecd
starts, firefox displays the links for each doc (all the docs are
in the cd, thats is the better)
- has a postgres wall paper
Could be great add-ons, what do you think about it? if i can help let
me know.
Regards!
oxy queries to different
> instances of postgres?
>
You can use dblink. But could interference the performance
and is not really what you want.
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
t
any more. but sounds charm for me. If i can offer some code
let me know :)
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
t it, if you have problems, i'll try to help again :)
The error is telling you that could not return an array into
integer.
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-g
ng to understand why happens
and not look for another way :)
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make change
8765 | 571112
168773 | 168766 | 992462
168774 | 168767 | 992471
(5 filas)
synchronize_seqscan are on in both engines.
I only want to know why is this difference...
--
Emanuel Calvo Franco
Database consultant at:
www.siu.edu.ar
www.emanu
nnot find include file:
>> "xpath.c", line 21: cannot find include file:
>> "xpath.c", line 22: cannot find include file:
>
> You need to tell configure where to find libxml's headers
> (--with-includes).
>
Ok, sounds good :)
I will try to take a
mbol: doctree
"xpath.c", line 190: cannot recover from previous errors
cc: acomp failed for xpath.c
Reaping losing child 0x080a3290 PID 1718
gmake: *** [xpath.o] Error 2
Removing child 0x080a3290 PID 1718 from chain.
The other problem was compiling uuid-opps and tablefunc contribs.
Som
his ? If not, i will continue my workaround on this and
try to propose something to fix it.
--
Emanuel Calvo Franco
www.emanuelcalvofranco.com.ar
ArPug.com.ar / aosug.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
//www.postgresql.jp/npo/logo/?searchterm=logo
It's no bad...
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://
>
> select ...
> from T
> where x > $1
>
prepare testy_prepare(int) as select * from T where x = $1;
execute testy_prepare(4);
Follow the docs :)
http://www.postgresql.org/docs/8.1/interactive/sql-prepare.html
--
Emanuel Calvo Franco
ArPUG [www.arp
mit).
Which improvement do you want to obtain with the array way?
If the table is very small, the improvement in terms of performance
will be negligible.
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
--
Sent via p
ca/
The project is growing and have a very easy setup and administration.
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ation for Solaris are in the site #1, you will find since
installation until complex trace rutines.
Enjoy it!
#1[http://www.sun.com/software/products/postgresql/index.jsp]
Regards,
--
Emanuel Calvo Franco
ArPUG [www.arpug.com.ar] / AOSUG Member
www.emanuelcalvofranco.com.ar
> so that I knew what to look for in the manual?
>
> Thank you for your time.
> Dimitry
>
You can use the function pg_read_file(text,bigint,bigint)?
like:
inser into table foo values(1,2,3 [...], pg_read_file(filename,1,[?]);
The problem is to write it on the disc, there is not a f
2009/5/29 David Fetter :
> On Fri, May 29, 2009 at 09:48:42AM -0300, Emanuel Calvo Franco wrote:
>> 2009/5/28 Kris Jurka :
>> >
>> >
>> > On Wed, 27 May 2009, Emanuel Calvo Franco wrote:
>> >
>> >> Hi community,
>> >>
>> &g
2009/5/28 Kris Jurka :
>
>
> On Wed, 27 May 2009, Emanuel Calvo Franco wrote:
>
>> Hi community,
>>
>> I'm trying to compile pl/java sources for 8.4 beta1 (for a test) but
>> it gives me 20 errors at the end:
>
> To build against 8.4 you need pljava
va_all] Error 2
..."
I have 8.3 jar compild pljava, exists a way to create a function and
the server 'ignore' the lib version?
Regards,
--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member
--
Sent via pgsql-gener
2009/5/27 Emanuel Calvo Franco :
> 2009/5/27 Anirban Pal :
>> Dear all members,
>>
>> I have been working on postgres (windows), for last 8 months. Recently, a
>> client requrement requires me to install postgres in solaris 10. What I did
>> is this. Untar the
sender does so expressly with
> due authority of NSTL.
>
Remember that in Solaris you have SMF to initialize Postgresql with more
'intelligence'.
Is a perfect document that describes the complete installation of Pgsql on
this platform:
http://dlc.sun.com/pdf/819-5578/819-557
;)
>
That's i call a good point XD
But i must say is not so handly ;P
> http://www.postgresql.org/docs/books/
If you look for well, you will find the book i recommended.
--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member
--
"postgresql handbook".
The Peter Einsertraut book is in Deustch language, but if you have intuition
you can read it :P
--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member
--
Sent via pgsql-general mailing list (pgsql-gen
ets large ... you'll never see it during devel testing on toy tables ...
>
> regards, tom lane
>
Yeap. If you see one of the test i made, you'll see this switch over the
~100 regs.
--
Emanuel Calvo Franco
Sumate al ARPUG !
( www.arpug.com.ar)
ArPUG / AOSUG Member
2009/5/8 David Fetter :
> On Fri, May 08, 2009 at 06:40:33PM -0300, Emanuel Calvo Franco wrote:
>>
>> I test it in the first time :)
>>
>> With the 'order by' it works well, but in 'theory'
>
> The theory under which you should operate is th
2009/5/8 David Fetter :
> On Fri, May 08, 2009 at 06:10:18PM -0300, Emanuel Calvo Franco wrote:
>> Hi all.
>>
>> I'll make this faster.
>>
>> I hace this table and this function:
>
> You should only ever assume that your SELECT's output will have
2009/5/8 Tom Lane :
> Emanuel Calvo Franco writes:
>> Executing 'select * from datos limit 1 offset 15' two times i have
>> different
>> result sets.
>
> The "synchronous scan" logic is probably responsible. Turn off
>
8.00 rows=172800 width=8)
(actual time=0.014..356.800 rows=
11 loops=1)
Total runtime: 622.247 ms
(3 rows)
That's correct? Is logical that if the scan is sequential in the
physical table returns differents
data?
I test it on 8.4 beta1 and 8.3.5 and 8.3.7 with the same results.
Thanks
a database in disk and have updatable
views in memory :)
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.postgres-arg.org -
www.arpug.com.ar)
ArPUG / AOSUG Member
Postgresql Support & Admin
--
Sent via pgsql-general mailing list (pgsql-general@
.049 ms
(2 rows)
So, let's see in a brief:
standard table on ram: 22836.532
standard table on disk: 16902.042
temp table on ram: 12773.371
temp table on disk: 13716.049
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.postgres-arg.org -
www.arpug.com.ar)
A
d lvalue in assignement
> warning no new line at end of file
>
> Please any direction of how to solve the problem
>
> here is the command i wrote in MinGW
>
> gcc -shared -o hamzeh.dll tt1.o -L "c:/programme/postgresql/8.3/lib"
> -lpostgres
>
try c:\programme\
Gw
>
> Thanks again
AFAIK gcc has an option -I for detail the path of the includes.
I think there must be inside a folder called 'server' in the same
path.
Yes, i was who said to you that committers is not the right place :)
--
Emanuel Calvo Franco
Sumate al ARPUG
fnction)
> error 'new_point' undeclared (first use in his function)
> error: syntax error befre ')' oken
> in function 'copy text':
> error: 'invalid lvalue in assinment
> In function 'concat_text'
> error: invalid lvalue in assignement
t;
> PG_RETURN_POINT_P(new_
> point);
> }
>
> the only function that are work are the one with int32 variable.
> the other function bring errors and are not working
> any body can give directions
>
>
> kind regards
> ihab
Re-send to pgsql-general.
Can you pas
2009/4/1 Emanuel Calvo Franco :
> 2009/4/1 Patrick Desjardins :
> Did you try to make a reindex?
>
If you get an error with that, try to drop indexes and create
again.
>
> --
> Emanuel Calvo Franco
> Sumate al ARPUG !
> (www.postgres-arg.org -
&g
x versions, i declare a var in postgresql.conf (zero_damaged_pages = on )
and make the dump with this option. I don't know if this var is in newly
versions.
Did you try to make a reindex?
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.postgres-arg.org -
www.arp
of error occurs generally on 7.x versions or if you are using
fsync =off and you have a surprised system down.
Try to do a pg_dump of the database or clean (no delete) del wal files
(this is not
recommendable for new users).
> What can I do to fix that problem?
>
> Thank you,
>
--
t;
> The two servers are using different ports. I'm running v 8.3 on a
> Mac running 10.5.
>
> What's the secret step I'm missing here?
>
> Thanks,
> Eric
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make chang
e any other clever solutions of this problem?
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Sumate al ARPUG !
(www.po
eful.
> --
> Gregory Stark
> EnterpriseDB http://www.enterprisedb.com
> Ask me about EnterpriseDB's RemoteDBA services!
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.p
of interest.
>> Finally, to know if there's any book (english) for the PostgreSQL
>> Certification, like in Japanese.
>>
>> Thank you for your time,
>>
>> Steve,
>>
>>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgr
om.ar/pgsql.vid.gz
[1] http://www.pglive.info
--
Emanuel Calvo Franco
ArPUG / AOSUG Member
Postgresql Support & Admin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
; Andreas Kretschmer
> Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
Daniel
> PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel
ystem
> Volume Information/
>
>
>
> It should have been two rows as follows:
>
>
>
> 1180635517879 3001C:/SQLBackup/
>
> 1180635517879 3001C:/System Volume Information/
>
>
>
> Is this something that is perhaps fixed in postgresql 8.3? Any assist
t;
>
> Regards,
> Aleksander
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
I forgive to tell you that you must add operators...d'oh!
--
Emanuel Calvo Franco
ArPUG / AOSUG Member
Postgresql Support & Admin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ely on those casts
http://code.open-bio.org/svnweb/index.cgi/biosql/revision?rev=284
here are the functions
--
Emanuel Calvo Franco
ArPUG / AOSUG Member
Postgresql Support & Admin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to y
ting Fax: +49 551 489500-91
> Hans-Böckler-Straße 2 http://www.deriva.de
> D-37079 Göttingen
>
> Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make chan
27;s but not the operator.
The cast is in other way (try to compare with a text '13')
for example.
>
> Regards,
> Aleksander
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresq
stgres database?
>>
>> dbi-link
Ora-link
>
> In the opposite direction, you can use Oracle's feature described here:
> http://lists.mysql.com/mysql/189287 (change to psqlodbc driver should be
> easy).
>
>
>
>
> --
> Filip Rembiałkowski
>
--
ntly see what it does with
> many users, and how it behaves as the number of users increases.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Syscope Postgresql Consultant
ArPUG / AOSUG Member
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
2008/12/26 Martijn van Oosterhout :
> On Fri, Dec 26, 2008 at 09:52:59AM -0200, Emanuel Calvo Franco wrote:
>> Hi people,
>>
>> Yesterday when i was making some commands on 8.3.5
>> (on Centos)
>> i found a rare behavior of limit offset.
>>
>> Try in ps
2008/12/24 Tom Lane :
> "Emanuel Calvo Franco" writes:
>> But when i want to make, i recieved an error (make and
>> /opt/SunStudioExpress/bin/dmake ):
>> "...
>> eca...@lastchance:~/Desktop/postgresql-snapshot$ sudo make
>> You must use GNU make t
from foo limitsdfsdfaerfgsafqaweawe; <- shows all rows
select * from foo limit; <- this shows error ok
select * from foo limitt;
All the chars inmediatly continue the limit or offset commands
are ignored.
If this kind of problems there isn't a bug, sorry.
--
Emanuel Calvo Franc
d for target `all'
..."
Exact Versions:
Product Version: Sun Studio (Build 200810171318, Sun Studio 20081005)
Java: 1.6.0_10; Java HotSpot(TM) Client VM 11.0-b15
System: SunOS version 5.11 running on x86; UTF-8; es_AR (sunstudio)
Userdir: /export/home/ecalvo/.sunstudio/ceres-dev4-SunOS-i386
Than
Hi !
There isn't another way to download 8.4devel that isn't
cvs and the last rpm binary?
I mean, i need source code, but in my work i can't
access with cvs because proxy policies.
Sorry for my bad english,
--
Emanuel Calvo Franco
Syscope Postgresql Consultant
ArPUG
ts of this implementation? what do you want to resolve with it?
>
> Ketema J. Harris
> www.ketema.net
> ket...@ketema.net
> ketemaj on iChat
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://w
t
know if there is a way to simmulate this.
>> Is there something I can do to make postgres works like Oracle ? I am
>> using postgres 8.1.11 on SLES10.
>>
>
> postgres grant model is different; you can't hide db structure from db
> users.
See that, that's becau
wrong.
>
> Cheers,
> Liraz
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Syscope Postgresql Con
> Cheers,
> Liraz
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Emanuel Calvo Franco
Syscope Postgresql Consultant
1 - 100 of 110 matches
Mail list logo
