Did you link in crypt? Try adding -lcrypt to the compile line.
-DEJ
> -Original Message-
> From: Matthew [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, June 12, 1998 10:50 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] crypt compile error
>
> Hello, I am new to the wor
> Hi,
>
> I have 2 queries, which are quite similar:
>
> a) select distinct p1.domain from dom_prot p1, identical p2,
> classification p3
>where p2.reference = p1.protein
>and p2.protein ~ 'EPA3_HUMAN'
>and p3.domain = p1.domain;
>
> b) select distinct p1.domain from dom_prot p1, id
> Jackson, DeJuan wrote:
> >
> > I think you should just go with what Vadim suggested and use:
> > select currval('my_sequence');
> > This will be the same within a
> Hi,
> I've managed to hack the code for check_primary_key. It now allows for
> a
> option
> [automatic|dependent]. It'll automatically insert into the parent
> table
> if the primary key doesn't exists in the parent table and if the
> option
> is "automatic". It works the same as before if the o
> seems that by creating a view ( with the query i mentioned before ),
> my
> queries were sped up by roughly 10 seconds... odd odd odd.
>
Not really so odd when you think of everything the backend has to do to
process a query. Parsing, planning, and optimizing (not necessarily in
that order) ca
> Hi all,
>
> I was just wondering if the IPv6 datatype has allready been
> implemented on the current version of postgres.
It should be in the CVS version, if you want to test it.
-DEJ
> Thanks,
> Lorenzo Huerta
>
>
>
> _
> D
nction date(timestamp) does not exist
> ---
>
> I have this column identified as type date and not timestamp.
try:
SELECT fagentname
FROM feedback
WHERE '@ 7 days'::timespan >= ftdate::datetime - now()::datetime;
> Any suggestions?
>
>
>
>
> Hi -- I've been dabbling in PostgreSQL on and off for a few months
> now. At
> this point I can get it to do a number of neat things, but I've run
> into
> one that is a stumper.
>
> I'm looking for a way that my Perl program can look up the names of
> the
> tables in a database. Is there a w
> 2 questions.
>
> 1)Hi, I have this 2 tables:
> esame=> select * from libro_autore\g
> id_libro|id_autore
> +-
> s1 |5
> n3 |1
> n2 |2
> n1 |1
> n1 |4
>
> and
> esame=> select * from autore\g
> cognome|nome |
> Paul Mookhachov <[EMAIL PROTECTED]> writes:
>
> > Hi!
>
> Hi !
>
> > How can I obtain information about tables' structure and list of
> tables
> > using psql.lib or Pg.pm (perl package)?
>
> I think you got no wayt to do it directly, but with here's a
> trick :
> all you ha
The easiest way is to give it another name
select presto.*, libro.tipo, libro.id_libro as id_libro2 from ...
and just grab id_libro2 for the second id_libro.
You can also select it by column number in most interfaces.
-DEJ
> -Original Message-
> From: ZioBudda [SMTP:[EMAIL PROTEC
I really have no idea what you are truly asking for here, but here's a
crack at what I think you want.
select count(p.*) from prestito p, libro l
where p.id_libro = l.id_libro
group by p.id_utente, l.tipo
Try it...
-DEJ
> -Original Message-
> Hi again,
> I have this 3 tables:
I don't know why you are experiencing a problem here but I think I can
speed up that query. Let's try a rewrite.
SELECT * FROM libro l WHERE EXISTS(
SELECT la.id_libro FROM libro_autore la, autore a
WHERE la.id_libro = l.id_libro_key AND
la.id_autore = a.id_autore AND
> -Original Message-
> From: ZioBudda [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, December 04, 1998 4:44 PM
> To: Jackson, DeJuan
> Cc: [EMAIL PROTECTED]
> Subject: RE: [GENERAL] question 3
>
> On Fri, 4 Dec 1998, Jackson, DeJuan wrote:
>
> > I
Make sure the PostgreSQL's postmaster is being run with the -i option.
Or take out the port number specification in your script.
Hope this helps,
DEJ
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 19, 1998 1:43 PM
> To: [EMAIL PROTECTED]; [
iggers: options besides compiled code?
>
> >>>>> "dej" == Jackson, DeJuan <[EMAIL PROTECTED]> writes:
>
> >> if you insert a new row, isn't the sequence automatically
> >> inserted?
> >>
> dej> It is if you
Very observant of you. The postgres function system doesn't have a way
to tell which parameter is null, so the function just returns null.
I don't like it and we hope to get it changed for PGv6.5 (at least I
do).
Is it on the TODO guys? Jan, do you think you'll have the time to get
to it by bet
There has been a discussion in the HACKERS list (check the archives on
the website
[http:\\www.postgresql.org\]) about PostgreSQL vs MS SQL 6.5 for the
last 2 days or so.
I think these ideas must come in threes, so where is that other person?
I can't really give a feature comparison of MS SQL 7
> I'm designing a database schema and have questions about OID.
>
> First, I assume that OID are system assigned? [yes]
yes - correct assumption
> Second, Can I use OID as a primary key? [no]
yes(qualified) - incorrect assumption
Currently PostgreSQL doesn't really do anything special with prima
> On Wed, 13 Jan 1999, Jackson, DeJuan wrote:
>
> > And remember unless you use full text indexing (which is
> expensive) you
> > won't have indexing on that search (for either the LIKE or regex).
> > -DEJ
>
> Actually, if you use case sensitive r
1st suggestion - If there is no reason behind have temp tables rewrite
your sql to eliminate them (this reduces to just 24 queries):
INSERT INTO week (address, origbytes, destbytes, when)
SELECT o.origine, sum(o.bytes), sum(d.bytes), '09/02/1999 9:00:01'
FROM day o, day d
WHERE o.origine=d
The only suggestion I have is to do the Sort after you get the data
back, Perl's pretty good at that.
Let me know what the timings are. I went to the site and it looks like
it only take ~3-5 seconds to get the data to my browser and format it.
-DEJ
> -Original Message-
> I di
> I am still having problems with the timespan and tinterval types.
>
> tinterval is defined as (abstime, abstime) but if set a value like
> ('2/2/1998, 2/2/1999') the result returned will be
>
>["Thu Jan 01 01:04:06 1970 MET" "Thu Apr 25 07:54:08 1974 MET"]
>
> timespan seems also worthle
You may want to do a 'make clean' or just start over from the tar.
'configure' should figure out that you have curses installed now. The
LIBS switch you need to link in curses is '-lcurses' but configure
should take care of that.
Hope this helps,
-DEJ
> Hello,
>
> the psql too
Fix:
http://www.postgresql.org/docs/todo.shtml
> I just did a relatively major cleanup of the WWW site, and am
> looking for feedback.
>
> Bsically, I was growing tired of looking at the site, and
> constantly reloading the same data over and over again (the 'index' on
> the
> > I think you should just go with what Vadim suggested and use:
> > select currval('my_sequence');
> > This will be the same within a transaction, even if there is another
> > transaction using the same sequence.
>
> Sorry, I wasn't thinking of it happening in the same transaction. In
> > If you use "datetime" type instead of "date" and set datestyle =
> 'Postgres'
> > your data will be like: Sat Dec 12 00:00:00 1998 CET
> > instead of: 1998-12-12
>
> I actually stumbled across this after my initial post.
>
> Now that my dates are being retreived in this format:
> Sat Dec 12
try:
pg_dump > tmp.sql
then edit tmp.sql to change the old_database name to new_database name.
then:
cat tmp.sql | psql template1
-DEJ
> -Original Message-
> From: James Olin Oden [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, July 09, 1998 11:45 AM
> To: Aleksey Dashevsky
> Cc:
> > I started to look at the triggers documentation and was immediately
> > dismayed to discover that I would have compile code to create a
> > trigger. I have been using the old "rules" mechanism to
> automatically
> > put a sequence number into a tuple when inserting new rows. Are my
> > choic
It's depends upon your needs, but if you're on a Unix system why not just
access the system crypt function. You could create a PostgreSQL C function
to easily access it. Just look in contrib for an example of the code.
If you're on a Windows system I'd say give up now unless you want to
implemen
> Hi!
>
> On Fri, 16 Apr 1999, Jackson, DeJuan wrote:
> > try:
> > EXPLAIN SELECT pos_id, rating
> > FROM pos_rating pr
> > WHERE date_i = current_date AND city_id = 2 AND
> > EXISTS (SELECT DISTINCT pos_id FROM positions p WHERE subsec_id = 1 AND
Use Indexes...
-DEJ
> -Original Message-
> From: Justin Long [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, April 27, 1999 11:31 AM
> To: [EMAIL PROTECTED]
> Subject: [GENERAL] Speed
>
> I find that it is actually faster to do a SELECT from a single record set,
> then fetch eac
> If I have a UNIQUE or PRIMARY KEY clause on my class, does that create a
> btree or hash index?
btree
> I guess if I have a UNIQUE constraint or PRIMARY KEY at class creation,
> I don't have to create an index explicitely via CREATE INDEX ?
correct
-DEJ
> If I want to have an index on oid, which will obviously be unique
> anyway, is it more efficient to have or not to have the UNIQUE option on
> CREATE INDEX ?
Good question my thought would be not to have the Unique; then the Indexing
code doesn't have to check for duplicates when inserting new v
The problem here is to find impartial comparisons.
The question between MySQL and PostgreSQL usually come down to
Do I care most about speed? - usually true for purely Web Apps.
or
Do I need transaction and the other features PostgreSQL offers? -
which tends to only be true if y
Try: select * from table LIMIT 100;
> Hi
>
> We upgraded our system from 6.4 to the new 6.5 version. The set
> query_limit function is not working
> anymore in 6.5.
>
> db => set query_limit to '100';
> SET VARIABLE
> db => select * from table;
>
> statement is returning all records from the t
Try EXCEPT (only in v6.5).
-DEJ
> -Original Message-
> From: Nikolay Mijaylov [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 13, 1999 6:41 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [GENERAL] Set operator.
>
> I know it is not the same but try this:
>
>
> select table1.va
You need to increase your max backends. The default for 6.4.2 was 64. I
believe it is a configure option (or it's in config.h).
You might also need to increase your semaphore limits (that's a kernel
option).
> -Original Message-
> From: Yin-So Chen [SMTP:[EMAIL PROTECTED]]
> Sent: Sunda
38 matches
Mail list logo
