am Thu, dem 15.02.2007, um 8:11:06 +0900 mailte Paul Lambert folgendes:
> Has anyone had any success installing on weendoze vista?
>
> Any install I try gets as far as the service user details, if I ask it
> to create a user it fails, if I specify an existing user account it
> complains about
am Wed, dem 14.02.2007, um 22:37:36 +0200 mailte Mikko Partio folgendes:
> > Why do you want to reinvent the wheel?
> >
> > http://pgfoundry.org/projects/tablelog/
> >
> >
> > But it use a separate log-table per table.
> >
> >
> > Andreas
>
> My original idea was to log changes from different tab
John McCawley <[EMAIL PROTECTED]> writes:
> My development machine is PostgreSQL 8.1.5, and my production machine is
> PostgreSQL 8.2. Until now I haven't run into any differences in
> behavior. I have a query with a relatively wacky join, and while it was
> working on my development machine,
Paul
Thanks for your time.
the installer log say:
fixing permissions on existing directory C:/Archivos
de programa/PostgreSQL/8.2/data ... ok
creating subdirectories ... initdb: could not create
directory "C:/Archivos de programa": File exists
initdb: removing contents of data directory
"C:/Arc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 19:34, Paul Lambert wrote:
> Ron Johnson wrote:
> On 02/14/07 19:11, carter ck wrote:
Hi all,
I am looking for ways to create an archive of records older than 3
months in one of my table, and store these extracted record
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 19:11, carter ck wrote:
Hi all,
I am looking for ways to create an archive of records older than 3
months in one of my table, and store these extracted records into a
local database. Does Postgres have any command to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 19:11, carter ck wrote:
> Hi all,
>
> I am looking for ways to create an archive of records older than 3
> months in one of my table, and store these extracted records into a
> local database. Does Postgres have any command to do this?
A
Question about pg_dump and Postgres 8.1.
Assuming you've let you buffers settle, and then you dump your
database. Will this clobber your shared buffers like a seq scan against
a large table will?
--
Brad Nicholson 416-673-4106[EMAIL PROTECTED]
Database Administrator, Afilias Canada Corp
Hi all,
I am looking for ways to create an archive of records older than 3 months in
one of my table, and store these extracted records into a local database.
Does Postgres have any command to do this?
Thanks.
_
Find just what y
Paul Lambert wrote:
Walter Vaughan wrote:
This may not help, but I noticed using pgAdminIII, you can create a
procedure or a function, but they seem to have the same creation
interface and use the same icon.
A procedure is a function that returns null.
That should have said void of cour
Has anyone had any success installing on weendoze vista?
Any install I try gets as far as the service user details, if I ask it
to create a user it fails, if I specify an existing user account it
complains about the user not having enough access - even when said user
account is put into the ad
Walter Vaughan wrote:
This may not help, but I noticed using pgAdminIII, you can create a
procedure or a function, but they seem to have the same creation
interface and use the same icon.
A procedure is a function that returns null.
You'll note if you create a procedure under pgAdminIII,
On Tue, 2007-02-13 at 05:46 -0800, Ray Bannon wrote:
> Select ID, plan_name from table/view
> Where plan_name = 'A'
> And rownum = 1
> UNION
...
>
> Ad infinitum for about 100 iterations.
>
> Any way to write this more efficiently?
I assume that "table/view" in your OP really refers to diffe
On Wed, Feb 14, 2007 at 05:18:10PM -0500, Walter Vaughan wrote:
> This may not help, but I noticed using pgAdminIII, you can create a
> procedure or a function, but they seem to have the same creation interface
> and use the same icon.
Way back when I learned that procedures are merely functions
"Jeanna Geier" <[EMAIL PROTECTED]> writes:
> I'm attempting to do an INNER JOIN on one of the views in my database,
> however, when I import the schema file that has it in there, it removes the
> "INNER" from the statement.
INNER is a noise word; if it's re-listing the statement without that,
ther
Bruce,
> Having contributors bought out was always one of our three risks, the
> other two being patent and trademark attacks. Not sure what we can
> really do about them.
Actually, the potential for trademark attacks is minimal to nonexistant
according to the attorney's report. So I'm not wor
Hello List-
I'm attempting to do an INNER JOIN on one of the views in my database,
however, when I import the schema file that has it in there, it removes the
"INNER" from the statement. I've also tried to add it by modifying it via
the 'Properites' -> 'Definition' tab on the VIEW. But, when I pu
Vladimir Zelinski wrote:
I'm struggling to create a stored procedure. I
searched on Internet for several hours trying to find
a simple example, but didn't find anything. I saw
dozens of questions how to create a procedure without
any responses. I searched on postgreSql site and found
a topic "St
John D. Burger wrote:
With a slip of the keyboard, I just dropped a database I'd like to
have
back. I don't have PITR or anything turned on - if nothing else has
And no backups?
been done to the cluster since then, is there any way to recover
anything at all?
I have a backup as of last n
Peter Eisentraut wrote:
The proper fix for this problem is to insert explicit SET search_path
commands into each affected function to produce a known safe schema
search path. Note that using the default search path, which includes a
reference to the "$user" schema, is not safe when unqualified
> Why do you want to reinvent the wheel?
>
> http://pgfoundry.org/projects/tablelog/
>
>
> But it use a separate log-table per table.
>
>
> Andreas
My original idea was to log changes from different tables to one audit
table, and I think tablelog uses separate audit tables for each monitored
table
Hello everyone,
I'm a brand new person to postgreSql, but not for
databases. I came from Oracle and Sybase areas.
I'm struggling to create a stored procedure. I
searched on Internet for several hours trying to find
a simple example, but didn't find anything. I saw
dozens of questions how to creat
marcelo Cortez wrote:
Magnus
I have NTFS only , i don't have FAT partitions at
all.
But the problem is not resolved.
The install fail at create cluster for me.
I set all permisions for user postgres.
Binary manual installation .. make sense i try .
It has any manual/instructions/links
Here is the link to Elein's presentation:
http://www.varlena.com/GeneralBits/Tidbits/tt.pdf
What [about] postgresql "time travel"? I have never used it, and it looks a
little bit unmaintained, but it might be perfect with some tweaking:
---(end of broadcast)--
- Original Message -
From: "Ron Johnson" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, February 14, 2007 3:46 PM
Subject: Re: [GENERAL] backup database by cloning itself
It seems to me that if you really want a historical record of what
certain tables looked like in the past, it would b
Vladimir Zelinski wrote:
Hi, I just now subscribed the mailing list, but I
can't understand what I should do next.
I need:
1) search forums for specific keywords
http://archives.postgresql.org/
2) be able to post my question.
You just did...
Sending mail to pgsql-@postgresql.org is all you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 14:59, John D. Burger wrote:
> With a slip of the keyboard, I just dropped a database I'd like to have
> back. I don't have PITR or anything turned on - if nothing else has
And no backups?
> been done to the cluster since then, is there
Vladimir Zelinski wrote:
1) search forums for specific keywords
You can do this at http://archives.postgresql.org/.
2) be able to post my question.
You've just done it! :) Send an email to pgsql-general@postgresql.org
and it is distributed to everyone subscribed to the list.
Ray.
Hi, I just now subscribed the mailing list, but I
can't understand what I should do next.
I need:
1) search forums for specific keywords
2) be able to post my question.
How can I do that? I read help but it didn't have any
information for helping me.
Thank you,
Vladimir
>> Maybe his real goal "all the backups readily available to be read by
>> my program (opening the backup read only)" is to have a historical
>> record of what certain records looked like in the past.
What postgresql "time travel"? I have never used it, and it looks a
little bit unmaintained, b
With a slip of the keyboard, I just dropped a database I'd like to
have back. I don't have PITR or anything turned on - if nothing else
has been done to the cluster since then, is there any way to recover
anything at all?
Thanks.
- John Burger
MITRE
---(end of b
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 13:40, Ted Byers wrote:
>> Maybe his real goal "all the backups readily available to be read by
>> my program (opening the backup read only)" is to have a historical
>> record of what certain records looked like in the past.
>>
>> There are
Mason Hale wrote:
> So, I'm fishing to see of there are alternatives to taking our
> production database down for 6+ hours do this upgrade. Can slony or
> wal files be of help here?
Slony can, but WAL files will not work between different versions.
> Also -- due to hardware limitations, we need t
No, we have no such option.
---
Wilton Wonrath wrote:
> Hello,
Does anyone knows if it?s possible to protect from users see a PL/PGSQL
source ?
I have a PL/PGSQL function and I want to make it invisible to users.
J
Mason Hale wrote:
From what I've read about postgres 8.2, upgrading from any previous
version requires a full database dump and restore.
I am working with largish database (~70GB) that I would like to
upgrade to 8.2.
A full database dump currently takes ~3 hrs, I expect a restore
require a si
Maybe his real goal "all the backups readily available to be read by
my program (opening the backup read only)" is to have a historical
record of what certain records looked like in the past.
There are other ways of doing that, though.
If your speculation is right, perhaps the OP ought to expl
From what I've read about postgres 8.2, upgrading from any previous
version requires a full database dump and restore.
I am working with largish database (~70GB) that I would like to upgrade to 8.2.
A full database dump currently takes ~3 hrs, I expect a restore
require a similar timeframe if no
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 12:41, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>> On Tue, 2007-02-13 at 07:54, filippo wrote:
>>> my database is not very big so I want to adopt this backup strategy:
>>> I want to clone my database every 1 hour to anot
Hello,
Does anyone knows if it´s possible to protect from users see a PL/PGSQL
source ?
I have a PL/PGSQL function and I want to make it invisible to users.
Just a example, in Oracle there is a option like this:
http://www.dbasupport.com/oracle/ora9i/wrap_utility.shtml
Regards,
Wil
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Tue, 2007-02-13 at 07:54, filippo wrote:
>> my database is not very big so I want to adopt this backup strategy:
>> I want to clone my database every 1 hour to another
>> database 'currenttime_mydatabase' in order to have 24 backup a day,
>> overwriti
On Tue, 2007-02-13 at 07:54, filippo wrote:
> Hello,
>
> my database is not very big so I want to adopt this backup strategy:
>
> I want to clone my database every 1 hour to another
> database 'currenttime_mydatabase' in order to have 24 backup a day,
> overwriting the yesterday backups by today
On Wed, 2007-02-14 at 10:55 -0500, Tom Lane wrote:
> Rajarshi Guha <[EMAIL PROTECTED]> writes:
> > Clearly a big improvement in performance.
>
> Huh? It looks like exactly the same plan as before. Any improvement
> you're seeing must be coming from cache effects.
Well the new run was done nearl
Magnus
I have NTFS only , i don't have FAT partitions at
all.
But the problem is not resolved.
The install fail at create cluster for me.
I set all permisions for user postgres.
Binary manual installation .. make sense i try .
It has any manual/instructions/links for that?
Best regards
Am Mittwoch, 14. Februar 2007 16:31 schrieb Merlin Moncure:
> Could you clarify what functions are going to get an explicit 'set
> search_path'? Will this change the behavior of any userland
> functions?
Nothing is going to "get" anything. You have to fix all affected functions
yourself.
--
P
Martijn van Oosterhout writes:
> There are some more comprehensive writeups around, but hopefully this
> gives you an idea.
You can find the official(tm) explanation at
http://www.postgresql.org/docs/8.2/static/executor.html
--- in fact, you might want to read all of chapter 42.
Rajarshi Guha <[EMAIL PROTECTED]> writes:
> Clearly a big improvement in performance.
Huh? It looks like exactly the same plan as before. Any improvement
you're seeing must be coming from cache effects.
> It looks like theres a big mismatch on the expected and observed costs and
> times.
Well
I did check with customer support (they are actual developers of the
system not middle men) and they said there aren't any triggers in the db
structure so it's safe for me to include triggers. So, that helps me
feel reassured because you had a good point. So more than likely, it was
my error and I
On 2/13/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
The proper fix for this problem is to insert explicit SET search_path
commands into each affected function to produce a known safe schema
search path. Note that using the default search path, which includes a
reference to the "$user" schema
> As suggested earlier, it is probably cleaner to define separate triggers
> on insert and on update. That is possible, but they can't have the same
> names.
> You probably want to name them accordingly too, or you'll get naming
> conflicts.
>
> I suggest:
> DROP TRIGGER archive_articles ON news_co
am Wed, dem 14.02.2007, um 16:38:27 +0200 mailte [EMAIL PROTECTED] folgendes:
> Hi,
>
> I'm trying to build an audit system for several tables. My idea was to use
> triggers and plpgsql to record changes made to "important tables" to a
> special audit table. My problem is that I don't want to cre
Hi,
I'm trying to build an audit system for several tables. My idea was to use
triggers and plpgsql to record changes made to "important tables" to a
special audit table. My problem is that I don't want to create a separate
audit log table for each table that is being monitored. What I would like
On Wed, Feb 14, 2007 at 08:22:42AM -0500, Rajarshi Guha wrote:
> (One question not directly related to the problem: when looking at the
> output of explain analyze, I know that one is supposed to start at the
> bottom and move up. Does that that the index scan on pubchem_compound is
> being perform
The installer is not supported in a fat environment. you need to install the
binaries manually for that.
/Magnus
--- Original message ---
From: RPK <[EMAIL PROTECTED]>
Sent: 2-14-'07, 5:14
>
> Paul,
>
> I installed on a Fat32 partition and gave the data directory path to an NTFS
> part
On Tue, 2007-02-13 at 22:04 -0500, Tom Lane wrote:
> "Adam Rich" <[EMAIL PROTECTED]> writes:
> > This line:
> > Index Scan using plp_total_idx on dockscore_plp
> > (cost=0.00..16733229.92 rows=4669988 width=80)
> > (actual time=98.323..322537.605 rows=25197 loops=1)
> > Means the planner did wha
Paul,
I installed on a Fat32 partition and gave the data directory path to an NTFS
partition. I have not set any file permissions. Installing as a default
"postgres" user.
Paul Lambert-2 wrote:
>
> marcelo Cortez wrote:
>> hi there
>>
>> same things occurs to me.
>> Any body install win32 ve
On Tue, 2007-02-13 at 21:44 -0500, Tom Lane wrote:
> Rajarshi Guha <[EMAIL PROTECTED]> writes:
> > However the clause:
> > dock.target = '1YC1' and
> > dock.dockid = dockscore_plp.id
> > reduces the number of rows from 4.6M to 96K.
>
> The planner seems to be estimating about te
I will be out of the office starting 09/02/2007 and will not return until
19/02/2007.
I will respond to your message when I return.
If you enquiry is regarding Norgren-i please contact Helen Jayne Walker.
Regards,
---(end of broadcast)---
TIP 2:
Pankaj wrote:
Need help if there is any script source or links to provide help how to you
PostgreSQL with ASP
I just use ODBC and ADO - set up a DSN, and then it's as simple as:
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "dsn=your_dsn;uid=your_user;pwd=your_pwd;"
set
Am Mittwoch, 14. Februar 2007 11:53 schrieb Alban Hertroys:
> I think you're looking for this:
>
> select to_date('01 2004', 'WW ');
> to_date
>
> 2004-01-01
> (1 row)
Or possibly to_date('01 2004', 'IW IYYY'), depending on taste.
--
Peter Eisentraut
http://developer.postgres
am Wed, dem 14.02.2007, um 11:53:09 +0100 mailte Alban Hertroys folgendes:
> vanessa wrote:
> > hi guys,
> > i was just wondering if it was at all possible to turn a year and a given
> > week number into a real date just using postgresql commands?
> >
> >
> > e.g. if i have year = 2004 and week
vanessa wrote:
> hi guys,
> i was just wondering if it was at all possible to turn a year and a given
> week number into a real date just using postgresql commands?
>
>
> e.g. if i have year = 2004 and week = 1,
> can i turn that into say 2004-01-01 (so that the specified
> date is the on
Laura McCord wrote:
> To make a long story short, I am archiving data from an original table
> to a table I created. This is a third party web application that I am
> doing this with, so I can't revise the structure/code of this
> application. With this said, if the original table goes through an
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 03:33, A. Kretschmer wrote:
> am Wed, dem 14.02.2007, um 3:10:17 -0600 mailte Ron Johnson folgendes:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 02/14/07 02:52, A. Kretschmer wrote:
>>> am Tue, dem 13.02.2007, um 13:56:1
am Wed, dem 14.02.2007, um 3:10:17 -0600 mailte Ron Johnson folgendes:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 02/14/07 02:52, A. Kretschmer wrote:
> > am Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes:
> [snip]
> >
> > test=*# select get_week(2007,2);
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 02:52, A. Kretschmer wrote:
> am Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes:
[snip]
>
> test=*# select get_week(2007,2);
> get_week
> -
> 08-01-2007 - 14-01-2007
> (1 row)
Is that wee
am Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes:
>
> hi guys,
> i was just wondering if it was at all possible to turn a year and a given
> week number into a real date just using postgresql commands?
>
>
> e.g. if i have year = 2004 and week = 1,
> can i turn that into s
Mike Harding wrote:
mvh=> set time zone 'UTC';
SET
mvh=> select now();
now
---
2007-02-13 03:37:35.660652+00
(1 row)
"+00" says your database thinks you are in Greenwich.
mvh=> select timestamp with time zone '2007-01-01' at time zone
'America/Los_Angeles';
timezon
It has come to the attention of the core team of the PostgreSQL project
that insecure programming practice is widespread in SECURITY DEFINER
functions. Many of these functions are exploitable in that they allow
users that have the privilege to execute such a function to execute
arbitrary code
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 02:13, A. Kretschmer wrote:
> am Wed, dem 14.02.2007, um 2:01:09 -0600 mailte Ron Johnson folgendes:
i was just wondering if it was at all possible to turn a year and a given
week number into a real date just using postgresql co
Ron Johnson <[EMAIL PROTECTED]> writes:
> I think he's asking why:
> select timestamp with time zone '2007-01-01'
> at time zone 'America/Los_Angeles';
> returns a different value than
> select timestamp '2007-01-01'
> at time zone 'America/Los_Angeles';
Those are transform
It has come to the attention of the core team of the PostgreSQL project
that insecure programming practice is widespread in SECURITY DEFINER
functions. Many of these functions are exploitable in that they allow
users that have the privilege to execute such a function to execute
arbitrary code
am Wed, dem 14.02.2007, um 2:01:09 -0600 mailte Ron Johnson folgendes:
> >> i was just wondering if it was at all possible to turn a year and a given
> >> week number into a real date just using postgresql commands?
> >>
> >>
> >> e.g. if i have year = 2004 and week = 1,
> >> can i turn that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 01:42, Tom Lane wrote:
> Mike Harding <[EMAIL PROTECTED]> writes:
>> Where does that extra 8 hours come from?
>
> Ellay is 8 hours west of UTC (at least on 1-Jan, at least till our
> congresscritters see fit to monkey with the DST laws aga
Ray Bannon <[EMAIL PROTECTED]> writes:
> Any way to write this more efficiently?
UNION -> UNION ALL, perhaps? Do you really need UNION's duplicate-row-
elimination behavior?
regards, tom lane
---(end of broadcast)---
TIP 3:
I will be out of the office starting 02/09/2007 and will not return until
02/21/2007.
I am travelling and will be back in the office only after the Lunar New
Year. During this time, I will check my email and voicemail from time to
time; however, response may be delayed.
You can reach me on m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 01:36, A. Kretschmer wrote:
> am Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes:
>> hi guys,
>> i was just wondering if it was at all possible to turn a year and a given
>> week number into a real date just using postgresq
76 matches
Mail list logo