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/ |--
, 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/ +
-
n
> similar to NULLIF().
Use the standard coalesce().
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
MONEY TALKS ... but all
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
hamando outra função que o faça).
-Roberto
P.S.: Tomaz, you understood his question correctly :-)
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club -
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
**
List of databases
Name | Owner| Encoding
++--
addresses | windozefoo | LATIN1
foobar | roberto| LATIN1
openacs-4 | roberto| LATIN1
template0 | postgres | LATIN1
template1 | postgre
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
to.
Thanks,
-Roberto
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
---(end of broadcast)
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
x.php?functions-conditional.html
Hope this works.
-Roberto
P.S.: Some indenting goes a long way through helping to understand your
code.
--
+|Roberto Mello -http://www.brasileiro.net/ |--+
+ Computer Science Graduate Student, Utah State University +
+ USU
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
ree Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
Itsdifficulttobeverycreativewithonlyfiftysevencharacters!
---(end of broadcast)---
at http://br.groups.yahoo.com/group/postgresql-br/
The archives are searchable, so you could try there.
-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
du/ USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
A .45 beats a royal flush EVERY TIME
---(end of broadcast)---
TIP 6:
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
tp://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
Why trying to DRINK and DRIVE, while you can SMOKE and FLY?
-
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
to
--
+| 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
* * * <- Tribbles § § § <- teenage mutant ninja tribbles
---
know if the \' way of escaping quotes works. I never tried within
a PL/pgSQL function. My guess is that it doesn't.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.
e
non-standard.
-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
NY cops go bar-hopping; LA cops go night-clubbing.
Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
Windows is not the problem. Ignorance is the problem.
---(end of broadcast)
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
Table "blah"
Attribute | Type | Modifier
---+--+---
something | timestamp with time zone | default 'now'
name | character(50)
-Roberto
--
+| Roberto Mello - http://www.brasileiro.net |+
+ '996654342 seconds'::interval;
> ?column?
>
> 2001-08-01 08:25:42+01
> (1 row)
Duh! Guess I could have thought of that.
Thanks a lot.
-Roberto
--
+| Roberto Mello - http://www.brasileiro.net |---
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
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
-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
Dente lupus, cornu taurus petit.
---(end
but can't you just add a:
CASE WHEN count(*) > 0 THEN count(*) ELSE 0 END AS count
-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 Dynami
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
Free Software & GNU/Linux Club |--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
*> -| <- Tribble Archery
---(end of broadcast)-
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
at fts.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, Developer
Windows? HA! CD\WINDOWS. DELETE *.* AH! That
lc.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
Death to all fanatics!!!
---(end of broadcast)---
TIP 2: you
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
du 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 what this button does? *&^(&^)#@$*&_% NO CARRIER
--
+| 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'm only a droid and not very knowledgeable about such things.
---
| 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
Be a pessimist. A pessimist is never disappointed.
---(en
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
| 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
"Data! I thought you were dead!" "No, Sir. I rebooted."
--
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
-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
_ _ _ _ _ _ || < domino effect at work
--
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
c.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
If at first you don't succeed, destroy all evidence that you tried.
---(end of broadcast)-
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
OT longer.
-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
Tetris tagline: @@ o@o @oo oo@
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
-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
-°*'. (Explosive Tagline)
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
| 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
Oh my GOSH! A Prompt!!! HELP A PROMPT ! HELP !
---
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 &
On Fri, Apr 13, 2001 at 09:00:45AM -0600, Roberto Mello wrote:
> If I try to connect through psql, it asks me for the password again.
> It looks like it's using password auth instead of ident auth, which used
> to be the default.
> There's nothing pointed in the
at or
anything. I've looked.
Thanks,
-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
ot;PostgreSQL Powered" button!
We've been getting many hits from techdocs.postgresql.org, which shows
that many are going to techdocs looking for solutions to common problems.
Very useful.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club |--+
R
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
Ad astra, per ardua nostra.
---(end of broadcast)
select max(id) from ;
-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
Backup is for whimps!
et of the functions here?
-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
TOFU -> Text Oben Fullquote Unten
-
w to change some Oracle'isms (e.g. nvl, decode, etc.) to
PostgreSQL, sticking to the standard where possible.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net
http:/
s jsp files and PostgreSQL does
not have a Java virtual machine. But you can use PostgreSQL from your Java
program by using JDBC.
Look for Jakarta/Tomcat for an open source servlet container.
-Roberto
--
+| http://fslc.usu.edu USU Free Software & GNU/Linux Club|--+
Rober
u can't roll back.
-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, Web Developer
"Carrier detected." Go to the dentist...
1 - 100 of 126 matches
Mail list logo