Poul Jensen <[EMAIL PROTECTED]> writes:
> One thought: PostgreSQL adds to every table a system column tableoid
> containing a constant value. Is that value really stored 1,000 times for
> a 1,000-row table? Or...?
No, tableoid is sort of a virtual column ... it doesn't exist on disk.
When you qu
On Thu, Sep 08, 2005 at 19:58:55 -0800,
Poul Jensen <[EMAIL PROTECTED]> wrote:
>
> This novice must be missing a sneaky way to avoid massive redundancy and
> still maintain easy access. I've been suggested to look at inheritance
> and foreign keys. Foreign keys I don't see how to use, but I co
I have ~500,000 data files each containing ~1,000 records that I want to
put into a database for easy access.
Fictive example for illustration: File w. meteorological data from a
given station.
stat_id | yr | d_o_y | hr | mn | tmp | wind
-|--|---|||--|--
78
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> This has been discussed before, and rejected. Please see the archives.
For SELECT, both LIMIT and OFFSET are only well-defined in the presence
of an ORDER BY clause. (One could argue that we should reject them when
no ORDER BY, but given that the data
> >>>Is there any way to do SELECTs with different priorities?
> >>
> >>>The issue is that response time for
> >>>these 50 processes is very important unlike for report generation, and
> >>>time spent by these processes while report running is unacceptable for
> >>>my production environment (respon
On Thu, Sep 08, 2005 at 07:19:34PM -0600, Cristian Prieto wrote:
> Maybe the first 1000 rows based in the primary index
No, this is not a satisfactory answer, because 1. it's possible that
there's no primary key at all, or 2. said index may not get used for the
execution of the update. Maybe
Joshua,
I know that i can format it explicitly, but instead of using a SELECT * FROM
.. I have to name the columns which is not very convenient. Right now I have
created views for each table just to re-format the output of the one
timestamp field.
Not sure it solves your problem, but you can
Joshua,
I know that i can format it explicitly, but instead of using a SELECT *
FROM .. I have to name the columns which is not very convenient. Right
now I have created views for each table just to re-format the output of
the one timestamp field.
Mysql for example has a in addition to the T
Maybe the first 1000 rows based in the primary index
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Cristian Prieto" <[EMAIL PROTECTED]>
Cc:
Sent: Thursday, September 08, 2005 6:05 PM
Subject: Re: [GENERAL] Support for Limit in Update, Insert...
"Cristian Priet
"Cristian Prieto" <[EMAIL PROTECTED]> writes:
> Would be any future support for limit in update/insert queries? so you =
> could do something like
> update table1 set col1=3Dvalue1 limit 1000;
> would update just the first 1000 rows in the table.
That seems like a spectacularly bad idea, consideri
Thank you for your patience and such a complete
answer. I'm not on the pgbox right now but those
examples did help clarify how to reference the back
references, which was my problem.
I wasn't aware the 1st parenthesis must be counted as
part of the regex, I assumed it was a wrapper. Thanks
for he
Would be any future support for limit in
update/insert queries? so you could do something like
update table1 set col1=value1 limit
1000;
would update just the first 1000 rows in the table.
I've been playing a little with the SPI and I get the SPI already has the
support for limit the num
On Thu, Sep 08, 2005 at 01:52:35PM -0700, Matthew Peter wrote:
> It's not a complex regex as I have wrote one that does
> what I want, yet not at the database level. The docs
> didn't help clarify anything. I'm still not clear on
> how it determines where the back reference comes from
> in the prev
I understand.
there was a issue with the pg_dump compression level defaulting to 0
which may have had some effect, or it may have been some other non
related network issue. PGLA uses pg_dump.exe and pg_restorel.exe in the
exact same way PG Admin III does (via createprocesses API command) so
s
On Thu, Sep 08, 2005 at 01:52:35PM -0700, Matthew Peter wrote:
> What I basically want to do is have a slice function
> like Python, where I can slice out items from a \s, \.
> or \n\n separated list. Where I'll just change the
> delimiter for the query that it applies.
There is a function for s
Mr. Caduto,
I downloaded the version from the website recently, so I think it was the
newest version. My database backs up in about 10 seconds with pgAdmin
III. When I tried to back it up with PG Lightning Admin, I got a sql wait
cursor for a couple of minutes, at which point I closed the
I knew I should never have said Python. I know regular
expressions, just not how postgresql handles them. The
fact of the matter is I don't want to use Python, it
was an example of the functionality I'm interested in
accomplishing with pgsql. Plus, I would like to use
other regex's once I figure ou
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> snacktime wrote:
>> I'm pretty sure the answer to this is no, but just in case I've
>> missed something. Is there a way to configure the server so it only
>> logs for specific users?
> No, but you can configure PostgreSQL to insert the user name into
I just installed
Postgres 8.0 (Windows native) on a HP server with Windows 2000 Server
Service Pack 4. This database is accessed by several windows PCs with an
ODBC (ver. 7.03.02.00) through a 100Mbps intranet.
I have notice that when I run a program that requires about 2 MB of
inform
snacktime wrote:
I'm pretty sure the answer to this is no, but just in case I've missed
something. Is there a way to configure the server so it only logs for
specific users?
Look into "ALTER USER" - that lets you set (some) configuration options
on a per-user level. Don't know if the logging
So it seemed to hang or it did hang? Have you tried a newer version? I
routinely backup 100mb databases and it never hangs.
I think one of the earlier versions did not change the cursor during the
backup, is that what you mean by it appeared to hang? i.e. not being
able to tell if it was doing
On Thu, Sep 08, 2005 at 12:45:40PM -0700, Matthew Peter wrote:
> Ya, but I'd have to recompile to get python in.
Recompiling to add support for another procedural language is a
one-time operation and it's easy to do, so that's not a good argument.
> Plus, I don't want to use Python. I want to use
snacktime wrote:
> I'm pretty sure the answer to this is no, but just in case I've
> missed something. Is there a way to configure the server so it only
> logs for specific users?
No, but you can configure PostgreSQL to insert the user name into each
log message, and then you could configure your
Ya, but I'd have to recompile to get python in. Plus,
I don't want to use Python. I want to use and learn
more pgsql. Keep things clean and lean if possible...
I just got a postgres book yesterday for additional
reading which it only had 2 pages on regex's in the
index :(
--- Peter Fein <[EMAIL PR
I'm pretty sure the answer to this is no, but just in case I've missed
something. Is there a way to configure the server so it only logs
for specific users?
Chris
> "Cristian" == Cristian Prieto <[EMAIL PROTECTED]> writes:
Cristian> res = res_query(name, C_IN, T_MX, answer, sizeof(answer));
This incorrectly fails if an address has an "A" record but no "MX"
record. According to RFC 2821 Section 5:
The lookup first attempts to locate an MX record a
I like both EMS PostgreSQL Manager and pgAdmin III. Both have their
strengths and weaknesses, and I go back and forth between them depending on what
I'm doing. I had a problem with the trial version of PG Lightning Admin -
it seemed to "hang" when I backed up my database. No experience wi
Matthew Peter wrote:
> That doesn't seem to work with digits
>
> SELECT substring('12.00.00.34' FROM $$((\d+)\.\2)$$);
> or
> SELECT substring('12.00.00.34' FROM $$((\w+)\.\2)$$);
>
> but works with strings
>
> SELECT substring('abc.foo.foo.xyz' FROM
> $$((\w+)\.\2)$$);
>
> What I basically
Well, I guess this could be a hard-expensive way to do it but I've done this
little Stored Function, it doesn't use a regular expresion (you could pass
your email first to one to check it out I guess).
#include "postgres.h"
#include "fmgr.h"
#include
#include
#include
PG_FUNCTION_INFO_V1(di
That doesn't seem to work with digits
SELECT substring('12.00.00.34' FROM $$((\d+)\.\2)$$);
or
SELECT substring('12.00.00.34' FROM $$((\w+)\.\2)$$);
but works with strings
SELECT substring('abc.foo.foo.xyz' FROM
$$((\w+)\.\2)$$);
What I basically want to do is have a slice function
like Pyth
Karsten Hilbert wrote:
3. An integrated way of logging what ran when (rather than either
stuffing logging code into each cron job or rummaging thru
cron logs)
Cron can log to syslog.
Karsten
And your cron scripts could log to your database log tables if that is
what you were
Note that theKompany departed from the developers of the Rekall product,
which they now distribute separately. See http://www.totalrekall.co.uk/
and in particular
http://www.totalrekall.co.uk/modules.php?name=FAQ&myfaq=yes&id_cat=6&categories=Rekall+%3A+TheKompany
So if you are trying a theKom
Alex wrote:
Hi,
I am using the timestamp various tables but dont like to see the
microseconds.
Is there way to format the output of timestamp fields globally (in the
postgres.conf)?
Preferably i only would like to see the MMDD HH:MM:SS.
Or can a formatting be passed to a SELECT * hm
I have a license of DataArchitect and it was a waste of money. I've
used much better applications. I currently use ChiliSoft Database
Design Studio. It has direct PgSQL support.
Regards,
Gavin
On Sep 8, 2005, at 2:58 AM, Wolfgang Keller wrote:
Hello,
I'vesearchedforand
We offer Postgresql hosting with phpPgAdmin on Mac Dual G5 Xserve servers:
http://www.systame.com/html/macwebhosting/
--
Randall Perry
sysTame
Xserve Web Hosting/Co-location/Leasing
QuickTime Streaming
Mac Consulting/Sales
http://www.systame.com/
---(end of broad
On Thu, 8 Sep 2005, Joshua D. Drake wrote:
http://cwihosting.com/
Apache with Frontpage extensions (if you want them), PHP, PostgreSQL and
ssh access including crontab support. Having pl/pgsql added to template1
was done in no time. I only had to put a binary cvs executable there so
that I
suscribe
end
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Hi,
I am using the timestamp various tables but dont like to see the
microseconds.
Is there way to format the output of timestamp fields globally (in the
postgres.conf)?
Preferably i only would like to see the MMDD HH:MM:SS.
Or can a formatting be passed to a SELECT * hmmm probably n
http://cwihosting.com/
Apache with Frontpage extensions (if you want them), PHP, PostgreSQL and
ssh access including crontab support. Having pl/pgsql added to template1
was done in no time. I only had to put a binary cvs executable there so
that I can develop somewhere else and deploy the ch
On Thu, Sep 08, 2005 at 07:52:57AM -0700, Joshua D. Drake wrote:
> Wolfgang Keller wrote:
>
> >Hello,
> >
> >>Both have trials - try it ;-)
> >
> >That's what I've done, as I mentioned. But sometimes others know/see
> >things that I don't see/know, at least not within a restricted trial
> >per
Just a FYI, you should also look at PG Lightning Admin (PGLA) it
compares well with EMS and has some nifty features they don't have.
i.e. EMS cannot cancel a long running query, they don't receive raise
notices (last time I checked) and they can't view unicode data.
Check it out at:
http://www.
On Thu, Sep 08, 2005 at 04:35:51PM +0200, Michael Fuhr wrote:
> On Thu, Sep 08, 2005 at 03:39:50PM +0200, Bohdan Linda wrote:
> commit it now." You have to do some extra bookkeeping and you can't
> commit several prepared transactions atomically (as far as I know),
> but that's one way you could m
Wolfgang Keller wrote:
Hello,
Both have trials - try it ;-)
That's what I've done, as I mentioned. But sometimes others know/see
things that I don't see/know, at least not within a restricted trial
period.
It seems to me that EMS PostgreSQL Manager is more actively developed
On 8/4/2005 10:28 PM, Richard Sydney-Smith wrote:
I have asked my internet host to include postgresql as part of their
service but it seems that there are issues in getting it to work with
"cpanel" which is their support service for their clients. Is their a
reason why Postgresql is harder to h
Zlatko Matić wrote:
If I use PgAdmin it works, but if I copy the command to .bat file
authentication fails although I enter correct password.
The .bat script is the following:
and the error is:
pg_restore: [archiver (db)] connection to database "MYDATABASE" failed:
FATAL: password authentica
I may have missed it in the docs, but were certain timestamp abbreviations
phased out between 8.0.3 and 8.1 beta1?
eg.
(8.0.3)
#SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'PST';
timezone
-
16/02/2001 20:38:40 PST
(8.1beta1)
#SELECT TIMESTAMP '2001-02-16
On Thu, Sep 08, 2005 at 03:39:50PM +0200, Bohdan Linda wrote:
> On Thu, Sep 08, 2005 at 02:53:47PM +0200, Michael Fuhr wrote:
> > One way would be to use contrib/dblink to open another connection
> > to the database so the status messages could be inserted in a
> > separate transaction.
>
> This c
Hello,
> Both have trials - try it ;-)
That's what I've done, as I mentioned. But sometimes others know/see
things that I don't see/know, at least not within a restricted trial
period.
Sincerely,
Wolfgang Keller
--
P.S.: My From-address is correct
---(end of bro
Matt schrieb:
Hi all,
I've recently been using some older version of postgres on linux
systems, and one of the most annoying problems i've come across is to
do with sequence values not being updated when a database backup is
restored. This is because the insert and copy routines used to restore
Hello.
I have a strange problem when trying to use pg_restore to restore data from
a backup, on WIN XP, PostgreSQL 8.0.3.
If I use PgAdmin it works, but if I copy the command to .bat file
authentication fails although I enter correct password.
The .bat script is the following:
cd D:\Program
[Please copy the mailing list on replies so others can participate
in and learn from the discussion.]
On Wed, Sep 07, 2005 at 10:40:22PM -0700, Matthew Peter wrote:
> I did read the docs ;) I always do. The question I
> really wanted answered is how to reference the back
> references in my regula
On Thu, Sep 08, 2005 at 02:53:47PM +0200, Michael Fuhr wrote:
> One way would be to use contrib/dblink to open another connection
> to the database so the status messages could be inserted in a
> separate transaction.
This could do the trick for logging, even writting of a package that would
do al
Hi all,
I've recently been using some older version of postgres on linux
systems, and one of the most annoying problems i've come across is to
do with sequence values not being updated when a database backup is
restored. This is because the insert and copy routines used to restore
the data into t
Tanks guys,
That was exactly what I was looking for.
B.
--- Begin Message ---
On 8/9/05 11:08 am, "Bohdan Linda" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I started thinking of some security access management. Basically imagine
> this scenario according users:
>
> 1) Writer does only inserts to
Alvaro Herrera wrote:
On Thu, Sep 08, 2005 at 04:22:07AM +0200, [EMAIL PROTECTED] wrote:
Hi,
we run 'out of space' in one of our columns which is smallint and we
need to make it integer.
I did some research and found out that the only way is to create a new
column with integer data type, th
On Thu, Sep 08, 2005 at 01:23:56PM +0200, Bohdan Linda wrote:
> plpgsq code does time intensive data manipulation + database vacuuming.
> This data manipulation is splitted logically into several steps. After
> each step I would like to give a message to the status table, what the
> procedure is pe
Hello!
> have. Has anyone used one, better both of these? What do you think
> about them?
Both have trials - try it ;-)
Im using EMS, like it, but for all features you have to use windows.
Lg,
AXEL.
--
Gentoo? Debian? RedHat? SuSE? *BSD? Stop the distri-war, make little user!
> 3. An integrated way of logging what ran when (rather than either
> stuffing logging code into each cron job or rummaging thru
> cron logs)
Cron can log to syslog.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
--
On 08/09/05, Roman Neuhauser <[EMAIL PROTECTED]> wrote:
> # [EMAIL PROTECTED] / 2005-09-08 11:31:25 +0300:
> > We have a daemon programme that acts as a pgsql client. It writes in a
> > DB the status of its own clients. And we have a different daemon that
> > needs to read that status information a
# [EMAIL PROTECTED] / 2005-09-08 11:31:25 +0300:
> We have a daemon programme that acts as a pgsql client. It writes in a
> DB the status of its own clients. And we have a different daemon that
> needs to read that status information and decide upon it. The problem
> is that the first daemon is a l
Hello,
I have read that 7.x version had a model "all or nothing" in transactions.
Thus I have upgraded to version 8 and would like to do the following:
plpgsq code does time intensive data manipulation + database vacuuming.
This data manipulation is splitted logically into several steps. After
Thank you Doug, Oleg for your responses.
I hoped there would be much more answers,
but... thanks anyway
Friendly,
Andrey
> -Original Message-
> From: Oleg Bartunov [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 06, 2005 11:54 PM
> To: Doug Bloebaum
> Cc: Andrey Fomichev; pgsql-gener
On 8/9/05 11:08 am, "Bohdan Linda" <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I started thinking of some security access management. Basically imagine
> this scenario according users:
>
> 1) Writer does only inserts to black hole.
>
> 2) Reader does only reports on inserted data, cannot modify or
On Thu, Sep 08, 2005 at 12:08:25PM +0200, Bohdan Linda wrote:
> The first 2 types are easily solvable, but with the third type I have
> problem. I have created task in plpgsql, I granted permissions to an user
> to execute the task, but revoked on him all rights to tables. Logically
> task failed.
Hello,
I'vesearchedforandtriednearlyeverydatabase
administration/design tool available and it seems my choice has
narrowed down to these two. Now a second opinion would be nice to
have. Has anyone used one, better both of these? What do you think
about t
Hi,
I started thinking of some security access management. Basically imagine
this scenario according users:
1) Writer does only inserts to black hole.
2) Reader does only reports on inserted data, cannot modify or add
anything
3) Maintainer can run a task on the data, but cannot read or add
Leonid Safronie wrote:
Hi, ppl
Is there any way to do SELECTs with different priorities?
The issue is that response time for
these 50 processes is very important unlike for report generation, and
time spent by these processes while report running is unacceptable for
my production environment
Hi list!
We have a daemon programme that acts as a pgsql client. It writes in a
DB the status of its own clients. And we have a different daemon that
needs to read that status information and decide upon it. The problem
is that the first daemon is a little fragile and from time to time it
crashes.
68 matches
Mail list logo
