Shavonne Marietta Wijesinghe escreveu:
Hello
I have a db in MS Access 97 and now i have to import the data in
PostgreSQL. I can create the table structure in PostgreSql but in what
format can i export the table from Access so Postgresql can read it?
Thanks
Shavonne
Export the data, instea
ivan marchesini escreveu:
Dear PG users,
I have an access db and I'm trying to pass all to postgres
I have used mdbtools to export the schema and all went quite well.
then I exported the single tables... to csv..
a lot of table have some timestamp fields containing data as DD/MM/,
and I'm no
Dani Castaños escreveu:
...
And have the result of both added.
I've tried something like
SELECT tot.status, COUNT(total)
Should be
SELECT tot.status, SUM(total)
FROM( QUERY A UNION QUERY B ) AS tot
GROUP BY tot.status
But it doesn't works. It doesn't add the total columns with the same
s
a melhor das ditaduras
>The worst of democracies is still better than the better of dictatorships
>http://ezequiasrocha.blogspot.com/
>
>---(end of broadcast)---
>TIP 6: explain analyze is your friend
>
Roberto Fichera.
--
At 12.21 16/12/2004, you wrote:
Am Donnerstag, 16. Dezember 2004 11:34 schrieb Roberto Fichera:
> Hi all,
>
> I have a table acct as (username, terminatedate, terminatecause)
> I would like to build a query which returns three columns orderd by data
> like:
>
> date_trunc(
04| 1 | 1
Thanks in advance.
Roberto Fichera.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the ma
t.ca/autodoc/
dbVisualizer - gratis, but not Free
and many others. Search in freshmeat.net and google.
-Roberto
--
+----| Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/L
On Mon, Dec 08, 2003 at 05:38:56PM -0800, viola wrote:
> Hi,
> How to call PostgreSql function from ColdFusion, if
> that function returns result set using cursor?
Through ODBC. Don't know it they have native access now.
-Roberto
--
+| Roberto Mel
#x27;s described in detail in the Administrator's Manual:
http://www.postgresql.org/docs/7.3/static/ssl-tcp.html
It's important to note that PostgreSQL has supported SSL connections for
much longer than MySQL.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--
Dear friends,
I have this table
table work{
day date,
hour integer,
}
select * from work;
date | text
---
1-1-20031
1-1-20031
2-1-20035
3-1-200310
5-1-200315
how can i obtain this?
date |text
---
1-1-20032
2-1-20035
3-1-2003
, blog, to an entire online
education vertical application: dotLRN (www.dotlrn.org)
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/L
next week, after my exams.
-Roberto
--
+----|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
-
t know what the
impact on index usage would be.
> Another problem is in creating function...
> How can i create a function that accept and return any type. the type "any" is not
> allowing as parameter or return type. Is it possible? i want to create a functio
Just a teste, please ignore
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
he documentation mentions this in several
places and examples.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
C
ow can we convert them into PostGres.
You can recompile to change the number of parameters.
PG 7.3 can have up to 32 arguments by default, IIRC.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University
ks in advance,
-Roberto
--
+| Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
If I only had a nickel for every time Window
rnt in corner cases,
> like you were.
>
> Any comments?
I think that is a preferred behavior.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software &a
t;non-standard tab character"? Are you saying tab is non-standard or that
there's some sort of weird tab character that could be being used in this
case?
I've always used tabs in my PL/pgSQL functions and it works just fine.
-Roberto
--
+|Roberto Mello -h
ype of every trigger
for TRIGGER (which means no 7.2 compatibility) or stay stuck in 7.2-land.
Are there plans to make the behavior of CREATE OR REPLACE FUNCTION consistent with
that of CREATE FUNCTION?
Thanks,
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |
ed chunk and cache it in RAM. Users
usually only look at the first few pages, so it suffices for most cases.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Softwar
ar uma "EXCEPTION" e mesmo assim gravar em outra
>tabela?!?!
Não dá. Quando você levanta uma exceção (exception) o controle volta para
quem chamou o gatilho. Não há como contornar, que eu saiba.
Você tem que fazer a inserção na relação desejada antes de levantar a
exceção (talvez c
ent with Oracle, evidently.
> Next I'll be wondering why DECODE doesn't work...
Because DECODE is non-standard AFAIK. You can use CASE WHEN in PostgreSQL,
which IIRC, started being supported in Oracle 8.1.7.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |
Look at the dblink module under the contrib section of PostgreSQL. It
implements the feature you're looking for.
-Roberto
--
+| Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Softwa
L documentation that show you how to do it.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
And God said: E = ½mv²
script that invokes psql with the appropriate queries
2) Schedule a cron job to the end of the month
Each tool doing its own small task well done.
-Roberto
--
+----| Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah Stat
On Thu, Jan 23, 2003 at 02:33:55PM -0600, Kristopher Yates wrote:
> I have been wondering the same thing..
SELECT * FROM pg_databases ?
> >Is there a query that will return all the databases available, similar
> >to what psql -l does?
The handy "-E" flag to psql h
cle and INSERT into PostgreSQL.
That assumes the database structure has already been migrated.
You might want to look at conversion tools in the PostgreSQL contrib tree
(see ftp site) and related articles at http://techdocs.postgresql.org/
-Roberto
--
+|Roberto Mello
ot;). The part on returning record sets is only
relevant to 7.3
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/L
Read "An Introduction to Database Systems" by C.J. Date.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club
f the
resolution to query the complaints table and return the concatenation of
all the details.
That way you could just:
SELECT
id, foo, bar, concat_resolution_details(id)
FROM
resolutions;
I'd give it a shot at the function, but you didn't give the structure of
the
he box." Oh, it's
> free/open-source as well.
I second that suggestion. Having used AOLserver for the past few years,
it's a very nice application/web server with superb database support.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+
out put of the ps command can be
> seen at http://dominion.dyndns.org/~mdiehl/ps.txt
Are you using PHP by chance? I've seen this behavior under Apache+PHP
before. My "fix" (workaround rather) was to disable persistent
connections.
-Roberto
--
+|Roberto Mello -http://www.b
update pg_attribute
set atttypmod = 204
where attrelid = ( select oid
from pg_class
where relname = 'bar' )
and attname = 'foo';
-Roberto
P.S: I don't know if this has any bad side effects.
-Roberto
--
+|Roberto M
On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote:
> Roberto Mello <[EMAIL PROTECTED]> writes:
> > Is there any way to make a timestamp difference operation not return an
> > interval? I'd like to get hours, minutes and seconds only, not the "1 day&quo
al? I'd like to get hours, minutes and seconds only, not the "1 day"
or whatnot.
lbn-dev=# select now() - '2002-11-07 7:42'::timestamp;
?column?
---
1 day 02:01:57.987838
(1 row)
Thanks,
-Roberto
--
+|Robert
On Fri, Oct 25, 2002 at 10:32:00PM -0500, John Ragan wrote:
>
> Does anybody know of CoreReader being run against
> PostGresql?
>
> If so, I would appreciate knowing the results.
What's CoreReader?
-Roberto
--
+|Roberto Mello -http:
greSQL, called dblink, that allows it. Look at
the contrib tree on the PostgreSQL archives.
-Roberto
--
+| Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - h
rocedure for working with i18n'd characters described in the
documentation? I'm looking for something that mentions the specifics of
locale interaction and all that.
I ask because the sort of question Tim asked is a recurrent one in a
portuguese PostgreSQL mailing list I subscribe
A?
> (something like "SELECT * FROM A.X ...")
See the dblink module in the PostgreSQL contrib tree (available via ftp.
packages available).
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State
7.2 documentation).
http://developer.postgresql.org/
-Roberto
--
+| Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
Bill Gates made $6.3
PostgreSQL contrib/ directory. See its documentation.
And here goes the same as above, but in Portuguese :)
O PostgreSQL não permite isso por padrão. Você pode usar 7.3 e schemas
como foi sugerido, ou usar um módulo chamado dblink com 7.2. Esse módulo
está no diretório contrib do PostgreSQL. Ve
Hi all,
Maybe I missed something obvious, but is there a built-in function to
convert epoch to date? I couldn't find it in the documentation for extract
and friends.
Thanks,
-Roberto
--
+| Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Gra
th this
> for a number of days now.
Argh, that's right, I forgot the ENDs. Ugh! Shame on me.
Glad that's working for you now.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University
LSE 'void') as order_state
FROM events_registrations
GROUP BY order_id ) o_states
WHERE o_states.order_id = o.order_id;
Oracle 9 does support SQL92-compliant CASE WHEN. It's much more clear than
using cryptic decode to me.
See http://www.postgresql.org/idocs/inde
ished through returning a cursor from the function.
See the 7.3 documentation to see how to do that (AFAIK, this is not
documented in the 7.2 docs, although it does work).
In 7.3 you can return true record sets without the use of cursors. Again,
see the docs for 7.3 in the developers site.
-Roberto
ave GUC 'log_duration' which will show query duration.
Forgive my ignorance here, but what is GUC? And how would I access the
query duration?
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State Universi
ackage called "Developer Support" that shows you (among
other things) how long a query took to be executed. Very good to finding
out slow-running queries that need to be optimized.
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ USU Fre
the code originated in
> Postgres. It is even more free than MySQL.
It should be mentioned that PostgreSQL has great community support.
If you require commercial support, that is provided by several companies,
including Pgsql Inc., Red Hat, Aglio, etc.
-Roberto
--
+| http://fslc.usu.edu/ USU F
On Mon, Jul 29, 2002 at 08:57:12AM -0300, Elielson Fontanezi wrote:
> Bom dia Roberto!
Bom Dia! :-)
> I have just read these documents.
> The variables listed in the link below, say about variable that I
> cannot
> set from a .profile file.
> By the way, if I
likely there are much more variables rather than PGDATA,
> PGHOST and PGPORT.
> Where can I find them?
Perhaps you're looking for
http://www.postgresql.org/idocs/index.php?runtime-config.html
Please trim your replies to the list.
-Roberto
--
+| http://fslc.usu.e
enerate the source in delphi, but I
> need a sql specification (BNF, EBNF) and I do not know where to find it.
You could look at how PostgreSQL does its parsing. The source code is
open.
-Roberto
--
+| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+
Roberto Mell
bian.org ("unstable" distribution) and unpacking them (Debian
packages are just "ar" packages with extra headers).
-Roberto
--
+| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
h
QL installations all the time.
-Roberto
--
+| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
Microsoft has been doing a really bad
an. A PL/pgSQL function is already part of the
database it belongs to. It doesn't need a handle.
-Roberto
--
+| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.ed
eresting, more useful, more
feature-complete (as far as Relational database servers go), more fun and
what you could learn with PostgreSQL you could take to other database
servers who are out to be real database servers, not the case with MySQL.
AFAIK, MySQL is more common.
-Roberto
--
+| ht
achive that effect by returning a cursor in PG 7.2 (the section on
returning cursors is ommitted from the current docs in
www.postgresql.org/idocs, so you need to look at the developer docs - see
www.us.postgresql.org).
-Roberto
--
+| http://fslc.usu.edu/ USU Free Software & GNU/Linux Clu
u currently have, as far as I could understand it. I didn't
read the procedure very attentively because it's horribly written in all caps,
and my eyes started scrambling the letters half way through.
-Roberto
--
+| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--
res/plpgsql-cursors.html
-Roberto
--
+| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
I wonder if Singapore has any c
On Mon, Jul 01, 2002 at 02:29:27PM +0300, Oleg Bartunov wrote:
>
> I tried 1.2.4 but didn't found how to configure tora to work
> with postgresql.
Tora is very nice. I'm using 1.3.5 with PG 7.2 (Debian). I had to compile
the PostgreSQL Qt 3 module for it to work.
-Rober
As the documentation for PL/pgSQL clearly states with several examples,
you have to double the quotes in strings>
INSERT INTO rtest(xz,yz,xy)
VALUES (''(0,2), (1,3)'',
''(1,2), (2,3)'',
''(0,1), (1,2)'');
I don't
ass
Unless it's some OO extension in PostgreSQL that I don't know about, I
have never heard of the type "repertory" and "name". I don't think you
can use your table name as a data type.
BTW, you should also stay away from arrays (IMHO), since they ar
On Mon, Oct 22, 2001 at 05:14:32PM +0800, guard wrote:
> dear all
>
> IF update table set field='c:\windows'
> but
>
> c:\windows -> c:windows
Errr. Some context please? My crystal ball is still getting fixed :)
-Roberto
--
+| http://fslc.usu.edu USU
You can use function overloading if you need the same function to
return different types.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.e
e". Give it for free and you'll
> get plenty of it when you need some.
I couldn't agree more!
-Roberto
--
+| Roberto Mello - http://www.brasileiro.net |+
Computer Science, Utah State University -http://www.usu.edu
USU Free Software &a
You can have psql output its internal queries and that will give you
some insight:
roberto@brasileiro:~/documents/pictures$ psql -e foobar
Welcome to psql, the PostgreSQL interactive terminal.
...
foobar=# \d blah
* QUERY *
SELECT relhasindex, relkind, relchecks, reltriggers,
On Wed, Aug 01, 2001 at 09:28:39AM +0100, Richard Huxton wrote:
> Hi Roberto - long time no see.
Hey Richard. Yeah. Summer classes and summer jobs :-) I have to finish
my expanded "Porting From Oracle" thingy.
>
> richardh=> select '1970-01-01'::date
I searched the docs for function to convert epoch to timestamps but
couldn't find any. Are there any?
Thanks,
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net |+
Computer Science, Utah State University - http://www.usu.edu
Hi
Is there any way, possible an SQL or pgsql command, to get the server version?
Thank you
Roberto
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ot; part is to avoid getting the PostgreSQL internal tables
in the output.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Develo
On Tue, Jul 03, 2001 at 11:07:35AM -0500, Manika Dey wrote:
>
> Hi,
> Is postgresql database available for WindowsNT platform.
Yes. Download CygWin at http://www.cygwin.com and read the
documentation in postgresql.org regarding installation on Windows.
SQL:
>
> SELECT date_part('day', date), count(*)
> FROM client_order WHERE (date >= '01/05/01' AND date < '01/06/01') AND
> status = 'Processing'
> GROUP BY date_part('day', date);
Didn't look very hard,
t,
> hint...)
How so? Would you please elaborate? I'm note familiar with the update.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu
INPUT = my_procedure_1, OUTPUT = my_procedure_2);
What would the functions my_procedure_1 and my_procedure_2 look like?
Thanks,
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
I've heard quite a bit about PL/TclU, but what's the difference
between that and regular PL/Tcl??
Thanks,
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.ne
ange. Is there an easier way?
pgAcess should make it easier. It lets you look at the definition and
lets you modify/drop/recreate it.
If you're on windows, you might want to look a pgAdmin (available at
greatbridge.org).
-Roberto
--
+| http://fslc.usu.edu USU
sileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=36
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
TAG
there anything we can do about this? It seems tailor-made for a
> PostgreSQL app ... I volunteer for design/SQL if someone can find a PHP
> or Java coder for the interface.
I think this has already been done, but I don't know if it has been
linked from the man pg.org site. It's
om trigger. It is
> possible to do this without triggers?
A little RTFM'ing wouldn't hurt.
Currently you can't return tuples from "regular" PL/pgSQL functions.
It heard this functionality will make it in 7.2.
-Roberto
--
+| http://fs
or examples of functions, head to http://www.brasileiro.net/postgres
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
On Wed, May 30, 2001 at 11:14:38PM +0530, Sharmad Naik wrote:
> hi,
> I wanted to know that does postgresql database support php-nuke
This is a php-nuke question. Head to their website and it should be
stated there somewhere.
-Roberto
--
+| http://fslc.usu.e
ter PGAccess
> editing are met with: 'Parse error at or near ""'
IIRC, pgaccess does quote-escaping for you, so if you try to write
"standard" PL/pgSQL (escaping single quotes), it'll barf this error.
Just something to check.
-Roberto
--
I couldn't find the documentation for dealing with Large Objects on
the documentation. Any pointers?
The only info I found on Large Objects was on the programming guide,
but I'm not looking to write C functions with largo objects.
Thanks,
-Roberto
--
+
n use to do this.
The OpenACS folks used that approach to port Oracle's CONNECT BY to
PostgreSQL, so you could probably ask them over at openacs.org/bboard.
-Roberto
P.S: I plan to add this to my expanded "Porting From Oracle" chapter of
the documentation.
--
+| htt
the PostgreSQL database. For Oracle support you should look for an
Oracle forum/list or call their support.
http://www.arsdigita.com/bboard (web/db forum) has lots of Oracle
users.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto
On Tue, May 08, 2001 at 09:16:56PM -0400, Wei Weng wrote:
> I have a table that has a serial for primary key. Is it possible to get
> the new available primary key right after I insert a row of new entry?
Yeah. Se the documentation on triggers.
-Roberto
--
+
tions there. The more we have, the better. I
am going to improve the site in a few days.
http://www.brasileiro.net/postgres
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileir
Again, you're giving way too little detail. What error? What are you
trying? Without this, it's very hard to help.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://w
On Fri, May 11, 2001 at 01:17:41PM +1000, Keith Gray wrote:
>
> The problem is in ipqsql...
What the heck is ipsql??
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.bras
t be able to do it with subqueries. PostgreSQL 7.1 has
subqueries in the FROM clause as well al regular sebqueries.
Read the subqueries chapter of Bruce Momjian's PostgreSQL
book for more info, or give us more information. The book is at
http://www.ca.postgresql.org/docs/awbook.html
I usually do the encrypting in the client application (AOLserver, PHP),
store the encrypted password, when the user comes back and enters the
password I encrypt it and test it against what's on the database.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux
;s to
answer your questions that we take the time to write docs in the first
place :)
Short answer: everything in your function is executed in one
transaction. BEGIN and END in PL/pgSQL are NOT the same as in the
transaction semantics.
-Roberto
--
+| http://fsl
ich one will survive the fall?
Comparing MySQL to PostgreSQL, Oracle or any other real database is
like comparing DOS with UNIX, or Emacs with an orange.
-Roberto Mello
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Compute
hat should I do.
Look at the article an http://techdocs.postgresql.org
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Develope
tch (1994) so I hope this won't be much of an issue (but
then PHP 4 still has threading problems AFAIK).
Not using persistant connections is just too slow for me. It's
instantaneous for AOLserver to generate a page, when the same page with the
connection overhead in PHP takes A L
penNSD world -- where ALL
connections are persistant, pooled, and dstributed among threads -- I'd be
interested in knowing the quirks of persistant connections in PHP.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Scie
e then.
>
> Do anyone know where the 7.1 RPM's are so that I can install them?
Have you tried postgresql.org? I am sure you can find it there :) It
looks like it's bogged down with downloads now. You can get it from our
mirror at http://fslc.usu.edu/downloads/pub
handles properly doing auto
> increments with the SERIAL type, and does the set/enum conversions?
What do you mean by "propely doing auto increments"? What's the
problem you are having?
-Roberto
--
+| http://fslc.usu.edu USU Free Softwar
use a howto or
Bernardo,
Do you really need the keys to be random numbers? Can't the keys be
sequential numbers, like 1,2,3,4...? That'd be a lot easier to make
unique, and as far as the user is concerned, it'll be random for him/her.
-Roberto
--
+
l for a 16-bit patch to an 8-bit operating system
> originally coded for a 4-bit microprocessor, written by a 2-bit
> company that can't stand for 1 bit of competition.
:) Remarkably accurate!
-Roberto
--
+| http://fslc.usu.edu USU Free Software &
1 - 100 of 139 matches
Mail list logo
