On Apr 7, 11:14 am, [EMAIL PROTECTED] (Alan Hodgson) wrote:
> On Monday 07 April 2008, Dan99 <[EMAIL PROTECTED]> wrote:
>
> > Does TRUNCATE TABLE keep all necessary table
> > information such as indexes, constraints, triggers, rules, and
> > privileges?
>
> Ye
On Apr 5, 6:36 pm, [EMAIL PROTECTED] ("Douglas McNaught") wrote:
> On Thu, Apr 3, 2008 at 2:34 PM, Dan99 <[EMAIL PROTECTED]> wrote:
> > Hi,
>
> > I am having some troubles with a select group of tables in a database
> > which are acting unac
Hi,
I am having some troubles with a select group of tables in a database
which are acting unacceptably slow. For example a table with
approximately < 10,000 rows took about 3,500ms to extract a single row
using the following select statement:
SELECT * FROM table WHERE column = 'value'
I have p
On Apr 3, 9:02 pm, [EMAIL PROTECTED] (Justin) wrote:
> Have a select statement with a where clause using datestamp with
> timezone column compared to a date
>
> Select * from sometable where DateStampColumn > '2008-03-31'
>
> this returns records that are equal 2008-03-31
>
> but when the query inc
Hi,
I am currently brainstorming ideas for a new RIA that I am planing to
make. In the RIA there would be many different sections which do
different things. Some of these sections would require data from
other sections and some sections can sit on there own. Knowing that
this RIA is meant to be
On Sep 25, 10:32 am, [EMAIL PROTECTED] ("Scott Marlowe") wrote:
> On 9/18/07, Dan99 <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hi,
>
> > I found out this morning that I cannot get pg_dump to work at all on
> > my database. It refuses to create a dump and
On Sep 25, 11:02 am, [EMAIL PROTECTED] (Alvaro Herrera)
wrote:
> Dan99 escribió:
>
>
>
> > Hi,
>
> > I found out this morning that I cannot get pg_dump to work at all on
> > my database. It refuses to create a dump and instead just freezes.
> > When
Hi,
I found out this morning that I cannot get pg_dump to work at all on
my database. It refuses to create a dump and instead just freezes.
When using the verbose option (-v) i get the following output and then
it stops (it at one point ran for days on end before i even noticed)
pg_dump: saving
Hi,
I am looking for a way to get the original query that caused a trigger
to fire. I need to be able to get this query either inside the
trigger itself (and then send it to the function the trigger calls) or
get it in the end function. Is this doable? The reason i am asking is
that I would like
Hello,
I am working on auditing interactions with a pgsql database using
php. So my question is how can i go about obtaining the following
information by only being provided a pgsql query. I have asked this
same question in a php group however i would also like to ask it here
encase there is a w
10 matches
Mail list logo
