Hi,
I face the following problem:
I use PostgreSQL 7.0.3 on RH6.2. When I make a select through ODBC (VB 6,
ODBC v.6.50, MDAC 2.6) that contains many text fields per row (i.e. more
than 10) there are no records returned to the recordset I use (I use ADO).
When I execute the query through psql al
The HTML programming documentation (e.g.
http://www.postgresql.org/devel-corner/docs/programmer/pg-system-catalogs.htm)
indicates that more extensive information about the system catalogs can
be found in the "Reference Manual". Where can this reference manual be
found? Or where can more extensiv
Hello,
I'm working on an application where I need to design for one table to grow
to an extremely large size. I'm already planning to partition the data into
multiple tables, and even possibly multiple servers, but even so each table
may need to grow to the 10 - 15 million tuple range. This table
hi all,
I try
select purc.trn_no,purcsub.item_no,purcsub.qty,emp_no,emp_na
from purc left join purcsub on (purc.trn_no=purcsub.trn_no)
left join emp on (purc.emp_no = emp.emp_no)
postgresql not run,please help,thank
Hi folks,
I am getting a strange parser error when I execute a PL/PGSQL function.
Q: Is there any way to get more infromation from the parser other than
the standard stuff in psql?
Q; Is there any support for "debugging" plpgsql functions?
Thanks in advance
Marcel
Subject: Re: [SQL] Optimization recommendations request
>
> What does explain show for your query?
>
I sent this a week ago using the wrong (i.e. not the one I signed up with)
reply-to address, so it didn't make it to the list until just now. In the
meantime I ran explain and noticed that the i
What does explain show for your query?
On Sat, 23 Dec 2000, Joe Conway wrote:
> Hello,
>
> I'm working on an application where I need to design for one table to grow
> to an extremely large size. I'm already planning to partition the data into
> multiple tables, and even possibly multiple serv
"Joe Conway" <[EMAIL PROTECTED]> writes:
> create index foo_idx1 on foo using HASH (guid);
> SELECT ks FROM foo WHERE guid = 'f9ee1930f4010ba34cc5ca6efd27d988eb4f921d';
> The query currently takes in excess of 40 seconds. I would appreciate any
> suggestions for optimizing to bring this down sub
Hello
I am moving from MySQL to Postgres and while converting my sql code I
have a lot of problems with this construction:
($ze is current time - 300 secounds):
delete from onlineuser where datum < FROM_UNIXTIME($ze)
Is there any Date/Time function in PGSQL? I want as shown in this
example del
Tx,
Thomas,
"Brett W. McCoy" wrote:
>
> On Sun, 24 Dec 2000, Thomas SMETS wrote:
>
> > I'm runnin postgres 7.?? (Last RPM package available from the site).
> >
> > I want to create a few DB creation scripts so I can "publish" that
> > afterwards.
> > On Oracle there's a such possibility but I
Oliver,
At the moment Tx for all your remarks...
I'll need some times to digest them all!
I'll keep this thread inform on updates
Regards,
Thomas
Oliver Elphick wrote:
>
> Thomas SMETS wrote:
> >
> >Rather thant making long sentences & comment.
> >Anyone wi
>
> Hi Thomas, I would love to help.
> Najm
>
What are your competences ?
Needed is
java <--> Basic devlopment in Java 2
php <--> Currently hosting free may buy web site later on
python <--> Install & config done via Python
Admin <--> What to Config, How, Custo
Yep,
Tx,
Thomas,
p.s. Sorry for the stupid question
Raju Mathur wrote:
>
> Hi Thomas,
>
> Is it possible you're looking for:
>
>psql -f script.sql
>
> ?
>
> Regards,
>
> -- Raju
>
> > "Thomas" == Thomas SMETS <[EMAIL PROTECTED]> writes:
>
> Thomas> I'm runnin post
Toad (the graphical interface for Oracle) has a functionnality that
allows one to dispaly tables & have them defined in the tool
accordingly.
Is there an equivalent tool for PostgreSQL ?
Tx,
thomas,
--
Sat Dec 30 00:39:50 CET 2000
Thomas SMETSe-mail : [EMAIL PROTECT
Thomas SMETS <[EMAIL PROTECTED]> writes:
> Toad (the graphical interface for Oracle) has a functionnality that
> allows one to dispaly tables & have them defined in the tool
> accordingly.
> Is there an equivalent tool for PostgreSQL ?
I'm not familiar with Toad, so I don't know exactly what func
Tulio Oliveira wrote:
>
> I appreciate any "C" Function complete samples, including de command
> line for
> the compiler.
I've attached a generic GNU make snippet for compiling .so files.
Adjust to suite your tastes. Like my math textbooks used to say
"writing the C code is trivial, and is lef
Hi,
I'm working in a database called frontbase..and I dont have a lot of
exposure to SQL92.So can u provide me some feedback with some site or
tutorials where in I can get myself acquainted with sql92.
regards
Narayanan
begin:vcard
n:Palasseri;Narayanan
x-mozilla-html:TRUE
org:GSI India
adr:;;
Frank Joerdens wrote:
>
> In a recent thread (How to represent a tree-structure in a relational
> database) I asked how to do a tree structure in SQL, and got lots of
> suggestions (thanks!), of which I chose the one below:
>
> create table Category (
> CategoryID int4 not null primary k
Ron Peterson wrote:
>
> CREATE TABLE category_edge (
> parent INTEGER
> NOT NULL
> REFERENCES category_node(id),
>
> child INTEGER
> NOT NULL
> REFERENCES category_node(id)
> );
Just for the sake of anal-retentiv
Stuart Statman wrote:
>
> I would suggest, instead, to create a table that represents your hierarchy
> without adding columns. For example :
>
> create table Category (
> CategoryID int4 not null primary key,
> ParentCategoryID int4 not null REFERENCES Category (CategoryID),
> Category
hi Ron,
Try the developers manual:
http://www.postgresql.org/devel-corner/docs/postgres/developer.htm
actual catalog info is:
http://postgresql.mirror.aarnet.edu.au/devel-corner/docs/postgres/catalogs.htm
If you find any other sources please let me know - especially any that
refer to composite
21 matches
Mail list logo