On Fri, 2008-10-17 at 19:45 +0200, Alain Roger wrote:
> i mean if i'm logged with the role "test_user", typing show
> search_path; will show me all default schemas.
On SHOW, the manual saith[1]:
"The function current_setting produces equivalent output" ...
SELECT current_setting('search_path');
Richard Broersma wrote:
On Fri, Oct 17, 2008 at 12:32 AM, searchelite <[EMAIL PROTECTED]> wrote:
I have an sql script consists of insert statement data. I want to insert
every row of data every one minute. How can i do that using batch file in
windows
Take a look at your windows sched
On Fri, Oct 17, 2008 at 12:32 AM, searchelite <[EMAIL PROTECTED]> wrote:
> I have an sql script consists of insert statement data. I want to insert
> every row of data every one minute. How can i do that using batch file in
> windows
Take a look at your windows scheduler in the control panel. Yo
On Fri, Oct 17, 2008 at 4:31 PM, Martin Gainty <[EMAIL PROTECTED]> wrote:
> non-existent and/or improper DB design can impede your progress
>
> You'll need to get stats pack configured, run explain plain on your selects
> to
> determine which columns you will to need to index..
I think you're conf
Hi all,
Here is the solution I ended up in using to solve the problem.
a. Created a copy_blob function.
CREATE OR REPLACE FUNCTION copy_blob(p_blobId OID)
RETURNS OID AS $$
DECLARE
v_NewOID OID;
BEGIN
SELECT lo_create(-1) INTO v_NewOID;
delete from pg_largeobject where loid = v_NewO
non-existent and/or improper DB design can impede your progress
You'll need to get stats pack configured, run explain plain on your selects to
determine which columns you will to need to index..
Martin Gainty
__
Disclaimer and confidentiality note
E
On Fri, Oct 17, 2008 at 3:19 PM, Brian Modra <[EMAIL PROTECTED]> wrote:
> Hi,
> I have a server in production running postgresql, receiving 110 rows
> inserted per second, with some pretty intense queries involving long
> plpgsql.
> This server has 4Gigs of RAM and dual processor. Disk is Raid 5.
On Fri, Oct 17, 2008 at 3:38 PM, Kynn Jones <[EMAIL PROTECTED]> wrote:
> Thanks for all your suggestions!
> Kynn
If an approximate count will work take a look in pg_stat_user_tables
right after a vacuum. It's much faster.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
On Oct 17, 2008, at 2:19 PM, Brian Modra wrote:
Hi,
I have a server in production running postgresql, receiving 110 rows
inserted per second, with some pretty intense queries involving long
plpgsql.
This server has 4Gigs of RAM and dual processor. Disk is Raid 5.
I need more power, and am
On Friday 17 October 2008, "Brian Modra" <[EMAIL PROTECTED]> wrote:
> I'm thinking of a 4xCPU and 20 Gigs and one of those large ram disks
> which has its own battery and writes all RAM to hard disk in the event of
> power failure.
Hey, if you really have enough cash for a RamSan you can do pretty
Thanks for all your suggestions!
Kynn
On Oct 17, 2008, at 12:30 PM, Kynn Jones wrote:
Suppose I have two table X and Y and I want to compute the ratio of
the number of rows in X and the number of rows in Y. What would be
the SQL I could type into a psql session to get this number?
This is an example of the recurring problem o
Hi,
I have a server in production running postgresql, receiving 110 rows
inserted per second, with some pretty intense queries involving long
plpgsql.
This server has 4Gigs of RAM and dual processor. Disk is Raid 5.
I need more power, and am wondering what is the place really I need to put
more emp
On Fri, Oct 17, 2008 at 1:30 PM, Kynn Jones <[EMAIL PROTECTED]> wrote:
> Suppose I have two table X and Y and I want to compute the ratio of the
> number of rows in X and the number of rows in Y. What would be the SQL I
> could type into a psql session to get this number?
> This is an example of t
Hi Diogo,
Thanks for your response. However, my requirement is to have two separate
copies. Think about table_a being the original copy, and table_b holding
the backup copy.
Inserting the OID from table_a to table_b will not make the backup copy.
Best Regards,
John
On Fri, Oct 17, 2008 at
Em 17/10/2008, às 18:18, John Skillings escreveu:
Hi all,
I am trying to copy blobs between two tables and need help on the
best way to get this done. My requirement is that the both the
tables maintain their own copy of the large object, instead of
sharing the OID.
I created two tabl
I am not fond of this approach either. I never find myself replying
directly to the poster.
I actually greatly prefer forums which email me a copy of every post
with a nice link to the original thread. 95% of the time I do not even
need to use the link. The latest posting is enough.
This
Hi all,
I am trying to copy blobs between two tables and need help on the best way
to get this done. My requirement is that the both the tables maintain their
own copy of the large object, instead of sharing the OID.
I created two tables:
create table table_a
(id bigserial not null,
filename o
I am a member of a number of lists, some of which exhibit this
'reply-to' behaviour and I have also managed to adapt... to a point.
Sometimes, however, I do end up replying directly to the poster rather
than through the list. Tellingly, I very nearly sent this post
directly to Serge Fonvilee.
Wit
Suppose I have two table X and Y and I want to compute the ratio of the
number of rows in X and the number of rows in Y. What would be the SQL I
could type into a psql session to get this number?
This is an example of the recurring problem of performing arithmetic using
the result of various calls
On Fri, Oct 17, 2008 at 9:26 PM, Serge Fonville <[EMAIL PROTECTED]>wrote:
> Altough I am not sure what the real issue is,I do know that on (for
> example) the tomcat mailing list, when I choose reply (in gmail) the to:
> field contains the address of the mailing list.
> Based on what I know, this
Guy Rouillier wrote:
> When I use "Reply All" in Thunderbird, it adds a "To:" to each of the
> individuals in the discussion, and a "CC:" to the list. Since I
> personally don't like receiving multiple copies of emails from this
> list, I delete all of the "To:" addressees and change the li
Bill Moran wrote:
You can resent it or not, but this _is_ a personal thing. It's personal
because you are the only one complaining about it. Despite the large
number of people on this list, I don't see anyone jumping in to defend
you.
I'm another in the crowd that had this same discussion whe
Awesome!
On Fri, 17 Oct 2008, Tom Lane wrote:
Ben <[EMAIL PROTECTED]> writes:
In 8.3, is there any way I can have a trigger that fires at commit time,
much like deferred foreign keys?
See CREATE CONSTRAINT TRIGGER ... same mechanism that FKs use ...
regards, tom lane
On Friday 17 October 2008 11:55:19 Dan Armbrust wrote:
> It would seem that way. But if you have ever tried programming with
> the constraints of an InstallAnywhere installer, you would know why :)
>
if you are the only user, force a restart into single user mode, then drop the
database, and res
On Fri, 17 Oct 2008, Andrew Sullivan wrote:
There is therefore a mail standards reason not to munge the headers, and
it rests in the rules about origin fields and in the potential for lost
functionality.
I should have included the standard links to both sides of this
discussion:
http://www
"Dan Armbrust" <[EMAIL PROTECTED]> writes:
> On windows, if I attempt to drop a database when I am purposefully
> holding a connection open to the DB, it fails immediately - ~ 100 ms.
> On linux, if I do the same thing, the drop database command takes
> upwards of 4 seconds before it gives up, and
Ben <[EMAIL PROTECTED]> writes:
> In 8.3, is there any way I can have a trigger that fires at commit time,
> much like deferred foreign keys?
See CREATE CONSTRAINT TRIGGER ... same mechanism that FKs use ...
regards, tom lane
--
Sent via pgsql-general mailing list (pgsq
Hi,
several days ago i wrote a post but i did not get any answer, so i'm asking
again just in case of someone hasn't seen it.
in fact i would like to know what are the default schemas allowed or active
for a particular role.
usually it's public and $user, but how to get those information ?
i mean
Tom Lane escreveu:
=?ISO-8859-1?Q?Andr=E9_Volpato?= <[EMAIL PROTECTED]> writes:
8. Postgres is up, but...
# psql matriz
psql: FATAL: could not read block 0 of relation 1664/0/2676: read only
0 of 8192 bytes
Looks like your raid array is dying under you :-( ...
We hope it last more 3
Scott Marlowe wrote:
On Thu, Oct 16, 2008 at 10:06 PM, Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Thu, 16 Oct 2008, Scott Marlowe wrote:
On Thu, Oct 16, 2008 at 10:01 PM, Stephan Szabo
<[EMAIL PROTECTED]> wrote:
On Fri, 17 Oct 2008, Tim Uckun wrote:
Is there a way to change this behavior s
This is interesting.
On windows, if I attempt to drop a database when I am purposefully
holding a connection open to the DB, it fails immediately - ~ 100 ms.
On linux, if I do the same thing, the drop database command takes
upwards of 4 seconds before it gives up, and says it can't drop the
DB.
=?ISO-8859-1?Q?Andr=E9_Volpato?= <[EMAIL PROTECTED]> writes:
> 8. Postgres is up, but...
> # psql matriz
> psql: FATAL: could not read block 0 of relation 1664/0/2676: read only
> 0 of 8192 bytes
Looks like your raid array is dying under you :-( ...
2676 is pg_authid_rolname_index, so you could
No. I need to support 8.0.
After those crashes I changed all IN clauses to
docid = ANY ({1,2,3,4,5,7,8,96,5445,.., 34534534})
I'm afraid that hardly counts as "supporting" 8.0 (or 8.1 for that
matter). The syntax may work but it can't be indexed.
I'm sorry. It seems that Richard Huxton sugge
On Fri, Oct 17, 2008 at 9:16 AM, Dan Armbrust
<[EMAIL PROTECTED]> wrote:
> I don't suppose that there is any easy way way that I can stop and/or
> disable the Autovac temporarily for the database that I want to drop.
>
> The only thing that I have seen so far, is that I would have to add
> rows to
André Volpato escreveu:
10. Same error
# psql matriz
psql: FATAL: could not read block 0 of relation 1664/0/2676: read
only 0 of 8192 bytes
Right now this is the message I got every time I try to connect, even
in single mode.
We tried to fsck the raid partition, but with no luck.
Hope ther
"Andrus" <[EMAIL PROTECTED]> writes:
> No. I need to support 8.0.
> After those crashes I changed all IN clauses to
> docid = ANY ({1,2,3,4,5,7,8,96,5445,.., 34534534})
I'm afraid that hardly counts as "supporting" 8.0 (or 8.1 for that
matter). The syntax may work but it can't be indexed.
In 8.3, is there any way I can have a trigger that fires at commit time,
much like deferred foreign keys? I suspect the answer is "no" but it would
be nice if I'm wrong.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgr
At 09:42 PM 10/14/2008, you wrote:
Mikkel Høgh wrote:
On 14/10/2008, at 11.40, Ivan Sergio Borgonovo wrote:
That might be true, if the only demographic you
are looking for are professional DBAs, but if
you're looking to attract more developers, not
having sensible defaults is not really a g
It would seem that way. But if you have ever tried programming with
the constraints of an InstallAnywhere installer, you would know why :)
On Fri, Oct 17, 2008 at 10:43 AM, Alvaro Herrera
<[EMAIL PROTECTED]> wrote:
> Dan Armbrust escribió:
>> I don't suppose that there is any easy way way that
Dan Armbrust escribió:
> I don't suppose that there is any easy way way that I can stop and/or
> disable the Autovac temporarily for the database that I want to drop.
>
> The only thing that I have seen so far, is that I would have to add
> rows to the pg_autovacuum table for each table in my dat
8.0 (and maybe newer releases also) throw dreaded "Stack lenght limit
exceeded"
message if IN contains large number or items.
Have y'all checked them there release notes? I'm sure they tell the
tale. (sorry too much True Blood...)
No. I need to support 8.0.
After those crashes I changed al
* Ivan Sergio Borgonovo ([EMAIL PROTECTED]) wrote:
> I'd say because postgresql list has been used to it by a longer time
> than most of the new comers doing the other way around did. But it
> seems that the new comers are the most vocal.
sigh. First people complain that poor Mikkel is the only o
On Fri, 17 Oct 2008 08:56:34 -0400
Stephen Frost <[EMAIL PROTECTED]> wrote:
> * Bill Moran ([EMAIL PROTECTED]) wrote:
> > You can resent it or not, but this _is_ a personal thing. It's
> > personal because you are the only one complaining about it.
> > Despite the large number of people on this l
I don't suppose that there is any easy way way that I can stop and/or
disable the Autovac temporarily for the database that I want to drop.
The only thing that I have seen so far, is that I would have to add
rows to the pg_autovacuum table for each table in my database, but
I'mnot confident t
> > Apart from lacking functionality, is there anything
> else I should be aware of i.e. could this cause us any
> serious problems?
>
> You really need to have a word with that application
> vendor.
>
Thanks Tom, I will do.
Send instant messages to your online friends http://uk.messenger.yah
Mike,
1. always separate attributes by blank unless you sure words can span different
columns, e.g., title||' '||description
2. use coalesce to avoid unexpected NULL string
Oleg
On Thu, 16 Oct 2008, Mike Christensen wrote:
Okay this one's driving me crazy.
Should there be any difference be
Hi,
We got a corrupted database server, and I need some advice on what else
can I do.
Specs:
- Postgres 8.3.3 @ Linux dbserver4 2.6.24-etchnhalf.1-686-bigmem
- 4 GB RAM
- PGDATA with 700GB (70GB used), software RAID-0 with 3 sata-2
(blame it on me, ugh...)
So, the steps till now:
1 - Vacuum
Sigh...
wasting another junk of bandwidth with this bike shed discussion
Granted, replying here is more annoying and less convenient compared to other
lists -
as long as your MUA still does not provide decent support for mailing lists.
Down back from 1998 is RFC 2369 that defined additional
Dan Armbrust escribió:
> Do I really just have to keep trying the DROP command N times in a
> row, until it decides it wants to work? That really doesn't seem
> right.
Yes. Most of the time it'll work on the first try, but if you add the
retry loop your operation is guaranteed to work all the t
Scott Marlowe escribió:
> I really do prefer the way this list works because when I hit reply
> all to a discussion with "Bob Smith and Postgresql-general" I know
> that Bob gets a direct answer from me, now, when he needs it at 2am
> when his servers are puking their data out their gigE ports, an
On Fri, Oct 17, 2008 at 8:24 AM, Andrus <[EMAIL PROTECTED]> wrote:
>> 8.x something was supposed to have improved that.
>
> Not in 8.0
> 8.0 (and maybe newer releases also) throw dreaded "Stack lenght limit
> exceeded"
>
> message if IN contains large number or items.
Have y'all checked them ther
On Fri, Oct 17, 2008 at 8:28 AM, Dan Armbrust
<[EMAIL PROTECTED]> wrote:
> But there is no user2. I _know_ I am the only user of this database.
>
> So how can User 1 create a race condition by himself?
>
> Or is this something PostgreSQL is doing internally (like vacuum) ?
>
> Do I really just hav
On Fri, Oct 17, 2008 at 8:24 AM, Martin Gainty <[EMAIL PROTECTED]> wrote:
> free unfettered and open discussion without interference from ANY entity is
> a requirement of a democracy
> the REAL question is ..is this a democracy???
No, it's a well mostly well behaved meritocracy. And I prefer that
On Friday 17 October 2008 Scott Ribe's cat, walking on the keyboard, wrote:
> Older versions of PG were inefficient with larger numbers of elements in an
> IN query, and in fact would error out with something about lack of stack
> space if you used very many (a few hundred IIRC).
>
> 8.x something
But there is no user2. I _know_ I am the only user of this database.
So how can User 1 create a race condition by himself?
Or is this something PostgreSQL is doing internally (like vacuum) ?
Do I really just have to keep trying the DROP command N times in a
row, until it decides it wants to wor
Martin Gainty escribió:
>
> free unfettered and open discussion without interference from ANY
> entity is a requirement of a democracy the REAL question is ..is this
> a democracy???
_Of course_ it isn't ... (thankfully!)
--
Alvaro Herrera
--
Sent via pgsql-general mailing list (pgsql-general
8.x something was supposed to have improved that.
Not in 8.0
8.0 (and maybe newer releases also) throw dreaded "Stack lenght limit
exceeded"
message if IN contains large number or items.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
free unfettered and open discussion without interference from ANY entity is a
requirement of a democracy
the REAL question is ..is this a democracy???
Thanks Scott
Martin
Please vote November 4
__
Disclaimer and confidentiality note
Everything in th
On Fri, Oct 17, 2008 at 8:11 AM, Dan Armbrust
<[EMAIL PROTECTED]> wrote:
>> There are obvious race conditions in that assumption. Why don't you
>> just try the drop and see if it succeeds?
>>
>>regards, tom lane
>>
>
> I don't follow - why is there a race condition? I'm dr
On Fri, Oct 17, 2008 at 8:15 AM, Mikkel Høgh <[EMAIL PROTECTED]> wrote:
> On 17/10/2008, at 16.12, Scott Marlowe wrote:
>
>> On Fri, Oct 17, 2008 at 7:39 AM, Collin Kidder <[EMAIL PROTECTED]> wrote:
>>>
>>> I was going to stay out of this but I'll jump in and defend him. The
>>> people
>>> on this
On 17/10/2008, at 16.12, Scott Marlowe wrote:
On Fri, Oct 17, 2008 at 7:39 AM, Collin Kidder <[EMAIL PROTECTED]>
wrote:
I was going to stay out of this but I'll jump in and defend him.
The people
on this list are so pedantic, so sure that their way is the only
way that
they absolutely rain
On Fri, Oct 17, 2008 at 7:39 AM, Collin Kidder <[EMAIL PROTECTED]> wrote:
> I was going to stay out of this but I'll jump in and defend him. The people
> on this list are so pedantic, so sure that their way is the only way that
> they absolutely rain nuclear fire down on anyone who dares to disagre
> There are obvious race conditions in that assumption. Why don't you
> just try the drop and see if it succeeds?
>
>regards, tom lane
>
I don't follow - why is there a race condition? I'm driving the
commands into postgresql via the command line.
The command that does t
Older versions of PG were inefficient with larger numbers of elements in an
IN query, and in fact would error out with something about lack of stack
space if you used very many (a few hundred IIRC).
8.x something was supposed to have improved that. Using 8.3 recently, after
an "oopsie" with some d
I resent that you're trying to make this a personal thing.
I was going to answer the rest of this email, then I realized that the
real problem was right here, and discussing anything else was dancing
around the issue and wasting time.
You can resent it or not, but this _is_ a personal th
On Fri, Oct 17, 2008 at 09:27:46AM -0400, Greg Smith wrote:
> Mikkel is right, every other well-organized mailing list I've ever been on
> handles things the sensible way he suggests, but everybody on his side
They may be well-organized, but they're doing bad things to the mail
headers. RFC 53
On Fri, 17 Oct 2008, Bill Moran wrote:
You can resent it or not, but this _is_ a personal thing. It's personal
because you are the only one complaining about it. Despite the large
number of people on this list, I don't see anyone jumping in to defend
you.
Mikkel is right, every other well-or
* Bill Moran ([EMAIL PROTECTED]) wrote:
> You can resent it or not, but this _is_ a personal thing. It's personal
> because you are the only one complaining about it. Despite the large
> number of people on this list, I don't see anyone jumping in to defend
> you.
Ugh. No one else is jumping in
In response to "Mikkel Høgh" <[EMAIL PROTECTED]>:
>
> On 17/10/2008, at 14.01, Bill Moran wrote:
>
> > Or, you could just be lonely.
>
> I resent that you're trying to make this a personal thing.
I was going to answer the rest of this email, then I realized that the
real problem was right here,
On Fri, Oct 17, 2008 at 01:02:57PM +0200, Mikkel Høgh wrote:
> Yay, even more manual labour instead of having the computers doing the work
> for us. What's your next suggestion, go back to pen and paper?
My suggestion would be to use a mail user agent that knows how to read
the list headers, whic
On 17/10/2008, at 14.06, Tom Lane wrote:
=?ISO-8859-1?Q?Mikkel_H=F8gh?= <[EMAIL PROTECTED]> writes:
Yay, even more manual labour instead of having the computers doing
the
work for us. What's your next suggestion, go back to pen and paper?
Please stop wasting everyone's time with this. The
On 17/10/2008, at 14.01, Bill Moran wrote:
In response to "Mikkel Høgh" <[EMAIL PROTECTED]>:
On 17/10/2008, at 13.20, Bill Moran wrote:
In response to "Mikkel Høgh" <[EMAIL PROTECTED]>:
On 17/10/2008, at 12.24, Tomasz Ostrowski wrote:
But again, how often do you want to give a personal r
Glyn Astill <[EMAIL PROTECTED]> writes:
> Sorry to steer this off the topic a bit, but we have a 3rd party app that
> insists on using libpq.dll version 8.0.1.5031 and we're on pgsql v 8.3.4.
> Apart from lacking functionality, is there anything else I should be aware of
> i.e. could this cause
On Oct 17, 2008, at 8:01 , Bill Moran wrote:
In response to "Mikkel Høgh" <[EMAIL PROTECTED]>:
but having to manually add a Reply-To
header to each message I send to pgsql-general is not my idea of fun.
I was not aware that Apple Mail was such a primitive email client.
You
should conside
=?ISO-8859-1?Q?Mikkel_H=F8gh?= <[EMAIL PROTECTED]> writes:
> Yay, even more manual labour instead of having the computers doing the
> work for us. What's your next suggestion, go back to pen and paper?
Please stop wasting everyone's time with this. The list policy has
been debated adequately in
In response to "Mikkel Høgh" <[EMAIL PROTECTED]>:
>
> On 17/10/2008, at 13.20, Bill Moran wrote:
>
> > In response to "Mikkel Høgh" <[EMAIL PROTECTED]>:
> >
> >> On 17/10/2008, at 12.24, Tomasz Ostrowski wrote:
> >>
> >> But again, how often do you want to give a personal reply only? That
> >> is
On 17/10/2008, at 13.20, Bill Moran wrote:
In response to "Mikkel Høgh" <[EMAIL PROTECTED]>:
On 17/10/2008, at 12.24, Tomasz Ostrowski wrote:
But again, how often do you want to give a personal reply only? That
is a valid use-case, but I'd say amongst the hundreds of mailing-list
replies I'
I'd like to learn more about how to use tsearch2 to build up a SE for
a catalogue (product name, manufacturer, category etc...).
I'm facing problems like how to implement an advanced search vs.
simple search.
eg.
1)
select * from doc where vector @@ to_tsquery('car:A | fast:B |
joy:C')
vs.
sear
In response to "Mikkel Høgh" <[EMAIL PROTECTED]>:
>
> On 17/10/2008, at 12.24, Tomasz Ostrowski wrote:
>
> > On 2008-10-17 12:13, Mikkel Høgh wrote:
> >
> >>> You're supposed to use "Reply to all" if you want to reply to the
> >>> list.
> >>
> >> Well, I think the most common use case for a mail
On 17/10/2008, at 12.24, Tomasz Ostrowski wrote:
On 2008-10-17 12:13, Mikkel Høgh wrote:
You're supposed to use "Reply to all" if you want to reply to the
list.
Well, I think the most common use case for a mailing list is to reply
back to the list, isn't that the whole point?
It is a poin
> It sounds like what you're actually using is an 8.1 or
> older libpq.dll.
Sorry to steer this off the topic a bit, but we have a 3rd party app that
insists on using libpq.dll version 8.0.1.5031 and we're on pgsql v 8.3.4.
Apart from lacking functionality, is there anything else I should be a
On 2008-10-17 12:13, Mikkel Høgh wrote:
>> You're supposed to use "Reply to all" if you want to reply to the
>> list.
>
> Well, I think the most common use case for a mailing list is to reply
> back to the list, isn't that the whole point?
It is a point of having "Reply to all" button. With "r
On 17/10/2008, at 11.37, Tomasz Ostrowski wrote:
On 2008-10-16 23:17, Mikkel Høgh wrote:
P.S.: Why are e-mails from this list not sent with a Reply-To: header
of the lists e-mail-address?
Because it is dangerous - too easy to send to the list, when you
really
mean to send to one. Most e-m
On 2008-10-16 23:17, Mikkel Høgh wrote:
> P.S.: Why are e-mails from this list not sent with a Reply-To: header
> of the lists e-mail-address?
Because it is dangerous - too easy to send to the list, when you really
mean to send to one. Most e-mail programs have two buttons for replying:
ordinar
Dann Corbit wrote:
>> -Original Message-
>> From: [EMAIL PROTECTED] [mailto:pgsql-general-
>> [EMAIL PROTECTED] On Behalf Of Magnus Hagander
>> Sent: Thursday, October 16, 2008 10:22 PM
>> To: Jeff Davis
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: [GENERAL] postgresql on 64-bit wind
Hello all.
I have a number of tables that are actually dictionaries.
This means that, in order to keep the reference integrity, in a number of
other tables I have FK definitions like these ones:
CREATE TABLE dict1 ( d1 TEXT PRIMARY KEY, ... );
CREATE TABLE user1 ( d1 TEXT NOT NULL REFERENCES dic
On 16/10/2008, at 18.27, Scott Marlowe wrote:
On Thu, Oct 16, 2008 at 9:26 AM, Stephen Frost <[EMAIL PROTECTED]>
wrote:
* DelGurth ([EMAIL PROTECTED]) wrote:
Seems Tomasz linked to the wrong patch. The patch he meant was:
http://drupal.org/files/issues/drupal_lookup_path-6.x.patch.txt
That'
Hi all..
I have an sql script consists of insert statement data. I want to insert
every row of data every one minute. How can i do that using batch file in
windows
Thank you
--
View this message in context:
http://www.nabble.com/auto-insert-data-every-one-minute-tp20027811p20027811.html
Sent f
89 matches
Mail list logo
