Hi,
We have API's in /usr/local/pgsql/include/libpq-fe.h which support large
objects in PostGres
extern int lo_open(PGconn *conn, Oid lobjId, int mode);
extern int lo_close(PGconn *conn, int fd);
extern int lo_read(PGconn *conn, int fd, char *buf, size_t len);
Hi,
On 6/7/05, Vadivel Subramaniam
[EMAIL PROTECTED] wrote:
My doubt is, do these API's operate on character data? i.e., My table
schema is like this
table (name varchar, script varchar). I have to store a large data(in
character form) in the script column (upto 3 MB).
As of my
On Tuesday 07 Jun 2005 11:29 am, Nick Johnson wrote:
if the value of 'fixed' is TRUE, then this row cannot be deleted.
How do i enforce this condition?
Try this:
CREATE RULE tablename_delete AS ON DELETE TO tablename WHERE
OLD.fixed = TRUE DO INSTEAD NOTHING;
cool - thanks
--
regards
O ON.KG Jun 7, 2005 :
RH ON.KG wrote:
Hi All!
What is faster - SLECTion data from one large table (200 000 - 300 000
records), or SELECTion from a few small tables (example, 2 tables 150
000 records each)?
For example i have two large tables
Structure of tables is same - has two
hi,
every time i post to this list i get a copy of the message below -
could the listadmin do something (or is there something i have to
do?)
-- Forwarded Message --
Subject: RE: Re: [SQL] preventing deletion of a row
Date: Tuesday 07 Jun 2005 12:24 pm
From: AntiSpam UOL
Kenneth Gonsalves wrote:
hi,
every time i post to this list i get a copy of the message below -
could the listadmin do something (or is there something i have to
do?)
I'm not sure it is from the list - it appears to be something setup by
[EMAIL PROTECTED]
Youve just sent a message to
On Tuesday 07 Jun 2005 1:35 pm, Richard Huxton wrote:
I'm not sure it is from the list - it appears to be something setup
by [EMAIL PROTECTED]
apparently he is a member of the list - so mail from any 'untrusted'
guy like me gets this message. (anyone else getting it?)
--
regards
kg
O Kenneth Gonsalves Jun 7, 2005 :
On Tuesday 07 Jun 2005 1:35 pm, Richard Huxton wrote:
I'm not sure it is from the list - it appears to be something setup
by [EMAIL PROTECTED]
apparently he is a member of the list - so mail from any 'untrusted'
guy like me gets this message. (anyone
Instead of tablenames just use functions (tablefunctions)
like my example
select a.Id, a.Code from GetLanguages() a, GetLanguages() b
2,en
2,en
1,de
1,de
|-Original Message-
|From: Markus Bertheau [mailto:[EMAIL PROTECTED]
|Sent: Dienstag, 07. Juni 2005 01:17
|To: KPFERL Robert
|Cc:
Can
please some of the administrators remove that member or
what-o-else
-Original Message-From: AntiSpam UOL
[mailto:[EMAIL PROTECTED]Sent: Dienstag, 07. Juni 2005
11:22To: KÖPFERL RobertSubject: RE: Re: [SQL] SQL
equivalent to nested loop
ANTISPAM UOL »
On Tue, 7 Jun 2005, M.D.G. Lange wrote:
It is not possible to create a constraint Foreign key for wordid. No
problem there, but I want to be certain that a given wordid exists in
tbldictionary.
Would I have to create a RULE or a TRIGGER to be certain that the
wordid is existing in
Achilleus Mantzios [EMAIL PROTECTED] writes:
O Kenneth Gonsalves Ýãñáøå óôéò Jun 7, 2005 :
On Tuesday 07 Jun 2005 1:35 pm, Richard Huxton wrote:
I'm not sure it is from the list - it appears to be something setup
by [EMAIL PROTECTED]
apparently he is a member of the list - so mail from any
M.D.G. Lange wrote:
In order for a dictionary system I have created the following system:
tbllanguages
- ID
- name
Primary key ( ID )
tbldictionary
- wordid
- languageid
- value
Primary key ( wordid, languageid)
The idea is to have a word id in several languages, so you only have to
look up
On Tue, Jun 07, 2005 at 13:54:21 +0530,
Kenneth Gonsalves [EMAIL PROTECTED] wrote:
On Tuesday 07 Jun 2005 1:35 pm, Richard Huxton wrote:
I'm not sure it is from the list - it appears to be something setup
by [EMAIL PROTECTED]
apparently he is a member of the list - so mail from any
14 matches
Mail list logo