Hi,
I would like to write a request where I would get the table name and column
name of a sequence.
In fact I want the opposite of pg_get_serial_sequence !
I have been looking at the sytem table and could not link the sequence from
pg_class to a table (and even less to a table).
And I have not
Am Donnerstag, 22. Mai 2008 schrieb Brijesh Shrivastav:
1) Can xml column be constrained to be DOCUMENT or CONTENT type?
Using a check constraint that does IS [NOT] DOCUMENT on the value.
2) Is there plan in near future to support XML schema validation
i.e to ensure inserted xml
Am Mittwoch, 21. Mai 2008 schrieb Thomas Kellerer:
How would I achieve the same without using the deprecated xml2 module?
xpath_table is probably the major piece that is not directly covered by the
new system. So until we have a replacement, we probably won't remove the old
module.
--
Sent
Peter Eisentraut wrote on 24.05.2008 13:35:
Am Mittwoch, 21. Mai 2008 schrieb Thomas Kellerer:
How would I achieve the same without using the deprecated xml2 module?
xpath_table is probably the major piece that is not directly covered by the
new system. So until we have a replacement, we
I would like to write a request where I would get the table name and
column name of a sequence.
In fact I want the opposite of pg_get_serial_sequence !
You are looking for refobjid in pg_depend, but this
time the sequence could be a dependent to more than table.
A query like the one
On Fri, 23 May 2008, Laurent ROCHE wrote:
I would like to write a request where I would get the table name and
column name of a sequence. I have been looking at the sytem table and
could not link the sequence from pg_class to a table (and even less to a
table).
There's an example of how to
Hmmm,
It was the protection on the /usr/local/pgsql directory. Solved, by myself
an hour after making this post. Odd that, its been bugging the heck out of
me for over a week now, and then one hour after posting
At 16:05 +0100 23/5/08, Fergus McMenemie wrote:
I have a perl cgi script that
Scott Ribe wrote:
I don't remember if MagicDraw supports multiple schema or not, but back when
I was looking at CASE-type tools it was one the nicer ones that I found that
would run on platforms other than Windows.
For Windows, I've been using Case Studio for several years and I've been
very
Hi,
I was wondering if anyone has written a tool that will drop (cascade) then
allow the edit and then restore the functions/triggers including the adding
the function/triggers to the inserts/deletes/etc.. to the tables.
It turns out that have to change 50 fifty triggers. At the moment I
Hi,
I am deciding between MySQL and Postgres. I'm leaning towards Postgres
mainly due the widely publicized speed when using transactions. However, I
am not able to find any good books / resources for tuning/ optimizing the
database. Is there a book like High Performance MySQL for Postgres that
Ram Ravichandran wrote:
Hi,
I am deciding between MySQL and Postgres. I'm leaning towards Postgres
mainly due the widely publicized speed when using transactions.
Everything except for a couple of actions in Postgresql are wrapped in
transactions and can be rollback, you can not turn it
On May 24, 2008, at 11:57 AM, Ram Ravichandran wrote:
Hi,
I am deciding between MySQL and Postgres. I'm leaning towards
Postgres mainly due the widely publicized speed when using
transactions. However, I am not able to find any good books /
resources for tuning/ optimizing the database.
On 5/24/08, Ram Ravichandran [EMAIL PROTECTED] wrote:
I am deciding between MySQL and Postgres. I'm leaning towards Postgres
mainly due the widely publicized speed when using transactions. However, I
am not able to find any good books / resources for tuning/ optimizing the
database. Is there a
I know some of these have already been mentioned, but here's the summary I had
stashed away. Although, I'm not sure which ones have any issues with default
schemas. If you do find any such problems (especially with the kind GPL
developers), I'm sure they'd appreciate any feedback.
/** GNU-GPL
14 matches
Mail list logo