lated question: I need to use /i file to import my
>current database into postgres. It seems that I have to use
>nextval(...) when doing an insert. Is it possible to insert a
>row without having to use 'nextval()'?
>
>David Hartwig wrote:
>>
>> Each PostgreS
Each PostgreSQL table has a, system assigned, oid (object ID) column which
is useful for uniquely identifying rows. Users have vertually no control
over it value.
There is also:
CREATE TABLE foo (
aiserial primary key,
bar integer
);
which is a short cut in the pa
- Original Message -
From: Robert Chalmers <[EMAIL PROTECTED]>
To: psql-general <[EMAIL PROTECTED]>
Sent: Wednesday, January 20, 1999 8:51 PM
Subject: [GENERAL] RE: ODBC question on R+w and +r only. solved
>Hmmm. Just gave all permisions to user, and created a NEW table database in
>Acc
For more features, better performance, and better support - upgrade.
[EMAIL PROTECTED] wrote:
> I just installed postgres 6.1.1 on Caldera 1.3 (it came with it).
> Should I upgrade this immediately or is this good enough for now?
> If so, which version should I upgrade to 6.3.x or 6.4.x?
>
> Tha
Bob Kruger wrote:
The second question is that I noticed the ODBC bug
(feature?) when linking
Postgres to MS Access still exists. This bug occurs when linking
a MS
Access table to a Postgres table, and identifying more than one field
as
the unique record identifier. This makes Postgres run unt
I have 4.1.4. My last compile was flawless other then a few tweaks necessary for
plpgsq. Your not that far yet.
>From what I can see apparent what your problem is.
mkldexport.sh is a script calls nm.
nm is a UNIX utility for extracting external symbols from executables and such.
It lo
SPI - Server Programming Interface is for coding C functions in the
backend. Thus triggers can reference functions created using SPI..
Libpq is a front-end (or client side) API.
Anand Surelia wrote:
> Hi,
> Can anyone tell me what is the difference between the SPI and the Libpq
> interfaces
In the Driver Setup dialog, go to Advanced Options / Driver. Turn OFF "Use
Declare/Fetch".This will cause the driver to read the entire keyset into memory
instead of leaving open the cursor that is fetched on request from the
application. Just one of those space/time trade-offs.
Daniel £a
select * from pg_trigger;
Andrew Gibson wrote:
> Greetings to the list from DownUnder!
>
> I have created a number of triggers and do not remember exactly what I
> called them. How do I list the triggers (to refint.c) I have created and
> which tables they reference etc.??
>
> --
We have quite a few NT users who have not reported any problems with the setup
process. Perhaps you are comparing this installation to earlier versions
(pre-insight). The old version would automatically invoke the driver setup as
part of the installation. Now you must start the "ODBC Data So
How are you representing NULL in the source file. Blank or zero length
strings are not NULL. They are treated as illegal dates. I believe
"\N" is used to represent NULL in the copy in/out.
William D. McCoy wrote:
> I'm running Postgres 6.3.2 on a Sparc20 running Solaris 2.5.1 and I'm
> hav
ODBC Connection Checklist
ODBC Driver Data Source Checks
1.Valid and resolvable hostname.
2.Valid port number. (default is 5432)
3.Valid and existing database name.
4.Valid user name.
5.Valid password for the sp
Linden wrote:
> Is it possible to store large image fiel's on a database then select
> them from a search .
>
Yes, the database supports large objects. You may need to decide on your
client side requirements to make a better judgment. For what its worth ODBC
driver supports OLE objects.
>
13 matches
Mail list logo
