Am Montag, 25. September 2006 07:09 schrieb A. Kretschmer:
> am Mon, dem 25.09.2006, um 2:56:47 +0200 mailte Markus Grabner folgendes:
> > Hi!
> >
> > As far as I understand, one can simulate updateable views in
> > PostgreSQL by providing appropriate query rewrite rules. Is there any
> >
On 9/21/06, stevethames <[EMAIL PROTECTED]> wrote:
Ok, thanks, Jeff.
This is not a critical problem. Just annoying. I'll wait for 8.2.
BTW, while I can see the reason for adding the IF EXISTS clause to the
language for checking the existence of objects, wouldn't it be easier to
simply provide
I too have been bothered about this behaviour in the past.On 9/25/06, Michael Fuhr <[EMAIL PROTECTED]> wrote:
Transactions are all-or-nothing: all statements must succeed or theCorrect.
> All other databases I used up to now just ignore the statement violating the
> constraint, but leave the trans
Jeff Davis wrote:
8.2 will fix this. You can send the WALs periodically even if they're
not full. In general, PITR will be substantially improved in 8.2 (thanks
Simon!).
This sounds very nice, and this will make PG an even more reliable tool.
The beta should be out soon enough. Download it (
On Mon, Sep 25, 2006 at 03:16:07PM +0530, Gurjeet Singh wrote:
> >All other databases I used up to now just ignore the statement violating
> >the
> >> constraint, but leave the transaction intact.
> >
> >Which databases behave that way? Does COMMIT succeed even if some
> >statements failed?
>
>
Gurjeet Singh wrote:
> All other databases I used up to now just ignore the statement
violating the
> constraint, but leave the transaction intact.
Which databases behave that way? Does COMMIT succeed even if some
statements failed?
Oracle, for one, behaves that way... Y
Jeff Davis wrote:
Standby mode means that the database is kept almost up to date with the
master, but is not "up". When the master goes down, you can bring the
standby machine up. Until then, you unfortunately can't even do read
queries on that machine.
Do you know if this will change in the
What kind of errors? Just saying "i got some errors" isn't very helpfull for
us to be able to help you properly ;)
So, what exact error messages you get when trying to restore the database?
-- Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf O
On 9/25/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
In this casePostgreSQL does the right thing; something went wrong, queries after theerror may very well depend on that data - you can't rely on the currentstate. And it's what the SQL specs say too, of course...
[1] I'm not trying to imply that
On Mon, Sep 25, 2006 at 05:40:56PM +0530, Gurjeet Singh wrote:
> >In this case
> >PostgreSQL does the right thing; something went wrong, queries after the
> >error may very well depend on that data - you can't rely on the current
> >state. And it's what the SQL specs say too, of course...
>
> In a
In response to "Bobby Gontarski" <[EMAIL PROTECTED]>:
> Basically I need to copy db1 to db2 which I create manually. How do I
> do that, I tried pg_dump pg_restore but I get some errors with foreign
> key restraint...
You can use create database with db1 as the template. See the docs for
details
On Sun, 2006-09-24 at 12:03 +0200, Ralf Wiebicke wrote:
> Hi all!
>
> I just realized the following behaviour in postgresql: when I violate any
> constraint (unique constraint in my case) then the transaction is not usable
> anymore. Any other sql command returns a "in failed sql transaction" er
I would tend to agree with Tom.
A table is by definition an unordered set of records. Forcing keys to
have meaning of this type implies that there is a relationship between
each record in the set. That's information you should be storing as
part of the record. If order is important, design the
Hello,
I have a table with TIMESTAMP WITH TIMEZONE column. I would like to
query for a timestamp using a different timezone.
For example if a column contains '2006-02-11 00:30:00-05'
select * from table where column='2006-02-10 19:30:00+00' would return
the column containing '2006-02-11 00:30:00
Use the AT TIME ZONE construct:
http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#F
UNCTIONS-DATETIME-ZONECONVERT
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Harry Hehl
Sent: Monday, Septem
Actually, I am not trying to "force keys" nor, I don't beleive, am I trying
to force an hierarchal structure within the database.
The numbers I want to assign to devices are nothing more than merely another
attribute of the device - perhaps akin to a number in a street address. The
problem, fr
On Mon, 2006-09-25 at 00:19 +0200, Gevik Babakhani wrote:
> On Sun, 2006-09-24 at 14:49 -0700, Bob Pawley wrote:
> > It's the behavior I expect - but the gaps aren't acceptable.
> >
> > Bob
>
> Then using the SERIAL or SEQUENCE won't do you any good.
>
> A possible solution for this would be to
On Mon, 2006-09-25 at 13:48 +0200, Bo Lorentsen wrote:
> Jeff Davis wrote:
> > Standby mode means that the database is kept almost up to date with the
> > master, but is not "up". When the master goes down, you can bring the
> > standby machine up. Until then, you unfortunately can't even do read
>
On Mon, Sep 25, 2006 at 05:40:56PM +0530, Gurjeet Singh wrote:
>I sure like PG's following of the standards, but usability should not be
> lost sight of.
One man's meal is another man's poison. For me, with a small number
of exceptions, the standards conformance _is_ what makes PostgreSQL
so
I would like to use autonomous transactions for a large batch process and I want this all encapsulated within stored procedures. I want to commit after say every 15,000 records. The only way I have found to do this is to use the perl DBI in my stored procedure to establish a new connection to the
As for persistent connection with PHP, start from here:
http://php.net/pg_pconnect.
Also, I recommend to ensure that you have proper set of indexes on
your tables and your system doesn't use badly written queries (such as
join of several dozens of tables :-) ). There is an excellent tool
that can
How could I translate this into sql?
select result from results
where date_entered between (last september and the one before that)
Its the part in brackets that has me guessing. I am still experimenting
but any help will be gratefully recieved.
Kind Regards
Garry
---(en
Nikolay Samokhvalov wrote:
As for persistent connection with PHP, start from here:
http://php.net/pg_pconnect.
Uhmmm no.
Start here: http://pgpool.projects.postgresql.org/
pg_pconnect tends to have a host of issues.
Joshua D. Drake
Also, I recommend to ensure that you have proper set of
Hi!
Thanks for all the help.
I finally used savepoints to get what I want.
However I don't like this very much. I tried a few other databases (hsqldb,
mysql/innodb and oracle), and none of them made the transaction unusable
after violating the constraint.
Best regards,
Ralf.
---
Thanks, that does it.
select * from table where column = '2006-02-10 19:30:00' AT TIME ZONE
'utc';
I also have a TIME WITH TIMEZONE column that I have to do the same thing
with but AT TIME ZONE can't be used directly. I tried several approaches
but I either get incorrect results or syntax errors.
On Mon, 2006-09-25 at 16:20, Ralf Wiebicke wrote:
> Hi!
>
> Thanks for all the help.
>
> I finally used savepoints to get what I want.
>
> However I don't like this very much. I tried a few other databases (hsqldb,
> mysql/innodb and oracle), and none of them made the transaction unusable
> af
Adrian Klaver <[EMAIL PROTECTED]> writes:
> On Sunday 24 September 2006 09:17 am, Tom Lane wrote:
>> Jon Lapham <[EMAIL PROTECTED]> writes:
>>> FATAL: pre-existing shared memory block (key 5432001, ID 65536) is
>>> still in use
>>
>> This is extremely odd, because a shared memory block could not
Ralf Wiebicke <[EMAIL PROTECTED]> writes:
> I finally used savepoints to get what I want.
> However I don't like this very much.
Have you experimented with psql's ON_ERROR_ROLLBACK setting?
regards, tom lane
---(end of broadcast)---
Hm? Works for me:
postgres=# select time with time zone '00:30:00-05' at time zone 'utc';
timezone
-
05:30:00+00
(1 row)
What are you trying to do with the query?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Does anybody have a stored proc they'd like to share that computes the
longest common substring for a set of strings? Wikipedia defines the
problem nicely:
http://en.wikipedia.org/wiki/Longest_common_substring_problem
Basically, given "abcba" and "abdba", the algorithm should return "ab" and
On Sep 26, 2006, at 5:59 , garry saddington wrote:
How could I translate this into sql?
select result from results
where date_entered between (last september and the one before that)
Its the part in brackets that has me guessing. I am still
experimenting
but any help will be gratefully rec
I noticed the following in some of our code today:
select ... ... for update of a, b;
Inasmuch as the cardinal rule for avoiding deadlocks is to acquire
locks in a consistent order, should such a construction be avoided
in favor of two separate "select ... for update" statements so that
the o
Clarence Gardner <[EMAIL PROTECTED]> writes:
> I noticed the following in some of our code today:
> select ... ... for update of a, b;
> Inasmuch as the cardinal rule for avoiding deadlocks is to acquire
> locks in a consistent order, should such a construction be avoided
> in favor of two se
On Monday 25 September 2006 02:48 pm, Tom Lane wrote:
> Adrian Klaver <[EMAIL PROTECTED]> writes:
> > On Sunday 24 September 2006 09:17 am, Tom Lane wrote:
> >> Jon Lapham <[EMAIL PROTECTED]> writes:
> >>> FATAL: pre-existing shared memory block (key 5432001, ID 65536) is
> >>> still in use
> >>
>
Adrian Klaver <[EMAIL PROTECTED]> writes:
> On Monday 25 September 2006 02:48 pm, Tom Lane wrote:
>> I spent quite some time today trying to duplicate this failure (by
>> pulling the plug on an up-to-date Fedora Core 5 machine). No luck.
> Is there something I could do to help capture useful info
I wrote:
> Also, if it is repeatable, "ipcs -m" output will be useful context.
I forgot to mention: on Linux it's important to run ipcs as root
(eg "sudo ipcs -m") else it will lie to you. An incomplete listing
is worse than useless.
regards, tom lane
---
Title: RE: [GENERAL] Timestamp with timezone query
I'm not at my dev station to check, but what about:
SELECT myTime AT TIME ZONE 'UTC' FROM theTable;
Then try:
SELECT myTime AT TIME ZONE 'UTC' FROM theTable WHERE myTime = '19:30:00-00';
Or:
SELECT myTime AT TIME ZONE 'UTC' FROM theTable W
On 9/25/06, Markus Grabner <[EMAIL PROTECTED]> wrote:
Am Montag, 25. September 2006 07:09 schrieb A. Kretschmer:
> am Mon, dem 25.09.2006, um 2:56:47 +0200 mailte Markus Grabner folgendes:
> > Hi!
> >
> > As far as I understand, one can simulate updateable views in
> > PostgreSQL by pro
zeljko wrote:
> SELECT convert(myfield,'LATIN2','WIN1250') FROM tbl;
>
> ERROR: character 0x828e of encoding "MULE_INTERNAL" has no equivalent in
> "WIN1250"
>
> I know I have few characters like this one in table with about 1.000.000
> rows.
> How to avoid such error and show eg. ? instead of
Jeff Davis wrote:
I don't know for sure, but I would guess not any time soon. A PITR
standby works by operating in recovery mode while it's waiting for the
WAL files to arrive. When you bring the database up, you're telling it
there are no more files to wait for, and to finish recovering and star
40 matches
Mail list logo