On Thu, Nov 03, 2005 at 06:15:08PM -0500, Robert Fitzpatrick wrote:
> I have a field with 'AA-BB-CC-DD' and I want to pull those four
> values into an array and then loop through the array inserting
> records into a table for each element. Can you someone point me to
> an example of this in pl/pgsq
On Thu, Nov 03, 2005 at 06:15:08PM -0500, Robert Fitzpatrick wrote:
> I have a field with 'AA-BB-CC-DD' and I want to pull those four values
> into an array and then loop through the array inserting records into a
> table for each element. Can you someone point me to an example of this
> in pl/pgsq
Omachonu Ogali wrote:
I have a table that contains my unique identifiers and their
respective values. In another table, I have a field that is an
array of integers.
Is there a simple way for one to build a constraint that checks
each array value against the primary key table even though the
fiel
Steven Brown wrote:
> When I change an id (primary key serial) in a table, the next value
> returned by the sequence for the id can conflict with that id (e.g.,
> change the id to be id + 1). [...]
If you're doing this to have a custom ordering of your data, consider adding
another int column wit
I have a table that contains my unique identifiers and their
respective values. In another table, I have a field that is an
array of integers.
Is there a simple way for one to build a constraint that checks
each array value against the primary key table even though the
field types don't exactly ma
Michal Hlavac <[EMAIL PROTECTED]> writes:
> but telnet ip_address 5432 result:
>
> x: # telnet 158.195.xx.xx 5432
> Trying 158.195.xx.xx...
> telnet: connect to address 158.195.xx.xx: Connection refused
>
> Why I cannot connect to ip address??
> I tried to add line to pg_hba.conf, then res
On Wed, 02 Nov 2005 19:29:10 -0800, you wrote:
>It's a migration thing - MySQL prevented this
>situation due to the way it handles auto_increment (it will never assign
>you an id that already exists).
AFAIK, in mysql, if you modify a serial by setting it to the max value for
this type, mysql wi
On Tuesday 01 November 2005 09:10, Douglas McNaught wrote:
> James Cloos <[EMAIL PROTECTED]> writes:
> > Does anyone provide binary rpms for rh-7.3 for recent version of pgsql?
> >
> > (My (aging) rh73 box is too small to compile it.)
> >
> > I need to change the setup on that box to mirror a db fr
On Monday 31 October 2005 13:12, Bill Bartlett wrote:
> However, the other place where both these two (Oracle Express and SQL
> Server Express) may hurt is not by taking current users away from
> PostgreSQL but rather by taking away future users, and therefore a
> certain amount of future growth.
Omachonu Ogali <[EMAIL PROTECTED]> writes:
> I've created a type that contains a few types and an array. But when
> I try to create an array from that in a table, I get a '"type[]" does
> not exist' error. The manual says that the array type is configured
> automatically when a type is created, but
hi,
My server is Postgres 8.0.1 on fedora core2.
My clients are remote and interface with my server using .NET GUI.
We are trying to store many images/icons/audio/video clips in our system.
We expect many of these. The way we are doing it is using Hierarchical File System.
I understand we need t
I've created a type that contains a few types and an array. But when
I try to create an array from that in a table, I get a '"type[]" does
not exist' error. The manual says that the array type is configured
automatically when a type is created, but this doesn't appear to be
the case. Am I missing s
> On Wed, Nov 02, 2005 at 03:44:26PM -0800, Marc Munro wrote:
>> experts there may suggest a better solution. I have seen talk of
>> disabling the standard slony triggers to allow this sort of thing but
>> whether that is more or less nasty is questionable.
>
> FWIW, I don't think that's the quest
> On Thu, Nov 03, 2005 at 04:49:33PM -0500, Andrew Sullivan wrote:
>> On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:
>> > > It seems kludgey this way, though. What you really need is
>> > > multimaster with conflict resolution, because you can depend on your
>> >
>> > Isn't Slony2
Michal Hlavac wrote:
hello,
I installed PostgreSQL 8.0.3 on Suse 10 (x86_64).
Firewall is down.
telnet localhost 5432 result:
x:/var # telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
but telnet ip_address 5432 result:
x: # telnet 158.195.
Save globally for all session or between sessions.
Well, I have a set of queries which runs several times. My clients connect
and execute it. But each time the client connects and disconnects, that
means that I loose the execution plan. I would like the keep the execution
plan between sessions tha
Jim C. Nasby wrote:
> This seems to be something useful to have... can we get a TODO? Unless
> maybe Bricklen wants to submit a patch... :)
I can barely even spell C ...
--
___
This e-mail may be privileged and/or confidential, and the sender does
not waive any relat
I agree it is the same old software. The point is that they are changing
the license. Note the text from the download window:
"Note: The current license is for Beta testing purposes only. It does not
include terms, such as free redistribution and embedding (read the FAQ),
that will be available
I have a field with 'AA-BB-CC-DD' and I want to pull those four values
into an array and then loop through the array inserting records into a
table for each element. Can you someone point me to an example of this
in pl/pgsql?
--
Robert
---(end of broadcast)---
hello,
I installed PostgreSQL 8.0.3 on Suse 10 (x86_64).
Firewall is down.
telnet localhost 5432 result:
x:/var # telnet localhost 5432
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
but telnet ip_address 5432 result:
x: # telnet 158.195.xx.xx 5432
Trying 158.19
On Thu, Nov 03, 2005 at 04:49:33PM -0500, Andrew Sullivan wrote:
> On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:
> > > It seems kludgey this way, though. What you really need is
> > > multimaster with conflict resolution, because you can depend on your
> >
> > Isn't Slony2 suppose
On Thu, Nov 03, 2005 at 08:16:01AM -0800, codeWarrior wrote:
> It doesnt sound to me like replication is the right answer to this
> problem... You are setting yourself up to try and defeat one of the major
> purposes of a database in a client-server system -- namely -- centralized
> storage.
Wh
On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:
> > It seems kludgey this way, though. What you really need is
> > multimaster with conflict resolution, because you can depend on your
>
> Isn't Slony2 supposed to do just that?
Well, to the extent that slony 2 ever is going to do an
On Wed, Nov 02, 2005 at 03:44:26PM -0800, Marc Munro wrote:
> experts there may suggest a better solution. I have seen talk of
> disabling the standard slony triggers to allow this sort of thing but
> whether that is more or less nasty is questionable.
FWIW, I don't think that's the question; it
Cristian Prieto wrote:
> Is there around any way to save a prepared plan in postgresql?
Save for how long? Save between sessions? Globally for all sessions?
No, we have no capability for that, and we are not sure why someone
would want that.
--
Bruce Momjian| http:/
On Thu, Nov 03, 2005 at 10:01:30AM -0600, Cristian Prieto wrote:
> Is there around any way to save a prepared plan in postgresql?
Save as in save in the database for other connections to use? It's not
very clear what you're asking...
--
Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECT
On Thu, Nov 03, 2005 at 05:10:44PM +, Richard Huxton wrote:
> Craig wrote:
> >Hi
> >
> >How can I query for all the tables that are referenced by a particular
> >table (i.e my table has 3 foreign keys. I need a query that will return
> >the table names of the referenced tables)?
>
> See the
On Thu, Nov 03, 2005 at 09:25:27AM -0800, Bricklen Anderson wrote:
> Richard Huxton wrote:
> > Bricklen Anderson wrote:
> >
> >>I couldn't find any useful references in the docs or archives for emitting
> >>the
> >>line number of a plpgsql function (in a RAISE statement). I'd like to use
> >>it
On Wed, Nov 02, 2005 at 06:30:38PM -0500, Bruce Momjian wrote:
> Jim C. Nasby wrote:
> > On Wed, Nov 02, 2005 at 05:59:15PM -0500, Bruce Momjian wrote:
> > > Actually, pre-8.1 used ROW EXCLUSIVE for foreign keys because we didn't
> > > have ROW SHARE until 8.1. I actually can't find out how we are
On Wed, Nov 02, 2005 at 07:12:36PM -0500, Tom Lane wrote:
> Bruce Momjian writes:
> > Jim C. Nasby wrote:
> >> Would it be feasable to have the lock manager spew out info about lock
> >> aquisition and release? Not only would it make getting this information
> >> easy, but I suspect it could be a
Go ahead and proceed through the click-throughs...this is still the same old
demo for development and testing only that they have had available for some
time.
This updated on Oct-28th only is for a newer
version(http://www.oracle.com/technology/software/products/database/xe/index
.html) of the sam
I beg to differ. Read this link. New today. Also announced to all
members of the OTN today. --Rick
http://www.oracle.com/technology/products/database/xe/index.html
[EMAIL PROTECTED] wrote on 11/03/2005 11:36:35 AM:
> Again, the previously provide link is NOT the version that is licensed
fre
[snip]
On Thu, 2005-11-03 at 18:02, [EMAIL PROTECTED] wrote:
> Strange - I had never realized that PostgreSQL would allow you to UPDATE a
> primary key value. I thought that other db's I had used (e.g. Sybase,
> Oracle, SQL Server, etc.) in the past would not allow that, and you had to
> DELETE, t
Richard Huxton wrote:
> Bricklen Anderson wrote:
>
>>I couldn't find any useful references in the docs or archives for emitting the
>>line number of a plpgsql function (in a RAISE statement). I'd like to use it
>>for
>>debugging some complex functions.
>>Does anyone have any tips on where to look
Craig wrote:
Hi
How can I query for all the tables that are referenced by a particular
table (i.e my table has 3 foreign keys. I need a query that will return
the table names of the referenced tables)?
See the chapters on the "Information Schema" (which is an SQL standard)
and the "system
Bricklen Anderson wrote:
I couldn't find any useful references in the docs or archives for emitting the
line number of a plpgsql function (in a RAISE statement). I'd like to use it for
debugging some complex functions.
Does anyone have any tips on where to look, or an example of this?
I don't t
Strange - I had never realized that PostgreSQL would allow you to UPDATE a
primary key value. I thought that other db's I had used (e.g. Sybase,
Oracle, SQL Server, etc.) in the past would not allow that, and you had to
DELETE, then INSERT to modify a row that needed a different primary key.
Of c
Florian G. Pflug wrote:
> Tony Caduto wrote:
> > Does anyone know if there is a way to reload the server config remotely
> > via a sql command?
> >
> > I looked through the docs, but may have missed it.
> AFAIK thats not possible with postgresql out-of-the-box.
>
> The latest pgadminIII release
Tony.
> I need to create a exact duplicate for a disaster recovery server, the
> disaster recovery server would not be in use until the production one
> went down for some reason.
While it's not what you asked about, copying the database files, what I do
is pg_dump nightly with a cronjob, th
Again, the previously provide link is NOT the version that is licensed free
for commercial production use!
The version in the headlines lately suggesting a free Oracle database for
professional and production use is NOT YET PUBLICLY AVAILABLE [expected by
year-end]. Still, the link below is likel
Tony Caduto wrote:
Does anyone know if there is a way to reload the server config remotely
via a sql command?
I looked through the docs, but may have missed it.
AFAIK thats not possible with postgresql out-of-the-box.
The latest pgadminIII release (1.4), however, includes some
server-side fun
Hi
How can I query for all the tables that are
referenced by a particular table (i.e my table has 3 foreign keys. I need a
query that will return the table names of the referenced tables)?
Thanks
Craig
FYI, since there has been so much discussion. Have not reviewed license.
Also too busy to download. --Rick
http://www.oracle.com/technology/software/products/database/xe/index.html
[EMAIL PROTECTED] wrote on 11/02/2005 09:34:50 AM:
> On 11/1/05, Andrew Rawnsley <[EMAIL PROTECTED]>
wrote:
> >
>
It doesnt sound to me like replication is the right answer to this
problem... You are setting yourself up to try and defeat one of the major
purposes of a database in a client-server system -- namely -- centralized
storage.
If you add up all the money you are going to spend trying to manage mul
Wouldn't DRBD be a better solution ? Or are you looking for a delay between
updates, so your other server is out by an hour's worth of stuff ? I guess this
is applicable if you use some Linux distro though. HTH.
Cheers,
Aly.
Steve Crawford wrote:
On Thursday 03 November 2005 07:28, Tony Cadu
On 03.11.2005 16:15, Alex Turner wrote:
Please, enlighten us all and demostrate a case of SQL Injection that
gets around magic quotes.
Just someone needs to forget to put quotes around a param..
$q = "DELETE FROM foo WHERE bar = {$_GET['id']};";
instead of
$q = "DELETE FROM foo WHERE bar =
Is there around any way to save a prepared plan in postgresql?
---(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 thr
You're better off doing a live backup with the PITR mechanism. That way its
not a trick (assuming you're running 8.0+). If you are archiving logs, do
select pg_start_backup();
(do rsync,tar,cp -r,whatever)
select pg_stop_backup();
Do an archive recovery with any saved logs, add 2 eggs, stir, and
SELECT
isc.table_name,
isc.ordinal_position::integer AS ordinal_position,
isc.column_name::character varying AS column_name,
isc.column_default::character varying AS column_default,
isc.data_type::character varying AS data_type,
isc.character_maximum_length::integer AS str_length,
C
Does anyone know if there is a way to reload the server config remotely
via a sql command?
I looked through the docs, but may have missed it.
Thanks,
Tony
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http
On Thursday 03 November 2005 07:28, Tony Caduto wrote:
> Hi,
> Does anyone know if it would be safe to use rsync to mirror a
> Postgresql setup to a backup server?
>
> I need to create a exact duplicate for a disaster recovery server,
> the disaster recovery server would not be in use until the
> p
Tony Caduto wrote:
> Hi,
> Does anyone know if it would be safe to use rsync to mirror a Postgresql
> setup to a backup server?
>
> I need to create a exact duplicate for a disaster recovery server, the
> disaster recovery server would not be in use until the production one
> went down for
> so
Re: the learning curve, I'd certainly include OpenRPT -
http://openrpt.sourceforge.net
It's similar to Crystal or Access' report designer, and full rich GUI for all
platforms (Win, Mac, Linux/BSD).
PDF documentation at
http://sourceforge.net/project/showfiles.php?group_id=132959&package_id=14
Hi,
Does anyone know if it would be safe to use rsync to mirror a Postgresql
setup to a backup server?
I need to create a exact duplicate for a disaster recovery server, the
disaster recovery server would not be in use until the production one
went down for
some reason.
It seems to me that
Please, enlighten us all and demostrate a case of SQL Injection that
gets around magic quotes. I know am I trying to think of one - and I
can't come up with one. Instead of just claiming it to be 'evil' why
don't you actualy back the statement up with some reasoned arguments?
I hate FUD.
Alex
I couldn't find any useful references in the docs or archives for emitting the
line number of a plpgsql function (in a RAISE statement). I'd like to use it for
debugging some complex functions.
Does anyone have any tips on where to look, or an example of this?
Cheers,
Bricklen
--
_
Original Message
From: Trent Shipley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 02, 2005 7:27 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] FOSS Reporting tools (was Oracle 10g
Express - any danger for Postgres?)
> On Wednesday 2005-11-02 13:11, Jim C. Nasby wrote:
> > On
> (There are many, many others that don't have a GUI designer
> available. There's at least one on pgfoundry that explicitly supports
> postgresql. They usually seem to take XML as an input template and
> render to HTML or PDF.)
Our reports tool does this as well and works with most major datab
Carlos Benkendorf schrieb:
> Hello,
>
> Currently our company has a lot of small stores distributed around the
> country and in the actual database configuration we have a central
> database and all the small stores accessing it remotely.
>
Hello Carlos,
There is a number of replication solut
Bonjour,
Nous sommes une équipe travaillant sur un projet open source de
logiciel de gestion. Dans ce projet, nous utilisons PostgreSQL et
nous souhaitons à présent faire des CD d'installation de notre
logiciel pour les clients ayant besoin de nos service.
Je voulais simplement m'assurer aup
HI,
I´m writing a technical document about PostGree implementations to
Database functionalities like ACID properties, XML database, INDEX
implementation etc... My interest is how PostGree work with the
functionalities in details of implementation. I have found a lot of
documentation about how to
Hi
When I call the same function
select * from usp_Commande_Dues_Retourner('{\'1734\'}', 'M',
'2005-02-02', '2005-11-02', 'EN' );
with the real line I get no result?
Why are you quoting the value inside the quotes?
Because I had a bug in my java application. I modify my code to
Hannes Dorbath wrote:
On 03.11.2005 04:12, Alex Turner wrote:
I would have to say that for security purposes - I would want magic
quotes _on_ rather than off for the whole reasons of SQL Injection
that we already talked about.
magic_quotes is evil and does if anything only prevent the simpl
My bad. It is doing what it is supposed to. Now I just have to figure
out why it is not giving me the results I am looking for.
Sim
"Sim Zacks" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> I tried the following code and was very suprised this didn't work the way I
> had expected
I tried the following code and was very suprised this didn't work the way I
had expected it to. Is my expectation correct or the way that it implements
it correct?
select * from a left join
( b join c on b.f1=c.f1 join d on d.f2=c.f2 join e on e.f3=d.f3) on
a.f4=b.f4
I would like it to have all t
On 03.11.2005 04:12, Alex Turner wrote:
I would have to say that for security purposes - I would want magic
quotes _on_ rather than off for the whole reasons of SQL Injection
that we already talked about.
magic_quotes is evil and does if anything only prevent the simplest
cases of SQL injecti
At 12:28 AM 11/2/2005 -0500, Jan Wieck wrote:
Using REPLACE INTO at one place and creating duplicates on purpose in
another seems to make zero sense to me. Until one can explain the reason
for that to me, I claim that a UNIQUE constraint on such key is a logical
consequence.
I believe it is
On Wed, Nov 02, 2005 at 10:19:53PM -0500, David Gagnon wrote:
> I cannot find what is the problem with my function below. The
> following line in the function :AND PD.PDPONUM = ANY (receivingIds)
> don't work. If I change this line byAND PD.PDPONUM = 1734 (Hardcode
> a given value) I
68 matches
Mail list logo
