Merlin Moncure wrote:
On Jan 15, 2008 1:15 AM, Ken Johanson <[EMAIL PROTECTED]> wrote:
The output of this is very verbose and broken into multiple queries
making joins difficult for me to understand, I'm afraid; my current
experience level likely will not reliably produce a single-query
equivale
Merlin Moncure wrote:
On Jan 15, 2008 1:15 AM, Ken Johanson <[EMAIL PROTECTED]> wrote:
The output of this is very verbose and broken into multiple queries
making joins difficult for me to understand, I'm afraid; my current
experience level likely will not reliably produce a single-query
equivale
Tino Wildenhain wrote:
Ken Johanson wrote:
I am looking for expertise on how to program the equivalent to this
query, but using the pg_catalog tables, which I understand have fewer
security restrictions than information_schema in some cases:
SELECT column_name
FROM information_schema.columns
WH
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 16 Jan 2008 00:29:16 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > If we are sure that this issue is apparent actual row insertion it
> > should be easy to duplicate.
>
> I think you missed my
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> If we are sure that this issue is apparent actual row insertion it
> should be easy to duplicate.
I think you missed my point entirely: I believe it's specific to
Clodoaldo's installation. Certainly I didn't have any luck reproducing
a huge 8.2-to-
Tom Lane wrote:
I went through this thread again, and noticed something that no one
seems to have remarked on at the time: the vmstat numbers near the
bottom of this post
http://archives.postgresql.org/pgsql-general/2008-01/msg00161.php
show close to 100% I/O wait time (either that or 50% idle
Robert Treat wrote:
On Tuesday 15 January 2008 21:00, Greg Smith wrote:
There's been a big move in the php community to push people towards php5 (one
of which was EOL of php4), which has started to pay off. I'd guess that if
they wanted to, they could switch to PDO with Drupal 7 and not hurt
On Tuesday 15 January 2008 21:00, Greg Smith wrote:
> On Wed, 16 Jan 2008, Ivan Sergio Borgonovo wrote:
> > Furthermore I think that developing in such a MySQLish centric way
> > will make MUCH harder to support any other DB not only PostgreSQL and
> > freedom of choice is very important to me.
>
>
I went through this thread again, and noticed something that no one
seems to have remarked on at the time: the vmstat numbers near the
bottom of this post
http://archives.postgresql.org/pgsql-general/2008-01/msg00161.php
show close to 100% I/O wait time (either that or 50% idle 50% I/O wait,
whic
with
the imagination that it is, therefore, obscure and, on the contrary, that
what is to prove it is clear, and so we understand it easily.
41. Epigrams of Martial.--Man loves malice, but not against one-eyed men nor
the unfortunate, but against the fortunate and proud. People are mistaken in
thi
His agony? Do they not know how to paint a resolute death? Yes, for
the same Saint Luke paints the death of Saint Stephen as braver than that of
Jesus Christ.
They make Him, therefore, capable of fear, before the necessity of dying has
come, and then altogether brave.
But when they make Him so tr
fit
to come to Christ; they are so wicked that Christ will never accept
them. And then it may be they set themselves upon a new course of
fruitless endeavors, in their own strength, to make themselves better,
and still meet with new disappointments. They are earnest to inquire
what they shall do. T
them. Every one can say this; every one can call
himself a prophet. But I see that Christian religion wherein prophecies are
fulfilled; and that is what every one cannot do.
694. And what crowns all this is prediction, so that it should not be said
that it is chance which has done it?
Whosoever,
point beyond which our senses
can no longer perceive anything, although by its nature it is infinitely
divisible.
Of these two Infinites of science, that of greatness is the most palpable,
and hence a few persons have pretended to know all things. "I will speak of
the whole," said Democritus.
But
That it had been her opinion, till now, she was not guilty of
Adam's sin, nor any way concerned in it, because she was not active in
it; but that now she saw she was guilty of that sin, and all over
defiled by it; and the sin which she brought into the world with her,
was alone sufficient to condem
who before had serious thoughts,
had their awakenings and convictions greatly increased. There were many
instances of persons who came from abroad on visits, or on business, who
had not been long here, before, to all appearances, they were savingly
wrought upon, and partook of that shower of divine
gave orders that the burning fiery furnace should be heated
seven times hotter than it was before; doubtless, it was raised to the
utmost degree of fierceness that human art could raise it. But the great
God is also willing to show his wrath, and magnify his awful majesty and
mighty power in the ex
the others in
their vastness. For who will not be astounded at the fact that our body,
which a little while ago was imperceptible in the universe, itself
imperceptible in the bosom of the whole, is now a colossus, a world, or
rather a whole, in respect of the nothingness which we cannot reach? He w
to the rich, that, if they do it not in the sight of God, they
depart from the command of religion.
SECTION VI: THE PHILOSOPHERS
339. I can well conceive a man without hands, feet, head (for it is only
experience which teaches us that the head is more necessary than feet).
shall be sprinkled on his
garments, so as to stain all his raiment. He will not only hate you, but
he will have you in the utmost contempt: no place shall be thought fit
for you, but under his feet to be trodden down as the mire of the
streets.
The misery you are exposed to is that which God wil
believe that matters were reversed? In short, as we often dream that
we dream, heaping dream upon dream, may it not be that this half of our
life, wherein we think ourselves awake, is itself only a dream on which the
others are grafted, from which we wake at death, during which we have as few
princ
fervent with love. Princes abandoned
their pomp; maidens suffered martyrdom. Whence came this influence? The
Messiah was come. These were the effect and sign of His coming.
773. Destruction of the Jews and heathen by Jesus Christ: Omnes gentes
venient et adorabunt eum.156 Parum est ut,157 etc. Pos
with
extraordinary success in his ministry, in the conversion of many souls.
He had five harvests, as he called them. The first was about 57 years
ago; the second about 53; the third about 40; the fourth about 24; the
fifth and last about 18 years ago. Some of these times were much more
remarkable
I think I found at least one part of the problem. I was able to
reproduce a crash similar to yours by running the german_ispell
dictionary against long random words, and what I found out is that
it's possible to overrun the fixed-length "buf" buffer declared at
line 1542 of spell.c.
Run till exit
On Wed, 16 Jan 2008, Ivan Sergio Borgonovo wrote:
Furthermore I think that developing in such a MySQLish centric way
will make MUCH harder to support any other DB not only PostgreSQL and
freedom of choice is very important to me.
Having helped out a bit getting Postnuke working better with Pos
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 16 Jan 2008 01:12:07 +0100
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Among Drupal developer there is such kind of discussion over and over
> recently:
>
> http://drupal4hu.com/node/64
I commented here.
> I'd ask to all th
On Tue, 15 Jan 2008, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
I'm noticing a problem where autovacuum touching template1 when createdb
is run is making createdb fail. That's easy to work around when doing
things by hand (just run it again), but when running createdb with a
script, it's n
Hi,
Among Drupal developer there is such kind of discussion over and over
recently:
http://drupal4hu.com/node/64
I'd be too PostgreSQL biased to comment further... my point of view
is not too different from the one expressed by Steve Rude at the
bottom of the page.
Furthermore I think that deve
Ben <[EMAIL PROTECTED]> writes:
> I'm noticing a problem where autovacuum touching template1 when createdb
> is run is making createdb fail. That's easy to work around when doing
> things by hand (just run it again), but when running createdb with a
> script, it's not so clear to me how to keep
2008/1/15, Alvaro Herrera <[EMAIL PROTECTED]>:
> Clodoaldo escribió:
>
> > I guess the samples above are not very useful. If you think it would
> > help, i can upload the database dump, along with the source txt files
> > and the insert script, to some web directory, so you can see it
> > working.
Erik Jones wrote:
On Jan 15, 2008, at 4:53 PM, Justin Pasher wrote:
Erik Jones wrote:
On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote:
PostgreSQL 7.4.17
My situation is basically like the one states in the archives:
http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php
We have s
Erik Jones <[EMAIL PROTECTED]> writes:
> You can build and EXECUTE the ALTER TABLE commands in a function of a
> few lines. With regards to removing the faulty permissions, will
> REVOKE not work if the user doesn't exist in the system anymore (I
> honestly don't know much about pre-8.0 beha
I'm noticing a problem where autovacuum touching template1 when createdb
is run is making createdb fail. That's easy to work around when doing
things by hand (just run it again), but when running createdb with a
script, it's not so clear to me how to keep things working all the time.
One thoug
On Jan 15, 2008, at 4:53 PM, Justin Pasher wrote:
Erik Jones wrote:
On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote:
PostgreSQL 7.4.17
My situation is basically like the one states in the archives:
http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php
We have some tables that use
Clodoaldo escribió:
> I guess the samples above are not very useful. If you think it would
> help, i can upload the database dump, along with the source txt files
> and the insert script, to some web directory, so you can see it
> working. Its bziped size is 914MB so I will only upload it if you s
Clodoaldo escribió:
> > > fahstats=> analyze;
> > > WARNING: skipping "pg_authid" --- only table or database owner can
> > > analyze it
> The problem with that warning message is that it implies that the db
> owner can analyze them which can not be done according to your
> comment. The message,
Tom Lane wrote:
This is not the same test data as in your previous concurrent-index
problem, then? I still had a copy of that, so I tried the case, and
it doesn't crash on that data ...
Teodor Sigaev wrote:
I tryed to reproduce the bug but without success.
Could you provide a dump of text col
Erik Jones wrote:
On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote:
PostgreSQL 7.4.17
My situation is basically like the one states in the archives:
http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php
We have some tables that used to be owned by a user (user id 117)
that no longer
On Jan 15, 2008 2:29 PM, Chris Browne <[EMAIL PROTECTED]> wrote:
> Kico Zaninetti <[EMAIL PROTECTED]> writes:
> > Hi all.
> >
> > I have a database with 62 million registers and I have to make a
> > SELECT using LIKE.
> >
> > This is my select:
> > SELECT * FROM phone WHERE name LIKE = '%ZANINETTI%
On Jan 15, 2008, at 3:59 PM, Justin Pasher wrote:
PostgreSQL 7.4.17
My situation is basically like the one states in the archives:
http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php
We have some tables that used to be owned by a user (user id 117)
that no longer exists. Because t
PostgreSQL 7.4.17
My situation is basically like the one states in the archives:
http://archives.postgresql.org/pgsql-sql/2005-10/msg00165.php
We have some tables that used to be owned by a user (user id 117) that
no longer exists. Because the user no longer exists, when the database
is dumpe
Kico Zaninetti <[EMAIL PROTECTED]> writes:
> Hi all.
>
> I have a database with 62 million registers and I have to make a
> SELECT using LIKE.
>
> This is my select:
> SELECT * FROM phone WHERE name LIKE = '%ZANINETTI%' AND city = 'SAO
> PAULO' AND state = 'SP'
>
> I have an index created like this
On Mon, Jan 14, 2008 at 11:42:50AM -0500, Josh Harrison wrote:
> Thanks
>
> On Jan 12, 2008 9:19 AM, David Fetter <[EMAIL PROTECTED]> wrote:
>
> > On Fri, Jan 11, 2008 at 01:02:01PM -0500, Josh Harrison wrote:
> > > Hi
> > > We have an Oracle production database with some terbytes of data. We
> >
Hannes Dorbath <[EMAIL PROTECTED]> writes:
> Alvaro Herrera wrote:
>> Can you please provide a backtrace from gdb?
> I hope that contains it: http://theendofthetunnel.de/backtrace.log
Hmmm --- one thing that jumps out at me is that SplitToVariants assumes
(in four places) that the SplitVar.stem a
Hannes Dorbath <[EMAIL PROTECTED]> writes:
> Crash happens about 7 minutes after issuing the UPDATE statement with
> current CVS HEAD. The table has around 5 million rows. It's always
> reproducible.
This is not the same test data as in your previous concurrent-index
problem, then? I still had
Shane Ambler <[EMAIL PROTECTED]> writes:
>SELECT generate_series(1,100) AS idx
> , substring('abcdefghijklmnopqrstuvwxyz0123456789' from
> cast((random()*36)as integer) for 1)
> ||substring('abcdefghijklmnopqrstuvwxyz0123456789' from
> cast((random()*36)as integer) for 1)
> ||substring('a
On Jan 15, 2008 7:58 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> If that really is the behavior you want, and not a typo
It is, most of parameters passed to a plpgsql function are in fact parts of
the filter and if certain filter item is null it is considered unknown and
we don't want it to affect th
Not real sure if this is an issue but from what I figure there is too
much RAM being chewed up from this.
The end result is an out of memory error
(I haven't delved deeper as yet)
So I am replicating what someone else is failing to get working in
sqlite to see what pg can do.
The end scenar
I tryed to reproduce the bug but without success.
Could you provide a dump of text column?
Hannes Dorbath wrote:
Crash happens about 7 minutes after issuing the UPDATE statement with
current CVS HEAD. The table has around 5 million rows. It's always
reproducible.
--
Teodor Sigaev
On Tue, Jan 15, 2008 at 12:18:18PM -0500, blackwater dev wrote:
> Ok, fair enough, in theory, I don't want to simply trust the file to have
> clean data so will want to put the data into a huge array (php) which I can
> clean and then pump into the db. What is the best way to pump all this data
>
Luca Arzeni <[EMAIL PROTECTED]> writes:
> That is: the sort order in postgres 8.1.9 seems to ignore the blank.
This is expected behavior in most non-C locales.
> In all cases I'm using locale LATIN9 during DB creation, but I tested also
> with ASCII, UTF8 and LATIN1 encoding.
LATIN9 isn't a loc
Hannes Dorbath <[EMAIL PROTECTED]> writes:
> Hannes Dorbath wrote:
>> Yes, I'll try to catch the row.
> I just slammed a BEFORE UPDATE FOR EACH ROW trigger with RAISE NOTICE on
> the table to catch the row ID where it fails.
> The row ID is never the same. Neither can I reproduce it when I use t
Hi there,
I have a table with a single column, pk of varchar type
The table contains few names, say:
A
C
B
In the first two records there is a between the and the following letter
A and C while, the third one has a B immediately following the (without
blanks).
In post
Hello all,
I'm pulling in a csv file nightly and need to pump in into my db. My plan
is to pump it into a temp table and then to an update or insert from the
temp table to the real table. I'm having an issue, however, with the copy.
Here is a my syntax.
COPY cars FROM 'cars04.txt'
Hannes Dorbath wrote:
> Hannes Dorbath wrote:
>> Yes, I'll try to catch the row.
>
> I just slammed a BEFORE UPDATE FOR EACH ROW trigger with RAISE NOTICE on
> the table to catch the row ID where it fails.
>
> The row ID is never the same. Neither can I reproduce it when I use the
> last reported
"Vyacheslav Kalinin" <[EMAIL PROTECTED]> writes:
> QUERY PLAN
> Bitmap Heap Scan on t1 (cost= 151.74..5307.59 rows=5000 width=8)
> Recheck Cond: ((val > $1) AND (val < $2))
> -> Bitmap Index Scan on idx_t1 (cost=0.00..150.49 rows=5000 width=0)
> Index Cond: ((val > $1) AND (val < $2)
Hannes Dorbath wrote:
Yes, I'll try to catch the row.
I just slammed a BEFORE UPDATE FOR EACH ROW trigger with RAISE NOTICE on
the table to catch the row ID where it fails.
The row ID is never the same. Neither can I reproduce it when I use the
last reported row ID.
Is NOTICE logging / pr
On 15 jan, 12:29, [EMAIL PROTECTED] (Richard Huxton) wrote:
> > It's quite simple to have problems with pgAdmin's backup procedure.
>
> Hmm - shouldn't be, and if so then please let the pgAdmin people know!
> They're always working to improve the package and it's
>
I think the same. We (company I
Ok, did what you said: stopping server, deleting "newly" created
"data" directory, re-running initdb, starting the server, stopping
the
server.
Renamed "empty" data directory.
Restarting server: NOT COMPLAINING "you need to run initdb" or
something else Although it's saying that it st
Hallo all
Is it possible on 8.2 database?
Thank you
Pavel Stehule
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can ge
Stefan Schwarzer <[EMAIL PROTECTED]> writes:
> Ok, did what you said: stopping server, deleting "newly" created
> "data" directory, re-running initdb, starting the server, stopping the
> server.
> Renamed "empty" data directory.
> Restarting server: NOT COMPLAINING "you need to run initdb" or
Hello,
I would appreciate if someone explained me how exactly prepared parametrized
statements are planned, i.e. what kind of assumptions planner makes on param
values, selectivity, expected row count etc. that affect in particular
whether indexes will be used or not. For instance consider the fol
I re-installed my machine and "forgot" to dump my database(s). I
naturally still have the whole database folders. For the moment I
installed the "old" postgres version (8.1) to be able to read my
data.
But how can I read them? It seems that it doesn't work that I just
overwrite the new database
On Tue, Jan 15, 2008 at 02:42:05PM +0100, Stefan Schwarzer wrote:
> Thanks a lot for this. Still trying. But although the postmaster did
> run at one time, now, after copying back and forth, it doesn't want to
> do anything anymore... Gush, getting really frustrated...
If it really doesn't wor
Stefan Schwarzer wrote:
There's no reason why you *have* to run the server as user postgres
though. It's perfectly possible to do the above as user schwarzer. If
the database system is intended just for that one user, that might
make sense too.
Oh, make sure the logfile is in a directory writ
T.J. Adami wrote:
On 14 jan, 10:36, hiddenhippo <[EMAIL PROTECTED]> wrote:
Having recently jumped ship from MSSQL to Postgres I'm finding it a
little difficult getting onto the 'correct path.' Basically I have a
live database and I want to take a copy of that and then restore it
onto a backup s
Now, it seems somewhat complicated - at least for me -, due to the
different read-write permissions, to do that. It worked before, but
now, after re-installing the machine, I really don't get it going...
The commands would be like this:
/usr/local/pgsql/bin/initdb -D /Users/schwarzer/Docu
On 14 jan, 09:08, [EMAIL PROTECTED] (Ashish Karalkar) wrote:
> Hello list members,
> I hav a table with 140M rows. While I am trying to select the count from the
> table
> I am getting following error
> ERROR: shared buffer hash table corrupted
> Can anybody please suggest me wht had gone wrong a
On Jan 15, 2008 1:15 AM, Ken Johanson <[EMAIL PROTECTED]> wrote:
> The output of this is very verbose and broken into multiple queries
> making joins difficult for me to understand, I'm afraid; my current
> experience level likely will not reliably produce a single-query
> equivalent to the above.
Stefan Schwarzer wrote:
I re-installed my machine and "forgot" to dump my database(s). I
naturally still have the whole database folders. For the moment I
installed the "old" postgres version (8.1) to be able to read my data.
But how can I read them? It seems that it doesn't work that I just
over
On Tue, 15 Jan 2008 14:43:35 +0100
Alban Hertroys <[EMAIL PROTECTED]> wrote:
> You need to scroll to the last row to find the size of the result
> set, but after that it's pretty easy to return random rows by
> scrolling to them (and marking them 'read' in some way to prevent
> accidentally
Stefan Schwarzer wrote:
Hi there,
I want to create my database not under /etc/ but under or within my
Mac-user level, that is /Users/schwarzer/
The data directory shouldn't ever end up in /etc - are you sure that's
what it's doing?
Now, it seems somewhat complicated - at least for
Alvaro Herrera wrote:
Can you please provide a backtrace from gdb?
I hope that contains it: http://theendofthetunnel.de/backtrace.log
It'd be nice to have text string which cause segfault and sql script for
configuration.
Yes, I'll try to catch the row.
--
Best regards,
Hannes Dorbath
-
On 14 jan, 10:36, hiddenhippo <[EMAIL PROTECTED]> wrote:
> Having recently jumped ship from MSSQL to Postgres I'm finding it a
> little difficult getting onto the 'correct path.' Basically I have a
> live database and I want to take a copy of that and then restore it
> onto a backup server.
>
> Fi
On Jan 15, 2008 12:03 AM, Adam Rich <[EMAIL PROTECTED]> wrote:
> > Advisory locks would work here (better that than table lock), but I
> > don't think that's the right approach. Transaction 2 should simply do
> > a
> > select * from parent_tbl
> > where id=1 for update;
> >
> > at the start of the
On Jan 9, 2008, at 8:07 PM, Scott Marlowe wrote:
I could see a use for an approximate count(*) with where clause, just
like I could see a use for the ability to retrieve random rows from a
table without using order by random() on it. And those are both
things that would require some form of hack
I re-installed my machine and "forgot" to dump my database(s). I
naturally still have the whole database folders. For the moment I
installed the "old" postgres version (8.1) to be able to read my
data.
But how can I read them? It seems that it doesn't work that I just
overwrite the new database
Hi there,
I want to create my database not under /etc/ but under or within
my Mac-user level, that is /Users/schwarzer/
Now, it seems somewhat complicated - at least for me -, due to the
different read-write permissions, to do that. It worked before, but
now, after re-installing t
On 14 jan, 17:02, "Andrus" <[EMAIL PROTECTED]> wrote:
> create temp table test (col char);
> select count(col) from test order by col;
>
> causes
>
> ERROR: column "test.col" must appear in the GROUP BY clause or be used in
> an aggregate function
> SQL state: 42803
>
> How to fix this ?
> This st
It'd be nice to have text string which cause segfault
and sql script for configuration.
Oleg
On Tue, 15 Jan 2008, Hannes Dorbath wrote:
Crash happens about 7 minutes after issuing the UPDATE statement with current
CVS HEAD. The table has around 5 million rows. It's always reproducible.
ISpell
Tore Halset wrote:
Hello.
One of our users tried a "insert into ... select ..." that gave a
strange error message. After digging into the issue, the problem seem to
be that the order of the columns in the select statement must match the
table definition. Here is a way to reproduce this case.
Hannes Dorbath wrote:
> test=# UPDATE test SET tsv = to_tsvector(text);
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> Jan 15 11:32:50 brainchild postmaster[14815] general protection ri
On Jan 15, 2008, at 12:16 , Albe Laurenz wrote:
Because the SQL standard says so.
ISO/IEC 9075-2, Chapter 14.8, Syntax Rule 9:
"If the is omitted, then an
that identifies all columns of T in the ascending sequence of
their ordinal positions within T is implicit."
You want an explicit :
I
Crash happens about 7 minutes after issuing the UPDATE statement with
current CVS HEAD. The table has around 5 million rows. It's always
reproducible.
ISpell dict used:
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-german-compound.tar.gz
(iconved to UTF-8)
Welcom
Josh Harrison wrote:
My question is abt the data migration. Im not sure how to try this
with an online oracle database. We are required to run both postgres
and oracle database simultaneously for a couple of months (atleast
till we decide whether we are going to shut down oracle for good !!!)
Tore Halset wrote:
> One of our users tried a "insert into ... select ..." that gave a
> strange error message. After digging into the issue, the problem seem
> to be that the order of the columns in the select statement must match
> the table definition. Here is a way to reproduce this case.
Tore Halset wrote:
Hello.
One of our users tried a "insert into ... select ..." that gave a
strange error message. After digging into the issue, the problem seem to
be that the order of the columns in the select statement must match the
table definition. Here is a way to reproduce this case.
Hello.
One of our users tried a "insert into ... select ..." that gave a
strange error message. After digging into the issue, the problem seem
to be that the order of the columns in the select statement must match
the table definition. Here is a way to reproduce this case.
-- a source tab
On Mon, Jan 14, 2008 at 10:57:45AM -0500, Tom Lane wrote:
> I'm concerned about this too. We'll at least have to call this out as
> an incompatibility in 8.3, and it seems like a rather unnecessary step
> backwards.
I thought I had send an email asking for comments back when this was
implemented.
Ken Johanson wrote:
I am looking for expertise on how to program the equivalent to this
query, but using the pg_catalog tables, which I understand have fewer
security restrictions than information_schema in some cases:
SELECT column_name
FROM information_schema.columns
WHERE table_catalog=? AND
90 matches
Mail list logo
