Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > How about if we add a UNION that does:
> > UNION
> > SELECT 'non-local temp schemas skipped', NULL
>
> I think showing that would only be appropriate if we actually *did* skip
> some. Finding that out would complicate the que
It did solve my problem
now its dumped like:
SET search_path = archives, pg_catalog;
SET
CREATE INDEX site_search_gist ON site_search USING gist (keywordidx
public.gist_txtidx_ops);
CREATE INDEX
thanks
regds
mallah.
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
What you really want is an end of session callback.
There is not one in PostgreSQL. However, if this is
for session management, you can handle this in your
application by bracketing the connection code with
the table management.
That is, in your app (or rather in your session pooling
code) follow
On Fri, 7 Nov 2003, Edwin Quijada wrote:
> I am trying running up using
> pg_ctl -D /data/dir -l logfile
>
>
> This is the last 100 lines from log
>
> The server must be started under an unprivileged user id to prevent
> a possible system security compromise. See the documentation for
> more inf
Thanks to Joe Conway for pointing out a couple of typos in what I posted
(the original code that I used didn't have quite as many, I edited it to
try to simplify). He also pointed out that I had not initialised my
'count' variable, which was a genuine mistake. I am pleased to say that
the correct
Yes check out the release notes for 7.4:
http://go.jitbot.com/pgsql-7.4-changes
-- Dolly
"Alex" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> is there a document available describing the changes / additions in 7.4 ?
>
> Thanks
> Alex
>
>
>
> ---(end
Tom Lane wrote:
> Frank van Vugt <[EMAIL PROTECTED]> writes:
> > Did I miss this future necessity on the TODO-list ('cause I did check...) or
> > is it simply not on there (yet) ?
>
> It's not there; it should be. Something like
>
> * Need better (safer, less prone to unnecessary failures) sche
Frank van Vugt <[EMAIL PROTECTED]> writes:
> Did I miss this future necessity on the TODO-list ('cause I did check...) or
> is it simply not on there (yet) ?
It's not there; it should be. Something like
* Need better (safer, less prone to unnecessary failures) scheme for
ensuring CREATE DATAB
Hi,
Thanks Bruce ;-)
Tom Lane wrote:
> Sooner or later we'll have to face up to the conflict
Thanks Tom, I understand what's happening now.
Did I miss this future necessity on the TODO-list ('cause I did check...) or
is it simply not on there (yet) ?
I'm just being inquisitive, I understand
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> Thanks for the explanation , Shall do that please tell me how to fetch
> ruleutils.c
> from 7.3-branch-head (do not know the cvs commands O:-) ) , thanks again.
The easiest way to get it is from the cvsweb interface:
http://developer.postgresql
Tom Lane wrote:
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
I face the following problem in transferring data from
pgsql 7.3.4 to pgsql 7.4 RC1 . I am piping the output of
pg_dumpall from 7.3 to 7.4 running on different port.
The problem is there is a gist index on txtidx type on a
non-publ
On Saturday 08 November 2003 9:04 am, Alex wrote:
> Hi,
> I want to remove data that is older that a certain number of
> months.. only full months.
>
> example: today is 11-08 and I want do delete all data that is older
> than this month - 3 month i.e. i want to delete all information
> that is old
Hello,
Can you pls explain how the constant values are stored in Postgresql, I
mean using the Const Data Structure.
What does the datum field represent?
Thanks
Shalu
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregi
On Wed, Nov 05, 2003 at 03:51:36 +,
Robin Munn <[EMAIL PROTECTED]> wrote:
> I'm trying to calculate the default values of a column when I insert a
> row, based on the values of other columns. It's something I thought
> should be simple enough, but I can't seem to figure out how to do it.
> He
Hi all,
just wanted to let you know (maybe you also know :)) - pgsql 7.4 is great!
I had do migrate a mysql database to pgsql within the database -
dump mysql database
restore that dump in pgsql
spread about 30 tables in >160 new tables (new database design)
...this migration took about 3,5 hrs.
Hello Miss Rothe,
I would like to know if the interface you developped to connect matlab
to postgresql still available. Can I use it? If yes from where do I have
to download MEX files. In advance Thank you very much for your help.
Paul Olamba Kalonda
Belgian Institute for Space Aeronomy
Av. cir
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> I face the following problem in transferring data from
> pgsql 7.3.4 to pgsql 7.4 RC1 . I am piping the output of
> pg_dumpall from 7.3 to 7.4 running on different port.
> The problem is there is a gist index on txtidx type on a
> non-public schema
Yes i may drop the indexes even , but is it quite usual
to take these work arounds in doing major upgrades.
Regds
Mallah.
Alvaro Herrera wrote:
On Mon, Nov 10, 2003 at 01:36:20AM +0530, Rajesh Kumar Mallah wrote:
PS: i do not want to edit the (splitted) dump file , my database
Hi,
I need to query each column's constraint and name of a table in
postgreSQL v7.3.4 with a single SQL query but don't know how. Would
appreciate any pointers!
Thank you.
Regards,
Damon
---(end of broadcast)---
TIP 7: don't forget to increase you
19 matches
Mail list logo
