am 19.12.2005, um 9:39:11 - mailte Marian Naghen folgendes:
> I want to insert records inside a transaction block (BEGIN -
> COMMIT/ROLLBACK). If the transaction fails,
> the sequence do not rollback and retain the new value.
>
> This is the default behavior of sequences ?
Yes.
HTH, An
I want to insert records inside a transaction block
(BEGIN - COMMIT/ROLLBACK). If the transaction fails,
the sequence do not rollback and retain the new
value.
This is the default behavior of sequences ?
I use the following table:
CREATE TABLE proceduri( procedura_id
int4 NOT NUL
On Sun, Dec 18, 2005 at 12:18:04PM -0500, [EMAIL PROTECTED] wrote:
> I am trying to figure out how to get (select) a list of all the names of
> the tables in a database when given the name of the database. ie.,
> Select table_name from ??? where datbase name = "XYZ";
Except for a few shared tables
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
> Any reason why a database would not get dumped by pg_dumpall?
> Always run pg_dumpall as the superuser.
As the operating system superuser or as a database superuser?
There's a difference.
> I do a nightly dump and have checked sev
On Sun, Dec 18, 2005 at 02:02:49PM +0100, stig erikson wrote:
> it seems like a sequence is always moving forward and cannot be rolled
> back. is this correct?
Yes.
> if it is correct, where in the docs do i find information about this
> behavior?
http://www.postgresql.org/docs/faqs.FAQ.html#i
hello.
is it possible to rollback sequences in postgresql 8.1.1?
(tested om FC4 with official rpms).
it seems like a sequence is always moving forward and cannot be rolled
back. is this correct?
if it is correct, where in the docs do i find information about this
behavior?
/stig
testcase:
Hi guys...
very new to postgres.
just downloaded latest stable postgres release.
need to install tsearch2, and i see the tsearch2 is already on the
/contrib folder of postgres.
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html
followed the instruction there o
hi, information to the news masters.
it seems like messages from news.fr.postgresql.org are not reaching
news.postgresql.org. (the other way around seems to work though).
end of message
---(end of broadcast)---
TIP 9: In versions below 8.0, the
Hi
I am trying to figure out how to get (select) a list of all the names of
the tables in a database when given the name of the database. ie.,
Select table_name from ??? where datbase name = "XYZ";
I can easily select names of tables in current db like this:
SELECT datname FROM pg_database;
But, i
Any reason why a database would not get dumped by pg_dumpall?
Always run pg_dumpall as the superuser.
I do a nightly dump and have checked several days so far and the database is
missing in all so far. :-(
The only thing, for that DB, that got backed up was the database, but not a
single tabl
Thanks Michael
Bob
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgre General"
Sent: Sunday, December 18, 2005 4:49 PM
Subject: Re: [GENERAL] Views
On Sun, Dec 18, 2005 at 02:52:23PM -0800, Bob Pawley wrote:
Thanks for the
On Sun, Dec 18, 2005 at 02:52:23PM -0800, Bob Pawley wrote:
> Thanks for the help. Could you point me to some documentation on the use of
> parentheses? Perhaps something that describes what action the parentheses
> accomplishes?
See "Lexical Precedence" and "Value Expressions" in the "SQL Synta
Michael
That worked fine.
Thanks for the help. Could you point me to some documentation on the use of
parentheses? Perhaps something that describes what action the parentheses
accomplishes?
Bob
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL
I've been having problems with bools in my Access frontend and
PostGreSQL backend. The problem is that Access uses -1 for true and 0
for false and when it does a select it uses those numbers instead of the
true or false values. PostGreSQL does not have an implicit conversion
from int to bool, s
I got it working.
This has been bothering me for a long time, but now that it was listed
as an official bug in my system, I had to deal with it.
I'll post the solution under a new post, because I think this will help
a lot of people.
Sim Zacks wrote:
I know I can do it explicitly, I need to
I know I can do it explicitly, I need to do it implicitly.
I am having a problem with a Microsoft Access front-end , that uses -1
as true and 0 as false.
I have everything worked around all the places where I could find it by
using a cbool(), but this doesn't work with filters, which probably ca
Sim Zacks <[EMAIL PROTECTED]> schrieb:
> How easy would it be to write a small type extension to have integer
> automatically convert to bool?
> For example, I want an implicit conversion that 0 is false and everything
> else is true.
test=# \d foo;
Table "public.foo"
Column | Type |
How easy would it be to write a small type extension to have integer
automatically convert to bool?
For example, I want an implicit conversion that 0 is false and
everything else is true.
Is this C programming or can you do it with a local procedural language?
Thanks
Sim
-
On Sat, Dec 17, 2005 at 10:30:04PM +0100, Martijn van Oosterhout wrote:
> I think the real solution is to implement COLLATE support. Then we can
> define all sorts of collations, like:
...
> My patch was halfway there (the grammer was sorted, as were the SQL
> propgation rules) but there was some
On Dec 18, 2005, at 3:50 AM, Chris Velevitch wrote:
(for v7.4.5) How do I get the number of rows updated by an update
command?
In general, the UPDATE command tells you the number of updated rows:
Outputs
On successful completion, an UPDATE command returns a command tag of
the form
UPDA
(for v7.4.5) How do I get the number of rows updated by an update command?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
21 matches
Mail list logo
