ly. Does this change
your explanation?
If your objective is to run a stored procedure once but return several
values, look at either defining multiple OUT parameters, or returning a
record type.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you
Jan Mura wrote:
Hello,
I am a little bit off Postgres but would like to know about some good
Oracle mailing lists.
A little bit off??? Use the forums on the Oracle Technology Network:
http://www.oracle.com/technology//index.html
--
Guy Rouillier
---(end of
Not sure what you are looking for, though, since your condition in both
CASEs above is exactly the same.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
guage and write stored procedures in it.
Who dreads PL/pgSQL? It's a pretty easy language to learn. Granted,
not as easy as one you already know, but I'm not aware of any RDBMS that
supports C# as a stored procedure language.
--
Guy Rouillier
---(e
in contrib, but it
is not as complete an implementation as Oracle's.
Hope that helps.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTEC
Oracle does
not implement substring() at all (up through release 9.2, the latest I
have to work with. Just checked the online documentation for 10g
Release 2 (latest available) and it doesn't have it either. Says this
under conformance: "E021-06, SUBSTRING functio
abcd'
Oracle substr('abcdefg', 0, 4) = 'abcd'
Oracle substr('abcdefg', -1, 4) = 'd'
PG substr('abcdefg', 1, 4) = 'abcd'
PG substr('abcdefg', 0, 4) = 'abc'
PG substr('abcdefg', -1, 4) = 'ab&
command?
SELECT INTO is used in procedural language functions to place column
values into program variables. To copy the contents of a view into a
table, look at instead CREATE TABLE AS or INSERT with SELECT.
--
Guy Rouillier
---(end of broadcast
compatible change in rule representation, which means you must initdb
when installing or removing it." I was unable to find pg-hier in a
quick cruise through PgFoundry.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading
bases (again)" for the latest.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
arted with c.setAutoCommit(false);
--
Guy Rouillier
---(end of broadcast)---
TIP 1: 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
e all the Tables and colums with relationship in
the PostgreSQL. So, what can doPlease replay me ASAP..
ERWin should have a menu item to generate DDL for your design.
--
Guy Rouillier
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
neralized, variable-length list of values in your IN
clause, you'd need to use dynamic SQL.
--
Guy Rouillier
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
devices are there, and how often do deletes happen? If
there are only 30 devices, and deletes only happen on the order of one
per week, then you could simply run a delete trigger to renumber them.
--
Guy Rouillier
---(end of broadcast)---
TIP 6
devices are there, and how often do deletes happen? If
there are only 30 devices, and deletes only happen on the order of one
per week, then you could simply run a delete trigger to renumber them.
--
Guy Rouillier
---(end of broadcast)---
TIP 5
Tom Lane wrote:
> -- repeat up to the most number of decode items you need to support
Does PG's function overloading make varargs difficult?
--
Guy Rouillier
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ign
occasion to use it, but that would seem to be an attractive option
for a cross-platform GUI.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMA
t in the admin
space. The only time admins encounter that type of volume is backups,
recoveries, copies, etc., which will likely be in the DBMS-specific
realm.
--
Guy Rouillier
---(end of broadcast)---
TIP 6: explain analyze is your friend
st change to it "cd
\windows\system32" and issue your command from there. The current
directory is searched first before the path.
>
> Still baffled.
Run it the way you were given, and if that doesn't work, reverse the
last two params per the help.
>
> Bob
&
dmin rights on this computer, you'll
accomplish exactly the same thing if you simply open up User Accounts
from the Control Panel and delete the account that way.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
since the plan may change over time.
--
Guy Rouillier
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
k. Or maybe a
> bar.
The Mantis bug tracking software http://www.mantisbt.org/ now works with
PostgreSQL (was developed with MySQL.) It works equally well with both,
including automated installation.
--
Guy Rouillier
---(end of broadcast)
a single value, you
can also avoid INTO altogether with something like:
REGNO := (select regno from admission where sname = myname);
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
hich case you only need one set of images on a central file
server.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
a failure code, don't store the rest of the data in the DB;
you've just implemented data consistency. That assumes, of course, that
the image is the only meaningful data you have, which in most situations
is not the case. Meaning you'd want to store the rest of the data
a
the end of a given week, month.
Timestamp each transaction, then use a GROUP BY clause to aggregate the
numbers however you wish. If the available date field extractions are
not sufficient, write a scalar function of your own to accomplish what
you need.
--
Guy Rouillier
FILEDATE
Enter these lines into file, e.g., filedate.sh. To make this file
executable, at a command prompt, type "chmod +x filedate.sh". Unlike
Windows, file types (e.g., executable vs text) are not determined by
their extensions, so you need to explicitly tell Linux this file can b
t, then just look them up when you
need a connection.
--
Guy Rouillier
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
nces. Does anyone know of a fix?
Well, if you want all your clients to interpret a null value in that
column as zero, can't you just update the column to actually contain a
zero for those rows?
--
Guy Rouillier
---(end of broadcast)---
TIP 6: explain analyze is your friend
the transaction? See the bottom of the
> following page:
>
> http://www.postgresql.org/docs/8.1/interactive/ecpg-commands.html
>
> "In the default mode, statements are committed only when EXEC SQL
> COMMIT is issued."
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
something wrong with XPath
> implementation.
Makes me think you have null values in the resultset.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Title: Message
PostgreSQL is a database engine. You use it
from a Java application just like you would any other DBMS. The JDBC
driver for it can be found here: http://jdbc.postgresql.org/
--Guy Rouillier
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED
ood for
some applications.
If your question truly is genuine, and you've done some reading, post
back with some more specifics that people can comment on with some
relevance.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
both the inner
and outer selects.
What you want to do is create a primary key on your student table. Then
try to do the insert, catching the "not unique" error return.
--
Guy Rouillier
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
(end of
>>> broadcast)---
>>> TIP 6: explain analyze is your friend
>>>
>>
>> ---(end of
>> broadcast)-------
>> TIP 2: Don't 'kill -9'
it to 32-bit. So RIP is simply the 64-bit
instruction pointer, RSP the 64-bit stack pointer.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
or an extended period. Both
containers can be configured to give up trying and return an error to
your app.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ress this. Bruce and/or
Tom, are there any far-off intentions to do anything to improve "not in"
execution? Or perhaps to rewrite it to an equivalent expression that
already works well?
--
Guy Rouillier
---(end of broadcast)-
ist all the people from the first table
> that do not have any entries in the second table? Basically, I want
> a listing of all my people who have not signed up for the class.
select *
from people
where id not in
(
select id
from class_registration
)
--
Guy Rouillier
--
Chris Velevitch wrote:
> It seems that all the postgresql mailing lists don't allow you to
> automatically reply to the list only the sender. I don't get this
> with all my other mailings list. Who I contact to have this
> rectified?
Done on purpose. Use "reply t
/tigerk8we_spec.html).
> It's no wonder that the other raid controllers showed significantly
> less performance than the PCI-e card.
You're looking at the wrong board. They are talking about the Tyan
*Thunder*, which does indeed have 64-bit PCI-X. You are looking
ix them or null them out.
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ecord is not inserted. now i
> would like to have a table with all records including hours with 0
> count.
>
> can somebody please help me urgently. i would really appreciate it.
> thanks.
Don't rely on your SELECT to provide the timestamps. You kn
int
Using the following input file t1.csv:
5,NULL,7
8,NULL,10
The following COPY command successfully put those rows in the table, with f2
null:
copy t1 (f1, f2, f3)
from 't1.csv'
null as 'NULL'
csv;
--
Guy Rouillier
-
ative tools available. Some, like pgAdmin III don't
require any additional server software at all; it is a client tool that
resides on your workstation, and both Windows and Linux/Unix
implementations are available. Other options exist as well; a quick
search of the archives will provide some
cuted.
How do you define success? A delete can do nothing and be considered
successfully executed as long as no DB errors occur. If all you want to
know is whether or not DB errors occurred, then Jaime supplied a
solution to that.
--
Guy Rouillier
---(end of broadcast)-
John McCawley wrote:
> Foreign keys do not cascade deletions.
They will if you specify "on delete cascade".
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
sub
a CSV file and load that?
(2) Read insert statements and execute those?
(3) Read unformatted data, interpret it and load the results?
(4) Something else?
--
Guy Rouillier
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will i
since getting the email account.
They obviously do aggressive spam filtering, but as far as I know I'm
getting all the email I should. An option to consider...
--
Guy Rouillier
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
e should have been; then execute that other statement.
There is no magic database-provided SQL statement that says "try an
insert and if that fails then try an update." You have to do that
yourself.
--
Guy Rouillier
---(end of broadcast)---
ful as it is, I'm surprised the
designers have elected not to implement synonyms, which is how most
other databases address this issue.
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ooking under the correct schema. Each
schema has its own set of objects.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
>
>
> -------(end of
> broadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
5
> valve
> 1
>
>
>
>
>
>
>
>
>
>
>
>
> Auto_control
>
>
>
>
>
>
>
>
>
> loop_id
> mon
> valve_a
> valve_b
>
> serial
> int4
> int4
what is the selection criteria that brings these results together?
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Jaime Casanova wrote:
> On 11/18/05, Guy Rouillier <[EMAIL PROTECTED]> wrote:
>> Short version of story: I'm converting some Java->Oracle code to PG.
>> It uses the standard JDBC batch facility, which is simply a
>> collection of statements sent to the server
I suppose, is to allow these verbs and then
translate them to SELECT in the driver and throw away any return value.
That seems like more of a hack than a solution. I suppose the same
could be said with respect to doing the same thing in the core language.
--
Guy Rouillier
-
return, you
force him/her to resume or delete the existing transaction before they
can start a new one.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Tom correctly
points out, there is no guarantee whatsoever that the end user will ever
complete such a transaction.
>
> If you really do need to allow one user to edit the information and
> still present the existing information to others but not let them
> update it co
to put your .sql script there. Either put the bin
directory in your path, or pass the full path to your .sql script to
psql.
--
Guy Rouillier
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
ill PostgreSQL 8.04 run perfectly on a
> 64-bit OS, or should I run the 32 bit OS for now?
AMD just announced new price cuts on Opterons. You'd be better off,
generally, running a server on Opteron vs. Athlon 64. And dual Opteron
would generally be better than single.
--
Guy Rouillier
clause, then update the rows that are returned. Many DBMSs have a
SELECT FOR UPDATE and then UPDATE WHERE CURRENT OF CURSOR, but a quick
read of the documentation doesn't list such constructs for PostgreSQL,
so if not you'll need to use separate statements.
--
Guy Rouillier
--
to reinstall
> PostgreSQL to reset it, or can I do this somewhere else?
If you leave everything installed via the defaults, you don't need any
password to log in locally. So if you forget the password, you can log
in locally with no password and reset it.
>
> Thanks for any hel
ach the opposite conclusion for varchar? If anything, I
would think that stripping pad characters makes more sense for varchar
than it does for char. But that may simply be bias from experience, as
my first real DBA work was with DB2, where fixed length columns really
n. I
would say that if the user hasn't specifically asked for a trim, it
shouldn't happen, but I have not read the standard on this.
We're all discussing these intricacies from a comp sci perspective.
From a normal user's perspective, of course, they would prefer the DBMS
to hide these types of nuances.
--
Guy Rouillier
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
LECT 'a '::char = 'a '::char;
> ?column?
> --
> t
>
This does't show anything useful, because the ::char casting simply
takes the first char of any string:
select 'abc'::char = 'axy'::char
Also results in 'true'. Ho
lease see a long, detailed thread in the archives titled "Email
Verification Regular Expression" on Sept 7, 2005.
--
Guy Rouillier
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose a
ions, but no DBMS should do that blindly.
> Port that to another database. Seen the JOIN syntax? *sigh*
I believe you're referring to the 8i (+) syntax? 9i supports regular
outer join syntax.
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
version also supports PostgreSQL quite well. I set
it up just to check it out, and even the automated database generator
works fine with PG. Click the download link and then 1.0.0rc2.
--
Guy Rouillier
---(end of broadcast)---
TIP 5: don't fo
uits do this for peace of mind. They are very nervous about
entrusting corporate data to open source databases with no support. Why
else do you think companies are willing to pay Oracle $300,000 per CPU?
At 2 am if something gets corrupted, they can call Oracle and attempt to
get it fix
Roman Neuhauser wrote:
> # [EMAIL PROTECTED] / 2005-08-15 20:25:20 -0500:
>> On Tue, Aug 09, 2005 at 03:26:27PM -0500, Guy Rouillier wrote:
>>> chiranjeevi.i wrote:
>>>> Hi Team Members,
>>>>
>>>> Is it possible to write jobs in postgresql
ld then require chainged
transactions, which could get very messy.
> (My understanding
> is that they currently get called immediately whether or not there is
> a transaction in progress.)
There is always a transaction in progress.
--
Guy Rouillier
---(end of b
>
> I want *no* PUBLIC access to anything by default for security
> reasons. Is there a way to prevent this behavior?
>
> ---(end of
> broadcast)---
> TIP 4: Have you searched our list archives?
>
chiranjeevi.i wrote:
> Hi Team Members,
>
> Is it possible to write jobs in postgresql & if possible how
> should I write .please help me.
See pgjob in pgfoundry: http://pgfoundry.org/projects/pgjob/. It's in
the planning stages.
--
Guy Rouillier
-
abled. Wouldn't
that affect the stats files as well?
--
Guy Rouillier
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
mess
ever, in order to post to a list, you must still subscribe to that
list (but it is possible to subscribe without receiving mail)."
Update your subscriptions to request that no emails be sent. Then read
posts and reply through the PG news serve.
--
Guy Rouillier
-
e page and the first
group I see under "Other Software" is "Graphical Clients".
--
Guy Rouillier
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
an
over all that large binary data to extract text or numeric data. And
backups will copy that static binary data repeatedly. For those
reasons, if I'm storing very large objects, like images, that I know
I'll never search or update, I prefer to manage them externall
MS world it will be a simple table (non-relational)
See the COPY command. Tab is the default delimiter in text mode.
--
Guy Rouillier
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Server.
Have you investigated updating the tool so it can talk directly to
PostgreSQL? Might end up being less work (and more robust) than
migrating all the data from PG to SQL Server each time the other group
sends you the database.
--
Guy Rouillier
--
nonnull values.
Technically, PRIMARY KEY is merely a combination of UNIQUE and NOT NULL"
Primary key columns cannot contain null values.
--
Guy Rouillier
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
.
I thought the 2.6 kernel had good NUMA support? (I realize I just made
an assumption that the original poster was running PG on Linux 2.6.)
--
Guy Rouillier
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index
or any suggestions.
Every version of Toad I've ever used connects to Oracle using the OCI
driver. You'll never get the OCI driver talking to PG - completely
different communication protocol (well, never say never, but not today
anyway...)
--
Guy Rouillier
Santharam wrote:
> Hi All,
> I am looking for a free data migration tool for migrating
> data from oracle tables to PostgreSQL. Can anybody help me on this?
Ora2pg.
--
Guy Rouillier
---(end of broadcast)---
TIP 4: Don't
em to other
functions:
DECLARE
numRows integer := 5;
BEGIN
perform add_5_min_table(numRows);
--
Guy Rouillier
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
table N-1 to backup and then just drop the table. You may want to
consider something like this; if you don't have too many volumes, have
separate tables by volume by month.
>
> Thanks
>
>
>
> ---(end of
> broadcast)-----
[EMAIL PROTECTED] wrote:
> On Sun, Mar 27, 2005 at 12:54:28AM -0600, Guy Rouillier wrote: []
>> The service_plane table is a reference table, i.e., a fixed set of
>> values used only to validate foreign keys. So the code doesn't have
>> any update statements on that tabl
the parent table with a
reference count? For example, the scenario I started this thread with
had two child tables referencing rows in a common parent table. For a
given parent tuple, a single "prevent write" lock with a reference count
would seem sufficient.
--
Guy Rouill
t to do it.)
>
>
> Thanks In Advance!
>
>
> Ross Mohan
> Postgres Rookie
>
> -------(end of
> broadcast)---
> TIP 8: explain analyze is your friend
--
Guy Rouillier
---(end of broadcast)---
TIP 8: explain analyze is your friend
it is a fairly common usage
model (think traveling salespeople.) I've personally used Watcom (now
Sybase) SQL Anywhere which has this and it works quite well. I would
respectfully disagree that the requirement for two-way replication
indicates a broken design.
--
Guy Rouillier
ular emerge to say absolutely. --pretend will allow you to see
what will be updated without actually doing the update.
--
Guy Rouillier
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Alvaro Herrera wrote:
> On Sun, Mar 27, 2005 at 06:02:25PM -0600, Guy Rouillier wrote:
>
>> With the current implementation, it appears I need to either (1)
>> always commit after every inserted row, or (2) single thread my
>> entire insert logic. Neither of these
Michael Fuhr wrote:
> On Sun, Mar 27, 2005 at 12:54:28AM -0600, Guy Rouillier wrote:
>> I'm getting the following in the server log:
>>
>> 2005-03-27 06:04:21 GMT estat DETAIL: Process 20928 waits for
>> ShareLock on transaction 7751823; blocked by process 20929.
is discussed very frequently; search the
archives for an extended discussion earlier this month under the subject
"Partitioning." Currently with PG, you can have "roll your own"
partitioning, and inherited tables help with this.
--
Guy Rouillier
---(en
> http://smallbusiness.yahoo.com/resources/
>
> ---(end of
> broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
--
Guy Rouillier
---(end of broadcast)---
TIP 8: explain analyze is your friend
FIVE_MIN_STATS_200503 has a foreign key into "rumba"."service_plane".
The service_plane table is a reference table, i.e., a fixed set of
values used only to validate foreign keys. So the code doesn't have any
update statements on that table.
e undefined_table exception in your trigger functions,
then create the tables if they don't exist? We do that and it seems to
work fine.
--
Guy Rouillier
---(end of broadcast)---
TIP 6: Have you searched our list archives
Jeff Amiel wrote:
> We intended to do that very thing (read the earlier parts of the
> thread between myself and Tom Lane)
Sorry, you're correct. Somehow I missed that exchange (just read the
archives.)
--
Guy Rouillier
---(end o
ool that uses SET SESSION AUTHORIZATION after
obtaining a connection. That way you can still have a small number of
pooled connections but have the real user id associated with the
connection.
--
Guy Rouillier
---(end of broadcast)---
TIP 8: explain analyze is your friend
ty context information, so you can extract the
authentication credentials from there to write to an audit table (or
even include in every row you write to the database.)
--
Guy Rouillier
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
101 - 200 of 237 matches
Mail list logo