Quoting Skippy <[EMAIL PROTECTED]>:
> How can I disable auto-commit for a Postgres connection? Apparently
> server-side autocommit was thrown out in Postgres 8.0, and clients have to
> issue their own setting (which is sensible).
Apparently this will work (or at least it will be accepted by pg_con
On Fri, July 1, 2005 6:24 am, Jason Wong said:
> On Friday 01 July 2005 09:55, Richard Lynch wrote:
>> If there's a reliable, web-safe, connection-dependent way of getting
>> the sequence ID used in an INSERT, it sure ain't documented, and I've
>> never seen it discussed on the PostgreSQL list (whi
OIDs *can* get re-used *IF* you end up having more than 32-bits (2
billion plus) of objects in the lifetime of your application.
For normal usage, that ain't a big problem, honestly...
Though I should have stated it for the record, cuz maybe the OP has a
site where 2 BILLION INSERTs are gonna ha
El Vie 01 Jul 2005 06:27, david forums escribió:
>
> before any insert call the id.
>
> select nextval('tablename_seq');
>
> and pass this id to your insert.
No. Best is to but a DEFAULT clause of nextval('tablename_seq') in the table
definition.
--
select 'mmarques' || '@' || 'unl.edu.ar' A
On Friday 01 July 2005 09:55, Richard Lynch wrote:
> There are innumerable on-line forums that (incorrectly) state that an
> OID could be returned that is not connection-specific, so two HTTP
> requests in parallel would criss-cross OIDs.
>
> This is patently false, and any user of PostgreSQL can
Hi
I'm migrating also to posgresql. The easyest way to manage incrementation
with postgres is to use
sequences.
How to :
Create a sequence for each table that need autoincrementation.
use pgMyAdmin, to make all needed changes
before any insert call the id.
select nextval('tablename_seq');
On Thu, June 30, 2005 2:17 pm, Jason Wong said:
> On Friday 01 July 2005 04:06, Richard Lynch wrote:
>
>> > last
>> > record from the tabel, for linking to another tabel.
>>
>> You have to use http://php.net/pg_last_oid to get the PostgreSQL
>> "internal" Object ID (OID) -- You can then use the ubi
On Friday 01 July 2005 04:06, Richard Lynch wrote:
> > last
> > record from the tabel, for linking to another tabel.
>
> You have to use http://php.net/pg_last_oid to get the PostgreSQL
> "internal" Object ID (OID) -- You can then use the ubiquitous "oid"
> column.
>
>
> $query = "insert ...";
> p
On Friday 01 July 2005 02:55, Uroš Kristan wrote:
> I have an application in production, build on mysql database.
>
> I decided to migrate to postgres because of numerous reasons.
Good idea :)
> Can you guys please guide me into the right direction?
>
> the main problem is the missing autoincre
On Thu, June 30, 2005 11:55 am, Uro¹ Kristan said:
> I have an application in production, build on mysql database.
>
> I decided to migrate to postgres because of numerous reasons.
>
> Can you guys please guide me into the right direction?
>
> the main problem is the missing autoincrement of pgsql
P. George wrote:
i am storing images in a postgres database and i have set up a little
php file to retrieve them in such a way that i can do:
This topic came up a few days ago and the pros and cons of saving images
in a data base was argued with very few pros been given. However the
defining mom
On Wed, 2004-11-03 at 10:20 +1000, Tom Rogers wrote:
> Hi,
>
> Wednesday, November 3, 2004, 8:45:17 AM, you wrote:
> PG> i am storing images in a postgres database and i have set up a little
> PG> php file to retrieve them in such a way that i can do:
>
> PG> echo "";
>
> PG> ...from another ph
Hi,
Wednesday, November 3, 2004, 8:45:17 AM, you wrote:
PG> i am storing images in a postgres database and i have set up a little
PG> php file to retrieve them in such a way that i can do:
PG> echo "";
PG> ...from another php file.
PG> it's working great, BUT i've noticed two things that bothe
On Tue, 2004-11-02 at 16:45 -0600, P. George wrote:
> i am storing images in a postgres database and i have set up a little
> php file to retrieve them in such a way that i can do:
>
> echo "";
>
> ...from another php file.
>
> it's working great, BUT i've noticed two things that bother me:
>
Yeah, I found the problem, It was adding a "order by lower(title)" in
another class which I forgot about when I was trying to test the query.
so it works fine now. So yep, using, joines, case, order bys,
lowers,inheritance in php/postgres all work fine.
1LT John W. Holmes wrote:
>Double che
Double check that you have a.title, and not just title by itself. Two
tables must have a title column, so make sure you specify which one you
mean.
---John Holmes...
- Original Message -
From: "Aaron" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 12, 2002 12:40 AM
S
There is a utiliti under contrib/ called oid2name which returns the name of the object
given its oid. This will probably help you locate which directories correspond to
which database.
cheers,
--thalis
On Sat, 30 Mar 2002, Robert Abbate wrote:
> Greetings to all!
>
> I have a webhosting com
suggestion would be to post a snippet of the relavent code... say lines 160 to
175 or something like that. Troubleshooting across the etherial plane is
expensive.
Dave
>-Original Message-
>From: aurelio [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, January 09, 2002 12:48 PM
>To: [EMAIL
hi there!
the operators you want are ~ and ~* and !~ and !~*.
select name from table where name ~* 'test';
to see all operators availlable type \do in psql's interactive mode ;)
Regards,
Nuno Silva
Derek wrote:
> anyone know how I force a case insensitive search through a postgres
> database
Hello Wade,
(HWM == "H. Wade Minter") [EMAIL PROTECTED] writes:
HWM> So, can I change all of the pg_connect calls to pg_pconnect call
HWM> and have the pages use persistent connections, or is there
HWM> something more that needs to be done?
Yes. AFAIK.
-Brian
--
The trouble with a lot of self
20 matches
Mail list logo
