Re: [SQL] Domains, casts, and MS Access

On Wed, Aug 4, 2010 at 3:41 PM, Peter Koczan wrote: > Yep, that's the stumbling block we're running into. ODBC and these > fields' assumptions of true/false are at odds. I'm trying a few other > things with casts in the meantime to see if they'll work. Well there is a solution that I've been toy

Re: [SQL] Domains, casts, and MS Access

On Wed, Aug 4, 2010 at 4:40 PM, Richard Broersma wrote: > On Wed, Aug 4, 2010 at 1:24 PM, Justin Graf wrote: > >> My memory is fuzzy but there are some additional settings in Access that >> allows data type mapping... > > My experience is that PostgreSQL Integer types work the best for > MS-Acces

Re: [SQL] Delete rules

On Wed, Aug 4, 2010 at 1:25 PM, Little, Douglas wrote: > But I don’t know how to access the entire sql statement for > interrogation. Is there a way I can see what the statement is that’s > executing and triggering the rule? > I've found complex and simple rules pretty hard to get correct. Th

Re: [SQL] Domains, casts, and MS Access

On Wed, Aug 4, 2010 at 1:24 PM, Justin Graf wrote: > My memory is fuzzy but there are some additional settings in Access that > allows data type mapping... My experience is that PostgreSQL Integer types work the best for MS-Access bit datatype considering the fact that in Access -1 = true. I kn

Re: [SQL] What does PostgreSQL do when time goes backward?

John Hasler wrote: Frank writes: My ntp client changes clock (by small amount) at any time: Jul 25 05:29:38 bax ntpd[10269]: adjusting local clock by 0.098724s Jul 25 05:31:43 bax ntpd[10269]: adjusting local clock by 0.038991s Jul 25 06:13:38 bax ntpd[10269]: adjusting local clock by -0.037131s

[SQL] Delete rules

Hi, We'd like to give our applications truncate capability, but that would also give them drop table permission, which we don't want them to have. So, we created a truncate function that uses the definers security context. The issue is that we now have 1000's of programs to change to use the func

Re: [SQL] workaround for missing ROWNUM feature with the help of GUC variables

On 08/04/2010 12:35 PM, Marc Mamin wrote: Hello, here my two pence on this recurring thema. (just a workaround) I don't understand what you mean by missing ROWNUM feature, PG got this with windows-functions in 8.4: http://www.postgresql.org/docs/8.4/interactive/functions-window.html Exa

Re: [SQL] Domains, casts, and MS Access

On 8/4/2010 1:56 PM, Richard Broersma wrote: > On Wed, Aug 4, 2010 at 11:51 AM, Peter Koczan wrote: > > >> This is one of my first forays into ODBC, so I didn't know that was a >> possibility. Is there any place where these are documented? Searching >> for ODBC options yields info on connectio

Re: [SQL] Domains, casts, and MS Access

On Wed, Aug 4, 2010 at 11:51 AM, Peter Koczan wrote: > This is one of my first forays into ODBC, so I didn't know that was a > possibility. Is there any place where these are documented? Searching > for ODBC options yields info on connection options, but none on > behavior that I could find. I k

Re: [SQL] Domains, casts, and MS Access

On Wed, Aug 4, 2010 at 12:47 PM, Richard Broersma wrote: > On Wed, Aug 4, 2010 at 10:31 AM, Peter Koczan wrote: > >> One of the snags that's popped up is that there's some incompatibility >> between data types. Specifically, many fields are the Sybase type >> "bit", which is basically a boolean,

Re: [SQL] What does PostgreSQL do when time goes backward?

John Hasler wrote: Frank writes: My ntp client changes clock (by small amount) at any time: Jul 25 05:29:38 bax ntpd[10269]: adjusting local clock by 0.098724s Jul 25 05:31:43 bax ntpd[10269]: adjusting local clock by 0.038991s Jul 25 06:13:38 bax ntpd[10269]: adjusting local clock by -0.037131

Re: [SQL] Domains, casts, and MS Access

On Wed, Aug 4, 2010 at 10:31 AM, Peter Koczan wrote: > One of the snags that's popped up is that there's some incompatibility > between data types. Specifically, many fields are the Sybase type > "bit", which is basically a boolean, but it accepts and displays > bareword 1 and 0 instead of 't' an

Re: [SQL] What does PostgreSQL do when time goes backward?

I wrote: > How does PostgreSQL react to time being stepped at bootup? My Chrony > NTP package might cause it to do so on rare occasions when the > hardware clock is way off. This would only happen during bootup. Ken writes: > PostgreSQL does not use system time to track transactions so you > sho

[SQL] Domains, casts, and MS Access

Hi all, I'm working on porting an old MS Access form application from Sybase to postgres/ODBC as part of a larger database port project. One of the snags that's popped up is that there's some incompatibility between data types. Specifically, many fields are the Sybase type "bit", which is basical

Re: [SQL] Some quick questions

On Wed, Aug 04, 2010 at 10:22:12AM -0400, Joshua Gooding wrote: > I am using Postgres 8.4 with 10 partition tables. We'll call them > reports_00 through reports_09. > > I have a field that is a BIGINT which is a 13 digit number that is the > epoch time, which is the constraint that the table is

[SQL] Some quick questions

I am using Postgres 8.4 with 10 partition tables. We'll call them reports_00 through reports_09. I have a field that is a BIGINT which is a 13 digit number that is the epoch time, which is the constraint that the table is partitioned on. (Between time x and y). All of the partitions hold 10

Re: [SQL] What does PostgreSQL do when time goes backward?

On Wed, Aug 04, 2010 at 07:20:31AM -0400, Frank Bax wrote: > John Hasler wrote: >> How does PostgreSQL react to time being stepped at bootup? My Chrony >> NTP package might cause it to do so on rare occasions when the hardware >> clock is way off. This would only happen during bootup. > > > My nt

Re: [SQL] Help Need some hindsight

In response to Andreas : > Hi, > I need to display log events (again). > The log is simply like this > log ( log_id serial primary key, create_ts timestamp default > localtimestamp, object_id, state_id, ... ) > > It records the state of objects and when and what happend to to change > this

Re: [SQL] What does PostgreSQL do when time goes backward?

John Hasler wrote: How does PostgreSQL react to time being stepped at bootup? My Chrony NTP package might cause it to do so on rare occasions when the hardware clock is way off. This would only happen during bootup. My ntp client changes clock (by small amount) at any time: Jul 25 05:29:38

Re: [SQL] join table problem

Howdy! At any rate, say I have 3 tables: table plant id:integer name string table seed_supplier id: integer company_name: string table plant_seed_supplier plant_id seed_supplier_id plant_seed_supplier is a join table that supports a many to many relationship between the plant table an

[SQL] workaround for missing ROWNUM feature with the help of GUC variables

Hello, here my two pence on this recurring thema. (just a workaround) regards, Marc Mamin The PG parameter must be set to allow defining own configuration variables: #--- --- # CU

[SQL] What does PostgreSQL do when time goes backward?

How does PostgreSQL react to time being stepped at bootup? My Chrony NTP package might cause it to do so on rare occasions when the hardware clock is way off. This would only happen during bootup. -- John Hasler jhas...@newsguy.com Elmwood, WI USA -- Sent via pgsql-sql mailing list (pgsql-sql

[SQL] Help Need some hindsight

Hi, I need to display log events (again). The log is simply like this log ( log_id serial primary key, create_ts timestamp default localtimestamp, object_id, state_id, ... ) It records the state of objects and when and what happend to to change this state. I'd like to get a list that sh

[SQL] join table problem

I have a specific problem with a join table and I've simplified it to these 3 tables so as not to have to post anything that hints towards the business nature of our database just in case .. At any rate, say I have 3 tables: table plant id:integer name string table seed_supplier id: in