Unsubscribe
---(end of broadcast)---
TIP 6: explain analyze is your friend
The syntax in Oracle is "is null" or "is not null" as in:
select count(*) from module_master where gatekeeper_status is null;
And yes that does work in PostGreSql. Now if your talking about the
Oracle function NVL, for Null Value, no that does not work and I don't
see a similar function in PostG
If your using V7.4 it doesn't but the following will create
one.
CREATE OR REPLACE FUNCTION to_date(text, text)
RETURNS "timestamp" AS'beginreturn to_timestamp($1,
$2);end;' LANGUAGE 'plpgsql' STABLE
STRICT;
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jim
FuSent: M
As I browse through the contrib directory I find an Oracle directory with
example perl scripts to do just as your asking.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bradley Kieser
Sent: Wednesday, December 28, 2005 10:12 AM
To: Murugan G
Cc: pgsql-a
Few, if any, application packages come with a preinstalled
db. They always send you the installation cd for the required database
engine, with a runtime license if applicable, or place the requirement on the
user to install the db first.
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] O
cond, this must be so instantaneous. Could you tell me more about
an additional Java procedure to handle Oracle??Thanks a lot in
advanced...Kind Regards.-Alfredo Rico.
On 10/20/05, Goulet,
Dick <[EMAIL PROTECTED]>
wrote:
Alfredo,
Well if you'll pardon my total lack of Spanis
Alfredo,
Well if you'll pardon my total lack of Spanish,
I'll definitely pardon your English.
First question though, what is the architecture
being implemented here? Are we talking about in Intranet application where
your Java & the Postgresql db are outside of the firewall. If
I believe the problem is that under Windows there is no such entity as
$HOME.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Lane Van Ingen
Sent: Tuesday, September 06, 2005 1:55 PM
To: Eric Emerton; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Window
From what I've seen in their beta version, yes their just being a Red
Hat like var and adding some gui based add-ons.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Izoel Aguiar C
Sent: Tuesday, August 23, 2005 12:43 PM
To: pgsql-admin@postgresql.org
Sub
Bruce,
Agree that pausing or sleeping is not really a database
function, more of a programming function. But Oracle and I understand
though I can't find it at the moment SQL*Server do offer this
functionality within their DB's just because people do store functions
and procedures that are
Check out WinSql
(http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp) It has the
ability to extract data from Sql*Sucker and drop it into PostGreSql, and
you can have that functionality free for 90 days to boot.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Then drop and rebuild the table. Otherwise add it onto the end, which I
believe is ANSI SQL expected behavior and forget about it. Where the
column is in the table is less important than where you place it in the
select statement. The only other time I can see column placement as
being important
Looks like you've tied into one of those Microsoft clone companies that
can't get off the Microslop stack. Have a similar problem with a
product here that will not work with anything other than Sql*slave and
if you hack it they won't support it. Best of luck. It also looks like
one of those "sm
This might help, got it from a project run by Great Bridge Software, now
defunct, to create an Oracle like data dictionary for PostGreSql:
CREATE VIEW all_objects
AS
SELECT UPPER(pg_get_userbyid (cls.relowner)) AS owner
,UPPER(cls.relname) AS object_name
,CASE WHEN cls.relk
Humm, I am unaware of any Oracle feature that does disk encryption.
There is a built-in package that allows one to encrypt the data as it is
on it's way to the table, but nothing to encrypt the data on it's way to
the disk. Your friend may have been mislead by the fact that Oracle
writes it's data
I'm an Oracle DBA first, but I've become very comfortable with
PostGreSql as well. The two have a lot in common and a lot of
differences. MySql in contrast is more used by those here who are very
comfortable with Access. Those two have a lot in common. As for GUI's
their great, until 2AM when a
My favorite for this task is WinSql available from
http://www.synametrics.com/SynametricsWebApp/WinSQL.jsp. It can compare
the structure and content of the two tables.
-Original Message-
From: John DeSoi [mailto:[EMAIL PROTECTED]
Sent: Monday, March 07, 2005 7:40 AM
To: Stef
Cc: pgsql-A
Collective user accounts are all well & good so long as everyone using
it understands that you don't change stuff. If you've got a user who is
adamant that they have to have a specific password, etc... Then your
only recourse is to create them their own user account. I've done that.
It's a bit pa
Scott,
Now add two managers who are more at home with HP MPE or VAX VMS
and a CIO whose more comfortable in software development & you'll see
why I am the way I am. Paranoia & irrational thought are everywhere.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message
ot;root"
Debate!
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thursday 13 January 2005 10:52 am, Goulet, Dick wrote:
> Doug,
>
> OK, Assume that the binaries are installed under root, but a
> hacker cracks PostGres, what is to stop him/her from trashing all of
the
>
nse of the most valuable.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
From: Doug Quale [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 13, 2005 11:56 AM
To: PostgreSQL Admin
Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus &qu
Well, thanks for the leeway, but getting one's nose rubbed in things for
good and bad comes with the turf. If there's one thing I've learned
about software over the years it's that there are many ways to skin the
same cat, just some are less painful than others.
Anyway, to the discussion: Commerc
:[EMAIL PROTECTED]
Sent: Wednesday, January 12, 2005 11:14 PM
To: Goulet, Dick
Cc: Peter Eisentraut; Tomeh, Husam; PgSQL ADMIN
Subject: Re: [ADMIN] Installing PostgreSQL as "postgress" versus "root"
Debate!
On Wed, 12 Jan 2005, Goulet, Dick wrote:
> You may well be on the
Peter,
You may well be on the development team, but you are wrong for
one very important reason. If the Postgresql executables are owned by
root they execute with the priviledges of root. Thereby any local
created extensions like database_size also execute with the priviledges
of root.
Sidnei,
You'll find PostGreSql and Oracle to be kindred spirits. Similar, but
different at the same time. I find performance very good, although you'll
need to tweak the system memory parameters from the defaults and the
postgresql.conf file.
Dick Goulet
Senior Oracle DBA
Oracle Ce
As far as I'm concerned I really don't care so long as the DBMS is
consistent on the matter. Both Oracle & PostGreSql do that.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
From: Robert Treat [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 28, 2004 10:31 PM
Thanks, that worked. Now does Pgsql support a script like Oracle's
login.sql.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 1:14 PM
To: Goulet, Dick
Cc: [EMAIL PROTECTED]
Subjec
Anyone know how to turn off the --MORE-- option when a query returns?
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmail
Sounds like the Oracle parameter TIMED_STATISTICS. Costs you soo little
in performance, but saves you a pile in troubleshooting. Many DBA's
still set it to false to "save the expense". Nice to know the same
exists here.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Messa
ED]
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Multiple WALs for PITR ?
Goulet, Dick wrote:
> As an Oracle DBA primarily, moving more towards PostGreSQL as time
> passes, the "alter system switch logfile" command is very often used
> at the end of a hot backup to force a logfi
As an Oracle DBA primarily, moving more towards PostGreSQL as time
passes, the "alter system switch logfile" command is very often used at
the end of a hot backup to force a logfile switch and consequently
provide a full archive log set. The command causes the database engine
to cease using the cu
Shane,
Two things: 1) when was the last time you vacuumed the
database? From my experience that has a large effect on the database
performance. 2) Why do you have so many postmaster processes? I've got
an active database but only one postmaster.
Dick Goulet
Senior Oracle DBA
Oracle
Given the "fun" I've had with Sql*Server and it's sister Access, you'd be much better
off porting things manually. I'd precreate all of the tables/indexes and then move
the data with the aid of Access or a similar ODBC tool. As for the rest, re-write it
as Tsql is more like VB than pgplsql.
D
Terry,
In pga_conf.hba you can setup to restrict access to the other databases as in:
# TYPE DATABASEUSERIP-ADDRESSIP-MASK METHOD
# IPv6-style local connections:
hostdb1 usr1 ::1
:::::::
No
habla Espanola!!!
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Christian Hache
[mailto:[EMAIL PROTECTED]Sent: Tuesday, September 07, 2004
7:07 AMTo: [EMAIL PROTECTED]Subject: [ADMIN]
Asignasr permisos a usuarios
Hola,
les comento mi
If your looking to have users connect to one database & see the entire enterprise
worth of databases then Postgres is not what you want. Have damanagement get out
their wallet & buy Oracle instead. It's made to purpose.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Messa
From: Christopher Browne [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 14, 2004 12:22 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Pseudo-Off-topic-survey: Opinions about future of
Postgresql(MySQL)?
[EMAIL PROTECTED] ("Goulet, Dick") wrote:
> Personal opinion here: Software pack
Personal opinion here: Software packages like MySql and Ingres in the open source
world are doomed to obsolescence. Reason, they are released by a for profit company
that is trying to play up to the open source market. In MySql's case they're pouring
all of their talent into MaxDB. Why, becau
I'd
not call it a "distributed database". It's simply replication of data from
one database to another, & SlonyI will do that for you in Postgres.
Down loaded it & the documentation form the Postgres web
site.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message
Your
username would have to have the same group as PostGreSQL assigned to you,
normally DBA.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Mohammad Tanvir Huda
[mailto:[EMAIL PROTECTED]Sent: Thursday, July 29, 2004 9:30
PMTo: [EMAIL PROTECTED]
Steve,
I'm a little short on PostgreSQL experience, but gaining fast. I'm more of an
Oracle nut. But I think you've pin pointed the problem, namely disk contention. The
easiest solution I can think of would be to stripe the volume group across all three
drives thereby spreading the p
BTW for those interested Oracle 9i also uses the LEFT, RIGHT, and OUTER join syntax as
well.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
From: Stephan Szabo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 23, 2004 12:54 PM
To: Jhonatas M. Rodríguez
Cc: [EMAIL
Idle processes are not uncommon on a database. Basically their client applications
that don't have anything for the database to do at the present time. Now if they
persist for a long period of time without ever changing state to active, then
something is probably wrong.
Dick Goulet
Senior Ora
Andrew,
Your absolutely right. During the DOTCOM fiasco commercial database licenses
were based on the number of processors & the speed of those processors. Oracle's
PowerUnit pricing was one of those stupid attempts. A power unit was defined as 1 CPU
running at 1 MHZ. Mind you a po
And speaking of Rolls Royce's, there is a commercial product called Terradata that is
extremely good at handling PB's of data. Of course the bottom of the barrel entry
price is $400,000US, not including the proprietary hardware & OS you need.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DB
Tom,
I believe PG's biggest problem is that many third party vendors of any
significant size (read that as PeopleSoft, SAP, etc.) don't support PG and PG as
an entity does not have a owner like Oracle, DB2, Sql*Server. There are other
problems with PG as well that I'll admit are no
Yeah, move on over to Oracle. Even on older versions the file limit may have been
2GB, but a tablespace could have more than one datafile. The true limit there is
4194303 blocks where a block can be 2KB, 4KB, 8KB, 16KB, 32KB, 64KB and with 10G comes
128KB. Then each table/index can have 419430
Eric,
I'm no lawyer, hate that slimy feeling. But from
reading the license documentation that is available, your right it is free
PROVIDED you maintain the copyright notice and liability waivers to anyone you
provide the software to.
Dick GouletSenior Oracle DBAOracle Certified 8i
D
Comparing a MySql upgrade to anything else is comparing apples to eggplants. Their
not even in the same group. mySql likes to leave their datafiles alone making all of
their changes in the binaries. Now while that is good from an upgrade standpoint,
what do you upgrade for? New Features. My
Scott,
If you feel it is necessary to apologize for such a minor infraction of polite
etiquette please come on over to Oracle-L. We have harshness 10 times greater.
Probably because there are so many practioners and so many different points of view.
We call them "Holy Wars". The cur
Most
flavors of Unix allow one to delete a file/directory while other processes are
accessing them. Not a problem as whether a file is deleted or not is only
an entry in the Volume Table Of Contents (VTOC) track on the drive. A df,
or dbf if your on HP-UX, will return the amount of free sp
Hope you don't mind if I disagree. Most OS's that have a tcp/ip layer also have a
parameter therein called tcp_keep_alive. They also set this parameter to infinity.
The purpose of tcp_keep_alive is to have the OS kernel periodically verify that all
tcp/ip connections it is managing are still
Philippe,
First off, welcome to the club. We're primarily an Oracle shop, but due to
Oracle's pricing we are using PostGreSql for web based applications.
Why PostGreSql. Well first off it provides a much smaller learning curve for
our developers than MySql does. MySql, until
I'd be interested in anything you hear. Have a similar, but not identical problem.
You could also set up Oracle with it's heterogeneous services capability. There are
ODBC drivers available for most platforms.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
F
Sounds
like what we in Oracle land would call a corrupt block. It also sounds
like it's an index block that got messed up. I'd try dropping and
rebuilding the index if possible before hitting the panic button. As a
quick check try selecting all of the rows out of the table without a where
55 matches
Mail list logo