Am Sonntag, den 06.11.2005, 19:10 -0700 schrieb Leonel Nunez:
> Hello
>
>
> I cant find any info if PygreSQL works with ByteA or if there's
> an escape function to store the objects in a ByteA Field
>
Where did you look and for which language do you look?
---(
am 06.11.2005, um 22:54:15 + mailte Chris folgendes:
> Andreas Kretschmer spamfence.net> writes:
> > Chris gmail.com> schrieb:
> >
> > > How do I create a virtaul column?
> >
> > A view. Example:
>
> Is a view completely compatible with tables? I mean, can I do everything with
> a
> view
On Nov 6, 2005, at 3:19 PM, Bob Pawley wrote:
Last week I received help form the list in inserting a serial row
of one table (process) into a row in a table called specification.
I was able to expand that to include inserting the same information
into a table called pipe.
On Sun, 6 Nov 2005 18:06:11 -0700, Assad Jarrahian <[EMAIL PROTECTED]> wrote:
> Hi,
> I am writing a .sql file to create a database, connect to it and create
> tables etc. (basic db setup).
> But I cannot figure out how to connect to the server (what statement) in a
> .sql file.
>
> any help would
Bill Bartlett wrote:
I hit this exact same problem, and my initial reaction was the same as
yours -- psql was "hanging". After much head-banging, I discovered that
it is not in fact hanging, but is instead getting confused by being run
from inside Putty, Cygwin, xterm, rxvt terminal, etc. Beca
Hello
I cant find any info if PygreSQL works with ByteA or if there's
an escape function to store the objects in a ByteA Field
Thanks
Leonel
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http:/
Thank you for your response Tom.
Should I set the max_fsm_pages to the "total pages needed" obtained from a
full vacuum or from a analize vacuum? When I run a vacuum analyze (vacuumdb
-z -v), I get a smaller number of pages needed than when I run a full vacuum
with analyze (vacuumdb -f -z -v)
--
Hi,
I am writing a .sql file to create a database, connect to it and create tables etc. (basic db setup).
But I cannot figure out how to connect to the server (what statement) in a .sql file.
any help would be appreciated.
-assad
I hit this exact same problem, and my initial reaction was the same as
yours -- psql was "hanging". After much head-banging, I discovered that
it is not in fact hanging, but is instead getting confused by being run
from inside Putty, Cygwin, xterm, rxvt terminal, etc. Because psql is
not being ru
Andreas Kretschmer spamfence.net> writes:
> Chris gmail.com> schrieb:
>
> > How do I create a virtaul column?
>
> A view. Example:
Is a view completely compatible with tables? I mean, can I do everything with a
view like I can do to a table, like insert, delete or update?
-
"Andrus Moor" <[EMAIL PROTECTED]> writes:
> CREATE TEMP TABLE t2 AS SELECT * FROM t1 ON COMMIT DROP;
> Causes ERROR: syntax error at or near "ON" at character 104
Not implemented, as the manual clearly states.
> How to implement this ?
Create the temp table with a plain CREATE, then fill it wit
Last week I received help form
the list in inserting a serial row of one table (process) into a row in a table
called specification.
I was able to expand that to
include inserting the same information into a table called pipe.
---
create or
replace function base() returns
In article <[EMAIL PROTECTED]>, Andrus Moor <[EMAIL PROTECTED]> wrote:
>I need to create temporary table with data which is dropped at end of
>transaction.
>
>CREATE TABLE t1 ( c1 INTEGER ) ;
>INSERT INTO t1 VALUES (1);
>CREATE TEMP TABLE t2 AS SELECT * FROM t1 ON COMMIT DROP;
>
>Causes ERROR: sy
I have 10 CHARACTER columns in table mytable. Mytable is indexed by some of
those columns.
CREATE TABLE mytable ( col1 CHARACTER(10),
col2 CHARACTER(10),col3 CHARACTER(10),col4 CHARACTER(10),col5
CHARACTER(10),col6 CHARACTER(10),col7 CHARACTER(10),col8 CHARACTER(10),col9
CHARACTER(10), col10 CH
I need to create temporary table with data which is dropped at end of
transaction.
CREATE TABLE t1 ( c1 INTEGER ) ;
INSERT INTO t1 VALUES (1);
CREATE TEMP TABLE t2 AS SELECT * FROM t1 ON COMMIT DROP;
Causes ERROR: syntax error at or near "ON" at character 104
How to implement this ?
Andrus.
On Sun, 6 Nov 2005, Tony Caduto wrote:
Hi,
Would anyone object if I posted the 8.1 release announcement (when it happens
of course) on the Borland Newsgroups (in Third Party anouncments)?
Once released, the more visibility, the better :) Release is schedualed
right now for Tuesday morning .
--- Martijn van Oosterhout wrote:
> On Sun, Nov 06, 2005 at 12:15:45AM -0500, Greg Stark
> wrote:
> >
> > Tom Lane <[EMAIL PROTECTED]> writes:
> >
> > > My advice to the Rails people would be to fix
> whatever it is in their
> > > code that is assuming a particular sequence
> name, or indeed a
I thought pgreplicator did provide multi-master replication and i did test it as well.
http://pgreplicator.sourceforge.net/
vishOn 11/3/05, Andrew Sullivan <[EMAIL PROTECTED]> wrote:
On Wed, Nov 02, 2005 at 05:23:34PM -0600, Jim C. Nasby wrote:> > It seems kludgey this way, though. What you real
Hi,
Would anyone object if I posted the 8.1 release announcement (when it
happens of course) on the Borland Newsgroups (in Third Party anouncments)?
Thanks,
Tony
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
Chris <[EMAIL PROTECTED]> schrieb:
> How do I create a virtaul column?
>
> A virtual column is accessible like any other column except that there is no
> physical column associated with it (unless it's indexed). The data for the
> column is derived from other columns in the table. For example, in
On Sun, Nov 06, 2005 at 12:15:45AM -0500, Greg Stark wrote:
>
> Tom Lane <[EMAIL PROTECTED]> writes:
>
> > My advice to the Rails people would be to fix whatever it is in their
> > code that is assuming a particular sequence name, or indeed assuming
> > a sequence at all...
>
> Well how else do
On Sun, Nov 06, 2005 at 02:58:15AM +, Chris wrote:
> How do I create a virtaul column?
>
> A virtual column is accessible like any other column except that there is no
> physical column associated with it (unless it's indexed). The data for the
> column is derived from other columns in the tab
How do I create a virtaul column?
A virtual column is accessible like any other column except that there is no
physical column associated with it (unless it's indexed). The data for the
column is derived from other columns in the table. For example, in a table
people, a persons name is the concate
23 matches
Mail list logo
